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 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 FillState() { string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE IN (" + ucRoleFilters.GetCommaSepartedSiteId() + ")"; 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 IN (" + ucRoleFilters.GetCommaSepartedSiteId() + ")"; 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(); } if (chkListSite.Items.Count > 1) { chkListState.Items[0].Selected = true; chkListSite.Items[0].Selected = true; } FillCustomerGroup(); } }
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 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(); chkListSite1.Items.Clear(); string sqlstr11 = "Select Distinct I.StateCode Code,I.StateCode +' - '+LS.Name as 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(); } else { chkListState.Items.Clear(); chkListSite1.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(); chkListSite1.DataSource = dt; chkListSite1.DataTextField = "SiteName"; chkListSite1.DataValueField = "SiteId"; chkListSite1.DataBind(); if (chkListSite1.Items.Count > 0) { chkListState.Items[0].Selected = true; chkListSite1.Items[0].Selected = true; } } }
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(); if (ddlState.SelectedItem == null) { } else { string sqlstr1 = @"Select Distinct SITEID as Code,SITEID+'-'+NAME 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 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"); ddlSiteId.DataSource = uniqueCols; ddlSiteId.DataTextField = "Name"; ddlSiteId.DataValueField = "Distributor"; ddlSiteId.DataBind(); //ddlSiteId.Items.Add("All..."); ddlSiteId.Items.Insert(0, "All..."); } else { string sqlstr1 = @"Select Distinct SITEID as Code,SITEID+'-'+NAME Name from [ax].[INVENTSITE] where SITEID = '" + Session["SiteCode"].ToString() + "'"; //ddlSiteId.Items.Add("All..."); baseObj.BindToDropDown(ddlSiteId, sqlstr1, "Name", "Code"); ddlSiteId_SelectedIndexChanged(null, null); } } }
protected void lstState_SelectedIndexChanged(object sender, EventArgs e) { string StateList = App_Code.Global.GetSelectState(ref lstState, true); string strSqlQuery = "", strCondition = ""; lstSiteId.Items.Clear(); strSqlQuery = @"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 "; if (Convert.ToString(Session["LOGINTYPE"]) == "3") { lstSiteId.Items.Clear(); DataTable dt1 = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE); DataView view = new DataView(dt1); DataTable distinctValues = view.ToTable(true, "Distributor", "DistributorName"); string AllSitesFromHierarchy = ""; foreach (DataRow row in distinctValues.Rows) { if (AllSitesFromHierarchy == "") { AllSitesFromHierarchy += "'" + row["Distributor"].ToString() + "'"; } else { AllSitesFromHierarchy += ",'" + row["Distributor"].ToString() + "'"; } } strCondition = " WHERE SITEID IN (" + AllSitesFromHierarchy + ")"; } else { string sqlstr = "select * from ax.ACXSITEMENU where SITE_CODE ='" + Session["SiteCode"].ToString() + "'"; object objcheckSitecode = baseObj.GetScalarValue(sqlstr); if (objcheckSitecode != null) { } else { strCondition = " WHERE SITEID='" + Session["SiteCode"].ToString() + "'"; } } if (StateList != "") { strCondition += (strCondition == "" ? " WHERE STATECODE in (" + StateList + ")" : " AND STATECODE in (" + StateList + ")"); } strCondition += " Order by SiteName"; strSqlQuery += StateList = strCondition; DataTable dt = baseObj.GetData(strSqlQuery); 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; } lstSiteId_SelectedIndexChanged(sender, e); } }
protected void ddlCountry_SelectedIndexChanged(object sender, EventArgs e) { 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 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 + ") 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 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() + "'"; 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; } } Session["SalesData"] = App_Code.Global.HierarchyDataTable(ref chkListHOS, ref chkListVP, ref chkListGM, ref chkListDGM, ref chkListRM, ref chkListZM, ref chkListASM, ref chkListEXECUTIVE); }
protected void btnAdd_Click(object sender, EventArgs e) { lblMessage.Text = string.Empty; //=============Validation================= foreach (GridViewRow grv in gvDetails.Rows) { HiddenField lblProduct = (HiddenField)grv.FindControl("HiddenValueItemCode"); if (DrpItemDescription.SelectedItem.Value == lblProduct.Value) { string message = "alert('" + DrpItemDescription.SelectedItem.Text + " is already exists in the list .Please Select Another Product !!');"; ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true); return; } } //================================= //============================================== if (drpItemCode.Text == "Select..." || drpItemCode.Text == "") { string message = "alert('Select Item Sub Group First !');"; ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true); drpItemCode.Focus(); return; } if (drpItemCategory.Text == string.Empty || drpItemCategory.Text == "Select...") { string message = "alert('Select Item Group First !');"; ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true); drpItemCategory.Focus(); return; } string strQuery = "select isnull(sum(TransQty),0) from [ax].[ACXINVENTTRANS] where ProductCode='" + DrpItemDescription.SelectedItem.Value + "' and SiteCode='" + Session["SiteCode"] + "' and DocumentType='9'"; string strTransQty = obj.GetScalarValue(strQuery); if (Convert.ToDecimal(txtQTYPcs.Text) >= Convert.ToDecimal(strTransQty)) { string message = "alert('" + DrpItemDescription.SelectedItem.Value + " is not available in stock.Enter Quantity below than " + Math.Round(Convert.ToDecimal(strTransQty), 2) + "!!');"; ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true); txtQTYPcs.Focus(); return; } if (txtQTYPcs.Text == string.Empty || txtQTYPcs.Text == "0") { string message = "alert(' Invalid Qty !');"; ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true); return; } if (drpPSRName.Text == string.Empty || drpPSRName.Text == "Select...") { string message = "alert('Select PSR Name First !');"; ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", message, true); drpItemCategory.Focus(); return; } DataTable dt = new DataTable(); dt = Session["ItemTable"] as DataTable; if (Session["LineItem"] == null) { DataColumn column = new DataColumn(); column.DataType = System.Type.GetType("System.Int32"); column.AutoIncrement = true; column.AutoIncrementSeed = 1; column.AutoIncrementStep = 1; column.ColumnName = "Sr_No"; //-----------------------------------------------------------// dtLineItems = new DataTable("LineItemTable"); dtLineItems.Columns.Add(column); dtLineItems.Columns.Add("Item_Category", typeof(string)); dtLineItems.Columns.Add("Item_SubCategory", typeof(string)); dtLineItems.Columns.Add("Item_Code", typeof(string)); dtLineItems.Columns.Add("Item_Name", typeof(string)); dtLineItems.Columns.Add("QTY", typeof(string)); } else { dtLineItems = (DataTable)Session["LineItem"]; } DataRow row; row = dtLineItems.NewRow(); row["Item_Category"] = drpItemCategory.Text; row["Item_SubCategory"] = drpItemCode.SelectedItem.Value; row["Item_Code"] = DrpItemDescription.SelectedItem.Value; row["Item_Name"] = DrpItemDescription.SelectedItem.Text; row["QTY"] = txtQTYPcs.Text; dtLineItems.Rows.Add(row); Session["LineItem"] = dtLineItems; dt = dtLineItems;; if (dt.Rows.Count > 0) { gvDetails.DataSource = dt; gvDetails.DataBind(); } else { gvDetails.DataSource = dt; gvDetails.DataBind(); } btnAdd.Enabled = true; btnAdd.Attributes.Add("onclick", " this.disabled = false; " + ClientScript.GetPostBackEventReference(btnAdd, null) + ";"); drpItemCategory.Focus(); }