protected void BindGridview(string param) { try { string query; query = @"Select A.INVOICE_NO,A.INVOIC_DATE,A.INVOICE_VALUE,A.SITEID as DistCode,DistName = (select Name from [ax].[INVENTSITE] where SITEID = A.SITEID) from [ax].[ACXSALEINVOICEHEADER] A left Join [ax].[ACXPURCHINVRECIEPTHEADER] B on B.Site_Code=A.Customer_Code and B.Supplier_Code=A.SiteID and B.Sale_InvoiceNo=A.Invoice_NO inner join [ax].[ACXUSERMASTER] C on C.Site_Code = A.CUSTOMER_CODE Where B.Sale_InvoiceNo is null and A.Trantype<>2 and A.INVOIC_DATE >= C.PurchaseStartDate and (SELECT ISNULL(SUM(BOX),0) FROM [ax].[ACXSALEINVOICELINE] SL WHERE SL.SITEID=A.SITEID AND SL.INVOICE_NO=A.INVOICE_NO) >(SELECT ISNULL(SUM(BOX),0) FROM [ax].[ACXSALEINVOICELINE] SL JOIN AX.ACXSALEINVOICEHEADER SH ON SH.SITEID=SL.SITEID AND SH.INVOICE_NO=SL.INVOICE_NO AND SL.SITEID=A.SITEID AND SH.SO_NO=A.INVOICE_NO AND SL.TRANTYPE=2)and A.Customer_Code='" + Session["SiteCode"].ToString() + param + "' Order by A.SITEID,A.INVOICE_NO "; CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); DataTable dt = new DataTable(); dt = obj.GetData(query); if (dt.Rows.Count > 0) { gvHeader.DataSource = dt; gvHeader.DataBind(); } else { gvHeader.DataSource = null; gvHeader.DataBind(); } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
private void GetPSRBeat() { try { CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); string query = " Select A.PSRCode,C.PSR_Name as PSRName,A.BeatCode,A.BeatName,d.Discription as BeatDayDesc " + " from AX.ACXPSRBEATMASTER A " + " inner JOIN AX.ACXPSRSITELinkingMaster B ON A.PSRCode = B.PSRCode and A.Site_code = B.Site_Code " + " inner Join ax.[ACXPSRMaster] c on A.PSRCode = C.PSR_Code " + " left Join ax.ACXWeekMaster d on d.DayCode=A.BeatDay " + " where B.Site_Code='" + Session["SiteCode"].ToString() + "'" + " order By C.PSR_Name,A.BeatName "; DataTable dt = obj.GetData(query); if (dt.Rows.Count > 0) { gvDetails.DataSource = dt; gvDetails.DataBind(); } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
private void GetPSRCustomer() { try { CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); string query = " Select A.CustomerCode,A.CustomerName ," + " A.PSRCode,PSRName=(select C.PSR_Name from [ax].[ACXPSRMaster] C where C.PSR_Code=A.PSRCode )," + " A.BeatCode,B.BeatName,B.BeatDay,BeatDayDesc=(Select F.Discription from ax.ACXWeekMaster F where F.DayCode=B.BeatDay) " + " from [ax].[ACXPSRCUSTLinkingMaster] A " + " Left Join [ax].[ACXPSRBeatMaster] B on A.BeatCode=B.BeatCode and A.PSRCode=b.PSRCode AND A.SITE_CODE = B.SITE_CODE " + " Left Join [ax].[ACXCUSTMASTER] C on A.CustomerCode=C.Customer_Code AND A.SITE_CODE = C.SITE_CODE " + " where A.Site_Code='" + Session["SiteCode"].ToString() + "' and C.Blocked = 0 order by PSRName,BeatName,A.CustomerName"; DataTable dt = obj.GetData(query); if (dt.Rows.Count > 0) { gvDetails.DataSource = dt; gvDetails.DataBind(); } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
private void ShowDetails() { CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); string query = "ACX_USP_OpenSaleOrder"; List <string> ilist = new List <string>(); List <string> item = new List <string>(); DataTable dt = new DataTable(); ilist.Add("@Site_Code"); item.Add(Session["SiteCode"].ToString()); ilist.Add("@DATAAREAID"); item.Add(Session["DATAAREAID"].ToString()); ilist.Add("@StartDate"); item.Add(txtFromDate.Text); ilist.Add("@EndDate"); item.Add(txtToDate.Text); dt = obj.GetData_New(query, CommandType.StoredProcedure, ilist, item); if (dt.Rows.Count > 0) { gvDetails.DataSource = dt; gvDetails.DataBind(); LblMessage.Text = "Total Records : " + dt.Rows.Count.ToString(); Session["OpenSO"] = dt; } else { gvDetails.DataSource = dt; gvDetails.DataBind(); LblMessage.Text = string.Empty; } }
protected void BindGridview() { try { string query; query = "EXEC [dbo].[ACX_GETPENDINGSO] '" + Session["SiteCode"].ToString() + "'"; CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); DataTable dt = new DataTable(); dt = obj.GetData(query); if (dt.Rows.Count > 0) { dt = SortDataView(dt); gvHeader.DataSource = dt; gvHeader.DataBind(); } else { dt.Rows.Add(dt.NewRow()); gvHeader.DataSource = dt; gvHeader.DataBind(); int columncount = gvHeader.Rows[0].Cells.Count; gvHeader.Rows[0].Cells.Clear(); gvHeader.Rows[0].Cells.Add(new TableCell()); gvHeader.Rows[0].Cells[0].ColumnSpan = columncount; gvHeader.Rows[0].Cells[0].Text = "No Records Found"; } Session["SaleOrderSearch"] = dt; } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
protected void btnGenerate_Click(object sender, EventArgs e) { CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); SqlConnection conn = null; SqlCommand cmd = null; DataTable dtDataByfilter = null; string query = string.Empty; conn = new SqlConnection(obj.GetConnectionString()); conn.Open(); cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandTimeout = 3600; cmd.CommandType = CommandType.StoredProcedure; query = "[dbo].[ACX_GETUSERDETAILS]"; cmd.CommandText = query; cmd.Parameters.AddWithValue("@State", ddlState.SelectedItem.Value); if (ddlSiteId.SelectedItem.Value == "All") { cmd.Parameters.AddWithValue("@SITECODE", ""); } else { cmd.Parameters.AddWithValue("@SITECODE", ddlSiteId.SelectedItem.Value); } if (rdoDistributor.Checked == true) { cmd.Parameters.AddWithValue("@USERTYPE", "DISTRIBUTOR"); } else { cmd.Parameters.AddWithValue("@USERTYPE", "PSRVRS"); } dtDataByfilter = new DataTable(); dtDataByfilter.Load(cmd.ExecuteReader()); DataTable dt = new DataTable(); dt = dtDataByfilter; if (dt.Rows.Count > 0) { gridLoginDetails.DataSource = dt; gridLoginDetails.DataBind(); LblMessage.Text = "Total Records : " + dt.Rows.Count.ToString(); } else { gridLoginDetails.DataSource = dt; gridLoginDetails.DataBind(); LblMessage.Text = string.Empty; } }
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 LoadSiteIDDetails() { CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); string query = "Select NAME , ACXADDRESS1 + ACXADDRESS2 + ',' + ACXCITY AS SITEADDRESS from ax.inventsite where SITEID='" + Session["SiteCode"] + "'"; System.Data.DataTable dt = obj.GetData(query); if (dt.Rows.Count > 0) { lblAddress.Text = dt.Rows[0]["SITEADDRESS"].ToString(); } }
protected void BindGridview() { try { CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); DataTable dt = new DataTable(); List <string> ilist = new List <string>(); List <string> item = new List <string>(); ilist.Add("@ITEM_CATEGORY"); item.Add(drpItemCategory.SelectedItem.Value); ilist.Add("@ITEM_CODE"); item.Add(drpItemCode.SelectedItem.Value); ilist.Add("@ITEM_DESC"); item.Add(DrpItemDescription.SelectedItem.Value); ilist.Add("@QTY_IN_PCS"); item.Add(txtQTYPcs.Text.Trim()); ilist.Add("@REMARK"); item.Add(txtRemark.Text.Trim()); if (dt.Rows.Count > 0) { gvDetails.DataSource = dt; gvDetails.DataBind(); } else { DataRow dr = null; dr = dt.NewRow(); dr["Line_No"] = 1; dr["ITEM_CATEGORY"] = string.Empty; dr["ITEM_CODE"] = string.Empty; dr["ITEM_NAME"] = string.Empty; dr["ITEM_DESC"] = string.Empty; dr["QTY_IN_PCS"] = string.Empty; dr["REMARK"] = 0; dt.Rows.Add(dr); gvDetails.DataSource = dt; gvDetails.DataBind(); int count = gvDetails.Rows.Count; for (int i = count; i > 0; i--) { gvDetails.Rows[i - 1].Cells.Clear(); } } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
protected void lnkbtn_Click(object sender, EventArgs e) { try { GridViewRow gvrow = (GridViewRow)(((LinkButton)sender)).NamingContainer; LinkButton lnk = sender as LinkButton; Session["Lndentno"] = lnk.Text; DataTable dt = new DataTable(); string query; //query = "select A.Indent_No, A.Line_No,A.Product_Group,A.Product_Code," + // "Product_Name=(Select B.Product_Name from ax.AcxProductMaster B where B.Product_Code=A.Product_Code and " + // "B.Product_GRoup=A.Product_Group)," + // "cast(A.Box as decimal(10,2)) Box ,cast(A.Crates as decimal(10,2)) Crates ,cast(A.Ltr as decimal(10,2)) Ltr " + // "from ax.ACXPurchIndentLine A Where A.Indent_No='" + lnk.Text + "' and A.SITEID='" + Session["SiteCode"].ToString() + "' order by A.Line_no"; query = "select A.Indent_No, A.Line_No,A.Product_Group,A.Product_Code," + "Product_Name=(Select B.Product_Name from ax.INVENTTABLE B where B.Itemid=A.Product_Code and " + "B.Product_GRoup=A.Product_Group)," + "cast(A.Box as decimal(10,2)) Box ,cast(A.Crates as decimal(10,2)) Crates ,cast(A.Ltr as decimal(10,2)) Ltr " + "from ax.ACXPurchIndentLine A Where A.Indent_No='" + lnk.Text + "' and A.SITEID='" + Session["SiteCode"].ToString() + "' order by A.Line_no"; CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); dt = obj.GetData(query); if (dt.Rows.Count > 0) { gvLineDetails.DataSource = dt; gvLineDetails.DataBind(); } else { dt.Rows.Add(dt.NewRow()); gvLineDetails.DataSource = dt; gvLineDetails.DataBind(); int columncount = gvHeader.Rows[0].Cells.Count; gvLineDetails.Rows[0].Cells.Clear(); gvLineDetails.Rows[0].Cells.Add(new TableCell()); gvLineDetails.Rows[0].Cells[0].ColumnSpan = columncount; } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } finally { } }
protected void SONo_CheckedChanged(object sender, EventArgs e) { try { GridViewRow gvrow = (GridViewRow)(((LinkButton)sender)).NamingContainer; CheckBox lnk = sender as CheckBox; DataTable dt = new DataTable(); string query = "Select B.SO_NO,CONVERT(VARCHAR(11),B.SO_Date,106) as SO_Date," + "Customer_Group=(select C.CustGroup_Name from ax.ACXCUSTGROUPMASTER C where C.CustGroup_Code=D.Cust_Group)," + "Concat(D.Customer_Code,'-',D.Customer_Name) as customer," + "E.Product_Group, E.ItemId+'-'+E.Product_Name as Product," + "cast(A.BOX as decimal(10,2)) as BOX,cast(A.Crates as decimal(10,2)) as Crates,cast(A.Ltr as decimal(10,2)) as Ltr " + " from ax.ACXLOADSHEETLINE A" + " left join ax.ACXLOADSHEETHEADER B on A.LoadSheet_No=B.LoadSheet_No" + " left join ax.Acxcustmaster D on D.Customer_Code=B.Customer_Code" + // " left Join ax.ACXProductMaster E on A.Product_COde=E.Product_Code" + " left Join ax.InventTable E on A.Product_COde=E.ItemId" + " Where B.SO_NO='" + lnk.Text + "' and A.SHITEID='" + Session["SiteCode"].ToString() + "'" + " Order By A.Line_No"; CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); dt = obj.GetData(query); if (dt.Rows.Count > 0) { gvLineDetails.DataSource = dt; gvLineDetails.DataBind(); } else { dt.Rows.Add(dt.NewRow()); gvLineDetails.DataSource = dt; gvLineDetails.DataBind(); int columncount = gvHeader.Rows[0].Cells.Count; gvLineDetails.Rows[0].Cells.Clear(); gvLineDetails.Rows[0].Cells.Add(new TableCell()); gvLineDetails.Rows[0].Cells[0].ColumnSpan = columncount; } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } finally { } }
public void BindLineItem() { try { DataTable dt = new DataTable(); string query = "select A.SO_NO,CONVERT(VARCHAR(11),B.[SO_DATE],106) as SO_Date," + "Customer_Group=(select C.CustGroup_Name from ax.ACXCUSTGROUPMASTER C where C.CustGroup_Code=D.Cust_Group),Concat (D.Customer_Code,'-',D.Customer_Name) as customer," + "Concat(D.Customer_Code,'-',D.Customer_Name) as customer," + "E.Product_Group, E.ItemId+'-'+E.Product_Name as Product,cast(A.BOX as decimal(10,2)) as BOX,cast(A.Crates as decimal(10,2)) as Crates,cast(A.Ltr as decimal(10,2)) as Ltr" + " from ax.ACXSALESLINE A left join [ax].[ACXSALESHEADER] B on A.SO_NO=B.SO_NO left join ax.Acxcustmaster D on D.Customer_Code=B.Customer_Code left Join ax.InventTable E on A.Product_COde=E.ItemId" + " Where B.SO_NO='" + Session["SO_NO"].ToString() + "' and A.SITEID='" + Session["SiteCode"].ToString() + "'" + " Order By A.Line_No"; CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); dt = obj.GetData(query); if (dt.Rows.Count > 0) { gvLineDetails.DataSource = dt; gvLineDetails.DataBind(); } else { dt.Rows.Add(dt.NewRow()); gvLineDetails.DataSource = dt; gvLineDetails.DataBind(); int columncount = gvLineDetails.Rows[0].Cells.Count; gvLineDetails.Rows[0].Cells.Clear(); gvLineDetails.Rows[0].Cells.Add(new TableCell()); gvLineDetails.Rows[0].Cells[0].ColumnSpan = columncount; } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } finally { } }
protected void BindGridview() { try { string query; query = "Select A.Indent_NO,CONVERT(VARCHAR(11),A.Indent_Date,106) as Indent_Date ,coalesce(CONVERT(VARCHAR(11),Required_Date,106),'') as Required_Date," + // "SALEOFFICE_CODE=(select B.SALEOFFICE_CODE from ax.ACXSITEMASTER B where B.SiteId=A.SiteId )," + "SALEOFFICE_CODE=(select B.ACXPLANTCODE from [ax].[INVENTSITE] B where B.SiteId=A.SiteId )," + //"SALEOFFICE_NAME=(select B.SALEOFFICE_NAME from ax.ACXSITEMASTER B where B.SiteId=A.SiteId ),"+ "SALEOFFICE_NAME=(select B.ACXPLANTNAME from [ax].[INVENTSITE] B where B.SiteId=A.SiteId )," + "Box=(Select cast(sum(C.BOX) as decimal(10,2)) BOX from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId )," + "Crates=(Select cast(sum(C.Crates) as decimal(10,2)) Crates from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId )," + "Ltr=(Select cast(sum(C.Ltr) as decimal(10,2)) Ltr from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId )," + "A.So_No, A.Invoice_No ," + " case A.STATUS when 1 then 'Confirm' when 0 then 'Pending' end as Confirm " + "from ax.ACXPURCHINDENTHEADER A where A.indent_No!='' and [Siteid]='" + Session["SiteCode"].ToString() + "' order by A.Indent_Date desc"; CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); DataTable dt = new DataTable(); dt = obj.GetData(query); if (dt.Rows.Count > 0) { gvHeader.DataSource = dt; gvHeader.DataBind(); } else { dt.Rows.Add(dt.NewRow()); gvHeader.DataSource = dt; gvHeader.DataBind(); int columncount = gvHeader.Rows[0].Cells.Count; gvHeader.Rows[0].Cells.Clear(); gvHeader.Rows[0].Cells.Add(new TableCell()); gvHeader.Rows[0].Cells[0].ColumnSpan = columncount; gvHeader.Rows[0].Cells[0].Text = "No Records Found"; } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
public void BindNewLine() { try { DataTable dt = new DataTable(); string query; query = "select A.Indent_No, A.Line_No,A.Product_Group,A.Product_Code," + "Product_Name=(Select B.Product_Name from ax.AcxProductMaster B where B.Product_Code=A.Product_Code and " + "B.Product_GRoup=A.Product_Group)," + "cast(A.Box as decimal(10,2)) Box ,cast(A.Crates as decimal(10,2)) Crates ,cast(A.Ltr as decimal(10,2)) Ltr " + "from ax.ACXPurchIndentLine A Where A.Indent_No='" + Session["IndentNo"].ToString() + "' and A.SITEID='" + Session["SiteCode"].ToString() + "' order by A.Line_no"; CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); dt = obj.GetData(query); if (dt.Rows.Count > 0) { gvLineDetails.DataSource = dt; gvLineDetails.DataBind(); } else { dt.Rows.Add(dt.NewRow()); gvLineDetails.DataSource = dt; gvLineDetails.DataBind(); int columncount = gvHeader.Rows[0].Cells.Count; gvLineDetails.Rows[0].Cells.Clear(); gvLineDetails.Rows[0].Cells.Add(new TableCell()); gvLineDetails.Rows[0].Cells[0].ColumnSpan = columncount; } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } finally { } }
private void GetPSRDistributorLinking() { try { CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); string query = " Select A.Site_Code,Site_Name=(select B.Name from [ax].[INVENTSITE] B where B.SITEID=A.Site_Code)," + " A.PSRCode,PSRName=(select C.PSR_Name from [ax].[ACXPSRMaster] C where C.PSR_Code=A.PSRCode)," + " CONVERT(VARCHAR(11),A.[FromDate],106) as [FromDate],CONVERT(VARCHAR(11),A.[TODate],106) as [TODate]" + " from [ax].[ACXPSRSITELinkingMaster] A where A.Site_Code='" + Session["SiteCode"].ToString() + "' and A.Blocked=0 Order By PSRName,A.[FromDate] Desc"; DataTable dt = obj.GetData(query); if (dt.Rows.Count > 0) { gvDetails.DataSource = dt; gvDetails.DataBind(); } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
private void ShowData(string CustID) { try { CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); string query = " Select *, B.CUSTGROUP_NAME, C.PSR_Name,D.BeatName,CG.Description As ChannelGroupName,CT.SubSegmentDescription As ChannelTypeName " + " FROM [ax].[ACXCUSTMASTER] A " + " LEFT OUTER JOIN [AX].[ACXSMMBUSRELSEGMENTGROUP] CG ON CG.SegmentID= A.CHANNELGROUP " + " LEFT OUTER JOIN [AX].[ACXSMMBUSRELSUBSEGMENTGROUP] CT ON CT.SubSegmentID= A.CHANNELTYPE " + " LEFT OUTER JOIN ax.ACXCUSTGROUPMASTER B ON A.CUST_GROUP=B.CUSTGROUP_CODE " + " LEFT OUTER JOIN [ax].[ACXPSRMaster] C ON A.PSR_CODE=C.PSR_Code LEFT OUTER JOIN " + " [ax].[ACXPSRBeatMaster] D ON A.PSR_BEAT = D.BeatCode and A.SITE_CODE=D.Site_code where Customer_Code ='" + CustID + "' and A.BLOCKED=0"; System.Data.DataTable dt = obj.GetData(query); if (dt.Rows.Count > 0) { LiteralCustID.Text = "[" + Request.QueryString["CustID"].ToString() + "] "; txtCustomerName.Text = dt.Rows[0]["Customer_Name"].ToString(); txtCustomerName.Font.Bold = true; txtContactPerson.Text = dt.Rows[0]["Contact_Name"].ToString(); txtAddress1.Text = dt.Rows[0]["Address1"].ToString(); txtAddress2.Text = dt.Rows[0]["Address2"].ToString(); txtCity.Text = dt.Rows[0]["City"].ToString(); txtZipCode.Text = dt.Rows[0]["ZipCode"].ToString(); txtArea.Text = dt.Rows[0]["Area"].ToString(); txtDistrict.Text = dt.Rows[0]["District"].ToString(); txtState.Text = dt.Rows[0]["State"].ToString(); txtMobileNo.Text = dt.Rows[0]["Mobile_No"].ToString(); txtMobileNo.Font.Bold = true; txtPhoneNo.Text = dt.Rows[0]["Phone_No"].ToString(); txtEmailID.Text = dt.Rows[0]["EmailId"].ToString(); txtPaymentTerm.Text = dt.Rows[0]["Payment_Term"].ToString(); txtPaymentMode.Text = dt.Rows[0]["Payment_Mode"].ToString(); txtPAN.Text = dt.Rows[0]["Pan"].ToString(); txtTINVAT.Text = dt.Rows[0]["VAT"].ToString(); txtCST.Text = dt.Rows[0]["CST"].ToString(); txtTAN.Text = dt.Rows[0]["TAN"].ToString(); txtRegDate.Text = dt.Rows[0]["Register_Date"].ToString(); txtClosingDate.Text = dt.Rows[0]["Closing_Date"].ToString(); txtCustGroup.Text = "[" + dt.Rows[0]["CUST_GROUP"].ToString() + "]" + " " + dt.Rows[0]["CUSTGROUP_NAME"].ToString(); txtCustGroup.Font.Bold = true; txtDistance.Text = string.Empty; txtPSRName.Text = "[" + dt.Rows[0]["PSR_Code"].ToString() + "]" + " " + dt.Rows[0]["PSR_Name"].ToString(); txtPSRName.Font.Bold = true; txtPSRBeatName.Text = "[" + dt.Rows[0]["PSR_Beat"].ToString() + "]" + " " + dt.Rows[0]["BeatName"].ToString(); //+"/" + dt.Rows[0]["PSR_Day"].ToString(); txtPSRBeatName.Font.Bold = true; txtDeepFreeer.Text = dt.Rows[0]["Deep_Frizer"].ToString(); txtDeepFreeer.Font.Bold = true; txtDeepFreeer.ForeColor = System.Drawing.Color.DarkGreen; //txtChannelType.Text = dt.Rows[0]["Channel_Type"].ToString(); txtChannelGroup.Text = dt.Rows[0]["ChannelGroupName"].ToString(); txtChannelType.Text = dt.Rows[0]["ChannelTypeName"].ToString(); txtMonday.Text = dt.Rows[0]["Monday"].ToString(); txtTuesday.Text = dt.Rows[0]["Tuesday"].ToString(); txtWednesday.Text = dt.Rows[0]["Wednesday"].ToString(); txtThursday.Text = dt.Rows[0]["Thursday"].ToString(); txtFriday.Text = dt.Rows[0]["Friday"].ToString(); txtSaturday.Text = dt.Rows[0]["Saturday"].ToString(); txtSunday.Text = dt.Rows[0]["Sunday"].ToString(); txtVisitFrequency.Text = dt.Rows[0]["VISITFREQUENCY"].ToString(); txtRepeatWeek.Text = dt.Rows[0]["REPEATWEEK"].ToString(); txtSequenceno.Text = dt.Rows[0]["SEQUENCENO"].ToString(); if (Convert.ToInt32(dt.Rows[0]["Key_Customer"].ToString()) == 0) { txtKeyCustomer.Text = "No"; txtKeyCustomer.Font.Bold = true; txtKeyCustomer.ForeColor = System.Drawing.Color.Red; } else { txtKeyCustomer.Text = "Yes"; txtKeyCustomer.Font.Bold = true; txtKeyCustomer.ForeColor = System.Drawing.Color.Green; } //txtKeyCustomer.Text = dt.Rows[0]["Key_Customer"].ToString(); if (Convert.ToInt32(dt.Rows[0]["Blocked"].ToString()) == 0) { txtActiveInactive.Text = "Yes"; txtActiveInactive.Font.Bold = true; txtActiveInactive.ForeColor = System.Drawing.Color.DarkGreen; } else { txtActiveInactive.Text = "No"; txtActiveInactive.ForeColor = System.Drawing.Color.Red; } string APPLICABLESCHEMEDISCOUNT; if (dt.Rows[0]["APPLICABLESCHEMEDISCOUNT"].ToString() == "0") { APPLICABLESCHEMEDISCOUNT = "None"; } else if (dt.Rows[0]["APPLICABLESCHEMEDISCOUNT"].ToString() == "1") { APPLICABLESCHEMEDISCOUNT = "Scheme"; } else if (dt.Rows[0]["APPLICABLESCHEMEDISCOUNT"].ToString() == "2") { APPLICABLESCHEMEDISCOUNT = "Discount"; } else { APPLICABLESCHEMEDISCOUNT = "Both"; } txtOutletType.Text = dt.Rows[0]["Outlet_Type"].ToString(); txtSchemeDisc.Text = APPLICABLESCHEMEDISCOUNT; //dt.Rows[0]["Scheme_Discount"].ToString(); } else { this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('No Data Exists !');", true); } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
private void ShowCurrentStock() { if (lstState.SelectedValue == string.Empty) { ScriptManager.RegisterStartupScript(this, typeof(Page), "Validation", "alert('Please select atleast one state before show!');", true); return; } else if (lstSiteId.SelectedValue == string.Empty) { ScriptManager.RegisterStartupScript(this, typeof(Page), "Validation", "alert('Please select atleast one distributor before show!');", true); return; } else if (ddlWarehouse.SelectedValue == string.Empty) { ScriptManager.RegisterStartupScript(this, typeof(Page), "Validation", "alert('Please select atleast one Warehouse before show!');", true); return; } CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); DataTable dt = new DataTable(); List <string> ilist = new List <string>(); List <string> item = new List <string>(); string WareHouse; WareHouse = ""; string siteid = ""; foreach (System.Web.UI.WebControls.ListItem litem in ddlWarehouse.Items) { if (litem.Selected) { if (WareHouse.Length == 0) { WareHouse = litem.Value.ToString(); } else { WareHouse += "," + litem.Value.ToString(); } } } foreach (System.Web.UI.WebControls.ListItem litem in lstSiteId.Items) { if (litem.Selected) { if (siteid.Length == 0) { siteid = litem.Value.ToString(); } else { siteid += "," + litem.Value.ToString(); } } } string query = "ACX_CurrentStock"; ilist.Add("@Site_Code"); item.Add(siteid.ToString()); ilist.Add("@TransLocation"); item.Add(WareHouse);//item.Add("59144MW");// ilist.Add("@Dataareaid"); item.Add(Session["DATAAREAID"].ToString()); if (ddlBuunit.SelectedIndex >= 1) { ilist.Add("@BUCODE"); item.Add(ddlBuunit.SelectedValue.ToString()); } else { ilist.Add("@BUCODE"); item.Add(""); } dt = obj.GetData_New(query, CommandType.StoredProcedure, ilist, item); if (dt.Rows.Count > 0) { //object sumLtr,SumQty,SumQtyLtr; //sumLtr = dt.Compute("Sum(LTR)", ""); //SumQty = dt.Compute("Sum(Qty)", ""); //SumQtyLtr = dt.Compute("Sum(QTYLtr)", ""); //dt.Rows.Add("TOTAL", "", "", "0", sumLtr, "0", SumQty, SumQtyLtr, "0", "", "", ""); gridCurrentStcok.DataSource = dt; gridCurrentStcok.DataBind(); LblMessage.Text = "Total Records : " + dt.Rows.Count.ToString(); Session["CurrentStock"] = dt; } else { gridCurrentStcok.DataSource = dt; gridCurrentStcok.DataBind(); LblMessage.Text = string.Empty; } }
public void UpdateTransTable(string PostedDocumentNo, SqlTransaction trans, SqlConnection conn) { try { CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); string TransLocation = ""; string TransId = string.Empty; string query1 = "select MainWarehouse from ax.inventsite where siteid='" + Session["SiteCode"].ToString() + "'"; DataTable dt = new DataTable(); dt = obj.GetData(query1); if (dt.Rows.Count > 0) { TransLocation = dt.Rows[0]["MainWarehouse"].ToString(); } string queryInsert = " Insert Into ax.acxinventTrans " + "([TransId],[SiteCode],[DATAAREAID],[RECID],[InventTransDate],[TransType],[DocumentType]," + "[DocumentNo],[DocumentDate],[ProductCode],[TransQty],[TransUOM],[TransLocation],[Referencedocumentno])" + " Values (@TransId,@SiteCode,@DATAAREAID,@RECID,@InventTransDate,@TransType,@DocumentType,@DocumentNo,@DocumentDate, " + " @ProductCode,@TransQty,@TransUOM,@TransLocation,@Referencedocumentno)"; cmd = new SqlCommand(queryInsert); cmd.Connection = conn; cmd.Transaction = transaction; cmd.CommandTimeout = 3600; cmd.CommandType = CommandType.Text; string st = Session["SiteCode"].ToString(); if (st.Length <= 6) { TransId = st + System.DateTime.Now.ToString("yymmddhhmmss"); } else { TransId = st.Substring(st.Length - 6) + System.DateTime.Now.ToString("yymmddhhmmss"); } for (int p = 0; p < GridPurchItems.Rows.Count; p++) { string Siteid = Session["SiteCode"].ToString(); string DATAAREAID = Session["DATAAREAID"].ToString(); int TransType = 1; // Type 1 for Purchase Invoice Receipt int DocumentType = 1; string DocumentNo = PostedDocumentNo; string productNameCode = GridPurchItems.Rows[p].Cells[2].Text; string[] str = productNameCode.Split('-'); string ProductCode = str[0].ToString(); string box = GridPurchItems.Rows[p].Cells[4].Text; decimal TransQty = Convert.ToDecimal(box) * 1; string UOM = GridPurchItems.Rows[p].Cells[6].Text; string Referencedocumentno = PostedDocumentNo; int REcid = p + 1; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@TransId", TransId); cmd.Parameters.AddWithValue("@SiteCode", Siteid); cmd.Parameters.AddWithValue("@DATAAREAID", DATAAREAID); cmd.Parameters.AddWithValue("@RECID", p + 1); cmd.Parameters.AddWithValue("@InventTransDate", DateTime.Now); cmd.Parameters.AddWithValue("@TransType", TransType); cmd.Parameters.AddWithValue("@DocumentType", DocumentType); cmd.Parameters.AddWithValue("@DocumentNo", DocumentNo); cmd.Parameters.AddWithValue("@DocumentDate", DateTime.Now); cmd.Parameters.AddWithValue("@ProductCode", ProductCode); cmd.Parameters.AddWithValue("@TransQty", TransQty); cmd.Parameters.AddWithValue("@TransUOM", UOM); cmd.Parameters.AddWithValue("@TransLocation", TransLocation); cmd.Parameters.AddWithValue("@Referencedocumentno", Referencedocumentno); int i = cmd.ExecuteNonQuery(); } } catch (Exception ex) { transaction.Rollback(); LblMessage.Text = ex.Message.ToString(); ErrorSignal.FromCurrentContext().Raise(ex); } #region old Code PROCEDURE ISSUE //try //{ // CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); // conn = obj.GetConnection(); // string TransLocation = ""; // string TransId = string.Empty; // string query1 = "select MainWarehouse from ax.inventsite where siteid='" + Session["SiteCode"].ToString() + "'"; // DataTable dt = new DataTable(); // dt = obj.GetData(query1); // if (dt.Rows.Count > 0) // { // TransLocation = dt.Rows[0]["MainWarehouse"].ToString(); // } // string st = Session["SiteCode"].ToString(); // if (st.Length <= 6) // { // TransId = st + System.DateTime.Now.ToString("yymmddhhmmss"); // } // else // { // TransId = st.Substring(st.Length - 6) + System.DateTime.Now.ToString("yymmddhhmmss"); // } // cmd = new SqlCommand(); // cmd.Connection = conn; // cmd.CommandTimeout = 100; // cmd.CommandText = string.Empty; // cmd.CommandType = CommandType.StoredProcedure; // cmd.CommandText = "[ACX_PURCHINVC_UPDATEINVENTTRANS]"; // cmd.Parameters.Clear(); // string strSite = Session["SiteCode"].ToString(); // string strDAtaArea = Session["DATAAREAID"].ToString(); // cmd.Parameters.AddWithValue("@SITECODE", strSite); // cmd.Parameters.AddWithValue("@DOCUMENTPURCHRECEIPTNUMBER", PostedDocumentNo); // cmd.Parameters.AddWithValue("@DATAAREAID", strDAtaArea); // cmd.Parameters.AddWithValue("@TRANSID", TransId); // cmd.Parameters.AddWithValue("@WAREHOUSE", TransLocation); // cmd.Parameters.AddWithValue("@TRANSTYPE", 1); // int i = cmd.ExecuteNonQuery(); //} //catch (Exception ex) //{ // LblMessage.Text = "Error: Inventory Update Issue - " + ex.Message.ToString(); //} //finally //{ // if (conn != null) // { // if (conn.State == ConnectionState.Open) // { // conn.Close(); // } // } //} #endregion }
protected void btnSave_Click(object sender, EventArgs e) { try { { if (Session["LineItem"] != null) { CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); conn = obj.GetConnection(); DataTable dtNumSeq = obj.GetNumSequenceNew(12, Session["SiteCode"].ToString(), Session["DATAAREAID"].ToString()); string NUMSEQ = string.Empty; string Code = string.Empty; if (dtNumSeq != null) { Code = dtNumSeq.Rows[0][0].ToString(); NUMSEQ = dtNumSeq.Rows[0][1].ToString(); } else { return; } cmd1 = new SqlCommand("[dbo].[ACX_InventoryReceipt_POPLine]"); transaction = conn.BeginTransaction(); cmd1.Connection = conn; cmd1.Transaction = transaction; cmd1.CommandTimeout = 3600; cmd1.CommandType = CommandType.StoredProcedure; //=============Save Line============= int i = 0; foreach (GridViewRow grv in gvDetails.Rows) { HiddenField lblProduct = (HiddenField)grv.FindControl("HiddenValueItemCode"); Label QTY = (Label)grv.Cells[5].FindControl("QTY"); Label Remark = (Label)grv.Cells[5].FindControl("Remark"); i = i + 1; string st = Session["SiteCode"].ToString(); string TransId = st.Substring(st.Length - 6) + System.DateTime.Now.ToString("yymmddhhmmss"); cmd1.Parameters.Clear(); cmd1.Parameters.AddWithValue("@TransId", TransId); cmd1.Parameters.AddWithValue("@Site_Code", lblsite.Text); cmd1.Parameters.AddWithValue("@Line_No", i); cmd1.Parameters.AddWithValue("@DOC_NO", Code); cmd1.Parameters.AddWithValue("@ITEM_CODE", lblProduct.Value); cmd1.Parameters.AddWithValue("@QTY_IN_PCS", QTY.Text); cmd1.Parameters.AddWithValue("@REMARK", Remark.Text); cmd1.Parameters.AddWithValue("@NumSeq", NUMSEQ); cmd1.Parameters.AddWithValue("@DATAAREAID", Session["DATAAREAID"].ToString()); cmd1.ExecuteNonQuery(); } // ==============Save Header========= List <string> ilist = new List <string>(); List <string> litem = new List <string>(); cmd = new SqlCommand("[dbo].[ACX_InventoryReceipt_POPHeader]"); cmd.Connection = conn; cmd.Transaction = transaction; cmd.CommandTimeout = 3600; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Site_Code", Session["SiteCode"].ToString()); cmd.Parameters.AddWithValue("@SUPPLIER_NAME", txtSupplierName.Text); cmd.Parameters.AddWithValue("@SUPPLIER_ADDRESS", txtSupplierAdd.Text); cmd.Parameters.AddWithValue("@DOC_NO", Code); cmd.Parameters.AddWithValue("@INVOICE_NO", txtDocumentNo.Text); cmd.Parameters.AddWithValue("@INVOICE_DATE", txtDocumentDate.Text); cmd.Parameters.AddWithValue("@NumSeq", NUMSEQ); cmd.Parameters.AddWithValue("@DATAAREAID", Session["DATAAREAID"].ToString()); cmd.ExecuteNonQuery(); transaction.Commit(); lblMessage.Text = "Data Saved Successfully. POP Inventory Reciept No is:" + Code + ""; clear(); } else { string message = "alert('Please Add Line Items First !');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); return; } } } catch (Exception ex) { transaction.Rollback(); string message = "alert('Error:" + ex.Message + " !');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); ErrorSignal.FromCurrentContext().Raise(ex); } finally { Session["LineItem"] = null; if (conn.State.ToString() == "Open") { conn.Close(); } } }
private void StockTransferTOWareHouse(string StockTransferCode, SqlTransaction trans, SqlConnection conn) // Save Same Stock to WAREHOUSE OTHER LOCATION B // { CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); //conn = obj.GetConnection(); #region Stock Transfer Save for Warehouse TO Location string queryInsert = " Insert Into AX.ACXINVENTTRANS " + " ([TransId],[SiteCode],[DATAAREAID],[RECID],[InventTransDate],[TransType],[DocumentType]," + " [DocumentNo],[DocumentDate],[ProductCode],[TransQty],[TransUOM],[TransLocation],[Referencedocumentno])" + " Values (@TransId,@SiteCode,@DATAAREAID,@RECID,@InventTransDate,@TransType,@DocumentType,@DocumentNo,@DocumentDate, " + " @ProductCode,@TransQty,@TransUOM,@TransLocation,@Referencedocumentno)"; string st = Session["SiteCode"].ToString(); string TransId = st.Substring(st.Length - 6) + System.DateTime.Now.AddSeconds(2).ToString("yymmddhhmmss"); //SiteCode[6 Character] plus yymmddhhss of current time// cmd = new SqlCommand(queryInsert); cmd.Connection = conn; cmd.Transaction = trans; cmd.CommandTimeout = 3600; cmd.CommandType = CommandType.Text; #region Grid Data Insert Section for (int i = 0; i < gridStockTransferItems.Rows.Count; i++) { string Siteid = Session["SiteCode"].ToString(); string DATAAREAID = Session["DATAAREAID"].ToString(); int TransType = 6; // For Stock Transfer TransType // int DocumentType = 6; // For Stock Transfer TransType // string DocumentNo = StockTransferCode; // Stock Transfer Number as generated by Code---// string productNameCode = gridStockTransferItems.Rows[i].Cells[3].Text; string[] str = productNameCode.Split('-'); string ProductCode = str[0].ToString(); decimal TransQty = Convert.ToDecimal(gridStockTransferItems.Rows[i].Cells[6].Text); string UOM = gridStockTransferItems.Rows[i].Cells[4].Text; int RecID = i + 1; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@TransId", TransId); cmd.Parameters.AddWithValue("@SiteCode", Siteid); cmd.Parameters.AddWithValue("@DATAAREAID", DATAAREAID); cmd.Parameters.AddWithValue("@RECID", RecID); cmd.Parameters.AddWithValue("@InventTransDate", DateTime.Now); cmd.Parameters.AddWithValue("@TransType", TransType); cmd.Parameters.AddWithValue("@DocumentType", DocumentType); cmd.Parameters.AddWithValue("@DocumentNo", DocumentNo); cmd.Parameters.AddWithValue("@Referencedocumentno", ""); cmd.Parameters.AddWithValue("@DocumentDate", Convert.ToDateTime(txtDate.Text)); cmd.Parameters.AddWithValue("@ProductCode", ProductCode); cmd.Parameters.AddWithValue("@TransQty", TransQty); // for Stock add from WareHouse TO Location// cmd.Parameters.AddWithValue("@TransUOM", UOM); cmd.Parameters.AddWithValue("@TransLocation", DDLWarehouseTo.SelectedValue.ToString()); cmd.ExecuteNonQuery(); } #endregion #endregion //} //catch (Exception ex) //{ // transaction.Rollback(); //} }
private void SaveManualPurchaseReturnToInventTransTable(string PurcReturnCode, SqlTransaction trans, SqlConnection conn, int Qty) { try { CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); string TransLocation = ""; if (Qty < 0) { string query1 = "select MainWarehouse from ax.inventsite where siteid='" + Session["SiteCode"].ToString() + "' "; DataTable dt = new DataTable(); dt = obj.GetData(query1); if (dt.Rows.Count > 0) { TransLocation = dt.Rows[0]["MainWarehouse"].ToString(); } } else { string query1 = "Select INVENTLOCATIONID from Ax.inventlocation where InventSiteid = '" + Session["SiteCode"].ToString() + "' and ACX_WAREHOUSETYPE = 1"; DataTable dt = new DataTable(); dt = obj.GetData(query1); if (dt.Rows.Count > 0) { TransLocation = dt.Rows[0]["INVENTLOCATIONID"].ToString(); } } string queryInsert = " Insert Into ax.acxinventTrans " + "([TransId],[SiteCode],[DATAAREAID],[RECID],[InventTransDate],[TransType],[DocumentType]," + "[DocumentNo],[DocumentDate],[ProductCode],[TransQty],[TransUOM],[TransLocation],[Referencedocumentno])" + " Values (@TransId,@SiteCode,@DATAAREAID,@RECID,@InventTransDate,@TransType,@DocumentType,@DocumentNo,@DocumentDate, " + " @ProductCode,@TransQty,@TransUOM,@TransLocation,@Referencedocumentno)"; cmd = new SqlCommand(queryInsert); cmd.Connection = conn; cmd.Transaction = trans; cmd.CommandTimeout = 0; cmd.CommandType = CommandType.Text; string st = Session["SiteCode"].ToString(); for (int i = 0; i < gvDetails.Rows.Count; i++) { string TransId = st.Substring(st.Length - 6) + System.DateTime.Now.ToString("yymmddhhmmss"); string Siteid = Session["SiteCode"].ToString(); string DATAAREAID = Session["DATAAREAID"].ToString(); int TransType = 8; // Type 5 for Manual Purchase Return int DocumentType = 8; string DocumentNo = PurcReturnCode; string productNameCode = gvDetails.Rows[i].Cells[2].Text; string[] str = productNameCode.Split('-'); string ProductCode = str[0].ToString(); TextBox txtBoxQty = (TextBox)gvDetails.Rows[i].Cells[4].FindControl("txtQty"); string strqty = txtBoxQty.Text; decimal TransQty = Convert.ToDecimal(strqty) * Qty; string UOM = gvDetails.Rows[i].Cells[7].Text; string Referencedocumentno = ddlInvoceNo.Text;// PurcReturnCode; int REcid = i + 1; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@TransId", TransId); cmd.Parameters.AddWithValue("@SiteCode", Siteid); cmd.Parameters.AddWithValue("@DATAAREAID", DATAAREAID); cmd.Parameters.AddWithValue("@RECID", i + 1); cmd.Parameters.AddWithValue("@InventTransDate", DateTime.Now); cmd.Parameters.AddWithValue("@TransType", TransType); cmd.Parameters.AddWithValue("@DocumentType", DocumentType); cmd.Parameters.AddWithValue("@DocumentNo", DocumentNo); cmd.Parameters.AddWithValue("@DocumentDate", DateTime.Now); cmd.Parameters.AddWithValue("@ProductCode", ProductCode); cmd.Parameters.AddWithValue("@TransQty", TransQty); cmd.Parameters.AddWithValue("@TransUOM", UOM); cmd.Parameters.AddWithValue("@TransLocation", TransLocation); cmd.Parameters.AddWithValue("@Referencedocumentno", ddlInvoceNo.SelectedItem.Value); cmd.ExecuteNonQuery(); } } catch (Exception ex) { transaction.Rollback(); ErrorSignal.FromCurrentContext().Raise(ex); } }
private void SaveDetails() { try { App_Code.Global obj = new App_Code.Global(); //string Number="DT16000001"; #region getnTUMBER string Number = string.Empty; string query = "SELECT ISNULL(MAX(CAST(RIGHT(DISTRUCTION_NO,6) AS INT)),0)+1 FROM [ax].[ACXDISTRUCTIONNOTE] where SITEID='" + Session["SiteCode"].ToString() + "'"; conn = obj.GetConnection(); cmd1 = new SqlCommand(query); transaction = conn.BeginTransaction(); cmd1.Connection = conn; cmd1.Transaction = transaction; cmd1.CommandTimeout = 3600; cmd1.CommandType = CommandType.Text; object vc = cmd1.ExecuteScalar(); Number = "DT" + System.DateTime.Today.ToString("yy") + ((int)vc).ToString("000000"); #endregion #region insert into distruction table if (Session["ProductDetails"] != null) { //conn = obj.GetConnection(); cmd = new SqlCommand("ACX_INSERTDISTRUCTIONNOTE"); // transaction = conn.BeginTransaction(); cmd.Connection = conn; cmd.Transaction = transaction; cmd.CommandTimeout = 3600; cmd.CommandType = CommandType.StoredProcedure; int i = 0; foreach (GridViewRow grv in gvDetails.Rows) { i = i + 1; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@SITEID", Session["SITECODE"].ToString()); cmd.Parameters.AddWithValue("@DISTRUCTION_NO", Number); cmd.Parameters.AddWithValue("@DATAAREAID", Session["DATAAREAID"].ToString()); cmd.Parameters.AddWithValue("@RECEIPT_NO", drpRecieptNo.SelectedItem.Text); cmd.Parameters.AddWithValue("@RECEIPTDATE", txtReceiptDate.Text); cmd.Parameters.AddWithValue("@INVOICE_NO", drpInvoceNo.SelectedItem.Text); cmd.Parameters.AddWithValue("@INVOICEDATE", txtInvoiceDate.Text); cmd.Parameters.AddWithValue("@LINENO", i); cmd.Parameters.AddWithValue("@PRODUCTCODE", grv.Cells[1].Text); cmd.Parameters.AddWithValue("@BOX", grv.Cells[3].Text); cmd.Parameters.AddWithValue("@BATCHNO", grv.Cells[5].Text.Replace(" ", "")); cmd.Parameters.AddWithValue("@MFD", grv.Cells[6].Text); cmd.Parameters.AddWithValue("@REMARK", grv.Cells[7].Text.Replace(" ", "")); cmd.Parameters.AddWithValue("@PRICE", grv.Cells[8].Text); cmd.Parameters.AddWithValue("@VALUE", Convert.ToDecimal(grv.Cells[9].Text)); cmd.Parameters.AddWithValue("@DISTRUCTIONTYPE", 0); cmd.ExecuteNonQuery(); } #endregion #region insert into transaction table and claim table cmd2 = new SqlCommand("ACX_DISTRUCTION_STOCK_MOVEMENT"); cmd2.Connection = conn; cmd2.Transaction = transaction; cmd2.CommandTimeout = 3600; cmd2.CommandType = CommandType.StoredProcedure; cmd2.Parameters.Clear(); cmd2.Parameters.AddWithValue("@Siteid", Session["SITECODE"].ToString()); cmd2.Parameters.AddWithValue("@DISTRUCTIONTYPE", 0); cmd2.Parameters.AddWithValue("@DISTRUCTION_NO", Number); cmd2.ExecuteNonQuery(); #endregion transaction.Commit(); ClearAll(); string message = "alert('Distruction No : " + Number + " Generated Successfully.!');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); } } catch (Exception ex) { transaction.Rollback(); string message = "alert('Error:" + ex.Message + " !');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); ErrorSignal.FromCurrentContext().Raise(ex); } finally { if (conn != null) { if (conn.State.ToString() == "Open") { conn.Close(); conn.Dispose(); } } } }
protected void btn2_Click(object sender, EventArgs e) { if (txtSearch.Text != "" || ddlSerch.SelectedItem.Text == "All") { gvHeader.DataSource = null; gvHeader.DataBind(); gvLineDetails.DataSource = null; gvLineDetails.DataBind(); if (ddlSerch.SelectedItem.Text == "All") { BindGridview(); } else { string search = ""; search = "%" + txtSearch.Text + "%"; try { string query; //string query = "Select A.Indent_NO,CONVERT(VARCHAR(11),A.Indent_Date,106) as Indent_Date ,coalesce(CONVERT(VARCHAR(11),Required_Date,106),'') as Required_Date," + // //"SALEOFFICE_CODE=(select B.SALEOFFICE_CODE from ax.ACXSITEMASTER B where B.SiteId=A.SiteId )," + //"SALEOFFICE_CODE=(select B.ACXPLANTCODE from [ax].[INVENTSITE] B where B.SiteId=A.SiteId )," + // //"SALEOFFICE_NAME=(select B.SALEOFFICE_NAME from ax.ACXSITEMASTER B where B.SiteId=A.SiteId )," + //"SALEOFFICE_NAME=(select B.ACXPLANTNAME from [ax].[INVENTSITE] B where B.SiteId=A.SiteId )," + //"Box=(Select cast(sum(C.BOX) as decimal(10,2)) BOX from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId )," + //"Crates=(Select cast(sum(C.Crates) as decimal(10,2)) Crates from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId )," + //"Ltr=(Select cast(sum(C.Ltr) as decimal(10,2)) Ltr from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId )," + //" A.So_No, A.Invoice_No ," + //" case A.STATUS when 1 then 'Confirm' when 0 then 'Pending' end as Confirm " + //"from ax.ACXPURCHINDENTHEADER A where A.indent_No!='' and [Siteid]='" + Session["SiteCode"].ToString() + "' and A." + ddlSerch.SelectedItem.Value + " like '" + search + "' order by A.Indent_No"; string searchitem = ddlSerch.SelectedItem.Value; if (searchitem == "Customer_Code") { searchitem = "SiteID"; query = @"Select A.Indent_NO,CONVERT(VARCHAR(11),A.Indent_Date,106) as Indent_Date ,coalesce(CONVERT(VARCHAR(11),A.Required_Date,106),'') as Required_Date, DISTRIBUTOR_CODE=(select B.SiteId from [ax].[INVENTSITE] B where B.SiteId=A.SiteId ), DISTRIBUTOR_NAME=(select B.NAME from [ax].[INVENTSITE] B where B.SiteId=A.SiteId), Box=(Select cast(sum(C.BOX) as decimal(10,2)) BOX from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ), Crates=(Select cast(sum(C.Crates) as decimal(10,2)) Crates from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ), Ltr=(Select cast(sum(C.Ltr) as decimal(10,2)) Ltr from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ), A.So_No, A.Invoice_No , case A.STATUS when 1 then 'Confirm' when 0 then 'Pending' end as Confirm from ax.ACXPURCHINDENTHEADER A where A.indent_No!='' and A.[ACXPLANTNAME]='" + Session["SiteCode"].ToString() + "' and A." + searchitem + " like '" + search + "' " + " and A.STATUS =1 order by Indent_Date Desc,A.Indent_No desc "; } else if (searchitem == "Customer_Name") { query = @"Select A.Indent_NO,CONVERT(VARCHAR(11),A.Indent_Date,106) as Indent_Date ,coalesce(CONVERT(VARCHAR(11),A.Required_Date,106),'') as Required_Date, DISTRIBUTOR_CODE=(select B.SiteId from [ax].[INVENTSITE] B where B.SiteId=A.SiteId ), DISTRIBUTOR_NAME=(select B.NAME from [ax].[INVENTSITE] B where B.SiteId=A.SiteId), Box=(Select cast(sum(C.BOX) as decimal(10,2)) BOX from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ), Crates=(Select cast(sum(C.Crates) as decimal(10,2)) Crates from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ), Ltr=(Select cast(sum(C.Ltr) as decimal(10,2)) Ltr from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ), A.So_No, A.Invoice_No , case A.STATUS when 1 then 'Confirm' when 0 then 'Pending' end as Confirm from ax.ACXPURCHINDENTHEADER A Inner Join [ax].[INVENTSITE] B on B.SiteId=A.SiteId where A.indent_No!='' and A.[ACXPLANTNAME]='" + Session["SiteCode"].ToString() + "' and B.NAME like '" + search + "' " + " and A.STATUS =1 order by Indent_Date Desc,A.Indent_No desc "; } else { query = @"Select A.Indent_NO,CONVERT(VARCHAR(11),A.Indent_Date,106) as Indent_Date ,coalesce(CONVERT(VARCHAR(11),A.Required_Date,106),'') as Required_Date, DISTRIBUTOR_CODE=(select B.SiteId from [ax].[INVENTSITE] B where B.SiteId=A.SiteId ), DISTRIBUTOR_NAME=(select B.NAME from [ax].[INVENTSITE] B where B.SiteId=A.SiteId), Box=(Select cast(sum(C.BOX) as decimal(10,2)) BOX from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ), Crates=(Select cast(sum(C.Crates) as decimal(10,2)) Crates from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ), Ltr=(Select cast(sum(C.Ltr) as decimal(10,2)) Ltr from ax.ACXPURCHINDENTLINE C where C.Indent_No=A.Indent_No and A.SiteId=C.SiteId ), A.So_No, A.Invoice_No , case A.STATUS when 1 then 'Confirm' when 0 then 'Pending' end as Confirm from ax.ACXPURCHINDENTHEADER A where A.indent_No!='' and A.[ACXPLANTNAME]='" + Session["SiteCode"].ToString() + "' and A." + searchitem + " like '" + search + "' " + " and A.STATUS =1 order by Indent_Date Desc,A.Indent_No desc "; } DataTable dt = new DataTable(); CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); dt = obj.GetData(query); if (dt.Rows.Count > 0) { gvHeader.DataSource = dt; gvHeader.DataBind(); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alerts", "javascript:alert('Record Not Found..')", true); } //=============================================== // dt.Clear(); // search = txtSearch.Text; // // query = "select A.Indent_No, A.Line_No,A.Product_Group,A.Product_Code," + // //"Product_Name=(Select B.Product_Name from ax.AcxProductMaster B where B.Product_Code=A.Product_Code and " + // //"B.Product_GRoup=A.Product_Group)," + // //"cast(A.Box as decimal(10,2)) Box ,cast(A.Crates as decimal(10,2)) Crates ,cast(A.Ltr as decimal(10,2)) Ltr " + // //"from ax.ACXPurchIndentLine A Where A." + ddlSerch.SelectedItem.Value + "='" + search + "' and A.SITEID='" + Session["SiteCode"].ToString() + "' order by A.Line_no"; // query = "select A.Indent_No, A.Line_No,A.Product_Group,A.Product_Code," + //"Product_Name=(Select B.Product_Name from ax.INVENTTABLE B where B.Itemid=A.Product_Code and " + //"B.Product_GRoup=A.Product_Group)," + //"cast(A.Box as decimal(10,2)) Box ,cast(A.Crates as decimal(10,2)) Crates ,cast(A.Ltr as decimal(10,2)) Ltr " + //"from ax.ACXPurchIndentLine A Where A." + ddlSerch.SelectedItem.Value + "='" + search + "' and A.SITEID='" + Session["SiteCode"].ToString() + "' order by A.Line_no"; // dt = obj.GetData(query); // if (dt.Rows.Count > 0) // { // gvLineDetails.DataSource = dt; // gvLineDetails.DataBind(); // } // else // { // //ScriptManager.RegisterStartupScript(this, this.GetType(), "alerts", "javascript:alert('Record Not Found..')", true); // } } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } finally { } } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alerts", "javascript:alert('Enter the text in serchbox..')", true); } }
protected void chkStatus_OnCheckedChanged(object sender, EventArgs e) //sale Header Grid View for Filling the Sale Line { try { string strSONO = string.Empty; DataTable dt = new DataTable(); foreach (GridViewRow row in gvDetails.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox chkRow = (row.Cells[0].FindControl("chkStatus") as CheckBox); if (chkRow.Checked) { //strSONO += "'" + chkRow.Text + "',"; //getting all So_No those are checked by User strSONO += "" + chkRow.Text + ","; } } } //==============For Warehouse Loacion 11-5-16=========== CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); string TransLocation = ""; string query1 = "select MainWarehouse from ax.inventsite where siteid='" + Session["SiteCode"].ToString() + "'"; dt = new DataTable(); dt = obj.GetData(query1); if (dt.Rows.Count > 0) { TransLocation = dt.Rows[0]["MainWarehouse"].ToString(); } //==================================== if (strSONO != string.Empty) { strSONO = strSONO.Remove(strSONO.Length - 1); //==============11-5-16======== //string strSaleLine = "Select AP.PRODUCT_GROUP,AL.PRODUCT_CODE,AP.PRODUCT_NAME,Sum(AL.CRATES) as CRATES,cast(Sum(AL.BOX) as integer) As BOX,cast(Sum(AL.BOX) as decimal(9,2)) As TotalQty,Sum(AL.LTR) AS LTR ,Cast(Round((cast(Sum(AL.BOX) as decimal(9,2))-cast(Sum(AL.BOX) as integer))*AP.Product_PackSize,2) as integer) as PCS,AP.Product_PackSize" + // ",StockBox=(Select coalesce(cast(sum(F.TransQty) as decimal(10,2)),0) as TransQty from [ax].[ACXINVENTTRANS] F where F.[SiteCode]=AL.SITEID and F.[ProductCode]=AL.Product_COde and F.[TransLocation]='" + TransLocation + "')" + // ",StockLtr =(Select coalesce(cast((sum(F.TransQty)*AP.Product_PackSize*AP.LTR)/1000 as decimal(10,2)),0) as TransQty from [ax].[ACXINVENTTRANS] F where F.[SiteCode]=AL.SITEID and F.[ProductCode]=AL.Product_COde and F.[TransLocation]='" + TransLocation + "')" + // " from [ax].[ACXSALESLINE] AL Inner Join [ax].[InventTable] AP on AL.PRODUCT_CODE = AP.ItemId " + // " where SO_No In (" + strSONO + ") and AL.SiteId='" + Session["SiteCode"].ToString() + "' group by AL.SITEID,AP.PRODUCT_GROUP,AL.PRODUCT_CODE,AP.PRODUCT_NAME,AP.Product_PackSize,AP.LTR"; string strSaleLine = "EXEC ACX_GETLOADSHEET '" + Session["SiteCode"].ToString() + "','" + TransLocation + "','" + strSONO + "'"; dt = baseObj.GetData(strSaleLine); if (dt.Rows.Count > 0) { GridView2.Visible = true; GridView2.DataSource = dt; GridView2.DataBind(); GridView2.FooterRow.Cells[2].Text = "Total :"; GridView2.FooterRow.Cells[2].HorizontalAlign = HorizontalAlign.Right; GridView2.FooterRow.Cells[2].ForeColor = System.Drawing.Color.MidnightBlue; GridView2.FooterRow.Cells[2].Font.Bold = true; decimal Crates = dt.AsEnumerable().Sum(row => row.Field <decimal>("CRATES")); GridView2.FooterRow.Cells[3].Text = Crates.ToString("N2"); GridView2.FooterRow.Cells[3].HorizontalAlign = HorizontalAlign.Right; GridView2.FooterRow.Cells[3].ForeColor = System.Drawing.Color.MidnightBlue; GridView2.FooterRow.Cells[3].Font.Bold = true; int BoxQty = dt.AsEnumerable().Sum(row => row.Field <int>("BOX")); GridView2.FooterRow.Cells[4].Text = BoxQty.ToString(); GridView2.FooterRow.Cells[4].HorizontalAlign = HorizontalAlign.Right; GridView2.FooterRow.Cells[4].ForeColor = System.Drawing.Color.MidnightBlue; GridView2.FooterRow.Cells[4].Font.Bold = true; int PCS = dt.AsEnumerable().Sum(row => row.Field <int>("PCS")); GridView2.FooterRow.Cells[5].Text = PCS.ToString(); GridView2.FooterRow.Cells[5].HorizontalAlign = HorizontalAlign.Right; GridView2.FooterRow.Cells[5].ForeColor = System.Drawing.Color.MidnightBlue; GridView2.FooterRow.Cells[5].Font.Bold = true; decimal TotalQtyConv = dt.AsEnumerable().Sum(row => row.Field <decimal>("TotalQty")); GridView2.FooterRow.Cells[6].Text = TotalQtyConv.ToString("N2"); GridView2.FooterRow.Cells[6].HorizontalAlign = HorizontalAlign.Right; GridView2.FooterRow.Cells[6].ForeColor = System.Drawing.Color.MidnightBlue; GridView2.FooterRow.Cells[6].Font.Bold = true; decimal ltr = dt.AsEnumerable().Sum(row => row.Field <decimal>("LTR")); GridView2.FooterRow.Cells[8].Text = ltr.ToString("N2"); GridView2.FooterRow.Cells[8].HorizontalAlign = HorizontalAlign.Right; GridView2.FooterRow.Cells[8].ForeColor = System.Drawing.Color.MidnightBlue; GridView2.FooterRow.Cells[8].Font.Bold = true; } else { dt = null; GridView2.DataSource = dt; GridView2.DataBind(); } } else { dt = null; GridView2.DataSource = dt; GridView2.DataBind(); } //UppnalegridDetails.Update(); } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
protected void btnBulkInv_Click(object sender, EventArgs e) { CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); SqlConnection con = obj.GetConnection(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 3600; try { int count = 0; string SO_NO = string.Empty; string custname = string.Empty; foreach (GridViewRow rw in gvHeader.Rows) { CheckBox chkBx = (CheckBox)rw.FindControl("chkSONO"); Label lblCustName = (Label)rw.FindControl("Customer_Name"); if (chkBx != null && chkBx.Checked) { count += 1; int row = rw.RowIndex; custname = lblCustName.Text; LinkButton lblSOno = (LinkButton)gvHeader.Rows[row].FindControl("lnkbtn"); Label lblinv = (Label)gvHeader.Rows[row].FindControl("Invoice_No"); if (lblSOno.Text != "") { if (lblinv.Text == "") { SO_NO += "" + lblSOno.Text + ","; } } } lblMessge.Text = ""; } if (count > 8) { ScriptManager.RegisterStartupScript(this, typeof(Page), "alerts", "alert('Maximum 8 sale order selected in single bulk invoice generation');", true); return; } SO_NO = SO_NO.Remove(SO_NO.Length - 1); cmd.Connection = con; cmd.CommandText = "EXEC AX.ACX_SOTOINVOICECREATION_BULK '" + Session["TransLocation"] + "','" + Session["SiteCode"] + "','" + SO_NO + "'"; DataTable dt = new DataTable(); dt.Load(cmd.ExecuteReader()); gridviewRecords.DataSource = dt; gridviewRecords.Visible = true; gridviewRecords.DataBind(); ModalPopupExtender1.Show(); ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", "javascript:MyMessage(" + dt.Rows.Count + "," + dt.Select("Remarks='Success'").Count() + ");", true); //Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "javascript:MyMessage("+dt.Rows.Count+","+dt.Select("Remarks='Success'").Count() +");", true); //Response.Write("<script>alert('test');</script>"); //ScriptManager.RegisterClientScriptBlock((sender as Control), this.GetType(), "alert", "alert('test');", true); } catch (Exception ex) { ErrorSignal.FromCurrentContext().Raise(ex); } }
protected void checkAll_CheckedChanged(object sender, EventArgs e) { string strSONO = string.Empty; DataTable dt = new DataTable(); foreach (GridViewRow row in gvDetails.Rows) { if (row.RowType == DataControlRowType.DataRow) { CheckBox chkRow = (row.Cells[0].FindControl("chkStatus") as CheckBox); if (chkRow.Checked) { //strSONO += "'" + chkRow.Text + "',"; //getting all So_No those are checked by User strSONO += "" + chkRow.Text + ","; } } } //==============For Warehouse Loacion 11-5-16=========== CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); string TransLocation = ""; string query1 = "select MainWarehouse from ax.inventsite where siteid='" + Session["SiteCode"].ToString() + "'"; dt = new DataTable(); dt = obj.GetData(query1); if (dt.Rows.Count > 0) { TransLocation = dt.Rows[0]["MainWarehouse"].ToString(); } //==================================== if (strSONO != string.Empty) { strSONO = strSONO.Remove(strSONO.Length - 1); //==============11-5-16======== //string strSaleLine = "Select AP.PRODUCT_GROUP,AL.PRODUCT_CODE,AP.PRODUCT_NAME,Sum(AL.CRATES) as CRATES,Sum(AL.BOX) AS BOX,Sum(AL.LTR) AS LTR " + // ",StockBox=(Select coalesce(cast(sum(F.TransQty) as decimal(10,2)),0) as TransQty from [ax].[ACXINVENTTRANS] F where F.[SiteCode]=AL.SITEID and F.[ProductCode]=AL.Product_COde and F.[TransLocation]='" + TransLocation + "')" + // ",StockLtr =(Select coalesce(cast((sum(F.TransQty)*AP.Product_PackSize*AP.LTR)/1000 as decimal(10,2)),0) as TransQty from [ax].[ACXINVENTTRANS] F where F.[SiteCode]=AL.SITEID and F.[ProductCode]=AL.Product_COde and F.[TransLocation]='" + TransLocation + "')" + // " from [ax].[ACXSALESLINE] AL Inner Join [ax].[InventTable] AP on AL.PRODUCT_CODE = AP.ItemId " + // " where SO_No In (" + strSONO + ") and AL.SiteId='" + Session["SiteCode"].ToString() + "' group by AL.SITEID,AP.PRODUCT_GROUP,AL.PRODUCT_CODE,AP.PRODUCT_NAME,AP.Product_PackSize,AP.LTR"; string strSaleLine = "EXEC ACX_GETLOADSHEET '" + Session["SiteCode"].ToString() + "','" + TransLocation + "','" + strSONO + "'"; dt = baseObj.GetData(strSaleLine); if (dt.Rows.Count > 0) { GridView2.Visible = true; GridView2.DataSource = dt; GridView2.DataBind(); } else { dt = null; GridView2.Visible = false; GridView2.DataSource = dt; GridView2.DataBind(); } } else { dt = null; GridView2.DataSource = dt; GridView2.DataBind(); } //UppnalegridDetails.Update(); }
private void SaveStockTransferToDB() { try { //var watch = System.Diagnostics.Stopwatch.StartNew(); // the code that you want to measure comes here CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); conn = obj.GetConnection(); string queryInsert = " Insert Into AX.ACXINVENTTRANS " + " ([TransId],[SiteCode],[DATAAREAID],[RECID],[InventTransDate],[TransType],[DocumentType]," + " [DocumentNo],[DocumentDate],[ProductCode],[TransQty],[TransUOM],[TransLocation],[Referencedocumentno])" + " Values (@TransId,@SiteCode,@DATAAREAID,@RECID,@InventTransDate,@TransType,@DocumentType,@DocumentNo,@DocumentDate, " + " @ProductCode,@TransQty,@TransUOM,@TransLocation,@Referencedocumentno)"; string st = Session["SiteCode"].ToString(); string TransId = st.Substring(st.Length - 6) + System.DateTime.Now.ToString("yymmddhhmmss"); //SiteCode[6 Character] plus yymmddhhss of current time// //string TransId = obj.GetNumSequence(10, Session["SiteCode"].ToString(), Session["DATAAREAID"].ToString()); #region Generate New Code for Stock Transfer string _query = "SELECT ISNULL(MAX(CAST(RIGHT(DocumentNo,10) AS INT)),0)+1 FROM [ax].[ACXINVENTTRANS] " + "where SITECODE='" + Session["SiteCode"].ToString() + "' and TransType=6"; cmd = new SqlCommand(_query); transaction = conn.BeginTransaction(); cmd.Connection = conn; cmd.Transaction = transaction; cmd.CommandTimeout = 3600; cmd.CommandType = CommandType.Text; object vc = cmd.ExecuteScalar(); string strCodeforStockTransfer = "ST-" + ((int)vc).ToString("0000000000"); //--Stock Transfer Number [ST-0000000001] ---// #endregion cmd.CommandText = string.Empty; cmd.CommandText = queryInsert; #region Grid Data Insert for Warehouse A for (int i = 0; i < gridStockTransferItems.Rows.Count; i++) { string Siteid = Session["SiteCode"].ToString(); string DATAAREAID = Session["DATAAREAID"].ToString(); int TransType = 6; // For Stock Transfer TransType // int DocumentType = 6; // For Stock Transfer TransType // string DocumentNo = strCodeforStockTransfer; // Stock Transfer Number as generated by Code---// string productNameCode = gridStockTransferItems.Rows[i].Cells[3].Text; string[] str = productNameCode.Split('-'); string ProductCode = str[0].ToString(); decimal TransQty = Convert.ToDecimal(gridStockTransferItems.Rows[i].Cells[6].Text); string UOM = gridStockTransferItems.Rows[i].Cells[4].Text; int RecID = i + 1; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@TransId", TransId); cmd.Parameters.AddWithValue("@SiteCode", Siteid); cmd.Parameters.AddWithValue("@DATAAREAID", DATAAREAID); cmd.Parameters.AddWithValue("@RECID", RecID); cmd.Parameters.AddWithValue("@InventTransDate", DateTime.Now); cmd.Parameters.AddWithValue("@TransType", TransType); cmd.Parameters.AddWithValue("@DocumentType", DocumentType); cmd.Parameters.AddWithValue("@DocumentNo", DocumentNo); cmd.Parameters.AddWithValue("@Referencedocumentno", ""); cmd.Parameters.AddWithValue("@DocumentDate", Convert.ToDateTime(txtDate.Text)); cmd.Parameters.AddWithValue("@ProductCode", ProductCode); cmd.Parameters.AddWithValue("@TransQty", TransQty * -1); // for Stock less from WareHouse From Location// cmd.Parameters.AddWithValue("@TransUOM", UOM); cmd.Parameters.AddWithValue("@TransLocation", DDLWarehouseFrom.SelectedValue.ToString()); cmd.ExecuteNonQuery(); ViewState["AdjustmentNo"] = TransId; } #endregion StockTransferTOWareHouse(strCodeforStockTransfer, transaction, conn); //obj.UpdateLastNumSequence(10, Session["SiteCode"].ToString(), Session["DATAAREAID"].ToString(), conn, transaction); transaction.Commit(); //watch.Stop(); //var elapsedMs = watch.ElapsedMilliseconds; // this.Page.ClientScript.RegisterStartupScript(GetType(), "Alert", " alert('Transfer No: " + strCodeforStockTransfer + " .Stock Transferred from "+DDLWarehouseTo.Text.ToString()+ " to "+DDLWarehouseTo.Text+ " Successfully !!. ');", true); string message = " alert('Transfer No: " + strCodeforStockTransfer + " .Stock Transferred from " + DDLWarehouseFrom.Text.ToString() + " to " + DDLWarehouseTo.Text + " Successfully !!. ');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", message, true); ResetAllControls(); cmd.Dispose(); conn.Close(); } catch (Exception ex) { transaction.Rollback(); LblMessage.Text = "► Stock Not Transffered. " + " Error: " + ex.Message.ToString(); ErrorSignal.FromCurrentContext().Raise(ex); } }
protected void btnSearch_Click(object sender, EventArgs e) { if (txtSearch.Text != "" || ddlSerch.SelectedItem.Text != "") { gvHeader.DataSource = null; gvHeader.DataBind(); gvLineDetails.DataSource = null; gvLineDetails.DataBind(); if (ddlSerch.SelectedItem.Text == "All") { BindGridview(); } else { string search = ""; search = "%" + txtSearch.Text + "%"; if (Session["SaleOrderSearch"] == null) { string query = "EXEC [dbo].[ACX_GETPENDINGSO] '" + Session["SiteCode"].ToString() + "'"; CreamBell_DMS_WebApps.App_Code.Global obj = new App_Code.Global(); DataTable dt = new DataTable(); dt = obj.GetData(query); Session["SaleOrderSearch"] = dt; dt = null; } DataTable dtSearch = (DataTable)Session["SaleOrderSearch"]; DataRow[] drSearch; if (ddlSerch.Text == "Customer Name") { drSearch = dtSearch.Select("Customer_Name like '" + search + "'"); } else if (ddlSerch.SelectedItem.Text == "Date") { drSearch = dtSearch.Select("SO_Date='" + Convert.ToDateTime(txtSearch.Text).ToString("dd MMM yyyy") + "'"); } else if (ddlSerch.SelectedItem.Text == "Load Sheet No") { drSearch = dtSearch.Select("LoadSheet_No like '" + search + "'"); } else if (ddlSerch.SelectedItem.Text == "Customer Group") { drSearch = dtSearch.Select("Customer_Group like '" + search + "'"); } else { drSearch = dtSearch.Select(ddlSerch.SelectedItem.Value + " like '" + search + "'"); } if (drSearch.Count() > 0) { DataTable dt = drSearch.CopyToDataTable(); dt = SortDataView(dt); gvHeader.DataSource = dt; gvHeader.DataBind(); CheckBox chkbox = (CheckBox)gvHeader.HeaderRow.Cells[0].FindControl("CheckAll"); chkbox.Checked = true; chkbox.Visible = true; foreach (GridViewRow grv in gvHeader.Rows) { CheckBox chkAll = (CheckBox)grv.Cells[0].FindControl("chkSONO"); chkAll.Checked = true; } return; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alerts", "javascript:alert('Record Not Found..')", true); return; } } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alerts", "javascript:alert('Enter the text in serchbox..')", true); } }