private void EmployeeHKInfoSave(ArrayList empInfo) { CustomList <EmployeeHKInfo> EmpHKList = new CustomList <EmployeeHKInfo>(); foreach (ASL.Hr.DAO.EntityList M in _EntityList) { if (M.IsUsed) { DropDownList ddl = new DropDownList(); EmployeeHKInfo newEHKI = new EmployeeHKInfo(); ddl = (DropDownList)Panel1.FindControl("ddl" + M.EntityName.ToString()); if (ddl.SelectedValue == "") { continue; } newEHKI.HKID = ddl.SelectedValue.ToInt(); newEHKI.HKName = M.EntityName.ToString(); EmpHKList.Add(newEHKI); } } var empHKInfoList = (CustomList <EmployeeHKInfo>)EmpHKList; empInfo.Add(empHKInfoList); }
public CustomList <EmployeeHKInfo> GetAllEmployeeHKInfo(Int64 empKey) { return(EmployeeHKInfo.GetAllEmployeeHKInfo(empKey)); }
public void SaveEmployeeInfo(ArrayList empInfo, string mode = "insert") { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); Boolean blnTranStarted = false; try { conManager.BeginTransaction(); blnTranStarted = true; #region save parent var genInfo = (CustomList <HRM_Emp>)empInfo[0]; ReSetSPName(genInfo); long empKey = genInfo[0].EmpKey; if (mode == "insert") { empKey = Convert.ToInt32(conManager.InsertData(blnTranStarted, genInfo)); } else { conManager.SaveDataCollectionThroughCollection(blnTranStarted, genInfo); } genInfo.AcceptChanges(); #endregion var addr = (CustomList <HRM_EmpAddr>)empInfo[1]; addr.ForEach(x => x.EmpKey = empKey); ReSetSPName(addr); conManager.SaveDataCollectionThroughCollection(blnTranStarted, addr); addr.AcceptChanges(); var EmergencyContact = (CustomList <EmployeeEmergencyInfo>)empInfo[2]; EmergencyContact.ForEach(x => x.EmpKey = empKey); ReSetSPName(EmergencyContact); conManager.SaveDataCollectionThroughCollection(blnTranStarted, EmergencyContact); EmergencyContact.AcceptChanges(); var JobResponsibility = (CustomList <JobResponsibility>)empInfo[3]; JobResponsibility.ForEach(x => x.EmpKey = empKey); ReSetSPName(JobResponsibility); conManager.SaveDataCollectionThroughCollection(blnTranStarted, JobResponsibility); JobResponsibility.AcceptChanges(); var edu = (CustomList <HRM_EmpEdu>)empInfo[4]; edu.ForEach(x => x.EmpKey = empKey); ReSetSPName(edu); conManager.SaveDataCollectionThroughCollection(blnTranStarted, edu); edu.AcceptChanges(); var dip = (CustomList <HRM_EmpEduDip>)empInfo[5]; dip.ForEach(x => x.EmpKey = empKey); ReSetSPName(dip); conManager.SaveDataCollectionThroughCollection(blnTranStarted, dip); dip.AcceptChanges(); var hist = (CustomList <HRM_EmpEmployment>)empInfo[6]; hist.ForEach(x => x.EmpKey = empKey); ReSetSPName(hist); conManager.SaveDataCollectionThroughCollection(blnTranStarted, hist); hist.AcceptChanges(); var file = (CustomList <HRM_EmpFileAttach>)empInfo[7]; file.ForEach(x => x.EmpKey = empKey); ReSetSPName(file); conManager.SaveDataCollectionThroughCollection(blnTranStarted, file); file.AcceptChanges(); CustomList <EmployeeHKInfo> deletedHKInfoList = new CustomList <EmployeeHKInfo>(); EmployeeHKInfo newHKInfo = new EmployeeHKInfo(); newHKInfo.EmpKey = empKey; newHKInfo.Delete(); deletedHKInfoList.Add(newHKInfo); deletedHKInfoList.DeleteSpName = "spDeleteEmployeeHKInfo"; var OfficalInfo = (CustomList <EmployeeHKInfo>)empInfo[8]; OfficalInfo.ForEach(x => x.EmpKey = empKey); ReSetSPName(OfficalInfo); conManager.SaveDataCollectionThroughCollection(blnTranStarted, deletedHKInfoList, OfficalInfo); OfficalInfo.AcceptChanges(); //Delete from Employee Salary CustomList <EmployeeSalary> deletedSalaryList = new CustomList <EmployeeSalary>(); EmployeeSalary eS = new EmployeeSalary(); eS.EmpKey = empKey; eS.Delete(); deletedSalaryList.Add(eS); deletedSalaryList.DeleteSpName = "spDeleteRoleEmployeeSalary"; var EmpSalary = (CustomList <EmployeeSalaryTemp>)empInfo[9]; EmpSalary.ForEach(x => x.EmpKey = empKey); ReSetSPName(EmpSalary); conManager.SaveDataCollectionThroughCollection(blnTranStarted, deletedSalaryList, EmpSalary); EmpSalary.AcceptChanges(); deletedSalaryList.AcceptChanges(); var EmpLanguage = (CustomList <LanguageInfo>)empInfo[10]; EmpLanguage.ForEach(x => x.EmpKey = empKey); ReSetSPName(EmpLanguage); conManager.SaveDataCollectionThroughCollection(blnTranStarted, EmpLanguage); EmpLanguage.AcceptChanges(); var EmpFamilyDet = (CustomList <HRM_EmpFamDet>)empInfo[11]; EmpFamilyDet.ForEach(x => x.EmpKey = empKey); ReSetSPName(EmpFamilyDet); conManager.SaveDataCollectionThroughCollection(blnTranStarted, EmpFamilyDet); EmpFamilyDet.AcceptChanges(); var MedicalAllowance = (CustomList <MedicalReinSetup>)empInfo[12]; MedicalAllowance.ForEach(x => x.EmpKey = empKey); ReSetSPName(MedicalAllowance); conManager.SaveDataCollectionThroughCollection(blnTranStarted, MedicalAllowance); MedicalAllowance.AcceptChanges(); conManager.CommitTransaction(); blnTranStarted = false; conManager.Dispose(); } catch (Exception Ex) { conManager.RollBack(); throw Ex; } finally { if (conManager.IsNotNull()) { conManager.Dispose(); } } }