protected void Page_Load(object sender, EventArgs e) { //this.SrchGrid.Height = Unit.Pixel(0); Response.ExpiresAbsolute = DateTime.Now.AddDays(-1d); Response.Expires = -1500; Response.CacheControl = "no-cache"; //block if without login if (Session["Login_User_Detail"] == null) { Response.Redirect("~/MODULES/Login.aspx", true); } //block if from URL ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]); //if (user.MenuList.ContainsKey("3,59,1") == true) //{ if (!IsPostBack) { LoadAllOrganizationNameList(); Session["EmployeeDuptation"] = new ATTEmployeeDeputaion(); LoadEmpCurentPostingInfo(user.PID); LoadEmpDeputationInfo(); } //} //else // Response.Redirect("~/MODULES/Login.aspx", true); }
protected void btnAdd_Click(object sender, EventArgs e) { ATTUserLogin user = ((ATTUserLogin)Session["Login_User_Detail"]); ATTEmployeeDeputaion obj = (ATTEmployeeDeputaion)Session["EmployeeDuptation"]; ATTEmployeePosting objEcp = (ATTEmployeePosting)Session["EmployeeCurentPosting"]; obj.EmpID = user.PID; obj.OrgID = user.OrgID; obj.DesID = objEcp.DesID; obj.CreatedDate = objEcp.CreatedDate; obj.PostID = objEcp.PostID; obj.FromDate = objEcp.FromDate; obj.ApplicationDate = txtAppdate_DT.Text; obj.DepOrgID = int.Parse(ddlOrganization.SelectedValue); //obj.DecisionVerifiedBy = ""; //obj.LeaveDate = ""; //obj.LeaveVerifiedBy = ""; //obj.ReturnDate = ""; //obj.ReturnVerifiedBy = ""; obj.Responsibilities = txtdescription.Text; obj.Active = "Y"; obj.EntryBy = user.UserName; //obj.TipOrgID = ""; // obj.TippaniID = ""; //obj.DecisionDate = ""; obj.Action = "A"; if (this.ddlOrganization.SelectedIndex <= 0) { this.lblStatusMessage.Text = "Please select organization Name."; this.programmaticModalPopup.Show(); this.lblStatus.Focus(); return; } if (this.txtAppdate_DT.Text == "") { this.lblStatusMessage.Text = "Please Enter Application Date."; this.programmaticModalPopup.Show(); this.lblStatus.Focus(); return; } if (this.txtdescription.Text == "") { this.lblStatusMessage.Text = "Please Enter Responsibilities."; this.programmaticModalPopup.Show(); this.lblStatus.Focus(); return; } if (BLLEmployeeDeputation.AddEmpForDeputationDetail(obj)) { this.lblStatusMessage.Text = "Information Saved"; this.programmaticModalPopup.Show(); } else { this.lblStatusMessage.Text = "Information could not be Saved"; this.programmaticModalPopup.Show(); } ClearControl(); }
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); } }
private ATTEmployeeDeputaion GetEmployeeFilterDep() { ATTEmployeeDeputaion EmployeeSearch = new ATTEmployeeDeputaion(); EmployeeSearch.OrgID = int.Parse(Session["Orgid"].ToString()); EmployeeSearch.Active = "Y"; //if (this.ddlPost.SelectedIndex > 0) EmployeeSearch.DesID = int.Parse(this.ddlPost.SelectedValue); //if (this.ddlUnit.SelectedIndex > 0) EmployeeSearch.UnitID = int.Parse(this.ddlBranch.SelectedValue); //if (this.ddlSection.SelectedIndex > 0) EmployeeSearch.SectionID = int.Parse(this.ddlFant.SelectedValue); //EmployeeSearch.DesType = "O"; //EmployeeSearch.ToDate = null; return(EmployeeSearch); }
private ATTEmployeeDeputaion GetEmployeeFilter() { ATTEmployeeDeputaion EmployeeSearch = new ATTEmployeeDeputaion(); if (this.ddlOrganization.SelectedIndex > 0) { EmployeeSearch.OrgID = int.Parse(this.ddlOrganization.SelectedValue); } EmployeeSearch.Active = "Y"; //if (this.ddlPost.SelectedIndex > 0) EmployeeSearch.DesID = int.Parse(this.ddlPost.SelectedValue); //if (this.ddlUnit.SelectedIndex > 0) EmployeeSearch.UnitID = int.Parse(this.ddlBranch.SelectedValue); //if (this.ddlSection.SelectedIndex > 0) EmployeeSearch.SectionID = int.Parse(this.ddlFant.SelectedValue); //EmployeeSearch.DesType = "O"; //EmployeeSearch.ToDate = null; return(EmployeeSearch); }
public static bool AddEmpForDeputationDetail(ATTEmployeeDeputaion obj) // added by shanjeev { string sp = ""; if (obj.Action == "A") { sp = "SP_ADD_EMP_DEPUTATION"; } List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam("p_emp_id", obj.EmpID, OracleDbType.Double, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_org_id", obj.OrgID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_des_id", obj.DesID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_created_date", obj.CreatedDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_post_id ", obj.PostID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_from_date ", obj.FromDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_application_date ", obj.ApplicationDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_decision_date", obj.DecisionDate, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_dep_org_id ", obj.DepOrgID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_decision_ver_by", obj.DecisionVerifiedBy, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_responsibilities", obj.Responsibilities, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_active", obj.Active, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("p_entry_by", obj.EntryBy, OracleDbType.Varchar2, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIP_ORG_ID", obj.TipOrgID, OracleDbType.Int32, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_TIPPANI_ID", obj.TippaniID, OracleDbType.Int32, ParameterDirection.Input)); GetConnection GetConn = new GetConnection(); OracleTransaction Tran = GetConn.GetDbConn(Module.PMS).BeginTransaction(); try { SqlHelper.ExecuteNonQuery(Tran, System.Data.CommandType.StoredProcedure, sp, paramArray.ToArray()); Tran.Commit(); return(true); } catch (Exception ex) { Tran.Rollback(); throw new Exception("Error occur while adding duptation details" + ex.Message); } finally { GetConn.CloseDbConn(); } }
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; } }
private ATTEmployeeDeputaion GetFilter() { ATTEmployeeDeputaion DeputedEmployeeSearch = new ATTEmployeeDeputaion(); if (this.txtSymbolNo.Text.Trim() != "") { DeputedEmployeeSearch.SymbolNo = this.txtSymbolNo.Text.Trim(); } if (this.txtFName.Text.Trim() != "") { DeputedEmployeeSearch.FirstName = this.txtFName.Text.Trim(); } if (this.txtMName.Text.Trim() != "") { DeputedEmployeeSearch.MiddleName = this.txtMName.Text.Trim(); } if (this.txtSurName.Text.Trim() != "") { DeputedEmployeeSearch.LastName = this.txtSurName.Text.Trim(); } if (this.ddlGender.SelectedIndex > 0) { DeputedEmployeeSearch.Gender = this.ddlGender.SelectedValue; } if (this.txtDOB.Text.Trim() != "") { DeputedEmployeeSearch.DOB = this.txtDOB.Text.Trim(); } if (this.ddlOrganization.SelectedIndex > 0) { DeputedEmployeeSearch.OrgID = int.Parse(this.ddlOrganization.SelectedValue); } if (this.ddlDeputedOrgs.SelectedIndex > 0) { DeputedEmployeeSearch.DepOrgID = int.Parse(this.ddlDeputedOrgs.SelectedValue); } return(DeputedEmployeeSearch); }
public static DataTable GetEmpForDeputation(ATTEmployeeDeputaion objDP, string choice) { GetConnection conn = new GetConnection(); OracleConnection obj = conn.GetDbConn(Module.PMS); string SelectSP = ""; if (choice == "wod") { SelectSP = "SP_GET_EMP_WO_DEPUTATION"; } else if (choice == "wld") { SelectSP = "SP_GET_EMP_W_DEP_WO_LEAVE"; } else if (choice == "wd") { SelectSP = "SP_GET_EMP_W_DEPUTATION"; } List <OracleParameter> paramArray = new List <OracleParameter>(); paramArray.Add(Utilities.GetOraParam("P_ORG_ID", objDP.OrgID, OracleDbType.Double, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_ACTIVE", objDP.Active, OracleDbType.Varchar2, ParameterDirection.Input)); //paramArray.Add(Utilities.GetOraParam("P_ORG_ID", objEmpDep.OrgID, OracleDbType.Double, ParameterDirection.Input)); //paramArray.Add(Utilities.GetOraParam("P_ORG_ID", objEmpDep.OrgID, OracleDbType.Double, ParameterDirection.Input)); //paramArray.Add(Utilities.GetOraParam("P_ORG_ID", objEmpDep.OrgID, OracleDbType.Double, ParameterDirection.Input)); paramArray.Add(Utilities.GetOraParam("P_RC", null, OracleDbType.RefCursor, ParameterDirection.Output)); try { DataSet ds = SqlHelper.ExecuteDataset(obj, CommandType.StoredProcedure, SelectSP, paramArray.ToArray()); return((DataTable)ds.Tables[0]); } catch (Exception ex) { throw ex; } }
public static DataTable SearchEmployeeDeputation(ATTEmployeeDeputaion objEmployee, string searchType) { try { string strSelectSQL = ""; if (searchType == "All") { strSelectSQL = "SELECT DISTINCT A.EMP_ID,A.EMP_NAME,A.FIRST_NAME,A.MID_NAME,A.SUR_NAME,A.DOB,A.GENDER,A.SYMBOL_NO," + "A.ORG_EMP_NO,A.ORG_ID,A.ORG_NAME,A.DES_ID,A.DES_NAME,A.DES_TYPE,A.FROM_DATE FROM VW_EMP_DEPUTATION A WHERE 1=1"; } else if (searchType == "Current") { strSelectSQL = "SELECT DISTINCT A.EMP_ID,A.EMP_NAME,A.FIRST_NAME,A.MID_NAME,A.SUR_NAME,A.DOB,A.GENDER,A.SYMBOL_NO," + "A.ORG_EMP_NO,A.ORG_ID,A.ORG_NAME,A.DES_ID,A.DES_NAME,A.DES_TYPE,A.FROM_DATE FROM VW_EMP_DEPUTATION A WHERE A.ORG_ID IS NOT NULL"; } int i = 0; if (objEmployee.EmpID != 0.0) { i++; } if (objEmployee.FirstName != null) { i++; } if (objEmployee.MiddleName != null) { i++; } if (objEmployee.LastName != null) { i++; } if (objEmployee.Gender != null) { i++; } if (objEmployee.DOB != null) { i++; } if (objEmployee.SymbolNo != null) { i++; } if (objEmployee.DesID != 0) { i++; } if (objEmployee.OrgID != 0) { i++; } if (objEmployee.DepOrgID != 0) { i++; } OracleParameter[] ParamArray = new OracleParameter[i]; int j = 0; if (objEmployee.EmpID != 0.0) { strSelectSQL += " AND A.EMP_ID =:EmpID"; ParamArray[j] = Utilities.GetOraParam(":EmpID", objEmployee.EmpID, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.FirstName != null) { strSelectSQL += " AND A.FIRST_NAME LIKE :FName||'%'"; ParamArray[j] = Utilities.GetOraParam(":FName", objEmployee.FirstName, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.MiddleName != null) { strSelectSQL += " AND A.MID_NAME LIKE :MName||'%'"; ParamArray[j] = Utilities.GetOraParam(":MName", objEmployee.MiddleName, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.LastName != null) { strSelectSQL += " AND A.SUR_NAME LIKE :SurName||'%'"; ParamArray[j] = Utilities.GetOraParam(":SurName", objEmployee.LastName, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.Gender != null) { strSelectSQL += " AND A.GENDER = :Gender"; ParamArray[j] = Utilities.GetOraParam(":Gender", objEmployee.Gender, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.DOB != null) { strSelectSQL += " AND A.DOB = :DOB"; ParamArray[j] = Utilities.GetOraParam(":DOB", objEmployee.DOB, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.SymbolNo != null) { strSelectSQL += " AND A.SYMBOL_NO = :SymbolNo"; ParamArray[j] = Utilities.GetOraParam(":SymbolNo", objEmployee.SymbolNo, OracleDbType.Varchar2, ParameterDirection.Input); j++; } if (objEmployee.DesID != 0) { strSelectSQL += " AND A.DES_ID = :DesID"; ParamArray[j] = Utilities.GetOraParam(":DesID", objEmployee.DesID, OracleDbType.Int64, ParameterDirection.Input); j++; } if (objEmployee.OrgID != 0) { strSelectSQL += " AND A.ORG_ID = :OrgID"; ParamArray[j] = Utilities.GetOraParam(":OrgID", objEmployee.OrgID, OracleDbType.Int64, ParameterDirection.Input); j++; } if (objEmployee.DepOrgID != 0) { strSelectSQL += " AND A.DEP_ORG_ID = :DepOrgID"; ParamArray[j] = Utilities.GetOraParam(":DepOrgID", objEmployee.DepOrgID, OracleDbType.Int64, ParameterDirection.Input); j++; } strSelectSQL += " ORDER BY A.EMP_ID"; DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, strSelectSQL, Module.PMS, ParamArray); return((DataTable)ds.Tables[0]); } catch (OracleException oex) { PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError(); throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message)); } catch (Exception ex) { throw ex; } }
protected void btnSave_Click(object sender, EventArgs e) { if (this.txtDecisionDate.Text == "") { this.lblStatusMessage.Text = "र्कपया काज निर्णय मिति बर्नुहोस्"; this.programmaticModalPopup.Show(); return; } double empId = double.Parse(Server.HtmlDecode(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[0].Text).ToString()); foreach (GridViewRow row in this.grdEmpDepRamana.Rows) { if (int.Parse(row.Cells[0].Text) == empId) { this.lblStatusMessage.Text = "**कर्मचारी काजको लागि सिफारिस भैसकेको छ"; this.programmaticModalPopup.Show(); return; } } int orgId = int.Parse(Server.HtmlDecode(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[3].Text).ToString()); int desId = int.Parse(Server.HtmlDecode(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[5].Text).ToString()); string createdDate = Server.HtmlDecode(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[7].Text).ToString(); int postId = int.Parse(Server.HtmlDecode(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[8].Text).ToString()); string fromDate = Server.HtmlDecode(grdEmployee.Rows[grdEmployee.SelectedIndex].Cells[9].Text).ToString(); string decisionDate = this.txtDecisionDate.Text; int dep_org_id = int.Parse(this.ddlDeputationOrganization.SelectedValue); int dicision_ver_by = 0; string responsibility = this.txtResponsibility.Text; string active = "Y"; string entry_by = Session["UserName"].ToString(); List <ATTEmployeeDeputaion> LSTAddDep; if (Session["EmpDepNoLeave"] != null) { LSTAddDep = (List <ATTEmployeeDeputaion>)Session["EmpDepNoLeave"]; } else { LSTAddDep = new List <ATTEmployeeDeputaion>(); } if (this.ddlDeputationOrganization.SelectedIndex < -1) { this.lblStatusMessage.Text = "काज कार्यालय छान्नुहोस्"; this.programmaticModalPopup.Show(); } else if (this.ddlDeputationOrganization.SelectedIndex > 0) { ATTEmployeeDeputaion objAddDep = new ATTEmployeeDeputaion(); objAddDep.EmpID = empId; objAddDep.OrgID = orgId; objAddDep.DesID = desId; objAddDep.CreatedDate = createdDate; objAddDep.PostID = postId; objAddDep.FromDate = fromDate; objAddDep.DecisionDate = decisionDate; objAddDep.DepOrgID = dep_org_id; objAddDep.DecisionVerifiedBy = dicision_ver_by; objAddDep.Responsibilities = responsibility; objAddDep.Active = active; objAddDep.EntryBy = entry_by; objAddDep.Action = "A"; objAddDep.LeaveDate = ""; objAddDep.LeaveVerifiedBy = 0; LSTAddDep.Add(objAddDep); //Session["DeputaionWOLeave"] = LSTAddDep; if (BLLEmployeeDeputation.SaveEmpForDeputation(LSTAddDep)) { this.lblStatusMessage.Text = "Employee Deputation Saved Successfully"; this.programmaticModalPopup.Show(); Session["EmpDepNoLeave"] = BLLEmployeeDeputation.GetEmpForDeputation(GetEmployeeFilterDep(), "wld"); grdEmpDepRamana.DataSource = Session["EmpDepNoLeave"]; grdEmpDepRamana.DataBind(); //grdEmployee.DataSource = BLLEmployeeDeputation.GetEmpForDeputation(GetEmployeeFilter(), "wod"); //this.grdEmployee.DataBind(); this.ddlDeputationOrganization.SelectedIndex = -1; this.txtDecisionDate.Text = ""; this.txtResponsibility.Text = ""; this.txtVerifiedBy.Text = ""; return; } } }
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; } }