public void Edit(EmpEducationDTO EduDTO)
{
using (var container = new InventoryContainer())
{
var Comp = new EmpEducation();
Comp = container.EmpEducations.FirstOrDefault(o => o.EduId.Equals(EduDTO.EduId));
// Comp = container.EmpEducations .FirstOrDefault(o => o.EmpId.Equals(EduDTO.EmpId));
// Comp.EmpId = EduDTO.EmpId;
// Comp.EduId = EduDTO.EduId;
Comp.Board = EduDTO.Board;
Comp.UpdateBy = EduDTO.UpdateBy;
Comp.Updatedate = EduDTO.Updatedate;
Comp.Cgpa = EduDTO.Cgpa;
Comp.Division = EduDTO.Division;
Comp.Eximination = EduDTO.Eximination;
Comp.InstituteName = EduDTO.InstituteName;
Comp.PassingYear = EduDTO.PassingYear; //problem can be occur
Comp.ResultType = EduDTO.ResultType;
Comp.Note = EduDTO.Note;
Comp = (EmpEducation)DTOMapper.DTOObjectConverter(EduDTO, Comp);
container.SaveChanges();
}
}
public void Add(EmpEducationDTO DTO)
{
using (var container = new InventoryContainer())
{
EmpEducation gur = new EmpEducation();
container.EmpEducations.AddObject((EmpEducation)DTOMapper.DTOObjectConverter(DTO, gur));
container.SaveChanges();
}
}
public DataSet GetEduLevel(EmpEducation objEmpEdu)
{
Hashtable htparams = new Hashtable()
{
{ "@inEduLevel_Id", objEmpEdu.EduLevelId },
{ "@inEduLevel_Name", objEmpEdu.EduLevelName },
{ "@inEduType_Id", objEmpEdu.EduType_Id },
};
return(ExecuteDataSet("get_education", htparams));
}
public DataSet GetEmpEducationList(EmpEducation objEmpEduList)
{
Hashtable htparams = new Hashtable
{
{ "@inS_No", objEmpEduList.S_No },
{ "@inemp_id", objEmpEduList.emp_id },
{ "@inEdu_Type", objEmpEduList.Edu_Type },
{ "@inEdu_Level", objEmpEduList.Edu_Level },
{ "@inSpecialization", objEmpEduList.Specialization },
{ "@inYearOfPassing", objEmpEduList.YearOfPassing },
{ "@inPercentage", objEmpEduList.Percentage },
{ "@inCategory", objEmpEduList.Category },
{ "@inSchoolName", objEmpEduList.SchoolName },
{ "@inBoardName", objEmpEduList.BoardName },
{ "@inStartDate", objEmpEduList.StartDate },
{ "@inEndDate", objEmpEduList.EndDate },
{ "@in_OpName", objEmpEduList.OpName },
};
return(ExecuteDataSet("EmpEducation", htparams));
}
public int InsertEmpEducation(EmpEducation objEmpEdu)
{
Hashtable htparams = new Hashtable
{
{ "@inS_No", objEmpEdu.S_No },
{ "@inemp_id", objEmpEdu.emp_id },
{ "@inEdu_Type", objEmpEdu.Edu_Type },
{ "@inEdu_Level", objEmpEdu.Edu_Level },
{ "@inSpecialization", objEmpEdu.Specialization },
{ "@inYearOfPassing", objEmpEdu.YearOfPassing },
{ "@inPercentage", objEmpEdu.Percentage },
{ "@inCategory", objEmpEdu.Category },
{ "@inSchoolName", objEmpEdu.SchoolName },
{ "@inBoardName", objEmpEdu.BoardName },
{ "@inStartDate", objEmpEdu.StartDate },
{ "@inEndDate", objEmpEdu.EndDate },
{ "@in_OpName", objEmpEdu.OpName },
};
return(ExecuteNonQuery("EmpEducation", htparams));
}
public Task UpdateAsync(EmpEducationModel model)
{
if (model == null)
{
throw new ArgumentNullException("EmpEducationModel ArgumentNullException Insert Async");
}
EmpEducation dto = AutoMapperGenericHelper <EmpEducationModel, EmpEducation> .Convert(model);
EmpEmployeePk pk1 = _empEmployeePkRepository.Get((int)model.EmployeePkId);
dto.EmpEmployeePk = pk1;
if (pk1 == null)
{
throw new ArgumentNullException("EmployeePkId ArgumentNullException Insert Async");
}
_empEducationRepository.Update(dto);
return(Task.FromResult <object>(null));
}
