protected void fillddl()
{
DataTable dtcomemail = new DataTable();
DataTable dtempemail = new DataTable();
MasterCls clsMaster = new MasterCls();
dtempemail = clsMaster.SelectEmpEmail(Convert.ToInt32(Session["EmployeeIdep"]));
if (dtempemail.Rows.Count > 0)
{
if (dtempemail.Rows[0]["Email"] != System.DBNull.Value)
{
empeml = dtempemail.Rows[0]["Email"].ToString();
}
}
dtcomemail = clsMaster.SelectCompanyEmailForEmp(Convert.ToInt32(Session["EmployeeIdep"]));
ddlempemail.DataSource = dtcomemail;
ddlempemail.DataBind();
ddlempemail.Items.Insert(0, "-Select-");
ddlempemail.SelectedItem.Value = "0";
if (empeml != "")
{
ddlempemail.Items.Insert(1, empeml);
ddlempemail.SelectedIndex = 1;
}
}
protected void Fillddlemployee()
{
MasterCls clsMaster = new MasterCls();
DataTable dt = new DataTable();
dt = clsMaster.SelectEmployeewithDesgDeptName(ddlbusiness.SelectedValue);
ddlemployee.DataSource = dt;
ddlemployee.DataBind();
ddlemployee.Items.Insert(0, "All");
ddlemployee.SelectedItem.Value = "0";
}
protected void FillGridDesignationwithDept()
{
DataTable dt;
dt = new DataTable();
clsMaster = new MasterCls();
dt = clsMaster.SelectDesignationMasterwithDataDept(ddlbusiness.SelectedValue);
//dt = clsMaster.SelectDesignationMasterwithDept(6);
grdDesignation.DataSource = dt;
DataView myDataView = new DataView();
myDataView = dt.DefaultView;
if (hdnsortExp.Value != string.Empty)
{
myDataView.Sort = string.Format("{0} {1}", hdnsortExp.Value, hdnsortDir.Value);
}
grdDesignation.DataBind();
}
