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)); }