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");
}
}
