public void fillDepartMent(string LocationId, DropDownList ddl)
{
string DeptId = string.Empty;
DataTable dt = DM.GetDepartmentMaster(Session["CompId"].ToString());
try
{
DataView dv = new DataView(dt);
dv.RowFilter = "Location_Id ='" + LocationId + "'";
dt = dv.ToTable();
ddl.DataSource = dt;
ddl.DataTextField = "Dep_Name";
ddl.DataValueField = "Dep_Id";
ddl.DataBind();
ddl.Items.Insert(0, "--Select One--");
ddl.SelectedIndex = 0;
}
catch
{ }
}
public static string[] GetCompletionListDepCode(string prefixText, int count, string contextKey)
{
DepartmentMaster objDepMaster = new DepartmentMaster();
DataTable dt = new DataView(objDepMaster.GetDepartmentMaster(HttpContext.Current.Session["CompId"].ToString()), "Dep_Code like '" + prefixText.ToString() + "%'", "", DataViewRowState.CurrentRows).ToTable();
dt = new DataView(dt, "Brand_Id='" + HttpContext.Current.Session["BrandId"].ToString() + "' and Location_Id='" + HttpContext.Current.Session["LocId"].ToString() + "' ", "", DataViewRowState.CurrentRows).ToTable();
string[] txt = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
txt[i] = dt.Rows[i]["Dep_Code"].ToString();
}
return(txt);
}
public void FillddlParentDepDDL()
{
DataTable dt = objDep.GetDepartmentMaster(Session["CompId"].ToString());
dt = new DataView(dt, "Brand_Id='" + Session["BrandId"].ToString() + "' and Location_Id='" + Session["LocId"].ToString() + "' ", "", DataViewRowState.CurrentRows).ToTable();
if (dt.Rows.Count > 0)
{
ddlParentDep.DataSource = null;
ddlParentDep.DataBind();
ddlParentDep.DataSource = dt;
ddlParentDep.DataTextField = "Dep_Name";
ddlParentDep.DataValueField = "Dep_Id";
ddlParentDep.DataBind();
ListItem li = new ListItem("--Select--", "0");
ddlParentDep.Items.Insert(0, li);
ddlParentDep.SelectedIndex = 0;
}
else
{
try
{
ddlParentDep.Items.Clear();
ddlParentDep.DataSource = null;
ddlParentDep.DataBind();
ListItem li = new ListItem("--Select--", "0");
ddlParentDep.Items.Insert(0, li);
ddlParentDep.SelectedIndex = 0;
}
catch
{
ListItem li = new ListItem("--Select--", "0");
ddlParentDep.Items.Insert(0, li);
ddlParentDep.SelectedIndex = 0;
}
}
}