public static List <ATTInsurance> GetEmpInsurance(double empID) { try { List <ATTInsurance> LSTInsurance = new List <ATTInsurance>(); ATTInsurance objInsurance = new ATTInsurance(); foreach (DataRow rw in DLLInsurance.GetEmpInsurance(empID).Rows) { objInsurance.CompanyName = rw["COMPANY_NAME"].ToString(); objInsurance.InsuranceNo = rw["INSURANCE_NO"].ToString(); objInsurance.FromDate = rw["FROM_DATE"].ToString(); objInsurance.MaturityDate = rw["MATURITY_DATE"].ToString(); LSTInsurance.Add(objInsurance); } return(LSTInsurance); } catch (Exception ex) { throw ex; } }
public static bool SaveEmployeeDetails(ATTEmployee objEmployee) { GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.PMS).BeginTransaction(); double employeeID; //double relativeID = 0; try { employeeID = DLLPerson.AddPersonnelDetails(objEmployee.ObjPerson, Tran); OracleParameter[] paramArray = new OracleParameter[7]; paramArray[0] = Utilities.GetOraParam(":p_EMP_ID", employeeID, OracleDbType.Double, ParameterDirection.Input); paramArray[1] = Utilities.GetOraParam(":p_SYMBOL_NO", objEmployee.SymbolNo, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[2] = Utilities.GetOraParam(":p_ORG_EMP_NO", objEmployee.OrgEmpNo, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[3] = Utilities.GetOraParam(":p_IDENTITY_MARK", objEmployee.IdentityMark, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[4] = Utilities.GetOraParam(":p_ENTRY_BY", objEmployee.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[5] = Utilities.GetOraParam(":p_PF_NO", objEmployee.PFNo, OracleDbType.Varchar2, ParameterDirection.Input); paramArray[6] = Utilities.GetOraParam(":p_CIT_NO", objEmployee.CitznNo, OracleDbType.Varchar2, ParameterDirection.Input); if (objEmployee.EmpID == 0) { SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "SP_ADD_EMPLOYEES", paramArray[0], paramArray); } else if (objEmployee.EmpID > 0) { SqlHelper.ExecuteNonQuery(Tran, CommandType.StoredProcedure, "SP_EDIT_EMPLOYEES", paramArray[0], paramArray); } if (objEmployee.LstEmployeeVisits.Count > 0) { DLLEmployeeVisits.AddEmployeeVisits(objEmployee.LstEmployeeVisits, Tran, employeeID); } if (objEmployee.LstEmployeeExperience.Count > 0) { DLLEmployeeExperience.AddEmployeeExperiences(objEmployee.LstEmployeeExperience, Tran, employeeID); } if (objEmployee.LstEmployeePosting.Count > 0) { DLLEmployeePosting.SaveEmployeePosting(objEmployee.LstEmployeePosting, Tran, employeeID); } if (objEmployee.LstEmployeePublication.Count > 0) { DLLEmployeePublication.AddEmployeePublication(objEmployee.LstEmployeePublication, Tran, employeeID); } if (objEmployee.LstEmployeeBeneficiary.Count > 0) { DLLEmployeeBeneficiary.SaveBeneficiary(objEmployee.LstEmployeeBeneficiary, Tran, employeeID); } if (objEmployee.LstInsurance.Count > 0) { DLLInsurance.SaveEmpInsurance(objEmployee.LstInsurance, Tran, employeeID); } if (objEmployee.LSTAttachments.Count > 0) { DLLPersonAttachments.SaveAttachments(objEmployee.LSTAttachments, Tran, employeeID); } if (objEmployee.ObjUser.Username != "" && objEmployee.ObjUser.Password != "") { DLLUsers.SaveUsers(objEmployee.ObjUser, Tran, employeeID); } if (objEmployee.OrgUser.Username != "") { DLLOrganizationUSers.SaveOrganizationUsers(objEmployee.OrgUser, Tran, employeeID); } if (objEmployee.LSTEmpDeputation != null) { DLLEmployeeDeputation.SaveEmpployeeDeputation(objEmployee.LSTEmpDeputation, Tran, employeeID); } if (objEmployee.LstManonayan.Count > 0) { DLLManonayan.SaveManonayan(objEmployee.LstManonayan, Tran, employeeID); } objEmployee.EmpID = employeeID; Tran.Commit(); return(true); } catch (OracleException oex) { PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError(); throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message)); } catch (Exception ex) { Tran.Rollback(); throw ex; } finally { GetConn.CloseDbConn(); } }