protected void fillstore()
{
ddlschool.Items.Clear();
filterschool.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
ddlschool.DataSource = ds;
ddlschool.DataTextField = "Name";
ddlschool.DataValueField = "WareHouseId";
ddlschool.DataBind();
filterschool.DataSource = ds;
filterschool.DataTextField = "Name";
filterschool.DataValueField = "WareHouseId";
filterschool.DataBind();
//ddlStore.Items.Insert(0, "Select");
filterschool.Items.Insert(0, "All");
filterbuilding.Items.Insert(0, "All");
ViewState["cd"] = "1";
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
//if (dteeed.Rows.Count > 0)
//{
// ddlschool.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
// filterschool.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
//}
}
protected void fillstore()
{
DropDownList1.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "WareHouseId";
DropDownList1.DataBind();
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
DropDownList1.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
DropDownList3.DataSource = ds;
DropDownList3.DataTextField = "Name";
DropDownList3.DataValueField = "WareHouseId";
DropDownList3.DataBind();
DropDownList3.Items.Insert(0, "All");
DropDownList3.Items[0].Value = "0";
}
protected void fillstore()
{
ddlschool.Items.Clear();
filterschool.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
ddlschool.DataSource = ds;
ddlschool.DataTextField = "Name";
ddlschool.DataValueField = "WareHouseId";
ddlschool.DataBind();
filterschool.DataSource = ds;
filterschool.DataTextField = "Name";
filterschool.DataValueField = "WareHouseId";
filterschool.DataBind();
filterschool.Items.Insert(0, "All");
filterbuilding.Items.Insert(0, "All");
filterfloor.Items.Insert(0, "All");
filterroomtype.Items.Insert(0, "All");
ViewState["cd"] = "1";
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
}
protected void fillstore()
{
ddlSchoolName.SelectedIndex = 0;
ddlSchoolName.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
ddlSchoolName.DataSource = ds;
ddlSchoolName.DataTextField = "Name";
ddlSchoolName.DataValueField = "WareHouseId";
ddlSchoolName.DataBind();
//ddlStore.Items.Insert(0, "Select");
ddlSchoolName_Search.Items.Clear();
DataTable ds1 = ClsStore.SelectStorename();
ddlSchoolName_Search.DataSource = ds;
ddlSchoolName_Search.DataTextField = "Name";
ddlSchoolName_Search.DataValueField = "WareHouseId";
ddlSchoolName_Search.DataBind();
ddlSchoolName_Search.Items.Insert(0, "All");
ddlSchoolName_Search.Items[0].Value = "0";
// ViewState["cd"] = "1";
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
//if (dteeed.Rows.Count > 0)
//{
// ddlSchoolName.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
//}
}
protected void fillstore()
{
ddlwarehouse.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
ddlwarehouse.DataSource = ds;
ddlwarehouse.DataTextField = "Name";
ddlwarehouse.DataValueField = "WareHouseId";
ddlwarehouse.DataBind();
//ddlstore.Items.Insert(0, "Select");
ViewState["cd"] = "1";
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddlwarehouse.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
ddlbussnessfilter.DataSource = ds;
ddlbussnessfilter.DataTextField = "Name";
ddlbussnessfilter.DataValueField = "WareHouseId";
ddlbussnessfilter.DataBind();
ddlbussnessfilter.Items.Insert(0, "All");
ddlbussnessfilter.Items[0].Value = "0";
}
protected void fillwarehouse()
{
//string str1 = "select WareHouseId,Name from WareHouseMaster WHERE comid='" + Session["Comid"].ToString() + "' And Status='1' ";
//DataTable ds1 = new DataTable();
//SqlDataAdapter da = new SqlDataAdapter(str1, con);
//da.Fill(ds1);
//if (ds1.Rows.Count > 0)
//{
// ddlwarehouse.DataSource = ds1;
// ddlwarehouse.DataTextField = "Name";
// ddlwarehouse.DataValueField = "WarehouseId";
// ddlwarehouse.DataBind();
//}
ddlwarehouse.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
if (ds.Rows.Count > 0)
{
ddlwarehouse.DataSource = ds;
ddlwarehouse.DataTextField = "Name";
ddlwarehouse.DataValueField = "WareHouseId";
ddlwarehouse.DataBind();
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddlwarehouse.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
}
}
protected void fillwarehouse()
{
//string str1 = "SELECT Distinct WareHouseId,Name FROM WareHouseMaster inner join EmployeeWarehouseRights on EmployeeWarehouseRights.Whid=WareHouseMaster.WareHouseId where comid = '" + Session["Comid"].ToString() + "' and WareHouseMaster.Status='1' and EmployeeWarehouseRights.AccessAllowed='True' order by name asc";
//DataTable ds1 = new DataTable();
//SqlDataAdapter da = new SqlDataAdapter(str1, con);
//da.Fill(ds1);
//if (ds1.Rows.Count > 0)
//{
// ddlwarehouse.DataSource = ds1;
// ddlwarehouse.DataTextField = "Name";
// ddlwarehouse.DataValueField = "WarehouseId";
// ddlwarehouse.DataBind();
//}
ddlwarehouse.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
if (ds.Rows.Count > 0)
{
ddlwarehouse.DataSource = ds;
ddlwarehouse.DataTextField = "Name";
ddlwarehouse.DataValueField = "WareHouseId";
ddlwarehouse.DataBind();
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddlwarehouse.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
}
fillEmployee();
}
protected void Fillwarehouse()
{
ddlstore.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
ddlstore.DataSource = ds;
ddlstore.DataTextField = "Name";
ddlstore.DataValueField = "WareHouseId";
ddlstore.DataBind();
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddlstore.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "WareHouseId";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "All");
DropDownList2.DataSource = null;
DropDownList2.DataTextField = "Departmentname";
DropDownList2.DataValueField = "id";
DropDownList2.DataBind();
DropDownList2.Items.Insert(0, "All");
}
protected void fillupdatestore()
{
ddlupdatebusiness.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
ddlupdatebusiness.DataSource = ds;
ddlupdatebusiness.DataTextField = "Name";
ddlupdatebusiness.DataValueField = "WareHouseId";
ddlupdatebusiness.DataBind();
}
protected void fillstoreprofile()
{
ddlWarehouse.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
ddlWarehouse.DataSource = ds;
ddlWarehouse.DataTextField = "Name";
ddlWarehouse.DataValueField = "WareHouseId";
ddlWarehouse.DataBind();
}
protected void fillstorewithfilter()
{
DropDownList1.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "WareHouseId";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "All");
DropDownList1.Items[0].Value = "0";
}
protected void fillfilterstore()
{
ddlbusifil.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
ddlbusifil.DataSource = ds;
ddlbusifil.DataTextField = "Name";
ddlbusifil.DataValueField = "WareHouseId";
ddlbusifil.DataBind();
ddlbusifil.Items.Insert(0, "All");
ddlbusifil.Items[0].Value = "0";
}
protected void fillwarehouse1()
{
ddBusinessfilter.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
ddBusinessfilter.DataSource = ds;
ddBusinessfilter.DataTextField = "Name";
ddBusinessfilter.DataValueField = "WarehouseId";
ddBusinessfilter.DataBind();
ddBusinessfilter.Items.Insert(0, "All");
ddBusinessfilter.Items[0].Value = "0";
}
protected void fillstore()
{
DataTable ds1 = ClsStore.SelectStorename();
if (ds1.Rows.Count > 0)
{
ddlsearchByStore.DataSource = ds1;
ddlsearchByStore.DataTextField = "Name";
ddlsearchByStore.DataValueField = "WarehouseId";
ddlsearchByStore.DataBind();
ddlsearchByStore.Items.Insert(0, "All");
ddlsearchByStore.Items[0].Value = "0";
}
}
protected void storefill()
{
DataTable dtwh = ClsStore.SelectStorename();
ddlWarehouse.DataSource = dtwh;
ddlWarehouse.DataTextField = "Name";
ddlWarehouse.DataValueField = "WareHouseId";
ddlWarehouse.DataBind();
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddlWarehouse.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
}
protected void fillware()
{
DataTable ds = ClsStore.SelectStorename();
if (ds.Rows.Count > 0)
{
ddlwarehouse.DataSource = ds;
ddlwarehouse.DataValueField = "WareHouseId";
ddlwarehouse.DataTextField = "Name";
ddlwarehouse.DataBind();
}
//ddlwarehouse.Items.Insert(0, "--Select--");
//ddlwarehouse.Items[0].Value = "0";
}
protected void fillwarehouse()
{
ddBusiness.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
ddBusiness.DataSource = ds;
ddBusiness.DataTextField = "Name";
ddBusiness.DataValueField = "WareHouseId";
ddBusiness.DataBind();
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddBusiness.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
}
protected void fillwarehouse()
{
//string str1 = "select * from WarehouseMaster where comid='" + Session["comid"] + "'and Status='" + 1 + "' order by name";
//DataTable ds1 = new DataTable();
//SqlDataAdapter da = new SqlDataAdapter(str1, con);
//da.Fill(ds1);
//if (ds1.Rows.Count > 0)
//{
// DropDownList1.DataSource = ds1;
// DropDownList1.DataTextField = "Name";
// DropDownList1.DataValueField = "WarehouseId";
// DropDownList1.DataBind();
// ddshorting.DataSource = ds1;
// ddshorting.DataTextField = "Name";
// ddshorting.DataValueField = "WarehouseId";
// ddshorting.DataBind();
// ddshorting.Items.Insert(0, "ALL");
// DropDownList1.SelectedIndex = DropDownList1.Items.IndexOf(DropDownList1.Items.FindByText("Eplaza Store"));
//}
DropDownList1.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "WareHouseId";
DropDownList1.DataBind();
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
DropDownList1.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
ddshorting.DataSource = ds;
ddshorting.DataTextField = "Name";
ddshorting.DataValueField = "WarehouseId";
ddshorting.DataBind();
ddshorting.Items.Insert(0, "All");
ddshorting.Items[0].Value = "0";
}
protected void addnewfillbusiness()
{
DropDownList2.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
DropDownList2.DataSource = ds;
DropDownList2.DataTextField = "Name";
DropDownList2.DataValueField = "WareHouseId";
DropDownList2.DataBind();
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
DropDownList2.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
}
protected void Fillwarehouse()
{
//string str = "select WareHouseId,Name from WareHouseMaster WHERE comid='" + Session["Comid"].ToString() + "'and [WareHouseMaster].Status='1' order by Name";
//SqlCommand cmd = new SqlCommand(str, conn);
//SqlDataAdapter adp = new SqlDataAdapter(cmd);
//DataSet ds = new DataSet();
//adp.Fill(ds);
//ddlstrname.DataSource = ds;
//ddlstrname.DataTextField = "Name";
//ddlstrname.DataValueField = "WareHouseId";
//ddlstrname.DataBind();
//DropDownList1.DataSource = ds;
//DropDownList1.DataTextField = "Name";
//DropDownList1.DataValueField = "WareHouseId";
//DropDownList1.DataBind();
//DropDownList1.Items.Insert(0, "ALL");
ddlstrname.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
ddlstrname.DataSource = ds;
ddlstrname.DataTextField = "Name";
ddlstrname.DataValueField = "WareHouseId";
ddlstrname.DataBind();
//ddlStore.Items.Insert(0, "Select");
ViewState["cd"] = "1";
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddlstrname.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "WareHouseId";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "All");
}
//public void FillProduct()
//{
// string strcln = " SELECT distinct ProductMaster.ProductId,ProductDetail.Active,VersionInfoMaster.VersionInfoId,ProductMaster.ProductName + ' : ' + VersionInfoMaster.VersionInfoName as productversion FROM ProductMaster inner join ProductDetail on ProductDetail.ProductId=ProductMaster.ProductId inner join VersionInfoMaster on VersionInfoMaster.ProductId= ProductMaster.ProductId where ProductDetail.Active='1' order by productversion";
// SqlCommand cmdcln = new SqlCommand(strcln, PageConn.licenseconn());
// DataTable dtcln = new DataTable();
// SqlDataAdapter adpcln = new SqlDataAdapter(cmdcln);
// adpcln.Fill(dtcln);
// ddlstproductname.DataSource = dtcln;
// ddlstproductname.DataValueField = "VersionInfoId";
// ddlstproductname.DataTextField = "productversion";
// ddlstproductname.DataBind();
// ddlstproductname.Items.Insert(0, "All");
// ddlstproductname.Items[0].Value = "0";
//}
protected void fillstore()
{
DataTable ds1 = ClsStore.SelectStorename();
if (ds1.Rows.Count > 0)
{
ddlstproductname.DataSource = ds1;
ddlstproductname.DataTextField = "Name";
ddlstproductname.DataValueField = "WarehouseId";
ddlstproductname.DataBind();
//ddlsearchByStore.Items.Insert(0, "All");
//ddlsearchByStore.Items[0].Value = "0";
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddlstproductname.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
}
}
protected void ware()
{
//string str1 = "select * from WarehouseMaster where comid='" + Session["comid"] + "' and WareHouseMaster.Status='1' order by Name";
//DataTable ds1 = new DataTable();
//SqlDataAdapter da = new SqlDataAdapter(str1, con);
//da.Fill(ds1);
DataTable ds = ClsStore.SelectStorename();
if (ds.Rows.Count > 0)
{
ddlbus.DataSource = ds;
ddlbus.DataTextField = "Name";
ddlbus.DataValueField = "WarehouseId";
ddlbus.DataBind();
}
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddlbus.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
}
protected void fillstore()
{
DataTable ds = ClsStore.SelectStorename();
ddlbusiness.DataSource = ds;
ddlbusiness.DataTextField = "Name";
ddlbusiness.DataValueField = "WareHouseId";
ddlbusiness.DataBind();
if (Request.QueryString["Wid"] != null)
{
ddlbusiness.SelectedValue = Convert.ToString(Request.QueryString["Wid"]);
}
else
{
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddlbusiness.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
}
}
protected void Fillwarehouse()
{
DataTable ds = ClsStore.SelectStorename();
if (ds.Rows.Count > 0)
{
ddlstore.DataSource = ds;
ddlstore.DataValueField = "WareHouseId";
ddlstore.DataTextField = "Name";
ddlstore.DataBind();
ddlfilterbus.DataSource = ds;
ddlfilterbus.DataValueField = "WareHouseId";
ddlfilterbus.DataTextField = "Name";
ddlfilterbus.DataBind();
ddlfilterbus.Items.Insert(0, "All");
ddlfilterbus.Items[0].Value = "0";
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddlstore.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
}
}
protected void fillfilterbusiness()
{
DropDownList1.Items.Clear();
DataTable ds = ClsStore.SelectStorename();
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "Name";
DropDownList1.DataValueField = "WareHouseId";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "All");
DropDownList1.Items[0].Value = "0";
string eeed = " Select distinct EmployeeMaster.Whid from EmployeeMaster where EmployeeMasterId='" + Session["EmployeeId"] + "'";
SqlCommand cmdeeed = new SqlCommand(eeed, con);
SqlDataAdapter adpeeed = new SqlDataAdapter(cmdeeed);
DataTable dteeed = new DataTable();
adpeeed.Fill(dteeed);
if (dteeed.Rows.Count > 0)
{
DropDownList1.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
}
protected void rdipright_SelectedIndexChanged(object sender, EventArgs e)
{
pnls.Visible = true;
if (rdipright.SelectedIndex == 0)
{
pnlexample1.Visible = true;
pnlexample2.Visible = false;
lblCompany.Text = Session["Cname"].ToString();
lbluserp.Text = "";
lblheadc.Text = "List of Allowed IP Addresses for Any Admin and Employee Users of the Company";
Label4.Text = "List of Allowed IP Addresses for Any Admin and Employee Users of the Company";
lblselecttype.Text = "The following IP Address will be added to the list of allowed IP addresses for all users of your company.";
lblbusiness.Visible = false;
pnlusershow.Visible = false;
pnlfilteruser.Visible = false;
FillGridView1();
btnadtolist.Text = "Add to the Allowed IP Address List for All Users";
btnaddn0.Text = "Add to the Allowed IP Address List for All Users";
// pnlusershow.Visible = false;
Button2.Text = "Add to the Allowed IP Address List for All User";
pnlvs.Visible = false;
lblselecttype.Visible = false;
alluseripcheck();
}
else if (rdipright.SelectedIndex == 1)
{
specificuseripcheck();
// pnlusershow.Visible = true;
pnlvs.Visible = false;
Button2.Text = "Add to the Allowed IP Address List for Specific User";
btnadtolist.Text = "Add to the Allowed IP Address List for Specific User";
btnaddn0.Text = "Add to the Allowed IP Address List for Specific User";
lblselecttype.Visible = false;
// pnldynmic.Visible = false;
pnlexample1.Visible = false;
pnlexample2.Visible = true;
pnlfilteruser.Visible = true;
lblselecttype.Text = "The following IP Address will be added to the list of allowed IP addresses for specific users of your company.";
// lblheadc.Text = "List of Allowed Ip Address for Access to a particular user";
lblheadc.Text = "List of Allowed IP Addresses for Any Admin and Employee Users of the Company";
Label4.Text = "List of Allowed IP Addresses for Any Admin and Employee Users of the Company";
DataTable ds = ClsStore.SelectStorename();
// pnlusershow.Visible = true;
if (ds.Rows.Count > 0)
{
ddlbusiness.DataSource = ds;
ddlbusiness.DataValueField = "WareHouseId";
ddlbusiness.DataTextField = "Name";
ddlbusiness.DataBind();
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddlbusiness.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
ddlfilterbus.DataSource = ds;
ddlfilterbus.DataValueField = "WareHouseId";
ddlfilterbus.DataTextField = "Name";
ddlfilterbus.DataBind();
ddlfilterbus.Items.Insert(0, "All");
ddlfilterbus.Items[0].Value = "0";
ddlfilteruser.Items.Insert(0, "All");
ddlfilteruser.Items[0].Value = "0";
}
ddlbusiness_SelectedIndexChanged(sender, e);
ddlfilterbus_SelectedIndexChanged(sender, e);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Comid"] == null)
{
Response.Redirect("~/Shoppingcart/Admin/ShoppingCartLogin.aspx");
}
PageConn pgcon = new PageConn();
con = pgcon.dynconn;
pagetitleclass pg = new pagetitleclass();
string strData = Request.Url.ToString();
char[] separator = new char[] { '/' };
string[] strSplitArr = strData.Split(separator);
int i = Convert.ToInt32(strSplitArr.Length);
string page = strSplitArr[i - 1].ToString();
Page.Title = pg.getPageTitle(page);
if (!IsPostBack)
{
Label1.Text = "";
lblfilen.Text = "";
ViewState["sortOrder"] = "";
Pagecontrol.dypcontrol(Page, page);
DataTable ds = ClsStore.SelectStorename();
ddlWarehouse.DataSource = ds;
ddlWarehouse.DataTextField = "Name";
ddlWarehouse.DataValueField = "WareHouseId";
ddlWarehouse.DataBind();
DataTable dteeed = ClsStore.SelectEmployeewithIdwise();
if (dteeed.Rows.Count > 0)
{
ddlWarehouse.SelectedValue = Convert.ToString(dteeed.Rows[0]["Whid"]);
}
//string strwh = "SELECT WareHouseId,Name,Address,CurrencyId FROM WareHouseMaster where comid='" + Session["comid"] + "'and Status='1' order by Name ";
//SqlCommand cmdwh = new SqlCommand(strwh, con);
//SqlDataAdapter adpwh = new SqlDataAdapter(cmdwh);
//DataTable dtwh = new DataTable();
//adpwh.Fill(dtwh);
//ddlWarehouse.DataSource = dtwh;
//ddlWarehouse.DataTextField = "Name";
//ddlWarehouse.DataValueField = "WareHouseId";
//ddlWarehouse.DataBind();
if (ddlWarehouse.SelectedIndex > -1)
{
FillddlInvCat();
ddlInvCat_SelectedIndexChanged(sender, e);
}
DropDownList2.DataSource = (DataSet)fillMediaType();
DropDownList2.DataTextField = "MediaFileType";
DropDownList2.DataValueField = "MediaFileTypeID";
DropDownList2.DataBind();
DropDownList2.Items.Insert(0, "-Select-");
DropDownList2.Items[0].Value = "0";
}
}
