public static List <ATTEmployeeDeputaion> SearchEmployeeDeputation(ATTEmployeeDeputaion objEmployee, string searchType) //flag defines whether or not to load employee other attributes.0-no,1-yes { List <ATTEmployeeDeputaion> lstEmployee = new List <ATTEmployeeDeputaion>(); foreach (DataRow row in DLLEmployeeDeputation.SearchEmployeeDeputation(objEmployee, searchType).Rows) { ATTEmployeeDeputaion obj = new ATTEmployeeDeputaion(); obj.EmpName = row["EMP_NAME"].ToString(); obj.EmpID = int.Parse(row["EMP_ID"].ToString()); obj.SymbolNo = ((row["SYMBOL_NO"] == System.DBNull.Value) ? "" : (string)row["SYMBOL_NO"]); obj.Gender = ((row["GENDER"] == System.DBNull.Value) ? "" : (string)row["GENDER"]); obj.DOB = ((row["DOB"] == System.DBNull.Value) ? "" : (string)row["DOB"]); if (!(row["ORG_EMP_NO"] == System.DBNull.Value)) { obj.OrgEmpNo = int.Parse(row["ORG_EMP_NO"].ToString()); } else { obj.OrgEmpNo = null; } lstEmployee.Add(obj); } return(lstEmployee); }
public static List <ATTEmployeeDeputaion> GetEmpForDeputationReturn(int orgid, string active) { try { List <ATTEmployeeDeputaion> LSTEmpDepReturn = new List <ATTEmployeeDeputaion>(); foreach (DataRow row in DLLEmployeeDeputation.GetEmpForDepReturn(orgid, active).Rows) { ATTEmployeeDeputaion objEmpDepReturn = new ATTEmployeeDeputaion(); objEmpDepReturn.EmpID = int.Parse(row["p_id"].ToString()); objEmpDepReturn.EmpName = row["employeename"].ToString(); objEmpDepReturn.Gender = row["gender"].ToString(); objEmpDepReturn.OrgID = int.Parse(row["org_id"].ToString()); objEmpDepReturn.OrgName = row["org_name"].ToString(); objEmpDepReturn.DesID = int.Parse(row["des_id"].ToString()); objEmpDepReturn.DesName = row["des_name"].ToString(); objEmpDepReturn.CreatedDate = row["created_date"].ToString(); objEmpDepReturn.PostID = int.Parse(row["post_id"].ToString()); objEmpDepReturn.PostFromDate = row["from_date"].ToString(); objEmpDepReturn.DecisionDate = row["decision_date"].ToString(); objEmpDepReturn.DepOrgID = int.Parse(row["dep_org_id"].ToString()); objEmpDepReturn.DepOrgName = row["dep_org_name"].ToString(); objEmpDepReturn.LeaveDate = row["leave_date"].ToString(); objEmpDepReturn.ReturnDate = row["return_date"].ToString(); objEmpDepReturn.Responsibilities = row["responsibilities"].ToString(); LSTEmpDepReturn.Add(objEmpDepReturn); } return(LSTEmpDepReturn); } catch (Exception ex) { throw ex; } }
public static bool AddEmpForDeputationDetail(ATTEmployeeDeputaion obj) { try { return(DLLEmployeeDeputation.AddEmpForDeputationDetail(obj)); } catch (Exception ex) { throw new Exception("Error occur while adding Duptation" + ex.Message); } }
public static bool SaveEmpForDeputation(List <ATTEmployeeDeputaion> LSTEmpDep) { try { DLLEmployeeDeputation.SaveEmpForDeputation(LSTEmpDep); } catch (Exception ex) { throw ex; } return(true); }
public static List <ATTEmployeeDeputaion> GetDeputationOrganisation() { List <ATTEmployeeDeputaion> lstDepOrg = new List <ATTEmployeeDeputaion>(); try { foreach (DataRow row in DLLEmployeeDeputation.GetDeputationOrganisations().Rows) { ATTEmployeeDeputaion obj = new ATTEmployeeDeputaion(); obj.DepOrgID = int.Parse(row["DEP_ORG_ID"].ToString()); obj.DepOrgName = row["DEP_ORG_NAME"].ToString(); lstDepOrg.Add(obj); } } catch (Exception ex) { throw ex; } return(lstDepOrg); }
public static List <ATTEmployeeDeputaion> GetEmpForDeputationInfo(int?orgid, string active, double empid) { try { List <ATTEmployeeDeputaion> lstEmployeeDeputaion = new List <ATTEmployeeDeputaion>(); foreach (DataRow row in DLLEmployeeDeputation.GetEmpForDeputationInfo(orgid, active, empid).Rows) { ATTEmployeeDeputaion objEmpDeputation = new ATTEmployeeDeputaion(); //if (row["org_id"].ToString() != "") //{ // objEmpDeputation.OrgID = int.Parse(row["org_id"].ToString()); //} objEmpDeputation.DepOrgName = row["dep_org_name"].ToString(); //objEmpDeputation.DesName = row["des_name"].ToString(); if (row["des_id"].ToString() != "") { objEmpDeputation.DesID = int.Parse(row["des_id"].ToString()); } objEmpDeputation.DecisionDate = row["decision_date"].ToString(); if (row["decision_ver_by"].ToString() != "") { objEmpDeputation.DecisionVerifiedBy = int.Parse(row["decision_ver_by"].ToString()); } objEmpDeputation.ApplicationDate = row["application_date"].ToString(); //if (row["dep_org_id"].ToString() != "") //{ // objEmpDeputation.DepOrgID = int.Parse(row["dep_org_id"].ToString()); //} objEmpDeputation.DepOrgName = row["dep_org_name"].ToString(); objEmpDeputation.LeaveDate = row["leave_date"].ToString(); objEmpDeputation.ReturnDate = row["return_date"].ToString(); objEmpDeputation.Responsibilities = row["responsibilities"].ToString(); lstEmployeeDeputaion.Add(objEmpDeputation); } return(lstEmployeeDeputaion); } catch (Exception ex) { throw ex; } }
public static List <ATTEmployeeDeputaion> GetEmpForDeputation(ATTEmployeeDeputaion obj, string choice) { try { List <ATTEmployeeDeputaion> LSTDep = new List <ATTEmployeeDeputaion>(); if (choice == "wod") { foreach (DataRow row in DLLEmployeeDeputation.GetEmpForDeputation(obj, choice).Rows) { ATTEmployeeDeputaion objDep = new ATTEmployeeDeputaion(); objDep.EmpID = double.Parse(row["p_id"].ToString()); objDep.EmpName = row["employeename"].ToString(); objDep.Gender = row["gender"].ToString(); objDep.OrgID = int.Parse(row["org_id"].ToString()); objDep.OrgName = row["org_name"].ToString(); objDep.DesID = int.Parse(row["des_id"].ToString()); objDep.DesName = row["des_name"].ToString(); objDep.CreatedDate = row["created_date"].ToString(); objDep.PostID = int.Parse(row["post_id"].ToString()); objDep.FromDate = row["from_date"].ToString(); objDep.Action = ""; LSTDep.Add(objDep); } } else if (choice == "wld") { foreach (DataRow row in DLLEmployeeDeputation.GetEmpForDeputation(obj, choice).Rows) { ATTEmployeeDeputaion objDep = new ATTEmployeeDeputaion(); objDep.EmpID = double.Parse(row["p_id"].ToString()); objDep.EmpName = row["employeename"].ToString(); objDep.Gender = row["gender"].ToString(); objDep.OrgID = int.Parse(row["org_id"].ToString()); objDep.OrgName = row["org_name"].ToString(); objDep.DesID = int.Parse(row["des_id"].ToString()); objDep.DesName = row["des_name"].ToString(); objDep.CreatedDate = row["created_date"].ToString(); objDep.PostID = int.Parse(row["post_id"].ToString()); objDep.FromDate = row["from_date"].ToString(); objDep.DecisionDate = row["decision_date"].ToString(); objDep.DepOrgID = int.Parse(row["dep_org_id"].ToString()); objDep.DepOrgName = row["dep_org_name"].ToString(); objDep.Responsibilities = row["responsibilities"].ToString(); objDep.Action = ""; LSTDep.Add(objDep); } } else if (choice == "wd") { foreach (DataRow row in DLLEmployeeDeputation.GetEmpForDeputation(obj, choice).Rows) { ATTEmployeeDeputaion objDep = new ATTEmployeeDeputaion(); objDep.EmpID = double.Parse(row["p_id"].ToString()); objDep.EmpName = row["employeename"].ToString(); objDep.Gender = row["gender"].ToString(); objDep.OrgID = int.Parse(row["org_id"].ToString()); objDep.OrgName = row["org_name"].ToString(); objDep.DesID = int.Parse(row["des_id"].ToString()); objDep.DesName = row["des_name"].ToString(); objDep.CreatedDate = row["created_date"].ToString(); objDep.PostID = int.Parse(row["post_id"].ToString()); objDep.FromDate = row["from_date"].ToString(); objDep.DecisionDate = row["decision_date"].ToString(); objDep.DepOrgID = int.Parse(row["dep_org_id"].ToString()); objDep.DepOrgName = row["dep_org_name"].ToString(); objDep.Responsibilities = row["responsibilities"].ToString(); objDep.LeaveDate = row["leave_date"].ToString(); objDep.ReturnDate = row["return_date"].ToString(); objDep.Action = ""; LSTDep.Add(objDep); } } return(LSTDep); } catch (Exception ex) { throw ex; } }