private void LoadWarehouse()
{
CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global();
string query1 = "SELECT INVENTLOCATIONID,NAME FROM AX.inventlocation WHERE INVENTSITEID='" + Session["SiteCode"].ToString() + "'";
DDLWarehouseFrom.Items.Clear();
DDLWarehouseFrom.Items.Add("-Select-");
obj.BindToDropDown(DDLWarehouseFrom, query1, "NAME", "INVENTLOCATIONID");
DDLWarehouseTo.Items.Clear();
DDLWarehouseTo.Items.Add("-Select-");
obj.BindToDropDown(DDLWarehouseTo, query1, "NAME", "INVENTLOCATIONID");
}
//private void UcRoleFilters_ListSiteChange(object sender, EventArgs e)
//{
// //FillCustomerGroup();
//}
protected void fillSiteAndState()
{
if (Convert.ToString(Session["ISDISTRIBUTOR"]) != "Y")
{
ddlState.Items.Clear();
string sqlstr11 = "Select Distinct I.StateCode Code,I.StateCode+'-'+LS.Name Name from [ax].[INVENTSITE] I left join [ax].[LOGISTICSADDRESSSTATE] LS on LS.STATEID = I.STATECODE where I.STATECODE <>'' ";
ddlState.Items.Add("All...");
baseObj.BindToDropDown(ddlState, sqlstr11, "Name", "Code");
}
else
{
ddlState.Items.Clear();
ddlSiteId.Items.Clear();
string sqlstr1 = @"Select I.StateCode StateCode,I.StateCode+'-'+LS.Name as StateName,I.SiteId,I.SiteId+'-'+I.Name as SiteName from [ax].[INVENTSITE] I left join [ax].[LOGISTICSADDRESSSTATE] LS on LS.STATEID = I.STATECODE where I.SiteId = '" + Session["SiteCode"].ToString() + "'";
baseObj.BindToDropDown(ddlState, sqlstr1, "StateName", "StateCode");
baseObj.BindToDropDown(ddlSiteId, sqlstr1, "SiteName", "SiteId");
}
}
