protected void FillState()
{
string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'";
object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
DataTable dt = new DataTable();
dt = new DataTable();
if (objcheckSitecode != null)
{
chkListState.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 <>'' ";
dt = baseObj.GetData(sqlstr11);
//chkListState.Items.Add("All...");
chkListState.DataSource = dt;
chkListState.DataTextField = "NAME";
chkListState.DataValueField = "Code";
chkListState.DataBind();
//chkListState.Items.Insert(0, new ListItem("All..."));
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// chkListState.DataSource = dt;
// chkListState.DataTextField = "NAME";
// chkListState.DataValueField = "Code";
// chkListState.DataBind();
//}
}
else
{
chkListState.Items.Clear();
chkListSite.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() + "'";
dt = baseObj.GetData(sqlstr1);
chkListState.DataSource = dt;
chkListState.DataTextField = "StateName";
chkListState.DataValueField = "StateCode";
chkListState.DataBind();
chkListSite.DataSource = dt;
chkListSite.DataTextField = "SiteName";
chkListSite.DataValueField = "SiteId";
chkListSite.DataBind();
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// chkListState.DataSource = dt;
// chkListState.DataTextField = "StateName";
// chkListState.DataValueField = "StateCode";
// chkListState.DataBind();
// chkListSite.DataSource = dt;
// chkListSite.DataTextField = "SiteName";
// chkListSite.DataValueField = "SiteId";
// chkListSite.DataBind();
//}
if (dt.Rows.Count > 0)
{
chkListState.Items[0].Selected = true;
chkListSite.Items[0].Selected = true;
}
}
}
protected void FillState()
{
try
{
string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'";
object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
DataTable dt = new DataTable();
dt = new DataTable();
if (objcheckSitecode != null)
{
chkListState.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 <>'' ";
dt = baseObj.GetData(sqlstr11);
chkListState.Items.Add("All...");
for (int i = 0; i < dt.Rows.Count; i++)
{
chkListState.DataSource = dt;
chkListState.DataTextField = "NAME";
chkListState.DataValueField = "Code";
chkListState.DataBind();
}
}
else
{
chkListState.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() + "'";
dt = baseObj.GetData(sqlstr1);
for (int i = 0; i < dt.Rows.Count; i++)
{
chkListState.DataSource = dt;
chkListState.DataTextField = "StateName";
chkListState.DataValueField = "StateCode";
chkListState.DataBind();
chkListSite.DataSource = dt;
chkListSite.DataTextField = "SiteName";
chkListSite.DataValueField = "SiteId";
chkListSite.DataBind();
}
chkListState.Items[0].Selected = true;
chkListSite.Items[0].Selected = true;
FillCustomerGroup();
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'";
object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
if (objcheckSitecode != null)
{
ddlSiteId.Items.Clear();
string sqlstr1 = @"Select Distinct SITEID as Code,SITEID + '-' + NAME as [Name] from [ax].[INVENTSITE] where STATECODE = '" + ddlState.SelectedItem.Value + "'";
ddlSiteId.Items.Add("All...");
baseObj.BindToDropDown(ddlSiteId, sqlstr1, "Name", "Code");
}
else
{
ddlSiteId.Items.Clear();
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
//DataTable dt = (DataTable)Session["SaleHierarchy"];
// DataTable dt = HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM);
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
DataTable uniqueCols = dt.DefaultView.ToTable(true, "Distributor", "DistributorName");
ddlSiteId.DataSource = uniqueCols;
ddlSiteId.DataTextField = "DistributorName";
ddlSiteId.DataValueField = "Distributor";
ddlSiteId.DataBind();
ddlSiteId.Items.Insert(0, "All...");
}
else
{
string sqlstr1 = @"Select Distinct SITEID as Code,SITEID + '-' + NAME as [Name] from [ax].[INVENTSITE] where SITEID = '" + Session["SiteCode"].ToString() + "'";
baseObj.BindToDropDown(ddlSiteId, sqlstr1, "Name", "Code");
}
}
}
protected void DDLProductDesc_SelectedIndexChanged(object sender, EventArgs e)
{
//===========Fill Product Group and Product Sub Cat========
DataTable dt = new DataTable();
string query = "select Product_Group,PRODUCT_SUBCATEGORY from ax.INVENTTABLE where ItemId='" + DDLProductDesc.SelectedValue.ToString() + "' order by Product_Name";
dt = baseObj.GetData(query);
if (dt.Rows.Count > 0)
{
DDLProductGroup.Text = dt.Rows[0]["PRODUCT_GROUP"].ToString();
ProductSubCategory();
//=============For Product Sub Cat======
DDLProdSubCategory.Text = dt.Rows[0]["PRODUCT_SUBCATEGORY"].ToString();
CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global();
string queryStock = " Select isnull(SUM(INVTS.TRANSQTY),0) AS STOCK From AX.ACXINVENTTRANS INVTS INNER JOIN AX.INVENTTABLE INV ON INV.ITEMID= INVTS.PRODUCTCODE " +
" WHERE INVTS.DATAAREAID='" + Session["DATAAREAID"] + "' AND INVTS.SiteCode='" + Session["SiteCode"] + "' " +
" AND INVTS.TRANSLOCATION='" + DDLWarehouseFrom.SelectedValue.Trim().ToString() + "' " +
" AND INVTS.PRODUCTCODE ='" + DDLProductDesc.SelectedValue.ToString() + "'";
object stockValue = obj.GetScalarValue(queryStock);
if (stockValue != null)
{
txtstock.Text = Convert.ToDecimal(stockValue.ToString()).ToString("0.00");
}
}
}
protected void ddlState_SelectedIndexChanged(object sender, EventArgs e)
{
string usertype = string.Empty;
string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'";
object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
if (objcheckSitecode != null)
{
usertype = ddlUserType.SelectedItem.Value.ToString();
DataTable dtDataByfilter = null;
string query = string.Empty;
try
{
ddlUsers.Items.Clear();
conn = new SqlConnection(baseObj.GetConnectionString());
conn.Open();
cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandTimeout = 3600;
cmd.CommandType = CommandType.StoredProcedure;
query = "USP_FILLUSERSINDROPDOWN";
cmd.CommandText = query;
if (ddlState.SelectedItem.Text == "ALL")
{
cmd.Parameters.AddWithValue("@STATECODE", "");
}
else
{
cmd.Parameters.AddWithValue("@STATECODE", ddlState.SelectedItem.Value);
}
cmd.Parameters.AddWithValue("@USERTYPE", usertype);
dtDataByfilter = new DataTable();
dtDataByfilter.Load(cmd.ExecuteReader());
if (dtDataByfilter.Rows.Count > 0)
{
ddlUsers.DataSource = dtDataByfilter;
ddlUsers.DataTextField = "Name";
ddlUsers.DataValueField = "Code";
ddlUsers.DataBind();
}
ddlUsers.Items.Insert(0, "ALL");
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
conn.Dispose();
}
}
}
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,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");
}
}
protected void FillSite()
{
string StateList = "";
foreach (ListItem item in chkListState1.Items)
{
if (item.Selected)
{
if (StateList == "")
{
StateList += "'" + item.Value.ToString() + "'";
}
else
{
StateList += ",'" + item.Value.ToString() + "'";
}
}
}
if (StateList.Length > 0)
{
DataTable dt = new DataTable();
string sqlstr1 = string.Empty;
string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE IN (" + ucRoleFilters.GetCommaSepartedSiteId() + ") ";
object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
if (Convert.ToString(Session["ISDISTRIBUTOR"]).ToUpper() != "Y")
{
sqlstr1 = @"Select Distinct SITEID ,SITEID+'-'+NAME as SiteName from [ax].[INVENTSITE] where STATECODE in (" + StateList + ") order by SiteName";
}
else
{
sqlstr1 = @"Select Distinct SITEID ,SITEID+'-'+NAME as SiteName from [ax].[INVENTSITE] where SITEID IN (" + ucRoleFilters.GetCommaSepartedSiteId() + ") ";
}
dt = new DataTable();
// dt = baseObj.GetData(sqlstr1);
chkListSite1.Items.Clear();
dt = baseObj.GetData(sqlstr1);
for (int i = 0; i < dt.Rows.Count; i++)
{
chkListSite1.DataSource = dt;
chkListSite1.DataTextField = "SiteName";
chkListSite1.DataValueField = "SiteId";
chkListSite1.DataBind();
}
}
else
{
chkListSite1.Items.Clear();
}
}
private bool ValidateStock(string ProductCode, decimal MoveQty)
{
bool stock = true;
CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global();
string queryStock = " Select isnull(SUM(INVTS.TRANSQTY),0) AS STOCK From AX.ACXINVENTTRANS INVTS INNER JOIN AX.INVENTTABLE INV ON INV.ITEMID= INVTS.PRODUCTCODE " +
" WHERE INVTS.DATAAREAID='" + Session["DATAAREAID"] + "' AND INVTS.SiteCode='" + Session["SiteCode"] + "' " +
" AND INVTS.TRANSLOCATION='" + DDLWarehouseFrom.SelectedValue.Trim().ToString() + "' " +
" AND INVTS.PRODUCTCODE ='" + ProductCode + "'";
object stockValue = obj.GetScalarValue(queryStock);
if (stockValue != null)
{
decimal AvailableStock = Math.Round(Convert.ToDecimal(stockValue.ToString()), 2);
if (MoveQty <= AvailableStock)
{
if (MoveQty + AvailableStock < 0)
{
stock = false;
//ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", " alert('Stock Negative Issue : Final Stock cannot be in negative figure. !');", true);
LblMessage.Text = "Stock Negative Issue : Final Stock cannot be in negative figure. !";
}
else
{
stock = true;
}
}
else
{
stock = false;
//ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", " alert('Stock Issue : Entered Value cannot be more than the available Stock !');", true);
LblMessage.Text = "Stock Issue : Entered Value cannot be more than the available Stock !";
}
//if (AdjusmentValue <= AvailableStock)
//{
// stock = true;
//}
//else
//{
// stock = false;
// ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", " alert('Stock Issue : Entered Value cannot be more than the available Stock !');", true);
//}
}
return(stock);
}
private void ShowReportSummary()
{
CreamBell_DMS_WebApps.App_Code.Global obj = new CreamBell_DMS_WebApps.App_Code.Global();
DataTable dtSetData = null;
SqlCommand cmd = new SqlCommand();
cmd.CommandTimeout = 0;
try
{
string query = "Select Top 1 NAME from ax.inventsite where SITEID='" + Session["SiteCode"].ToString() + "'";
object obj1 = obj.GetScalarValue(query);
string sqlstr = @"Select I.Siteid,I.Name,I.StateCode,from_Date,To_Date,TC.Name as Cat,TS.Name as Subcat,Target_Description,Actual_Incentive,
Case when Claim_Type = '0' then 'Sale' else 'Purchase' end as ClaimType
from [ax].[ACXCLAIMMASTER] CM
left join
[ax].[ACXTARGETCATEGORY] TC on CM.Claim_Category = TC.CATEGORY
left join
[ax].[ACXTARGETSUBCATEGORY] TS on CM.CLAIM_SUBCATEGORY = TS.Subcategory
left join
[ax].[INVENTSITE] I on CM.SITE_CODE = I.Siteid
where CM.from_Date >= " +
" '" + Convert.ToDateTime(txtFromDate.Text) + "' and CM.TO_DATE <= '" + Convert.ToDateTime(txtToDate.Text) + "' ";
// " ";
if (ddlSiteId.SelectedIndex != -1)
{
if (ddlSiteId.SelectedItem.Text != "Select...")
{
sqlstr += "and CM.SITE_CODE = '" + ddlSiteId.SelectedItem.Value + "' ";
}
}
dtSetData = new DataTable();
dtSetData = obj.GetData(sqlstr);
LoadDataInReportViewerDetail(dtSetData);
}
catch (Exception ex)
{
LblMessage.Text = ex.Message.ToString();
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
public bool checkifDataAlreadyExist()
{
try {
string ClaimType = "0";
if (ddlObjectType.SelectedItem.Text == "PSR")
{
ClaimType = "0";
}
if (ddlObjectType.SelectedItem.Text == "SITE")
{
ClaimType = "1";
}
if (ddlObjectType.SelectedItem.Text == "CUSTOMERGROUP")
{
ClaimType = "2";
}
string sqstr = @"Select * from [ax].[ACXCLAIMMASTER] where FROM_DATE ='" + txtFromDate.Text + "' and TO_DATE = '" + txttoDate.Text + "' " +
" and SITE_CODE = '" + Session["SiteCode"].ToString() + "' and CLAIM_CATEGORY= '" + ddlClaimCategory.SelectedItem.Value + "' " +
" and CLAIM_TYPE = '" + ClaimType + "' and OBJECT_CODE = '" + ddlObjectCode.SelectedItem.Value + "' and BU_CODE= '" + ddlBusinessUnit.SelectedItem.Value + "'";
if (ddlClaimSubCategory.SelectedIndex > 0)
{
sqstr += " and CLAIM_SUBCATEGORY = '" + ddlClaimSubCategory.SelectedItem.Value + "' ";
}
object obj = baseObj.GetScalarValue(sqstr);
if (obj != null)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Alert", " alert('Data already exist for combination.. !');", true);
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
lblError.Text = ex.Message;
ErrorSignal.FromCurrentContext().Raise(ex);
return(false);
}
}
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string statesel = "";
foreach (System.Web.UI.WebControls.ListItem litem1 in lstState.Items)
{
if (litem1.Selected)
{
if (statesel.Length == 0)
{
statesel = "'" + litem1.Value.ToString() + "'";
}
else
{
statesel += ",'" + litem1.Value.ToString() + "'";
}
}
}
if (lstState.SelectedValue == string.Empty)
{
lstSiteId.Items.Clear();
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
DataView view = new DataView(dt);
DataTable distinctValues = view.ToTable(true, "Distributor", "DistributorName");
lstSiteId.DataSource = distinctValues;
string AllSitesFromHierarchy = "";
foreach (DataRow row in distinctValues.Rows)
{
if (AllSitesFromHierarchy == "")
{
AllSitesFromHierarchy += "'" + row["Distributor"].ToString() + "'";
}
else
{
AllSitesFromHierarchy += ",'" + row["Distributor"].ToString() + "'";
}
}
if (AllSitesFromHierarchy != "")
{
string sqlstr1 = @"Select Distinct SITEID as Code,SITEID +' - '+ Name AS Name,Name as SiteName from [ax].[INVENTSITE] IV LEFT JOIN AX.ACXUSERMASTER UM on IV.SITEID = UM.SITE_CODE where UM.DEACTIVATIONDATE = '1900-01-01 00:00:00.000' AND SITEID IN (" + AllSitesFromHierarchy + ") Order by SiteName ";
dt = baseObj.GetData(sqlstr1);
lstSiteId.DataSource = dt;
lstSiteId.DataTextField = "Name";
lstSiteId.DataValueField = "Code";
lstSiteId.DataBind();
}
}
else
{
string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'";
object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
if (objcheckSitecode != null)
{
lstSiteId.Items.Clear();
string sqlstr1 = @"Select Distinct SITEID as Code,SITEID + ' - ' + NAME AS NAME,Name as SiteName from [ax].[INVENTSITE] IV JOIN AX.ACXUSERMASTER UM on IV.SITEID=UM.SITE_CODE where STATECODE in (" + statesel + ") AND UM.DEACTIVATIONDATE = '1900-01-01 00:00:00.000' Order by SiteName";
DataTable dt = baseObj.GetData(sqlstr1);
lstSiteId.DataSource = dt;
lstSiteId.DataTextField = "Name";
lstSiteId.DataValueField = "Code";
lstSiteId.DataBind();
}
else
{
lstSiteId.Items.Clear();
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
dt.DefaultView.RowFilter = "STATE in (" + statesel + ")";
DataTable uniqueCols = dt.DefaultView.ToTable(true, "Distributor", "DistributorName");
string AllSitesFromHierarchy = "";
foreach (DataRow row in uniqueCols.Rows)
{
if (AllSitesFromHierarchy == "")
{
AllSitesFromHierarchy += "'" + row["Distributor"].ToString() + "'";
}
else
{
AllSitesFromHierarchy += ",'" + row["Distributor"].ToString() + "'";
}
}
string sqlstr1 = @"Select Distinct SITEID as Code,SITEID +' - '+ Name AS Name,Name as SiteName from [ax].[INVENTSITE] IV LEFT JOIN AX.ACXUSERMASTER UM on IV.SITEID = UM.SITE_CODE where UM.DEACTIVATIONDATE = '1900-01-01 00:00:00.000' AND SITEID IN (" + AllSitesFromHierarchy + ") Order by SiteName ";
dt = baseObj.GetData(sqlstr1);
lstSiteId.DataSource = dt;
lstSiteId.DataTextField = "Name";
lstSiteId.DataValueField = "Code";
lstSiteId.DataBind();
}
else
{
string sqlstr1 = @"Select Distinct SITEID as Code,SITEID + ' - ' + NAME AS NAME from [ax].[INVENTSITE] IV JOIN AX.ACXUSERMASTER UM on IV.SITEID=UM.SITE_CODE where SITEID = '" + Session["SiteCode"].ToString() + "' AND UM.DEACTIVATIONDATE = '1900-01-01 00:00:00.000'";
DataTable dt = baseObj.GetData(sqlstr1);
lstSiteId.DataSource = dt;
lstSiteId.DataTextField = "Name";
lstSiteId.DataValueField = "Code";
lstSiteId.DataBind();
}
}
}
if (lstSiteId.Items.Count == 1)
{
foreach (System.Web.UI.WebControls.ListItem litem in lstSiteId.Items)
{
litem.Selected = true;
}
FillBU();
}
Session["SalesData"] = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
protected void FillSite()
{
try
{
string StateList = "";
foreach (ListItem item in lstSTATE.Items)
{
if (item.Selected)
{
if (StateList == "")
{
StateList += "'" + item.Value.ToString() + "'";
}
else
{
StateList += ",'" + item.Value.ToString() + "'";
}
}
}
if (StateList.Length > 0)
{
string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'";
object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
if (objcheckSitecode != null)
{
lstDIS.Items.Clear();
string sqlstr1 = @"Select Distinct SITEID as Code,SITEID+'-'+Name Name from [ax].[INVENTSITE] where STATECODE in (" + StateList + ") Order by Name";
lstDIS.Items.Add("All...");
DataTable dt1 = new DataTable();
dt1 = baseObj.GetData(sqlstr1);
lstDIS.DataSource = dt1;
lstDIS.DataTextField = "Name";
lstDIS.DataValueField = "Code";
lstDIS.DataBind();
}
else
{
lstDIS.Items.Clear();
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
DataTable uniqueCols = dt.DefaultView.ToTable(true, "Distributor", "DistributorName");
uniqueCols.Columns.Add("Name", typeof(string), "Distributor + ' - ' + DistributorName");
lstDIS.DataSource = uniqueCols;
lstDIS.DataTextField = "Name";
lstDIS.DataValueField = "distributor";
lstDIS.DataBind();
}
else
{
string sqlstr1 = @"Select Distinct SITEID as Code,SITEID+'-'+NAME Name from [ax].[INVENTSITE] where SITEID = '" + Session["SiteCode"].ToString() + "'";
//drpDIS.Items.Add("All...");
DataTable dt1 = new DataTable();
dt1 = baseObj.GetData(sqlstr1);
lstDIS.DataSource = dt1;
lstDIS.DataTextField = "Name";
lstDIS.DataValueField = "Code";
lstDIS.DataBind();
}
if (lstDIS.Items.Count == 1)
{
CheckBox8.Visible = false;
lstDIS.Items[0].Selected = true;
lstDIS_SelectedIndexChanged(null, null);
}
}
}
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
try {
if (ddlState.SelectedItem.Text == "All...")
{
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
//DataTable uniqueCols = dt.DefaultView.ToTable(true, "Distributor", "DistributorName");
DataView view = new DataView(dt);
DataTable distinctValues = view.ToTable(true, "Distributor", "DistributorName");
distinctValues.Columns.Add("Name", typeof(string), "Distributor + ' - ' + DistributorName");
ddlSiteId.DataSource = distinctValues;
ddlSiteId.DataTextField = "Name";
ddlSiteId.DataValueField = "Distributor";
ddlSiteId.DataBind();
//ddlSiteId.Items.Add("All...");
ddlSiteId.Items.Insert(0, "All...");
}
else
{
string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'";
object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
if (objcheckSitecode != null)
{
ddlSiteId.Items.Clear();
string sqlstr1 = @"Select Distinct SITEID as Code,SITEID +' - '+ NAME as NAME from [ax].[INVENTSITE] where STATECODE = '" + ddlState.SelectedItem.Value + "'";
ddlSiteId.Items.Insert(0, "All...");
baseObj.BindToDropDown(ddlSiteId, sqlstr1, "Name", "Code");
}
else
{
ddlSiteId.Items.Clear();
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
// DataTable dt = (DataTable)Session["SaleHierarchy"];
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
dt.DefaultView.RowFilter = "STATE='" + ddlState.SelectedItem.Value.Trim() + "'";
DataTable uniqueCols = dt.DefaultView.ToTable(true, "Distributor", "DistributorName");
uniqueCols.Columns.Add("Name", typeof(string), "Distributor + ' - ' + DistributorName");
ddlSiteId.DataSource = uniqueCols;
ddlSiteId.DataTextField = "Name";
ddlSiteId.DataValueField = "distributor";
ddlSiteId.DataBind();
ddlSiteId.Items.Insert(0, "All...");
}
else
{
string sqlstr1 = @"Select Distinct SITEID as Code,SITEID +' - '+ NAME as NAME from [ax].[INVENTSITE] where SITEID = '" + Session["SiteCode"].ToString() + "'";
//ddlSiteId.Items.Add("All...");
baseObj.BindToDropDown(ddlSiteId, sqlstr1, "Name", "Code");
}
}
}
}
catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); }
}
protected void drpRecieptNo_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
DropDownList ddllist = (DropDownList)sender;
object objcheckproductcode = null;
if (ddllist.ID == "ddlInvoceNo")
{
query = "Select Top 1 A.PURCH_RECIEPTNO from [ax].[ACXPURCHINVRECIEPTHEADER] A where A.[SITE_Code]='" + Session["SiteCode"].ToString() + "' " +
"and A.[DATAAREAID]='" + Session["DATAAREAID"].ToString() + "' and A.[SALE_INVOICENO]='" + ddlInvoceNo.SelectedItem.Value + "' ";
objcheckproductcode = obj.GetScalarValue(query);
if (objcheckproductcode == null)
{
LblMessage.Text = "PURCH_RECIEPTNO Number Not Found";
return;
}
drpRecieptNo.SelectedIndex = drpRecieptNo.Items.IndexOf(drpRecieptNo.Items.FindByText(objcheckproductcode.ToString()));
}
else
{
//=================Fill Header Part===============
string sqlstr = "Select Top 1 [SALE_INVOICENO] from [ax].[ACXPURCHINVRECIEPTHEADER] A where A.[SITE_Code]='" + Session["SiteCode"].ToString() + "' " +
"and A.[DATAAREAID]='" + Session["DATAAREAID"].ToString() + "' and A.PURCH_RECIEPTNO='" + drpRecieptNo.SelectedItem.Text + "' ";
objcheckproductcode = obj.GetScalarValue(sqlstr);
if (objcheckproductcode == null)
{
LblMessage.Text = "Invoice Number Not Found";
return;
}
ddlInvoceNo.SelectedIndex = ddlInvoceNo.Items.IndexOf(ddlInvoceNo.Items.FindByText(objcheckproductcode.ToString()));
}
query = "Select A.[DOCUMENT_NO],CONVERT(VARCHAR(11),A.[DOCUMENT_DATE] ,106) as [DOCUMENT_DATE], A.PURCH_INDENTNO, CONVERT(VARCHAR(11),A.[PURCH_INDENTDATE],106) AS PURCH_INDENTDATE, " +
"A.MATERIAL_VALUE, A.PURCH_RECIEPTNO, A.TRANSPORTER_CODE,A.VEHICAL_NO, A.VEHICAL_TYPE, A.[SALE_INVOICENO] AS INVOICENO, " +
" CONVERT(VARCHAR(11), A.[SALE_INVOICEDATE],106) AS INVOICEDATE from [ax].[ACXPURCHINVRECIEPTHEADER] A where A.[SITE_Code]='" + Session["SiteCode"].ToString() + "' " +
"and A.[DATAAREAID]='" + Session["DATAAREAID"].ToString() + "' and A.PURCH_RECIEPTNO='" + drpRecieptNo.SelectedItem.Text + "' ";
dt = new DataTable();
dt = obj.GetData(query);
if (dt.Rows.Count > 0)
{
txtReceiptDate.Text = dt.Rows[0]["DOCUMENT_DATE"].ToString();
//txtInvoiceNo.Text = dt.Rows[0]["INVOICENO"].ToString();
txtInvoiceDate.Text = dt.Rows[0]["INVOICEDATE"].ToString();
decimal materialValue = Convert.ToDecimal(dt.Rows[0]["MATERIAL_VALUE"].ToString());
txtReceiptValue.Text = (Math.Round(materialValue, 2)).ToString();
txtIndentNo.Text = dt.Rows[0]["PURCH_INDENTNO"].ToString();
txtIndentDate.Text = dt.Rows[0]["PURCH_INDENTDATE"].ToString();
txtTransporterName.Text = dt.Rows[0]["TRANSPORTER_CODE"].ToString();
txtVehicleNumber.Text = dt.Rows[0]["VEHICAL_NO"].ToString();
txtVehicleType.Text = dt.Rows[0]["VEHICAL_TYPE"].ToString();
//txtDriverNumber.Text = dt.Rows[0]["PURCH_INDENTDATE"].ToString();
}
//================Fill Line Item=============
ShowRecords(drpRecieptNo.SelectedItem.Text);
}
catch (Exception ex)
{
ErrorSignal.FromCurrentContext().Raise(ex);
}
}
//protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
//{
// string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'";
// object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
// if (objcheckSitecode != null)
// {
// ddlSiteId.Items.Clear();
// string sqlstr1 = @"Select Distinct SITEID as Code,NAME from [ax].[INVENTSITE] where STATECODE = '" + ddlState.SelectedItem.Value + "'";
// ddlSiteId.Items.Add("All...");
// ddlSiteId.Items.Insert(0, "All...");
// baseObj.BindToDropDown(ddlSiteId, sqlstr1, "Name", "Code");
// }
// else
// {
// ddlSiteId.Items.Clear();
// if (Convert.ToString(Session["LOGINTYPE"]) == "3")
// {
// DataTable dt = (DataTable)Session["SaleHierarchy"];
// DataTable uniqueCols = dt.DefaultView.ToTable(true, "Distributor", "distributor Name");
// ddlSiteId.DataSource = uniqueCols;
// ddlSiteId.DataTextField = "distributor name";
// ddlSiteId.DataValueField = "distributor";
// ddlSiteId.DataBind();
// //ddlSiteId.Items.Add("All...");
// ddlSiteId.Items.Insert(0, "All...");
// }
// else
// {
// string sqlstr1 = @"Select Distinct SITEID as Code,NAME from [ax].[INVENTSITE] where SITEID = '" + Session["SiteCode"].ToString() + "'";
// ddlSiteId.Items.Add("All...");
// baseObj.BindToDropDown(ddlSiteId, sqlstr1, "Name", "Code");
// }
// }
//}
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e)
{
string statesel = "";
foreach (System.Web.UI.WebControls.ListItem litem1 in ddlState.Items)
{
if (litem1.Selected)
{
if (statesel.Length == 0)
{
statesel = "'" + litem1.Value.ToString() + "'";
}
else
{
statesel += ",'" + litem1.Value.ToString() + "'";
}
}
}
if (ddlState.SelectedValue == string.Empty)
{
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
//DataTable uniqueCols = dt.DefaultView.ToTable(true, "Distributor", "DistributorName");
DataView view = new DataView(dt);
DataTable distinctValues = view.ToTable(true, "Distributor", "DistributorName");
ddlSiteId.DataSource = distinctValues;
ddlSiteId.DataTextField = "DistributorName";
ddlSiteId.DataValueField = "distributor";
ddlSiteId.DataBind();
//ddlSiteId.Items.Add("All...");
}
else
{
string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'";
object objcheckSitecode = baseObj.GetScalarValue(sqlstr);
if (objcheckSitecode != null)
{
ddlSiteId.Items.Clear();
string sqlstr1 = @"Select Distinct SITEID as Code,NAME from [ax].[INVENTSITE] where STATECODE in (" + statesel + ")";
//ddlSiteId.Items.Add("All...");
// ddlSiteId.Items.Insert(0, "All...");
//baseObj.BindToDropDown(ddlSiteId, sqlstr1, "Name", "Code");
DataTable dt = baseObj.GetData(sqlstr1);
ddlSiteId.DataSource = dt;
ddlSiteId.DataTextField = "Name";
ddlSiteId.DataValueField = "Code";
ddlSiteId.DataBind();
}
else
{
ddlSiteId.Items.Clear();
if (Convert.ToString(Session["LOGINTYPE"]) == "3")
{
//DataTable dt = (DataTable)Session["SaleHierarchy"];
// DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM);
DataTable dt = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE);
dt.DefaultView.RowFilter = "STATE in (" + statesel + ")";
DataTable uniqueCols = dt.DefaultView.ToTable(true, "Distributor", "DistributorName");
ddlSiteId.DataSource = uniqueCols;
ddlSiteId.DataTextField = "DistributorName";
ddlSiteId.DataValueField = "distributor";
ddlSiteId.DataBind();
//ddlSiteId.Items.Add("All...");
}
else
{
string sqlstr1 = @"Select Distinct SITEID as Code,NAME from [ax].[INVENTSITE] where SITEID = '" + Session["SiteCode"].ToString() + "'";
//ddlSiteId.Items.Add("All...");
//baseObj.BindToDropDown(ddlSiteId, sqlstr1, "Name", "Code");
DataTable dt = baseObj.GetData(sqlstr1);
ddlSiteId.DataSource = dt;
ddlSiteId.DataTextField = "Name";
ddlSiteId.DataValueField = "Code";
ddlSiteId.DataBind();
}
}
}
}