protected void btnSubmitAdd_Click(object sender, EventArgs e) { try { clsEmployeeHierarchy objHierarchy = new clsEmployeeHierarchy(); objHierarchy.CreatedBy = Session["uid"].ToString(); objHierarchy.MngrID = lstManager.SelectedValue; objHierarchy.RowID = ViewState["rowID"].ToString(); objHierarchy.EmpID = txtEmpID.Text; clsEmployeeHierarchyHandler.UpdateEmployeeManagerDetails(objHierarchy, "Update", "", ref strErrMsg, ref strSuccMsg, clsCommonHandler.PageName()); if (strErrMsg.Trim().Length > 0) { lblError.Text = strErrMsg; mpeEmpMgrHierarchy.Show(); return; } else { mpeEmpMgrHierarchy.Hide(); bindDataGrid(); lblErrorEdit.Text = strSuccMsg; } } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName()); } }
void InsertEmployeeHierarchy(string strXML) { clsEmployeeHierarchy objHier = new clsEmployeeHierarchy(); objHier.CreatedBy = Session["uid"].ToString(); clsEmployeeHierarchyHandler.UploadHierarchy(objHier, strXML, ref strErrMsg, ref strSuccMsg, clsCommonHandler.PageName()); }
protected void btnSubmitAdd_Click(object sender, EventArgs e) { try { clsEmployeeHierarchy objHier = new clsEmployeeHierarchy(); objHier.EmpID = EmployeeHdn.Value; objHier.MngrID = lstManager.SelectedValue; objHier.Company = ComapnyHdn.Value; objHier.Location = LocationHdn.Value; objHier.Division = DivisionHdn.Value; objHier.Department = DepartmentHdn.Value; objHier.CreatedBy = Session["uid"].ToString(); clsEmployeeHierarchyHandler.InsertEmployeeMgr(objHier, ref strErrMsg, ref strSuccMsg, "HierarchyManagerView.aspx"); if (strErrMsg.Trim().Length >= 1) { lblMessages.Text = strErrMsg; lblMessages.Visible = true; return; } else { reset(); lblMessages.Text = strSuccMsg; lblMessages.Visible = true; } } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName()); } }
public void bindDataGrid() { try { clsEmployeeHierarchy objData = new clsEmployeeHierarchy(); DataTable dt = clsEmployeeHierarchyHandler.GetEmployeeManagerDetails("MngrHierarchy", objData); gvEmpMgrHier.DataSource = dt; gvEmpMgrHier.DataBind(); DropDownList ddl = (DropDownList)gvEmpMgrHier.BottomPagerRow.FindControl("ddlPageNo"); for (int i = 1; i <= gvEmpMgrHier.PageCount; i++) { ddl.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddl.SelectedValue = (gvEmpMgrHier.PageIndex + 1).ToString(); Label lblcount = (Label)gvEmpMgrHier.BottomPagerRow.FindControl("lblTotal"); lblcount.Text = ((DataTable)gvEmpMgrHier.DataSource).Rows.Count.ToString() + " Records."; if (gvEmpMgrHier.PageCount == 0) { ((Button)gvEmpMgrHier.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; ((Button)gvEmpMgrHier.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvEmpMgrHier.PageIndex + 1 == gvEmpMgrHier.PageCount) { ((Button)gvEmpMgrHier.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvEmpMgrHier.PageIndex == 0) { ((Button)gvEmpMgrHier.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; } ((Label)gvEmpMgrHier.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvEmpMgrHier.PageSize * gvEmpMgrHier.PageIndex) + 1) + " to " + (((gvEmpMgrHier.PageSize * (gvEmpMgrHier.PageIndex + 1)) - 10) + gvEmpMgrHier.Rows.Count); gvEmpMgrHier.BottomPagerRow.Visible = true; if (dt.Rows.Count != 0) { btnDelete.Enabled = true; btnSearch.Enabled = true; } else { btnDelete.Enabled = false; btnSearch.Enabled = false; } } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName()); } }
public void bindData() { try { clsEmployeeHierarchy objData = new clsEmployeeHierarchy(); objData.EmpID = EmployeeHdn.Value; objData.Company = ComapnyHdn.Value; objData.Location = LocationHdn.Value; objData.Division = DivisionHdn.Value; objData.Department = DepartmentHdn.Value; DataTable dt = clsEmployeeHierarchyHandler.GetEmployeeManagerDetails("EMPFilter", objData); gvEmpMgrAdd.DataSource = dt; gvEmpMgrAdd.DataBind(); DropDownList ddl = (DropDownList)gvEmpMgrAdd.BottomPagerRow.FindControl("ddlPageNo"); for (int i = 1; i <= gvEmpMgrAdd.PageCount; i++) { ddl.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddl.SelectedValue = (gvEmpMgrAdd.PageIndex + 1).ToString(); Label lblcount = (Label)gvEmpMgrAdd.BottomPagerRow.FindControl("lblTotal"); lblcount.Text = ((DataTable)gvEmpMgrAdd.DataSource).Rows.Count.ToString() + " Records."; if (gvEmpMgrAdd.PageCount == 0) { ((Button)gvEmpMgrAdd.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; ((Button)gvEmpMgrAdd.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvEmpMgrAdd.PageIndex + 1 == gvEmpMgrAdd.PageCount) { ((Button)gvEmpMgrAdd.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvEmpMgrAdd.PageIndex == 0) { ((Button)gvEmpMgrAdd.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; } ((Label)gvEmpMgrAdd.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvEmpMgrAdd.PageSize * gvEmpMgrAdd.PageIndex) + 1) + " to " + (gvEmpMgrAdd.PageSize * (gvEmpMgrAdd.PageIndex + 1)); gvEmpMgrAdd.BottomPagerRow.Visible = true; } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName()); } }
public void delete() { try { StringBuilder strXML = new StringBuilder(); clsEmployeeHierarchy objHierarchy = new clsEmployeeHierarchy(); objHierarchy.CreatedBy = Session["uid"].ToString(); strXML.Append("<ENT_HierarchyDef>"); for (int i = 0; i <= gvEmpMgrHier.Rows.Count - 1; i++) { CheckBox chk = (CheckBox)gvEmpMgrHier.Rows[i].FindControl("DeleteRows"); if (chk.Checked) { strXML.Append("<Hierarchy>"); strXML.Append("<Hier_Emp_ID>" + gvEmpMgrHier.Rows[i].Cells[2].Text.Trim() + "</Hier_Emp_ID>"); strXML.Append("</Hierarchy>"); } } strXML.Append("</ENT_HierarchyDef>"); clsEmployeeHierarchyHandler.UpdateEmployeeManagerDetails(objHierarchy, "Delete", strXML.ToString(), ref strErrMsg, ref strSuccMsg, clsCommonHandler.PageName()); if (strErrMsg.Trim().Length >= 1) { lbltext.Text = strErrMsg; lbltext.Visible = true; } else { lbltext.Text = strSuccMsg; lbltext.Visible = true; bindDataGrid(); } } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName()); } }
private void FillEmployeeEntity(string empId) { try { clsEmployeeHierarchy objHierarchy = new clsEmployeeHierarchy(); objHierarchy.EmpID = empId; DataTable dt = clsEmployeeHierarchyHandler.GetEmployeeManagerDetails("EMP", objHierarchy); LstEmployee.DataValueField = "ID"; LstEmployee.DataTextField = "NAME"; LstEmployee.DataSource = dt; LstEmployee.DataBind(); lstEmployDummy.DataValueField = "ID"; lstEmployDummy.DataTextField = "NAME"; lstEmployDummy.DataSource = dt; lstEmployDummy.DataBind(); } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "EmployeeManagerHierarchyAdd"); } }
protected void btnSearch_Click(object sender, EventArgs e) { try { this.lblErrorEdit.Text = string.Empty; clsEmployeeHierarchy objData = new clsEmployeeHierarchy(); DataTable dt = clsEmployeeHierarchyHandler.GetEmployeeManagerDetails("MngrHierarchy", objData); if (txtCompanyId.Text.ToString() == "" && txtCompanyName.Text.ToString() == "") { gvEmpMgrHier.DataSource = dt; gvEmpMgrHier.DataBind(); } else { String[,] values = { { "empid~" + txtCompanyId.Text.Trim(), "S" }, { "EmpName~" + txtCompanyName.Text.Trim(), "S" } }; DataTable _tempDT = new DataTable(); Search _sc = new Search(); if (_tempDT != null) { _tempDT.Rows.Clear(); } _tempDT = _sc.searchTable(values, dt); gvEmpMgrHier.DataSource = _tempDT; gvEmpMgrHier.DataBind(); } DropDownList ddl = (DropDownList)gvEmpMgrHier.BottomPagerRow.FindControl("ddlPageNo"); for (int i = 1; i <= gvEmpMgrHier.PageCount; i++) { ddl.Items.Add(new ListItem(i.ToString(), i.ToString())); } ddl.SelectedValue = (gvEmpMgrHier.PageIndex + 1).ToString(); Label lblcount = (Label)gvEmpMgrHier.BottomPagerRow.FindControl("lblTotal"); lblcount.Text = ((DataTable)gvEmpMgrHier.DataSource).Rows.Count.ToString() + " Records."; if (gvEmpMgrHier.PageCount == 0) { ((Button)gvEmpMgrHier.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; ((Button)gvEmpMgrHier.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvEmpMgrHier.PageIndex + 1 == gvEmpMgrHier.PageCount) { ((Button)gvEmpMgrHier.BottomPagerRow.FindControl("btnNext")).Enabled = false; } if (gvEmpMgrHier.PageIndex == 0) { ((Button)gvEmpMgrHier.BottomPagerRow.FindControl("btnPrevious")).Enabled = false; } ((Label)gvEmpMgrHier.BottomPagerRow.FindControl("lblShowing")).Text = "Showing " + ((gvEmpMgrHier.PageSize * gvEmpMgrHier.PageIndex) + 1) + " to " + (((gvEmpMgrHier.PageSize * (gvEmpMgrHier.PageIndex + 1)) - 10) + gvEmpMgrHier.Rows.Count); gvEmpMgrHier.BottomPagerRow.Visible = true; if (dt.Rows.Count != 0) { btnDelete.Enabled = true; btnSearch.Enabled = true; } else { btnDelete.Enabled = false; btnSearch.Enabled = false; } } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "EmployeeManagerHierarchy"); } }