48 lines
2.5 KiB
C#
48 lines
2.5 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using System.Linq;
|
|||
|
|
using System.Text;
|
|||
|
|
using Ease.CoreV35.DataAccess;
|
|||
|
|
using Ease.CoreV35.Model;
|
|||
|
|
using Payroll.BO;
|
|||
|
|
|
|||
|
|
namespace Payroll.Service
|
|||
|
|
{
|
|||
|
|
public class EductionalQualificationDA
|
|||
|
|
{
|
|||
|
|
internal static void InsertEductionalQualification(EductionalQualification eduItem,TransactionContext tc)
|
|||
|
|
{
|
|||
|
|
string sql = SQLParser.MakeSQL(@"Insert Into CVEductionalQualification(EductionalQualificationID,BoardId,
|
|||
|
|
CgpaOrMarks,CgpaOrMarksOutOf,CvId,DegreeTitleId,DisciplineId,IsHighestEducation,
|
|||
|
|
Name,PassingYear,Result,InstituteName)
|
|||
|
|
Values(%n,%n,%n,%n,%n,%n,%n,%n,%s,%n,%n,%s)", eduItem.ID.Integer,eduItem.BoardId.Integer,
|
|||
|
|
eduItem.CgpaOrMarks, eduItem.CgpaOrMarksOutOf, eduItem.CvId.Integer, eduItem.DegreeTitleId.Integer, eduItem.DisciplineId.Integer, Convert.ToInt16(eduItem.IsHighestEducation), eduItem.Name, eduItem.PassingYear, eduItem.ResultID.Integer,eduItem.InstituteName);
|
|||
|
|
tc.ExecuteNonQuery(sql);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
internal static void UpdateEductionalQualification(EductionalQualification eduItem,TransactionContext tc)
|
|||
|
|
{
|
|||
|
|
string sql = SQLParser.MakeSQL(@"Update CVEductionalQualification Set BoardId = %n,
|
|||
|
|
CgpaOrMarks = %n,CgpaOrMarksOutOf = %n,CvId = %n,DegreeTitleId = %n,DisciplineId = %n,IsHighestEducation = %n,
|
|||
|
|
Name = %s,PassingYear = %n,Result = %n,InstituteName = %s Where EductionalQualificationID = %n",
|
|||
|
|
eduItem.BoardId.Integer,eduItem.CgpaOrMarks,eduItem.CgpaOrMarksOutOf,eduItem.CvId.Integer,eduItem.DegreeTitleId.Integer,
|
|||
|
|
eduItem.DisciplineId.Integer,Convert.ToInt32(eduItem.IsHighestEducation),eduItem.Name,eduItem.PassingYear,eduItem.ResultID.Integer,eduItem.InstituteName,eduItem.ID.Integer);
|
|||
|
|
tc.ExecuteNonQuery(sql);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
internal static void Delete(ID id, TransactionContext tc)
|
|||
|
|
{
|
|||
|
|
string sql = SQLParser.MakeSQL(
|
|||
|
|
@"Delete From CVEductionalQualification Where EductionalQualificationID = %n", id.Integer);
|
|||
|
|
tc.ExecuteNonQuery(sql);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
internal static void DeleteByCvId(ID oID, TransactionContext tc)
|
|||
|
|
{
|
|||
|
|
string sql = SQLParser.MakeSQL(
|
|||
|
|
@"Delete From CVEductionalQualification Where CvId = %n", oID.Integer);
|
|||
|
|
tc.ExecuteNonQuery(sql);
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|