public static bool SaveEmpRetirement(List <ATTRetirement> LSTRet) { try { return(DLLRetirement.SaveEmpRetirement(LSTRet)); } catch (Exception ex) { throw ex; } }
public static List <ATTRetirement> SearchEmployee(ATTRetirement objEmpRet) { try { List <ATTRetirement> LSTEmpRet = new List <ATTRetirement>(); foreach (DataRow row in DLLRetirement.SearchEmployee(objEmpRet).Rows) { ATTRetirement obj = new ATTRetirement(); obj.empID = int.Parse(row["P_ID"].ToString()); string first_name = row["FIRST_NAME"].ToString(); string mid_name = row["MID_NAME"].ToString(); string sur_name = row["SUR_NAME"].ToString(); if (mid_name != "") { obj.fullName = first_name + " " + mid_name + " " + sur_name; } else { obj.fullName = first_name + " " + sur_name; } //obj.OrgEmpNo = int.Parse(row["ORG_EMP_NO"].ToString()); obj.gender = row["GENDER"].ToString(); obj.orgID = int.Parse(row["ORG_ID"].ToString()); obj.orgName = row["ORG_NAME"].ToString(); obj.desID = int.Parse(row["DES_ID"].ToString()); obj.desName = row["DES_NAME"].ToString(); obj.desType = row["DES_TYPE"].ToString(); obj.createdDate = row["CREATED_DATE"].ToString(); obj.postID = int.Parse(row["POST_ID"].ToString()); obj.fromDate = row["POST_FROM_DATE"].ToString(); obj.action = ""; LSTEmpRet.Add(obj); } return(LSTEmpRet); } catch (Exception ex) { throw ex; } }
public static List <ATTRetirement> GetEmployeeRetirement(ATTRetirement objRetirement, string opt) { List <ATTRetirement> LST = new List <ATTRetirement>(); try { if (opt == "appl") { foreach (DataRow row in DLLRetirement.GetEmployeeRetirement(objRetirement, opt).Rows) { ATTRetirement objEmpRet = new ATTRetirement(); objEmpRet.empID = int.Parse(row["EMP_ID"].ToString()); objEmpRet.orgID = int.Parse(row["ORG_ID"].ToString()); objEmpRet.postID = int.Parse(row["POST_ID"].ToString()); objEmpRet.desID = int.Parse(row["DES_ID"].ToString()); objEmpRet.createdDate = row["CREATED_DATE"].ToString(); objEmpRet.fromDate = row["FROM_DATE"].ToString(); objEmpRet.fullName = row["EMP_NAME"].ToString(); objEmpRet.gender = row["GENDER"].ToString(); objEmpRet.retirementDate = row["RETIREMENT_DATE"].ToString(); objEmpRet.isSelf = row["IS_SELF"].ToString(); objEmpRet.retirementType = row["RETIREMENT_TYPE"].ToString(); objEmpRet.ApplDesc = row["APP_DESC"].ToString(); objEmpRet.isDecided = row["IS_DECIDED"].ToString(); objEmpRet.isApproved = row["IS_APPROVED"].ToString(); LST.Add(objEmpRet); } } else if (opt == "dec") { foreach (DataRow row in DLLRetirement.GetEmployeeRetirement(objRetirement, opt).Rows) { ATTRetirement objEmpRet = new ATTRetirement(); objEmpRet.empID = int.Parse(row["EMP_ID"].ToString()); objEmpRet.orgID = int.Parse(row["ORG_ID"].ToString()); objEmpRet.postID = int.Parse(row["POST_ID"].ToString()); objEmpRet.desID = int.Parse(row["DES_ID"].ToString()); objEmpRet.createdDate = row["CREATED_DATE"].ToString(); objEmpRet.fromDate = row["FROM_DATE"].ToString(); objEmpRet.fullName = row["EMP_NAME"].ToString(); objEmpRet.gender = row["GENDER"].ToString(); objEmpRet.retirementDate = row["RETIREMENT_DATE"].ToString(); objEmpRet.isSelf = row["IS_SELF"].ToString(); objEmpRet.retirementType = row["RETIREMENT_TYPE"].ToString(); objEmpRet.ApplDesc = row["APP_DESC"].ToString(); objEmpRet.decisionDate = row["DECISION_DATE"].ToString(); if (row["DECISION_BY"] != System.DBNull.Value) { objEmpRet.decisionBy = int.Parse(row["DECISION_BY"].ToString()); } objEmpRet.decPerson = row["DECISION_PERSON"].ToString(); objEmpRet.decisionDesc = row["DECISION_DESC"].ToString(); objEmpRet.isDecided = row["IS_DECIDED"].ToString(); objEmpRet.isApproved = row["IS_APPROVED"].ToString(); LST.Add(objEmpRet); } } else if (opt == "appr") { foreach (DataRow row in DLLRetirement.GetEmployeeRetirement(objRetirement, opt).Rows) { ATTRetirement objEmpRet = new ATTRetirement(); objEmpRet.empID = int.Parse(row["EMP_ID"].ToString()); objEmpRet.orgID = int.Parse(row["ORG_ID"].ToString()); objEmpRet.postID = int.Parse(row["POST_ID"].ToString()); objEmpRet.createdDate = row["CREATED_DATE"].ToString(); objEmpRet.fromDate = row["FROM_DATE"].ToString(); objEmpRet.fullName = row["EMP_NAME"].ToString(); objEmpRet.gender = row["GENDER"].ToString(); objEmpRet.retirementDate = row["RETIREMENT_DATE"].ToString(); objEmpRet.isSelf = row["IS_SELF"].ToString(); objEmpRet.retirementType = row["RETIREMENT_TYPE"].ToString(); objEmpRet.ApplDesc = row["APP_DESC"].ToString(); objEmpRet.decisionDate = row["DECISION_DATE"].ToString(); objEmpRet.decisionBy = int.Parse(row["DECISION_BY"].ToString()); objEmpRet.decPerson = row["DECISION_PERSON"].ToString(); objEmpRet.decisionDesc = row["DECISION_DESC"].ToString(); objEmpRet.appDate = row["APP_DATE"].ToString(); if (row["APP_BY"] != System.DBNull.Value) { objEmpRet.appBy = int.Parse(row["APP_BY"].ToString()); } objEmpRet.apprPerson = row["APP_PERSON"].ToString(); objEmpRet.appDesc = row["APP_DESC"].ToString(); objEmpRet.isDecided = row["IS_DECIDED"].ToString(); objEmpRet.isApproved = row["IS_APPROVED"].ToString(); LST.Add(objEmpRet); } } return(LST); } catch (Exception ex) { throw ex; } }