protected void BtnSave_Click(object sender, EventArgs e) { try { vdm = new VehicleDBMgr(); DateTime CreateDate = VehicleDBMgr.GetTime(vdm.conn); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; string[] dateFromstrig = txtFromdate.Text.Split(' '); if (dateFromstrig.Length > 1) { if (dateFromstrig[0].Split('-').Length > 0) { string[] dates = dateFromstrig[0].Split('-'); string[] times = dateFromstrig[1].Split(':'); fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } foreach (GridViewRow row in grdReports.Rows) { //string PaymentMode = "CASH"; //string B1Upload = "N"; //string Processed = "N"; if (row.RowType == DataControlRowType.DataRow) { CheckBox chkRow = (row.Cells[0].FindControl("chkRow") as CheckBox); if (chkRow.Checked) { string VoucherDate = row.Cells[1].Text; string VoucherNo = row.Cells[2].Text; string VoucherType = row.Cells[3].Text; string whcode = row.Cells[4].Text; string debitcode = row.Cells[5].Text; string debitledger = row.Cells[6].Text; string creditcode = row.Cells[8].Text; string AcctCode = row.Cells[8].Text; string creditledger = row.Cells[9].Text; string Amount = row.Cells[10].Text; string Narration = row.Cells[12].Text; string ser = row.Cells[11].Text; //string AcctCode = dr["Credit Code"].ToString(); //string VoucherNo = dr["Voucher No"].ToString(); //string vochertype = dr["Voucher Type"].ToString(); //string whcode = dr["WH Code"].ToString(); //string creditcode = dr["Credit Code"].ToString(); //string creditledger = dr["Ledger (Cr)"].ToString(); //string debitcode = dr["Debit Code"].ToString(); //string debitledger = dr["Ledger (Dr)"].ToString(); //string Amount = dr["Amount"].ToString(); //string Narration = dr["Narration"].ToString(); if (AcctCode == "") { } else { double num; if (double.TryParse(creditcode, out num)) { string PaymentMode = "BANK"; double amount = 0; double.TryParse(Amount, out amount); string B1Upload = "N"; string Processed = "N"; sqlcmd = new SqlCommand("SELECT CreateDate, RefDate, DocDate, Ref1, Ref2, Ref3 FROM EMROJDTP WHERE (RefDate BETWEEN @d1 AND @d2) AND (Ref1 = @Refno) AND (AcctCode=@AcctCode)"); sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); sqlcmd.Parameters.Add("@AcctCode", AcctCode); sqlcmd.Parameters.Add("@Refno", VoucherNo); DataTable dtJournelPay = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtJournelPay.Rows.Count > 0) { lbl_msg.Text = "This Receipt Already Saved"; } else { sqlcmd = new SqlCommand("Insert into EMROJDTP (CreateDate, RefDate, DocDate, TransNo, TransCode, AcctCode, AcctName, Debit, Credit, B1Upload, Processed,Ref1,OcrCode,Remarks,series) values (@CreateDate, @RefDate, @DocDate,@TransNo,@TransCode, @AcctCode, @AcctName, @Debit, @Credit, @B1Upload, @Processed,@Ref1,@OcrCode,@Remarks,@series)"); sqlcmd.Parameters.Add("@CreateDate", CreateDate); sqlcmd.Parameters.Add("@RefDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@Ref1", VoucherNo); string TransCode = "T1"; sqlcmd.Parameters.Add("@TransNo", VoucherNo); sqlcmd.Parameters.Add("@TransCode", TransCode); sqlcmd.Parameters.Add("@AcctCode", debitcode); sqlcmd.Parameters.Add("@AcctName", debitledger); double.TryParse(Amount, out amount); sqlcmd.Parameters.Add("@Debit", amount); string Creditamount = "0"; sqlcmd.Parameters.Add("@Credit", Creditamount); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@OcrCode", whcode); sqlcmd.Parameters.Add("@Remarks", Narration); string series = "134"; sqlcmd.Parameters.Add("@series", series); SAPvdm.insert(sqlcmd); sqlcmd = new SqlCommand("Insert into EMROJDTP (CreateDate, RefDate, DocDate, TransNo,TransCode, AcctCode, AcctName, Debit, Credit, B1Upload, Processed,Ref1,OcrCode,Remarks,series) values (@CreateDate, @RefDate, @DocDate,@TransNo,@TransCode, @AcctCode, @AcctName, @Debit, @Credit, @B1Upload, @Processed,@Ref1,@OcrCode,@Remarks,@series)"); sqlcmd.Parameters.Add("@CreateDate", CreateDate); sqlcmd.Parameters.Add("@RefDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@Ref1", VoucherNo); sqlcmd.Parameters.Add("@TransNo", VoucherNo); sqlcmd.Parameters.Add("@TransCode", TransCode); sqlcmd.Parameters.Add("@AcctCode", creditcode); sqlcmd.Parameters.Add("@AcctName", creditledger); string Debitamount = "0"; sqlcmd.Parameters.Add("@Debit", Debitamount); sqlcmd.Parameters.Add("@Credit", amount); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@OcrCode", whcode); sqlcmd.Parameters.Add("@Remarks", Narration); sqlcmd.Parameters.Add("@series", series); SAPvdm.insert(sqlcmd); } } else { sqlcmd = new SqlCommand("SELECT CreateDate, PaymentDate, DOE FROM EMRORCT WHERE (PaymentDate BETWEEN @d1 AND @d2) AND (ReferenceNo = @TNo) AND (CardCode=@CardCode)"); sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); sqlcmd.Parameters.Add("@TNo", VoucherNo); sqlcmd.Parameters.Add("@CardCode", creditcode); DataTable dtovpm = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtovpm.Rows.Count > 0) { lbl_msg.Text = "This Receipt Already Saved"; } else { sqlcmd = new SqlCommand("INSERT INTO EMRORCT(CreateDate, PaymentDate, DOE, ReferenceNo, CardCode, AcctNo, Remarks, PaymentMode, PaymentSum, OcrCode, B1Upload, Processed, Series) values (@CreateDate, @RefDate, @DocDate, @TransNo, @CardCode, @AcctCode, @Remarks, @PaymentMode, @PaymentSum, @OcrCode, @B1Upload, @Processed, @Series)"); sqlcmd.Parameters.Add("@CreateDate", CreateDate); sqlcmd.Parameters.Add("@RefDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@VoucherNo", VoucherNo); sqlcmd.Parameters.Add("@TransNo", VoucherNo); sqlcmd.Parameters.Add("@OcrCode", whcode); sqlcmd.Parameters.Add("@CardCode", creditcode); sqlcmd.Parameters.Add("@AcctCode", debitcode); sqlcmd.Parameters.Add("@AcctName", creditledger); sqlcmd.Parameters.Add("@Series", ser); sqlcmd.Parameters.Add("@Remarks", Narration); sqlcmd.Parameters.Add("@PaymentMode", "BANK"); sqlcmd.Parameters.Add("@PaymentSum", Amount); string B1Upload = "N"; string Processed = "N"; sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); SAPvdm.insert(sqlcmd); } } } } } } pnlHide.Visible = false; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); if (lbl_msg.Text == "") { lbl_msg.Text = "SuccessFully Saved"; } } catch (Exception ex) { lbl_msg.Text = ex.ToString(); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { vdm = new VehicleDBMgr(); DateTime CreateDate = VehicleDBMgr.GetTime(vdm.conn); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; string[] dateFromstrig = txtFromdate.Text.Split(' '); if (dateFromstrig.Length > 1) { if (dateFromstrig[0].Split('-').Length > 0) { string[] dates = dateFromstrig[0].Split('-'); string[] times = dateFromstrig[1].Split(':'); fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } foreach (DataRow dr in dt.Rows) { string AcctCode = dr["Ledger Code"].ToString(); string whCode = dr["WH Code"].ToString(); if (AcctCode == "" || whCode == "") { } else { sqlcmd = new SqlCommand("Insert into EMROJDT (CreateDate, RefDate, DocDate, TransNo, AcctCode, AcctName, Debit, Credit, B1Upload, Processed,Ref1,ocrcode,series) values (@CreateDate, @RefDate, @DocDate,@TransNo, @AcctCode, @AcctName, @Debit, @Credit, @B1Upload, @Processed,@Ref1,@ocrcode,@series)"); sqlcmd.Parameters.Add("@CreateDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@RefDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@Ref1", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@TransNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@AcctCode", dr["Ledger Code"].ToString()); sqlcmd.Parameters.Add("@AcctName", dr["Ledger Name"].ToString()); double amount = 0; double.TryParse(dr["Amount"].ToString(), out amount); if (amount < 0) { amount = Math.Abs(amount); double Debit = 0; sqlcmd.Parameters.Add("@Debit", Debit); sqlcmd.Parameters.Add("@Credit", amount); } else { amount = Math.Abs(amount); double Credit = 0; sqlcmd.Parameters.Add("@Debit", amount); sqlcmd.Parameters.Add("@Credit", Credit); } string B1Upload = "N"; string Processed = "N"; string series = "17"; sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@ocrcode", whCode); sqlcmd.Parameters.Add("@series", series); SAPvdm.insert(sqlcmd); } } pnlHide.Visible = false; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); lblmsg.Text = "Successfully Saved"; } catch (Exception ex) { lblmsg.Text = ex.ToString(); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { vdm = new VehicleDBMgr(); DateTime CreateDate = VehicleDBMgr.GetTime(vdm.conn); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; string[] dateFromstrig = txtfromdate.Text.Split(' '); if (dateFromstrig.Length > 1) { if (dateFromstrig[0].Split('-').Length > 0) { string[] dates = dateFromstrig[0].Split('-'); string[] times = dateFromstrig[1].Split(':'); fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } DateTime ServerDateCurrentdate = VehicleDBMgr.GetTime(vdm.conn); fromdate = fromdate.AddDays(1); if (dt.Rows.Count > 0) { DateTime doe = DateTime.Now; int i = 1; foreach (DataRow dr in dt.Rows) { string ocrcode2 = ""; sqlcmd = new SqlCommand("SELECT PostingDate,DocDate FROM EMROIGN WHERE DocDate BETWEEN @d1 and @d2 AND ReferenceNo=@rno AND ItemCode=@ItemCode AND ItemName=@ItemName and WhsCode=@WhsCode"); sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); sqlcmd.Parameters.Add("@rno", dr["RefNo"].ToString()); sqlcmd.Parameters.Add("@ItemCode", dr["ItemCode"].ToString()); sqlcmd.Parameters.Add("@ItemName", dr["ItemName"].ToString()); sqlcmd.Parameters.Add("@WhsCode", dr["WhsCode"].ToString()); DataTable dtSAPproduction = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtSAPproduction.Rows.Count > 0) { lblmsg.Text = "This date data already Saved"; } else { sqlcmd = new SqlCommand("Insert into EMROIGN (CreateDate,PostingDate,DocDate,ReferenceNo,ItemCode,ItemName,Quantity,WhsCode,Price,OcrCode,Remarks,B1Upload,Processed,Series,OcrCode2) values (@CreateDate,@PostingDate,@DocDate,@ReferenceNo,@ItemCode,@ItemName,@Quantity,@WhsCode,@Price,@OcrCode,@Remarks,@B1Upload,@Processed,@Series,@OcrCode2)"); sqlcmd.Parameters.Add("@CreateDate", ServerDateCurrentdate); sqlcmd.Parameters.Add("@PostingDate", fromdate); sqlcmd.Parameters.Add("@DocDate", fromdate); sqlcmd.Parameters.Add("@ReferenceNo", dr["RefNo"].ToString()); sqlcmd.Parameters.Add("@ItemCode", dr["ItemCode"].ToString()); sqlcmd.Parameters.Add("@ItemName", dr["ItemName"].ToString()); sqlcmd.Parameters.Add("@Quantity", dr["Production Quantity"].ToString()); sqlcmd.Parameters.Add("@WhsCode", dr["WhsCode"].ToString()); sqlcmd.Parameters.Add("@Price", dr["Price"].ToString()); sqlcmd.Parameters.Add("@OcrCode", dr["WhsCode"].ToString()); sqlcmd.Parameters.Add("@Remarks", dr["Remarks"].ToString()); sqlcmd.Parameters.Add("@Series", "19"); sqlcmd.Parameters.Add("@OcrCode2", dr["OcrCode2"].ToString()); string B1Upload = "N"; string Processed = "N"; sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); SAPvdm.insert(sqlcmd); } } pnlHide.Visible = false; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); lblmsg.Text = "Successfully Saved"; } } catch (Exception ex) { lblmsg.Text = ex.Message; } }
protected void BtnSave_Click(object sender, EventArgs e) { try { vdm = new VehicleDBMgr(); DateTime CreateDate = VehicleDBMgr.GetTime(vdm.conn); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; string[] dateFromstrig = txtFromdate.Text.Split(' '); if (dateFromstrig.Length > 1) { if (dateFromstrig[0].Split('-').Length > 0) { string[] dates = dateFromstrig[0].Split('-'); string[] times = dateFromstrig[1].Split(':'); fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } if (ddlSalesOffice.SelectedValue == "306") { fromdate = fromdate.AddDays(1); } else { fromdate = fromdate; } //cmd = new MySqlCommand("SELECT sno, BranchName, whcode, ladger_dr_code, tax, ntax, ledger_jv_code FROM branchdata WHERE (sno = @BranchID)"); //cmd.Parameters.AddWithValue("@BranchID", ddlSalesOffice.SelectedValue); //DataTable dtwhscode = vdm.SelectQuery(cmd).Tables[0]; //sqlcmd = new SqlCommand("SELECT CreateDate, RefDate, DocDate, Ref1, Ref2, Ref3, TransNo, AcctCode FROM EMROJDT WHERE (RefDate BETWEEN @d1 AND @d2) AND (OcrCode = @WhsCode)"); //sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); //sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); //sqlcmd.Parameters.Add("@WhsCode", dtwhscode.Rows[0]["whcode"].ToString()); //DataTable dtGI = SAPvdm.SelectQuery(sqlcmd).Tables[0]; //if (dtGI.Rows.Count > 0) //{ // lblmsg.Text = "This Transaction already saved"; //} //else //{ DataTable dtJournelPay = new DataTable(); foreach (DataRow dr in dt.Rows) { string AcctCode = dr["Ledger Code"].ToString(); string whCode = dr["WH Code"].ToString(); if (AcctCode == "" && whCode == "") { } else { sqlcmd = new SqlCommand("SELECT CreateDate, RefDate, DocDate, Ref1, Ref2, Ref3, TransNo, AcctCode FROM EMROJDT WHERE (RefDate BETWEEN @d1 AND @d2) AND (TransNo = @TransNo) AND (Ref1=@Ref1) AND (OcrCode = @OcrCode)"); sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); sqlcmd.Parameters.Add("@TransNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@OcrCode", dr["WH Code"].ToString()); sqlcmd.Parameters.Add("@Ref1", dr["Item Code"].ToString()); dtJournelPay = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtJournelPay.Rows.Count > 0) { lblmsg.Text = "This Transaction already saved"; break; } else { sqlcmd = new SqlCommand("Insert into EMROJDT (CreateDate, RefDate, DocDate, TransNo, AcctCode, AcctName, Debit, Credit, B1Upload, Processed,Ref1,OcrCode,OcrCode2,series) values (@CreateDate, @RefDate, @DocDate,@TransNo, @AcctCode, @AcctName, @Debit, @Credit, @B1Upload, @Processed,@Ref1,@OcrCode,@OcrCode2,@series)"); sqlcmd.Parameters.Add("@CreateDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@RefDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@Ref1", dr["Item Code"].ToString()); sqlcmd.Parameters.Add("@TransNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@AcctCode", dr["Ledger Code"].ToString()); sqlcmd.Parameters.Add("@AcctName", dr["Ledger Name"].ToString()); double amount = 0; double.TryParse(dr["Total Amount"].ToString(), out amount); amount = Math.Round(amount, 2); if (amount < 0) { amount = Math.Abs(amount); double Debit = 0; sqlcmd.Parameters.Add("@Debit", Debit); sqlcmd.Parameters.Add("@Credit", amount); } else { amount = Math.Abs(amount); double Credit = 0; sqlcmd.Parameters.Add("@Debit", amount); sqlcmd.Parameters.Add("@Credit", Credit); } string B1Upload = "N"; string Processed = "N"; sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@OcrCode", dr["WH Code"].ToString()); sqlcmd.Parameters.Add("@OcrCode2", dr["Category Code"].ToString()); string series = "17"; sqlcmd.Parameters.Add("@series", series); if (amount == 0.0) { } else { SAPvdm.insert(sqlcmd); } } } } if (dtJournelPay.Rows.Count > 0) { pnlHide.Visible = false; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); lblmsg.Text = "This Transaction already saved"; } else { pnlHide.Visible = false; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); lblmsg.Text = "Successfully Saved"; } //} } catch (Exception ex) { lblmsg.Text = ex.ToString(); } }
protected void btn_save_click(object sender, EventArgs e) { try { vdm = new SalesDBManager(); DateTime CreateDate = SalesDBManager.GetTime(vdm.conn); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; string[] dateFromstrig = dtp_FromDate.Text.Split(' '); if (dateFromstrig.Length > 1) { if (dateFromstrig[0].Split('-').Length > 0) { string[] dates = dateFromstrig[0].Split('-'); string[] times = dateFromstrig[1].Split(':'); fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } foreach (DataRow dr in dt.Rows) { string itemcode = dr["ITEMCODE"].ToString(); string cardcode = dr["CARD CODE"].ToString(); if (itemcode == "") { } else if (cardcode == "") { } else { cmd = new SqlCommand("SELECT * FROM EMROPOR WHERE (TaxDate BETWEEN @d1 AND @d2) AND (ReferenceNo = @ReferenceNo) AND (ItemCode = @ItemCode) AND (WhsCode = @WhsCode)"); cmd.Parameters.Add("@d1", GetLowDate(fromdate)); cmd.Parameters.Add("@d2", GetHighDate(fromdate)); cmd.Parameters.Add("@ReferenceNo", dr["REFERENCE NO"].ToString()); cmd.Parameters.Add("@WhsCode", dr["WARE HOUSE CODE"].ToString()); cmd.Parameters.Add("@ItemCode", dr["ITEMCODE"].ToString()); DataTable dtPCH = SAPvdm.SelectQuery(cmd).Tables[0]; if (dtPCH.Rows.Count > 0) { } else { cmd = new SqlCommand("insert into EMROPOR (CreateDate, CardCode, CardName, TaxDate, DocDate, DocDueDate, DiscPercent, ReferenceNo, ItemCode, Dscription, WhsCode, Quantity, Price, OcrCode, TaxCode, PURCHASETYPE, B1Upload, Processed,remarks,VAT_Percent) values (@CreateDate, @CardCode, @CardName, @TaxDate, @DocDate, @DocDueDate, @DiscPercent, @ReferenceNo, @ItemCode, @Dscription, @WhsCode, @Quantity, @Price, @OcrCode, @TaxCode, @purchasetype, @B1Upload, @Processed,@remarks,@TAXPER)"); cmd.Parameters.Add("@CreateDate", CreateDate); cmd.Parameters.Add("@CardCode", dr["CARD CODE"].ToString()); cmd.Parameters.Add("@CardName", dr["CARD NAME"].ToString()); cmd.Parameters.Add("@TaxDate", fromdate); cmd.Parameters.Add("@DocDate", fromdate); cmd.Parameters.Add("@DocDueDate", fromdate); cmd.Parameters.Add("@DiscPercent", dr["DISCOUNT %"].ToString()); cmd.Parameters.Add("@ReferenceNo", dr["REFERENCE NO"].ToString()); cmd.Parameters.Add("@ItemCode", dr["ITEMCODE"].ToString()); cmd.Parameters.Add("@Dscription", dr["DESCRIPTION"].ToString()); cmd.Parameters.Add("@WhsCode", dr["WARE HOUSE CODE"].ToString()); double qty = 0; double.TryParse(dr["QUANTITY"].ToString(), out qty); cmd.Parameters.Add("@Quantity", qty); double price = 0; double.TryParse(dr["PRICE"].ToString(), out price); cmd.Parameters.Add("@Price", price); cmd.Parameters.Add("@OcrCode", dr["WARE HOUSE CODE"].ToString()); cmd.Parameters.Add("@TaxCode", dr["TAXCODE"].ToString()); cmd.Parameters.Add("@TAXPER", dr["TAX%"].ToString()); string B1Upload = "N"; string Processed = "N"; string purchasetype = "93"; cmd.Parameters.Add("@purchasetype", purchasetype); cmd.Parameters.Add("@B1Upload", B1Upload); cmd.Parameters.Add("@Processed", Processed); cmd.Parameters.Add("@remarks", dr["Narration"].ToString()); if (qty == 0.0) { } else { SAPvdm.insert(cmd); } } } } hidepanel.Visible = false; lblmsg.Text = "Saved successfully"; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); } catch (Exception ex) { lblmsg.Text = ex.Message; hidepanel.Visible = false; } }
protected void BtnSave_Click(object sender, EventArgs e) { try { vdm = new VehicleDBMgr(); DateTime CreateDate = VehicleDBMgr.GetTime(vdm.conn); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; string[] dateFromstrig = txtFromdate.Text.Split(' '); if (dateFromstrig.Length > 1) { if (dateFromstrig[0].Split('-').Length > 0) { string[] dates = dateFromstrig[0].Split('-'); string[] times = dateFromstrig[1].Split(':'); fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } foreach (GridViewRow row in grdReports.Rows) { string PaymentMode = "CASH"; string B1Upload = "N"; string Processed = "N"; if (row.RowType == DataControlRowType.DataRow) { CheckBox chkRow = (row.Cells[0].FindControl("chkRow") as CheckBox); if (chkRow.Checked) { string sno = row.Cells[0].Text; string VoucherDate = row.Cells[1].Text; string VoucherNo = row.Cells[2].Text; string whcode = row.Cells[3].Text; string VoucherType = row.Cells[4].Text; string Ledgercode = row.Cells[5].Text; string LedgerDr = row.Cells[6].Text;; //string CreatedBy = row.Cells[5].Text; string PaidDate = row.Cells[7].Text; string customercode = row.Cells[8].Text; string LedgerCr = row.Cells[9].Text; string Amount = row.Cells[10].Text; string Narration = row.Cells[11].Text; double amount = 0; double.TryParse(Amount, out amount); //string customercode = dr["Customer Code"].ToString(); double num; if (double.TryParse(customercode, out num)) { string Customercode = row.Cells[8].Text; if (Ledgercode == "" || Customercode == "") { } else { sqlcmd = new SqlCommand("Insert into EMROJDTP (CreateDate, RefDate, DocDate, TransNo, TransCode, AcctCode, AcctName, Debit, Credit, B1Upload, Processed,Ref1,OcrCode,Remarks,series) values (@CreateDate, @RefDate, @DocDate,@TransNo,@TransCode, @AcctCode, @AcctName, @Debit, @Credit, @B1Upload, @Processed,@Ref1,@OcrCode,@Remarks,@series)"); sqlcmd.Parameters.Add("@CreateDate", CreateDate); sqlcmd.Parameters.Add("@RefDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@Ref1", VoucherNo); string TransCode = "T1"; sqlcmd.Parameters.Add("@TransNo", VoucherNo); sqlcmd.Parameters.Add("@TransCode", TransCode); sqlcmd.Parameters.Add("@AcctCode", Ledgercode); sqlcmd.Parameters.Add("@AcctName", LedgerDr); sqlcmd.Parameters.Add("@Debit", Amount); string Creditamount = "0"; sqlcmd.Parameters.Add("@Credit", Creditamount); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@OcrCode", whcode); sqlcmd.Parameters.Add("@Remarks", Narration); string series = "134"; sqlcmd.Parameters.Add("@series", series); SAPvdm.insert(sqlcmd); sqlcmd = new SqlCommand("Insert into EMROJDTP (CreateDate, RefDate, DocDate, TransNo,TransCode, AcctCode, AcctName, Debit, Credit, B1Upload, Processed,Ref1,OcrCode,Remarks,series) values (@CreateDate, @RefDate, @DocDate,@TransNo,@TransCode, @AcctCode, @AcctName, @Debit, @Credit, @B1Upload, @Processed,@Ref1,@OcrCode,@Remarks,@series)"); sqlcmd.Parameters.Add("@CreateDate", CreateDate); sqlcmd.Parameters.Add("@RefDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@Ref1", VoucherNo); sqlcmd.Parameters.Add("@TransNo", VoucherNo); sqlcmd.Parameters.Add("@TransCode", TransCode); sqlcmd.Parameters.Add("@AcctCode", Customercode); sqlcmd.Parameters.Add("@AcctName", LedgerCr); string Debitamount = "0"; sqlcmd.Parameters.Add("@Debit", Debitamount); sqlcmd.Parameters.Add("@Credit", amount); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@OcrCode", whcode); sqlcmd.Parameters.Add("@Remarks", Narration); sqlcmd.Parameters.Add("@series", series); SAPvdm.insert(sqlcmd); } } else { sqlcmd = new SqlCommand("Insert into EMRORCT (CreateDate,PaymentDate,DOE,ReferenceNo,CardCode,Remarks,PaymentMode,PaymentSum,OcrCode,B1Upload,Processed,AcctNo,series) values(@CreateDate,@PaymentDate,@DOE,@ReferenceNo,@CardCode,@Remarks,@PaymentMode,@PaymentSum,@OcrCode,@B1Upload,@Processed,@AcctNo,@series)"); sqlcmd.Parameters.Add("@CreateDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@PaymentDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@DOE", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@ReferenceNo", VoucherNo); sqlcmd.Parameters.Add("@CardCode", VoucherNo); sqlcmd.Parameters.Add("@Remarks", Narration); //sqlcmd.Parameters.Add("@InvoiceNo", dr["Voucher No"].ToString()); sqlcmd.Parameters.Add("@PaymentMode", PaymentMode); sqlcmd.Parameters.Add("@PaymentSum", amount); sqlcmd.Parameters.Add("@OcrCode", whcode); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@AcctNo", Ledgercode); string series = "15"; sqlcmd.Parameters.Add("@series", series); SAPvdm.insert(sqlcmd); } } } } pnlHide.Visible = false; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); lblmsg.Text = "Successfully Saved"; } catch (Exception ex) { lblmsg.Text = ex.ToString(); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { DBManager SalesDB = new DBManager(); DateTime CreateDate = DBManager.GetTime(vdm.conn); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; foreach (DataRow dr in dt.Rows) { string AcctCode = dr["Ledger Code"].ToString(); string whcode = dr["WH Code"].ToString(); if (AcctCode == "" && whcode == "") { } else { sqlcmd = new SqlCommand("Insert into EMROJDT (CreateDate, RefDate, DocDate, TransNo, AcctCode, AcctName, Debit, Credit, B1Upload, Processed,Ref1,OCRCODE, Series) values (@CreateDate, @RefDate, @DocDate,@TransNo, @AcctCode, @AcctName, @Debit, @Credit, @B1Upload, @Processed,@Ref1,@OCRCODE, @Series)"); sqlcmd.Parameters.Add("@CreateDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@RefDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@Ref1", dr["Invoice"].ToString()); sqlcmd.Parameters.Add("@OCRCODE", dr["WH Code"].ToString()); // int TransNo = 1; sqlcmd.Parameters.Add("@Series", "17"); sqlcmd.Parameters.Add("@TransNo", dr["Invoice"].ToString()); sqlcmd.Parameters.Add("@AcctCode", dr["Ledger Code"].ToString()); sqlcmd.Parameters.Add("@AcctName", dr["Ledger Name"].ToString()); double amount = 0; double.TryParse(dr["Amount"].ToString(), out amount); if (amount < 0) { amount = Math.Abs(amount); double Debit = 0; sqlcmd.Parameters.Add("@Debit", Debit); sqlcmd.Parameters.Add("@Credit", amount); } else { amount = Math.Abs(amount); double Credit = 0; sqlcmd.Parameters.Add("@Debit", amount); sqlcmd.Parameters.Add("@Credit", Credit); } string B1Upload = "N"; string Processed = "N"; sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); SAPvdm.insert(sqlcmd); } } DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); lblmsg.Text = "Successfully Saved"; } catch (Exception ex) { lblmsg.Text = ex.ToString(); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { vdm = new SalesDBManager(); DateTime CreateDate = SalesDBManager.GetTime(vdm.conn); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; string[] dateFromstrig = txtFromdate.Text.Split(' '); if (dateFromstrig.Length > 1) { if (dateFromstrig[0].Split('-').Length > 0) { string[] dates = dateFromstrig[0].Split('-'); string[] times = dateFromstrig[1].Split(':'); fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } foreach (DataRow dr in dt.Rows) { string PaymentMode = "CASH"; double amount = 0; double.TryParse(dr["Amount"].ToString(), out amount); string B1Upload = "N"; string Processed = "N"; string date = dr["Voucher Date"].ToString(); DateTime from_date = Convert.ToDateTime(date); sqlcmd = new SqlCommand("Insert into EMROJDTP (CreateDate, RefDate, DocDate, TransNo,TransCode, AcctCode, AcctName, Debit, Credit, B1Upload, Processed,Ref1,OcrCode,Remarks) values (@CreateDate, @RefDate, @DocDate,@TransNo,@TransCode, @AcctCode, @AcctName, @Debit, @Credit, @B1Upload, @Processed,@Ref1,@OcrCode,@Remarks)"); sqlcmd.Parameters.Add("@CreateDate", CreateDate); sqlcmd.Parameters.Add("@RefDate", GetLowDate(from_date)); sqlcmd.Parameters.Add("@docdate", GetLowDate(from_date)); sqlcmd.Parameters.Add("@Ref1", dr["Voucher No"].ToString()); string TransCode = "T1"; sqlcmd.Parameters.Add("@TransNo", dr["Voucher No"].ToString()); sqlcmd.Parameters.Add("@TransCode", TransCode); sqlcmd.Parameters.Add("@AcctCode", dr["Debit Code"].ToString()); sqlcmd.Parameters.Add("@AcctName", dr["Ledger (Dr)"].ToString()); double.TryParse(dr["Amount"].ToString(), out amount); sqlcmd.Parameters.Add("@Debit", amount); string Creditamount = "0"; sqlcmd.Parameters.Add("@Credit", Creditamount); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@OcrCode", dr["whcode"].ToString()); sqlcmd.Parameters.Add("@Remarks", dr["Narration"].ToString()); SAPvdm.insert(sqlcmd); sqlcmd = new SqlCommand("Insert into EMROJDTP (CreateDate, RefDate, DocDate, TransNo,TransCode, AcctCode, AcctName, Debit, Credit, B1Upload, Processed,Ref1,OcrCode,Remarks) values (@CreateDate, @RefDate, @DocDate,@TransNo,@TransCode, @AcctCode, @AcctName, @Debit, @Credit, @B1Upload, @Processed,@Ref1,@OcrCode,@Remarks)"); sqlcmd.Parameters.Add("@CreateDate", CreateDate); sqlcmd.Parameters.Add("@RefDate", GetLowDate(from_date)); sqlcmd.Parameters.Add("@docdate", GetLowDate(from_date)); sqlcmd.Parameters.Add("@Ref1", dr["Voucher No"].ToString()); sqlcmd.Parameters.Add("@TransNo", dr["Voucher No"].ToString()); sqlcmd.Parameters.Add("@TransCode", TransCode); sqlcmd.Parameters.Add("@AcctCode", dr["Credit Code"].ToString()); sqlcmd.Parameters.Add("@AcctName", dr["Ledger (Cr)"].ToString()); string Debitamount = "0"; sqlcmd.Parameters.Add("@Debit", Debitamount); sqlcmd.Parameters.Add("@Credit", amount); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@OcrCode", dr["whcode"].ToString()); sqlcmd.Parameters.Add("@Remarks", dr["Narration"].ToString()); SAPvdm.insert(sqlcmd); } pnlHide.Visible = false; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); lblmsg.Text = "Successfully Saved"; } catch (Exception ex) { lblmsg.Text = ex.ToString(); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { vdm = new SalesDBManager(); DateTime CreateDate = SalesDBManager.GetTime(vdm.conn); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; string[] dateFromstrig = dtp_FromDate.Text.Split(' '); if (dateFromstrig.Length > 1) { if (dateFromstrig[0].Split('-').Length > 0) { string[] dates = dateFromstrig[0].Split('-'); string[] times = dateFromstrig[1].Split(':'); fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } foreach (DataRow dr in dt.Rows) { if (ddltype.SelectedItem.Value == "2") { string AcctCode = dr["Ledger Code"].ToString(); string whCode = dr["WH Code"].ToString(); if (AcctCode == "" && whCode == "") { } else { sqlcmd = new SqlCommand("SELECT CreateDate, RefDate, DocDate, Ref1, Ref2, Ref3, TransNo, AcctCode FROM EMROJDT WHERE (RefDate BETWEEN @d1 AND @d2) AND (TransNo = @TransNo) AND (Ref1=@Ref1) AND (OcrCode = @OcrCode) AND (AcctCode=@AcCode)"); sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); sqlcmd.Parameters.Add("@TransNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@OcrCode", dr["WH Code"].ToString()); sqlcmd.Parameters.Add("@Ref1", dr["Item Code"].ToString()); sqlcmd.Parameters.Add("@AcCode", dr["Ledger Code"].ToString()); DataTable dtJournelPay = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtJournelPay.Rows.Count > 0) { } else { sqlcmd = new SqlCommand("Insert into EMROJDT (CreateDate, RefDate, DocDate, TransNo, AcctCode, AcctName, Debit, Credit, B1Upload, Processed,Ref1,OcrCode,OcrCode2,series) values (@CreateDate, @RefDate, @DocDate,@TransNo, @AcctCode, @AcctName, @Debit, @Credit, @B1Upload, @Processed,@Ref1,@OcrCode,@OcrCode2,@series)"); sqlcmd.Parameters.Add("@CreateDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@RefDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@Ref1", dr["Item Code"].ToString()); sqlcmd.Parameters.Add("@TransNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@AcctCode", dr["Ledger Code"].ToString()); sqlcmd.Parameters.Add("@AcctName", dr["Ledger Name"].ToString()); double amount = 0; double.TryParse(dr["Total Amount"].ToString(), out amount); double Debit = 0; sqlcmd.Parameters.Add("@Debit", Debit); sqlcmd.Parameters.Add("@Credit", amount); string B1Upload = "N"; string Processed = "N"; sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@OcrCode", dr["WH Code"].ToString()); sqlcmd.Parameters.Add("@OcrCode2", dr["Category Code"].ToString()); string series = "230"; sqlcmd.Parameters.Add("@series", series); SAPvdm.insert(sqlcmd); sqlcmd = new SqlCommand("Insert into EMROJDT (CreateDate, RefDate, DocDate, TransNo, AcctCode, AcctName, Debit, Credit, B1Upload, Processed,Ref1,OcrCode,OcrCode2,series) values (@CreateDate, @RefDate, @DocDate,@TransNo, @AcctCode, @AcctName, @Debit, @Credit, @B1Upload, @Processed,@Ref1,@OcrCode,@OcrCode2,@series)"); sqlcmd.Parameters.Add("@CreateDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@RefDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@Ref1", dr["Item Code"].ToString()); sqlcmd.Parameters.Add("@TransNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@AcctCode", dr["Ledger Code"].ToString()); sqlcmd.Parameters.Add("@AcctName", dr["Ledger Name"].ToString()); double tamount = 0; double.TryParse(dr["Total Amount"].ToString(), out tamount); double Credit = 0; sqlcmd.Parameters.Add("@Debit", tamount); sqlcmd.Parameters.Add("@Credit", Credit); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@OcrCode", dr["WH Code"].ToString()); sqlcmd.Parameters.Add("@OcrCode2", dr["Category Code"].ToString()); sqlcmd.Parameters.Add("@series", series); SAPvdm.insert(sqlcmd); } } } else { double amount = 0; double.TryParse(dr["Total Amount"].ToString(), out amount); string B1Upload = "N"; string Processed = "N"; sqlcmd = new SqlCommand("SELECT CreateDate, PostingDate, DocDate, ReferenceNo, ItemCode, ItemName FROM EMROIGE WHERE (PostingDate BETWEEN @d1 AND @d2) AND (ItemCode=@ItemCode) AND (ReferenceNo = @ReferenceNo) AND (WhsCode = @WhsCode)"); sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); sqlcmd.Parameters.Add("@ReferenceNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@WhsCode", dr["WH Code"].ToString()); sqlcmd.Parameters.Add("@ItemCode", dr["Item Code"].ToString()); DataTable dtGoodsIssue = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtGoodsIssue.Rows.Count > 0) { } else { sqlcmd = new SqlCommand("Insert into EMROIGE (CreateDate,PostingDate,DocDate,ReferenceNo,ItemCode,ItemName,Price,Quantity,WhsCode,OcrCode,OcrCode2,Remarks,B1Upload,Processed,series) values (@CreateDate,@PostingDate,@DocDate,@ReferenceNo,@ItemCode,@ItemName,@Price,@Quantity,@WhsCode,@OcrCode,@OcrCode2,@Remarks,@B1Upload,@Processed,@series)"); sqlcmd.Parameters.Add("@CreateDate", CreateDate); sqlcmd.Parameters.Add("@PostingDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@DocDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@ReferenceNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@ItemCode", dr["Item Code"].ToString()); sqlcmd.Parameters.Add("@ItemName", dr["Item Name"].ToString()); sqlcmd.Parameters.Add("@Price", amount); sqlcmd.Parameters.Add("@Quantity", dr["Qty"].ToString()); sqlcmd.Parameters.Add("@WhsCode", dr["WH Code"].ToString()); sqlcmd.Parameters.Add("@OcrCode", dr["WH Code"].ToString()); sqlcmd.Parameters.Add("@OcrCode2", dr["Category Code"].ToString()); sqlcmd.Parameters.Add("@Remarks", dr["Narration"].ToString()); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); string series = "240"; sqlcmd.Parameters.Add("@series", series); SAPvdm.insert(sqlcmd); } string AcctCode = dr["Ledger Code"].ToString(); string whCode = dr["WH Code"].ToString(); if (AcctCode == "" && whCode == "") { } else { sqlcmd = new SqlCommand("SELECT CreateDate, RefDate, DocDate, Ref1, Ref2, Ref3, TransNo, AcctCode FROM EMROJDT WHERE (RefDate BETWEEN @d1 AND @d2) AND (TransNo = @TransNo) AND (Ref1=@Ref1) AND (OcrCode = @OcrCode)"); sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); sqlcmd.Parameters.Add("@TransNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@OcrCode", dr["WH Code"].ToString()); sqlcmd.Parameters.Add("@Ref1", dr["Item Code"].ToString()); DataTable dtJournelPay = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtJournelPay.Rows.Count > 0) { } else { sqlcmd = new SqlCommand("Insert into EMROJDT (CreateDate, RefDate, DocDate, TransNo, AcctCode, AcctName, Debit, Credit, B1Upload, Processed,Ref1,OcrCode,OcrCode2,series) values (@CreateDate, @RefDate, @DocDate,@TransNo, @AcctCode, @AcctName, @Debit, @Credit, @B1Upload, @Processed,@Ref1,@OcrCode,@OcrCode2,@series)"); sqlcmd.Parameters.Add("@CreateDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@RefDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@Ref1", dr["Item Code"].ToString()); sqlcmd.Parameters.Add("@TransNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@AcctCode", dr["Ledger Code"].ToString()); sqlcmd.Parameters.Add("@AcctName", dr["Ledger Name"].ToString()); double camount = 0; double.TryParse(dr["Total Amount"].ToString(), out camount); double Debit = 0; sqlcmd.Parameters.Add("@Debit", Debit); sqlcmd.Parameters.Add("@Credit", camount); string cB1Upload = "N"; string cProcessed = "N"; sqlcmd.Parameters.Add("@B1Upload", cB1Upload); sqlcmd.Parameters.Add("@Processed", cProcessed); sqlcmd.Parameters.Add("@OcrCode", dr["WH Code"].ToString()); sqlcmd.Parameters.Add("@OcrCode2", dr["Category Code"].ToString()); string series = "230"; sqlcmd.Parameters.Add("@series", series); SAPvdm.insert(sqlcmd); sqlcmd = new SqlCommand("Insert into EMROJDT (CreateDate, RefDate, DocDate, TransNo, AcctCode, AcctName, Debit, Credit, B1Upload, Processed,Ref1,OcrCode,OcrCode2,series) values (@CreateDate, @RefDate, @DocDate,@TransNo, @AcctCode, @AcctName, @Debit, @Credit, @B1Upload, @Processed,@Ref1,@OcrCode,@OcrCode2,@series)"); sqlcmd.Parameters.Add("@CreateDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@RefDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@Ref1", dr["Item Code"].ToString()); sqlcmd.Parameters.Add("@TransNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@AcctCode", dr["Ledger Code"].ToString()); sqlcmd.Parameters.Add("@AcctName", dr["Ledger Name"].ToString()); double damount = 0; double.TryParse(dr["Total Amount"].ToString(), out damount); double Credit = 0; sqlcmd.Parameters.Add("@Debit", damount); sqlcmd.Parameters.Add("@Credit", Credit); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@OcrCode", dr["WH Code"].ToString()); sqlcmd.Parameters.Add("@OcrCode2", dr["Category Code"].ToString()); sqlcmd.Parameters.Add("@series", series); SAPvdm.insert(sqlcmd); } } } } DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); lblmsg.Text = "Successfully Saved"; } catch (Exception ex) { lblmsg.Text = ex.ToString(); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { vdm = new VehicleDBMgr(); DateTime CreateDate = VehicleDBMgr.GetTime(vdm.conn); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; string[] dateFromstrig = txtFromdate.Text.Split(' '); if (dateFromstrig.Length > 1) { if (dateFromstrig[0].Split('-').Length > 0) { string[] dates = dateFromstrig[0].Split('-'); string[] times = dateFromstrig[1].Split(':'); fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } cmd = new MySqlCommand("SELECT sno, BranchName, whcode, ladger_dr_code, tax, ntax, ledger_jv_code FROM branchdata WHERE (sno = @BranchID)"); cmd.Parameters.AddWithValue("@BranchID", ddlSalesOffice.SelectedValue); DataTable dtwhscode = vdm.SelectQuery(cmd).Tables[0]; sqlcmd = new SqlCommand("SELECT CreateDate, PostingDate, DocDate, CardCode, Cardname FROM EMRORIN WHERE (PostingDate BETWEEN @d1 AND @d2) AND (OcrCode = @whscode)"); sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); sqlcmd.Parameters.Add("@whscode", dtwhscode.Rows[0]["whcode"].ToString()); DataTable dtGI = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtGI.Rows.Count > 0) { lblmsg.Text = "This Transaction already saved"; } else { foreach (DataRow dr in dt.Rows) { string CardCode = dr["Customer Code"].ToString(); if (CardCode == "") { } else { sqlcmd = new SqlCommand("SELECT CreateDate, PostingDate, DocDate, CardCode, Cardname , Series FROM EMRORIN WHERE (PostingDate BETWEEN @d1 AND @d2) AND (ReferenceNo = @ReferenceNo) and (CardCode=@CardCode)"); sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); sqlcmd.Parameters.Add("@ReferenceNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@CardCode", dr["Customer Code"].ToString()); DataTable dtIncentives = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtIncentives.Rows.Count > 0) { } else { sqlcmd = new SqlCommand("Insert into EMRORIN (CreateDate,PostingDate,DocDate,CardCode,Cardname,ReferenceNo,Description,AcctCode,Price,TaxCode,LocCode,OcrCode,Remarks,B1Upload,Processed,Series) values (@CreateDate,@PostingDate,@DocDate,@CardCode,@Cardname,@ReferenceNo,@Description,@AcctCode,@Price,@TaxCode,@LocCode,@OcrCode,@Remarks,@B1Upload,@Processed,@Series)"); sqlcmd.Parameters.Add("@CreateDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@PostingDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@DocDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@CardCode", dr["Customer Code"].ToString()); sqlcmd.Parameters.Add("@Cardname", dr["Customer Name"].ToString()); sqlcmd.Parameters.Add("@ReferenceNo", dr["JV No"].ToString()); string Description = "Incentive"; sqlcmd.Parameters.Add("@Description", Description); string AcctCode = "5134006"; sqlcmd.Parameters.Add("@AcctCode", dr["Account Code"].ToString()); double Price = 0; double.TryParse(dr["Amount"].ToString(), out Price); sqlcmd.Parameters.Add("@Price", Price); string TaxCode = "EXEMPT"; int TransNo = 1; sqlcmd.Parameters.Add("@TaxCode", TaxCode); sqlcmd.Parameters.Add("@LocCode", TransNo); sqlcmd.Parameters.Add("@OcrCode", dr["WH Code"].ToString()); string B1Upload = "N"; string Processed = "N"; sqlcmd.Parameters.Add("@Remarks", dr["Narration"].ToString()); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@Series", dr["Series"].ToString()); SAPvdm.insert(sqlcmd); } } } pnlHide.Visible = false; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); lblmsg.Text = "Successfully Saved"; } } catch (Exception ex) { lblmsg.Text = ex.ToString(); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { vdm = new VehicleDBMgr(); DateTime CreateDate = VehicleDBMgr.GetTime(vdm.conn); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; string[] dateFromstrig = txtFromdate.Text.Split(' '); if (dateFromstrig.Length > 1) { if (dateFromstrig[0].Split('-').Length > 0) { string[] dates = dateFromstrig[0].Split('-'); string[] times = dateFromstrig[1].Split(':'); fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } if (ddlSalesOffice.SelectedValue == "306") { fromdate = fromdate.AddDays(1); } else { fromdate = fromdate; } //cmd = new MySqlCommand("SELECT sno, BranchName, whcode, ladger_dr_code, tax, ntax, ledger_jv_code FROM branchdata WHERE (sno = @BranchID)"); //cmd.Parameters.AddWithValue("@BranchID", ddlSalesOffice.SelectedValue); //DataTable dtwhscode = vdm.SelectQuery(cmd).Tables[0]; //sqlcmd = new SqlCommand("SELECT CreateDate, PostingDate, DocDate, ReferenceNo, ItemCode, ItemName, MILKTYPE FROM EMROIGE WHERE (PostingDate BETWEEN @d1 AND @d2) AND (WhsCode = @WhsCode)"); //sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); //sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); //sqlcmd.Parameters.Add("@WhsCode", dtwhscode.Rows[0]["whcode"].ToString()); //DataTable dtGI = SAPvdm.SelectQuery(sqlcmd).Tables[0]; //if (dtGI.Rows.Count > 0) //{ // lblmsg.Text = "This Transaction already saved"; //} //else //{ DataTable dtGoodsIssue = new DataTable(); foreach (DataRow dr in dt.Rows) { double amount = 0; double.TryParse(dr["Amount"].ToString(), out amount); string B1Upload = "N"; string Processed = "N"; sqlcmd = new SqlCommand("SELECT CreateDate, PostingDate, DocDate, ReferenceNo, ItemCode, ItemName, MILKTYPE FROM EMROIGE WHERE (PostingDate BETWEEN @d1 AND @d2) AND (ItemCode=@ItemCode) AND (ReferenceNo = @ReferenceNo) AND (WhsCode = @WhsCode)"); sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); sqlcmd.Parameters.Add("@ReferenceNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@WhsCode", dr["whcode"].ToString()); sqlcmd.Parameters.Add("@ItemCode", dr["Item Code"].ToString()); dtGoodsIssue = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtGoodsIssue.Rows.Count > 0) { lblmsg.Text = "This Transaction already saved"; break; } else { sqlcmd = new SqlCommand("Insert into EMROIGE (CreateDate,PostingDate,DocDate,ReferenceNo,ItemCode,ItemName,Price,Quantity,WhsCode,OcrCode,OcrCode2,Remarks,B1Upload,Processed,series,Milktype) values (@CreateDate,@PostingDate,@DocDate,@ReferenceNo,@ItemCode,@ItemName,@Price,@Quantity,@WhsCode,@OcrCode,@OcrCode2,@Remarks,@B1Upload,@Processed,@series,@Milktype)"); sqlcmd.Parameters.Add("@CreateDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@PostingDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@DocDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@ReferenceNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@ItemCode", dr["Item Code"].ToString()); sqlcmd.Parameters.Add("@ItemName", dr["Item Name"].ToString()); sqlcmd.Parameters.Add("@Price", amount); sqlcmd.Parameters.Add("@Quantity", dr["Qty"].ToString()); sqlcmd.Parameters.Add("@WhsCode", dr["whcode"].ToString()); sqlcmd.Parameters.Add("@OcrCode", dr["whcode"].ToString()); sqlcmd.Parameters.Add("@OcrCode2", dr["Category Code"].ToString()); sqlcmd.Parameters.Add("@Remarks", dr["Narration"].ToString()); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); string series = "98"; sqlcmd.Parameters.Add("@series", series); sqlcmd.Parameters.Add("@Milktype", dr["Milk Type"].ToString()); SAPvdm.insert(sqlcmd); } } if (dtGoodsIssue.Rows.Count > 0) { pnlHide.Visible = false; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); lblmsg.Text = "This Transaction already saved"; } else { pnlHide.Visible = false; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); lblmsg.Text = "Successfully Saved"; } //} } catch (Exception ex) { lblmsg.Text = ex.ToString(); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; string[] dateFromstrig = txtFromdate.Text.Split(' '); if (dateFromstrig.Length > 1) { if (dateFromstrig[0].Split('-').Length > 0) { string[] dates = dateFromstrig[0].Split('-'); string[] times = dateFromstrig[1].Split(':'); fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } foreach (DataRow dr in dt.Rows) { double amount = 0; double.TryParse(dr["Amount"].ToString(), out amount); string B1Upload = "N"; string Processed = "N"; sqlcmd = new SqlCommand("SELECT CreateDate, PostingDate, DocDate, ReferenceNo, ItemCode, ItemName, MILKTYPE FROM EMROIGE WHERE (PostingDate BETWEEN @d1 AND @d2) AND (ItemCode=@ItemCode) AND (ReferenceNo = @ReferenceNo) AND (WhsCode = @WhsCode)"); sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); sqlcmd.Parameters.Add("@ReferenceNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@WhsCode", dr["whcode"].ToString()); sqlcmd.Parameters.Add("@ItemCode", dr["Item Code"].ToString()); DataTable dtGoodsIssue = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtGoodsIssue.Rows.Count > 0) { } else { sqlcmd = new SqlCommand("Insert into EMROIGE (CreateDate,PostingDate,DocDate,ReferenceNo,ItemCode,ItemName,Price,Quantity,WhsCode,OcrCode,OcrCode2,Remarks,B1Upload,Processed,series,Milktype) values (@CreateDate,@PostingDate,@DocDate,@ReferenceNo,@ItemCode,@ItemName,@Price,@Quantity,@WhsCode,@OcrCode,@OcrCode2,@Remarks,@B1Upload,@Processed,@series,@Milktype)"); sqlcmd.Parameters.Add("@CreateDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@PostingDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@DocDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@ReferenceNo", dr["JV No"].ToString()); sqlcmd.Parameters.Add("@ItemCode", dr["Item Code"].ToString()); sqlcmd.Parameters.Add("@ItemName", dr["Item Name"].ToString()); sqlcmd.Parameters.Add("@Price", amount); sqlcmd.Parameters.Add("@Quantity", dr["Qty"].ToString()); sqlcmd.Parameters.Add("@WhsCode", dr["whcode"].ToString()); sqlcmd.Parameters.Add("@OcrCode", dr["whcode"].ToString()); sqlcmd.Parameters.Add("@OcrCode2", dr["Category Code"].ToString()); sqlcmd.Parameters.Add("@Remarks", dr["Narration"].ToString()); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); string series = "240"; sqlcmd.Parameters.Add("@series", series); sqlcmd.Parameters.Add("@Milktype", dr["Milk Type"].ToString()); SAPvdm.insert(sqlcmd); } } pnlHide.Visible = false; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); lblmsg.Text = "Successfully Saved"; } catch (Exception ex) { lblmsg.Text = ex.ToString(); } }
protected void btn_save_click(object sender, EventArgs e) { try { vdm = new SalesDBManager(); DateTime CreateDate = SalesDBManager.GetTime(vdm.conn); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; string[] dateFromstrig = dtp_FromDate.Text.Split(' '); if (dateFromstrig.Length > 1) { if (dateFromstrig[0].Split('-').Length > 0) { string[] dates = dateFromstrig[0].Split('-'); string[] times = dateFromstrig[1].Split(':'); fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } string ocrcode2 = "", remarks = ""; foreach (DataRow dr in dt.Rows) { string itemcode = dr["ITEMCODE"].ToString(); if (itemcode == "") { } else { cmd = new SqlCommand("insert into EMROPDN (CreateDate, CardCode, CardName, TaxDate, DocDate, DocDueDate, ReferenceNo, ItemCode, Dscription, WhsCode, Quantity, Price, VAT_Percent, LineTotal, OcrCode, OcrCode2, REMARKS, B1Upload, Processed) values (@CreateDate, @CardCode, @CardName, @TaxDate, @DocDate, @DocDueDate, @ReferenceNo, @ItemCode, @Dscription, @WhsCode, @Quantity, @Price, @VAT_Percent, @LineTotal, @OcrCode, @OcrCode2, @REMARKS, @B1Upload, @Processed)"); cmd.Parameters.Add("@CreateDate", fromdate); cmd.Parameters.Add("@CardCode", dr["CARD CODE"].ToString()); cmd.Parameters.Add("@CardName", dr["CARD NAME"].ToString()); cmd.Parameters.Add("@TaxDate", fromdate); cmd.Parameters.Add("@DocDate", fromdate); cmd.Parameters.Add("@DocDueDate", fromdate); cmd.Parameters.Add("@ReferenceNo", dr["REFERENCE NO"].ToString()); cmd.Parameters.Add("@ItemCode", dr["ITEMCODE"].ToString()); cmd.Parameters.Add("@Dscription", dr["DESCRIPTION"].ToString()); cmd.Parameters.Add("@WhsCode", dr["WARE HOUSE CODE"].ToString()); double qty = 0; double.TryParse(dr["QUANTITY"].ToString(), out qty); cmd.Parameters.Add("@Quantity", qty); double price = 0; double.TryParse(dr["price"].ToString(), out price); cmd.Parameters.Add("@Price", price); double vatpercent = 0; double.TryParse(dr["VAT PERCENT"].ToString(), out vatpercent); cmd.Parameters.Add("@VAT_Percent", vatpercent); double linetotal = 0; double.TryParse(dr["LINE TOTAL"].ToString(), out linetotal); cmd.Parameters.Add("@LineTotal", linetotal); cmd.Parameters.Add("@OcrCode", dr["WARE HOUSE CODE"].ToString()); cmd.Parameters.Add("@OcrCode2", ocrcode2); cmd.Parameters.Add("@REMARKS", remarks); string B1Upload = "N"; string Processed = "N"; cmd.Parameters.Add("@B1Upload", B1Upload); cmd.Parameters.Add("@Processed", Processed); SAPvdm.insert(cmd); } } lblmsg.Text = "Saved successfully"; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); } catch (Exception ex) { lblmsg.Text = ex.Message; hidepanel.Visible = false; } }
protected void btn_save_click(object sender, EventArgs e) { try { vdm = new SalesDBManager(); DateTime CreateDate = SalesDBManager.GetTime(vdm.conn); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DataTable dt = (DataTable)Session["xportdata"]; string[] dateFromstrig = dtp_FromDate.Text.Split(' '); if (dateFromstrig.Length > 1) { if (dateFromstrig[0].Split('-').Length > 0) { string[] dates = dateFromstrig[0].Split('-'); string[] times = dateFromstrig[1].Split(':'); fromdate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } fromdate = fromdate; foreach (DataRow dr in dt.Rows) { double amount = 10; string B1Upload = "N"; string Processed = "N"; string ledgercode = dr["Item Code"].ToString(); if (ledgercode == "") { } else { sqlcmd = new SqlCommand("SELECT CreateDate, PostingDate, DocDate, ReferenceNo AS Processed, Series FROM EMROWTR WHERE (PostingDate BETWEEN @d1 AND @d2) AND (ItemCode=@ItemCode) AND (ReferenceNo = @ReferenceNo)"); sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); sqlcmd.Parameters.Add("@ReferenceNo", dr["ReferenceNo"].ToString()); sqlcmd.Parameters.Add("@ItemCode", dr["Item Code"].ToString()); DataTable dtST = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtST.Rows.Count > 0) { } else { sqlcmd = new SqlCommand("Insert into EMROWTR (CreateDate,PostingDate,DocDate,ReferenceNo,FromWhsCode,ToWhsCode,ItemCode,ItemName,Quantity,Price,OcrCode,OcrCode2,Remarks,B1Upload,Processed,series) values (@CreateDate,@PostingDate,@DocDate,@ReferenceNo,@FromWhsCode,@ToWhsCode,@ItemCode,@ItemName,@Quantity,@Price,@OcrCode,@OcrCode2,@Remarks,@B1Upload,@Processed,@series)"); sqlcmd.Parameters.Add("@CreateDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@PostingDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@DocDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@ReferenceNo", dr["ReferenceNo"].ToString()); string fromwhcode = "SVDSPP02"; sqlcmd.Parameters.Add("@FromWhsCode", fromwhcode); sqlcmd.Parameters.Add("@ToWhsCode", dr["Wh Code"].ToString()); sqlcmd.Parameters.Add("@ItemCode", dr["Item Code"].ToString()); sqlcmd.Parameters.Add("@ItemName", dr["Item Name"].ToString()); sqlcmd.Parameters.Add("@Quantity", dr["Qty"].ToString()); sqlcmd.Parameters.Add("@Price", dr["Price"].ToString()); sqlcmd.Parameters.Add("@OcrCode", fromwhcode); sqlcmd.Parameters.Add("@OcrCode2", ""); sqlcmd.Parameters.Add("@Remarks", dr["Narration"].ToString()); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); string series = "241"; sqlcmd.Parameters.Add("@series", series); SAPvdm.insert(sqlcmd); } } } DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); lblmsg.Text = "Successfully Saved"; } catch (Exception ex) { lblmsg.Text = ex.ToString(); } }