public void fillPSRDetails()
{
strQuery = "select distinct([PSR_Code]),[PSR_Code]+'-'+[PSR_Name] as PSR_Name from [ax].[ACXPSRMaster]";
DrpPSRDetails.Items.Clear();
DrpPSRDetails.Items.Add("Select...");
Obj.BindToDropDown(DrpPSRDetails, strQuery, "PSR_Name", "PSR_Code");
}
protected void fillSiteAndState()
{
try
{
string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'";
object objcheckSitecode = obj.GetScalarValue(sqlstr);
if (objcheckSitecode != null)
{
ddlState.Items.Clear();
string sqlstr11 = "Select Distinct I.StateCode Code,LS.Name from [ax].[INVENTSITE] I left join [ax].[LOGISTICSADDRESSSTATE] LS on LS.STATEID = I.STATECODE where I.STATECODE <>'' ORDER BY LS.Name ";
ddlState.Items.Add("Select...");
obj.BindToDropDown(ddlState, sqlstr11, "Name", "Code");
}
else
{
ddlState.Items.Clear();
ddlSiteId.Items.Clear();
string sqlstr1 = @"Select I.StateCode StateCode,LS.Name as StateName,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() + "' ORDER BY LS.Name";
obj.BindToDropDown(ddlState, sqlstr1, "StateName", "StateCode");
obj.BindToDropDown(ddlSiteId, sqlstr1, "SiteName", "SiteId");
}
}
catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); }
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["USERID"] == null || Session["USERID"].ToString() == string.Empty)
{
Response.Redirect("Login.aspx");
return;
}
if (!IsPostBack)
{
string sqlstr11;
if (Convert.ToString(Session["ISDISTRIBUTOR"]) == "Y")
{
sqlstr11 = "Select Distinct I.StateCode Code,LS.Name from [ax].[INVENTSITE] I left join [ax].[LOGISTICSADDRESSSTATE] LS on LS.STATEID = I.STATECODE where I.STATECODE <>'' AND I.SITEID='" + Convert.ToString(Session["SiteCode"]) + "'";
}
else
{
sqlstr11 = "Select Distinct I.StateCode Code,LS.Name from [ax].[INVENTSITE] I left join [ax].[LOGISTICSADDRESSSTATE] LS on LS.STATEID = I.STATECODE where I.STATECODE <>'' ";
}
ddlState.Items.Add("Select...");
baseObj.BindToDropDown(ddlState, sqlstr11, "Name", "Code");
if (ddlState.Items.Count == 2)
{
ddlState.SelectedIndex = 1;
ddlState_SelectedIndexChanged(sender, e);
}
GetVRSName();
}
}
protected void fillState()
{
ddlState.Items.Clear();
string sqlstr11 = "Select Distinct STATE Code,STATE as Name from [ax].[acxConfigInfo] where UserId<>'' and STATE<>'' ";
ddlState.Items.Add("All...");
baseObj.BindToDropDown(ddlState, sqlstr11, "Name", "Code");
}
private void FillItemCode()
{
DrpItemDescription.Items.Clear();
// DDLMaterialCode.Items.Add("Select...");
if (drpItemCategory.Text == "Select..." && drpItemCode.Text == "Select..." || drpItemCode.Text == "")
{
strQuery = "select distinct(ItemId) as Product_Code,concat([ITEMID],' - ',Product_Name) as Product_Name from ax.INVENTTABLE where PRODUCT_GROUP ='POP' and BLOCK=0 order by Product_Name";
DrpItemDescription.Items.Clear();
DrpItemDescription.Items.Add("Select...");
baseObj.BindToDropDown(DrpItemDescription, strQuery, "Product_Name", "Product_Code");
DrpItemDescription.Focus();
}
}
protected void fillSiteAndState()
{
if (Convert.ToString(Session["ISDISTRIBUTOR"]) != "Y")
{
ddlState.Items.Clear();
string sqlstr11 = "Select Distinct I.StateCode Code,LS.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,LS.Name as StateName,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");
}
}
public void fillState()
{
string strQuery;
strQuery = "Select STATEID+'-'+NAME as Name,STATEID from ax.LOGISTICSADDRESSSTATE where stateid not in ('All','IN') and isnull(stateid,'')<>'' ";
ddlstate.Items.Clear();
ddlstate.Items.Add("Select...");
baseObj.BindToDropDown(ddlstate, strQuery, "Name", "STATEID");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["USERID"] == null || Session["USERID"].ToString() == string.Empty)
{
Response.Redirect("Login.aspx");
return;
}
if (!IsPostBack)
{
string sqlstr = @"select distinct TC.Name,TC.Category as Code from [ax].[ACXTARGETCATEGORY] TC ";
ddlClaimCat.Items.Add("Select...");
baseObj.BindToDropDown(ddlClaimCat, sqlstr, "Name", "Code");
// txtFromDate.Text = string.Format("{0:dd-MMM-yyyy }", DateTime.Today.AddDays(-1));
// txtToDate.Text = string.Format("{0:dd-MMM-yyyy }", DateTime.Today);
}
}
protected void fillSiteAndState()
{
string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'";
object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
if (objcheckSitecode != null)
{
ddlState.Items.Clear();
string sqlstr11 = "Select Distinct I.StateCode Code,LS.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,LS.Name as StateName,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");
}
}
//protected void FillSiteAndState()
//{
// string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'";
// object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
// if (objcheckSitecode != null)
// {
// ddlState.Items.Clear();
// ddlState.Items.Add("All...");
// string sqlstr11 = "Select Distinct I.StateCode Code,LS.Name from [ax].[INVENTSITE] I left join [ax].[LOGISTICSADDRESSSTATE] LS on LS.STATEID = I.STATECODE where I.STATECODE <>'' ";
// baseObj.BindToDropDown(ddlState, sqlstr11, "Name", "Code");
// }
// else
// {
// ddlState.Items.Clear();
// chkListSite.Items.Clear();
// string sqlstr1 = @"Select I.StateCode StateCode,LS.Name as StateName,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");
// DataTable dt = new DataTable();
// dt = baseObj.GetData(sqlstr1);
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// chkListSite.DataSource = dt;
// chkListSite.DataTextField = "SiteName";
// chkListSite.DataValueField = "SiteId";
// chkListSite.DataBind();
// }
// //chkListSite.Items[0].Selected = true;
// }
//}
protected void fillSiteAndState(DataTable dt)
{
string sqlstr = "";
if (Convert.ToString(Session["ISDISTRIBUTOR"]) == "Y")
{
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
DataTable dtState = dt.DefaultView.ToTable(true, "STATE", "STATEWNAME");
//dtState.Columns.Add("STATENAMES", typeof(string), "STATE + ' - ' + STATENAME");
ddlState.Items.Clear();
DataRow dr = dtState.NewRow();
dr[0] = "--Select--";
dr[1] = "--Select--";
dtState.Rows.InsertAt(dr, 0);
ddlState.DataSource = dtState;
ddlState.DataTextField = "STATEWNAME";
ddlState.DataValueField = "STATE";
ddlState.DataBind();
}
else
{
sqlstr = "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 <>'' AND I.SITEID='" + Convert.ToString(Session["SiteCode"]) + "'";
baseObj.BindToDropDown(ddlState, sqlstr, "Name", "Code");
}
}
else
{
sqlstr = "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("Select...");
baseObj.BindToDropDown(ddlState, sqlstr, "Name", "Code");
}
if (ddlState.Items.Count == 1)
{
ddlState.SelectedIndex = 1;
ddlCountry_SelectedIndexChanged(null, null);
}
}
