public void benficerydetails(string WorkItemCode, string SurveyWorkItemMappingCode, string Type) { vdm = new SalesDBManager(); postvdm = new SAPdbmanger(); string workitemcode = "51621535"; string mappingcode = "51621535"; string servaytype = "51621535"; cmd = new SqlCommand("SELECT tbl_TRN_WorkItem.WorkItemCode, tbl_TRN_WorkItem.MileStoneCode, tbl_TRN_WorkItem.WorkItemName, tbl_TRN_WorkItem.WorkItemDesc, tbl_TRN_WorkItem.WorkItemType, tbl_TRN_WorkItem.ParentWorkItemCode, tbl_TRN_WorkItem.PlanStartDate, tbl_TRN_WorkItem.PlanEndDate, tbl_TRN_WorkItem.PlanBudget, tbl_TRN_WorkItem.NonActivityBudget, tbl_TRN_WorkItem.NonActivityBudgetPercentage, tbl_TRN_WorkItem.ActualStartDate, tbl_TRN_WorkItem.ActualEndDate, tbl_TRN_WorkItem.ActualExpenses, tbl_TRN_WorkItem.PrimaryOwner, tbl_TRN_WorkItem.LocationCode, tbl_TRN_WorkItem.Target, tbl_TRN_WorkItem.TargetMeasurementUnit, tbl_TRN_WorkItem.Achievement, tbl_TRN_WorkItem.PercentageCompleted, tbl_TRN_WorkItem.Remarks, tbl_TRN_WorkItem.Status, tbl_TRN_WorkItem.CreatedBy, tbl_TRN_WorkItem.CreatedOn, tbl_TRN_WorkItem.ModifiedBy, tbl_TRN_WorkItem.ModifiedOn, tbl_TRN_WorkItem.DisplayOrder, tbl_TRN_WorkItem.SynchedOn, tbl_MMP_SurveyWorkItem.SurveyWorkItemMappingCode, tbl_MMP_SurveyWorkItem.SurveyCode, tbl_MMP_SurveyWorkItem.WorkItemCode AS Expr1, tbl_MMP_SurveyWorkItem.LocationCode AS Expr2, tbl_MMP_SurveyWorkItem.Status AS Expr3, tbl_MMP_SurveyWorkItem.isActive, tbl_MMP_SurveyWorkItem.CreatedBy AS Expr4, tbl_MMP_SurveyWorkItem.CreatedOn AS Expr5, tbl_MMP_SurveyWorkItem.ModifiedBy AS Expr6, tbl_MMP_SurveyWorkItem.ModifiedOn AS Expr7, tbl_MMP_SurveyWorkItem.Frequncy, tbl_MMP_SurveyWorkItem.StartDate, tbl_MMP_SurveyWorkItem.EndDDate FROM tbl_TRN_WorkItem INNER JOIN tbl_MMP_SurveyWorkItem ON tbl_TRN_WorkItem.WorkItemCode = tbl_MMP_SurveyWorkItem.WorkItemCode WHERE tbl_MMP_SurveyWorkItem.SurveyWorkItemMappingCode=@mappingcode AND tbl_TRN_WorkItem.WorkItemCode=@workitemcode"); cmd.Parameters.Add("@workitemcode", WorkItemCode); cmd.Parameters.Add("@mappingcode", SurveyWorkItemMappingCode); DataTable dtworkitemdetails = vdm.SelectQuery(cmd).Tables[0]; cmd = new SqlCommand("SELECT RowCode, WorkItemCode, LocationCode, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn FROM tbl_MMP_WorkItemLocation WHERE WorkItemCode=@workitemcode"); cmd.Parameters.Add("@workitemcode", workitemcode); DataTable dtWorkItemLocationdtls = vdm.SelectQuery(cmd).Tables[0]; cmd = new SqlCommand("SELECT SurveyCode, SurveyName, SurveyDesc, SectorCode, QuestionSetCode, Status, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn, Type, Frequency, StartDate, EndDate, ProgramCode, InterventionCode FROM tbl_MST_Survey WHERE Type=@type"); cmd.Parameters.Add("@type", Type); DataTable dtsurveydtls = vdm.SelectQuery(cmd).Tables[0]; }
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 Customercode = dr["Customer Code"].ToString(); string whccode = dr["WH Code"].ToString(); if (Customercode == "") { } else { string Itemcode = dr["Item Code"].ToString(); if (Itemcode == "") { } else { sqlcmd = new SqlCommand("Insert into EMROINV (cardcode,cardname,TaxDate, DocDate, DocDueDate,dscription,itemcode,quantity,price,whscode,vat_percent,taxamount,ReferenceNo,TaxCode,B1Upload,Processed,CreateDate,REMARKS,SALETYPE,OcrCode,ocrCode2) values(@cardcode,@cardname,@TaxDate,@DocDate,@DocDueDate,@dscription,@itemcode,@quantity,@price,@whscode,@vat_percent,@taxamount,@ReferenceNo,@TaxCode,@B1Upload,@Processed,@CreateDate,@REMARKS,@SALETYPE,@OcrCode,@ocrCode2)"); sqlcmd.Parameters.Add("@cardcode", dr["Customer Code"].ToString()); sqlcmd.Parameters.Add("@cardname", dr["Customer Name"].ToString()); sqlcmd.Parameters.Add("@TaxDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@DocDueDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@dscription", dr["Item Name"].ToString()); sqlcmd.Parameters.Add("@itemcode", dr["Item Code"].ToString()); sqlcmd.Parameters.Add("@quantity", dr["Qty"].ToString()); sqlcmd.Parameters.Add("@price", dr["Rate"].ToString()); sqlcmd.Parameters.Add("@whscode", whccode); sqlcmd.Parameters.Add("@OcrCode", whccode); sqlcmd.Parameters.Add("@ocrCode2", dr["Category Code"].ToString()); sqlcmd.Parameters.Add("@vat_percent", dr["vat_percent"].ToString()); sqlcmd.Parameters.Add("@taxamount", dr["TaxAmount"].ToString()); sqlcmd.Parameters.Add("@ReferenceNo", dr["Invoce No"].ToString()); string TaxCode = dr["Tax Code"].ToString(); string B1Upload = "N"; string Processed = "N"; sqlcmd.Parameters.Add("@TaxCode", TaxCode); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@CreateDate", CreateDate); sqlcmd.Parameters.Add("@REMARKS", dr["Narration"].ToString()); string salestype = dr["Sales Type"].ToString(); sqlcmd.Parameters.Add("@SALETYPE", salestype);//Cash-sale //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); } } DataTable CustomerCodes = new DataTable(); CustomerCodes.Columns.Add("Ledger Type"); CustomerCodes.Columns.Add("Customer Code"); CustomerCodes.Columns.Add("Customer Name"); CustomerCodes.Columns.Add("Invoice Date"); CustomerCodes.Columns.Add("Invoce No"); CustomerCodes.Columns.Add("HSN CODE"); CustomerCodes.Columns.Add("Item Code"); CustomerCodes.Columns.Add("Item Name"); CustomerCodes.Columns.Add("Qty"); CustomerCodes.Columns.Add("Rate"); CustomerCodes.Columns.Add("Tax Code"); CustomerCodes.Columns.Add("Sales Type"); CustomerCodes.Columns.Add("TAX%"); CustomerCodes.Columns.Add("Taxable Value"); CustomerCodes.Columns.Add("Rounding Off"); CustomerCodes.Columns.Add("WH Code"); CustomerCodes.Columns.Add("Inv Value"); CustomerCodes.Columns.Add("Net Value"); CustomerCodes.Columns.Add("Narration"); 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, CardCode, CardName, TaxDate, DocDate, DocDueDate, DiscPercent, ReferenceNo FROM EMRORDR WHERE (TaxDate BETWEEN @d1 AND @d2) AND (WhsCode = @WhsCode) AND CardCode=@CardCode"); ////sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); ////sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); ////sqlcmd.Parameters.Add("@WhsCode", dtwhscode.Rows[0]["whcode"].ToString()); ////sqlcmd.Parameters.Add("@CardCode", dtwhscode.Rows[0]["whcode"].ToString()); DataTable dtOrder = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtOrder.Rows.Count > 0) { lblmsg.Text = "This Transaction already saved"; } else { foreach (DataRow dr in dt.Rows) { sqlcmd = new SqlCommand("SELECT CreateDate, CardCode, CardName, TaxDate, DocDate, DocDueDate, DiscPercent, ReferenceNo FROM EMRORDR WHERE (TaxDate BETWEEN @d1 AND @d2) AND (WhsCode = @WhsCode) AND CardCode=@CardCode"); sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); sqlcmd.Parameters.Add("@WhsCode", dtwhscode.Rows[0]["whcode"].ToString()); sqlcmd.Parameters.Add("@CardCode", dtwhscode.Rows[0]["whcode"].ToString()); string Customercode = dr["Customer Code"].ToString(); string whccode = dr["WH Code"].ToString(); if (Customercode == "CHN01") { } if (Customercode == "") { DataRow newrow = CustomerCodes.NewRow(); newrow["Ledger Type"] = dr["Ledger Type"].ToString(); newrow["Customer Name"] = dr["Customer Name"].ToString(); newrow["Customer Code"] = dr["Customer Code"].ToString(); newrow["Invoice Date"] = dr["Invoice Date"].ToString(); newrow["Invoce No"] = dr["Invoce No"].ToString(); newrow["HSN CODE"] = dr["HSN CODE"].ToString(); newrow["Item Code"] = dr["Item Code"].ToString(); newrow["Item Name"] = dr["Item Name"].ToString(); newrow["Qty"] = dr["Qty"].ToString(); newrow["Rate"] = dr["Rate"].ToString(); newrow["Tax Code"] = dr["Tax Code"].ToString(); newrow["Sales Type"] = dr["Sales Type"].ToString(); newrow["TAX%"] = dr["TAX%"].ToString(); newrow["Taxable Value"] = dr["Taxable Value"].ToString(); newrow["WH Code"] = dr["WH Code"].ToString(); newrow["Net Value"] = dr["Net Value"].ToString(); newrow["Narration"] = dr["Narration"].ToString(); CustomerCodes.Rows.Add(newrow); } else { if (Customercode.Length >= 8) { string Itemcode = dr["Item Code"].ToString(); if (Itemcode == "") { } else { //sqlcmd = new SqlCommand("SELECT CreateDate, CardCode, CardName, TaxDate, DocDate, DocDueDate, DiscPercent, ReferenceNo FROM EMRORDR WHERE (TaxDate BETWEEN @d1 AND @d2) AND (ReferenceNo = @ReferenceNo) AND (itemcode=@itemcode) AND (WhsCode = @WhsCode)"); //sqlcmd.Parameters.Add("@d1", GetLowDate(fromdate)); //sqlcmd.Parameters.Add("@d2", GetHighDate(fromdate)); //sqlcmd.Parameters.Add("@ReferenceNo", dr["Invoce No"].ToString()); //sqlcmd.Parameters.Add("@WhsCode", whccode); //sqlcmd.Parameters.Add("@itemcode", dr["Item Code"].ToString()); //DataTable dtSalesOrder = SAPvdm.SelectQuery(sqlcmd).Tables[0]; //if (dtSalesOrder.Rows.Count > 0) //{ //} //else //{ sqlcmd = new SqlCommand("Insert into EMRORDR (cardcode,cardname,TaxDate, DocDate, DocDueDate,dscription,itemcode,quantity,price,whscode,vat_percent,taxamount,ReferenceNo,TaxCode,B1Upload,Processed,CreateDate,REMARKS,SALETYPE) values(@cardcode,@cardname,@TaxDate,@DocDate,@DocDueDate,@dscription,@itemcode,@quantity,@price,@whscode,@vat_percent,@taxamount,@ReferenceNo,@TaxCode,@B1Upload,@Processed,@CreateDate,@REMARKS,@SALETYPE)"); sqlcmd.Parameters.Add("@cardcode", dr["Customer Code"].ToString()); sqlcmd.Parameters.Add("@cardname", dr["Customer Name"].ToString()); sqlcmd.Parameters.Add("@TaxDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@docdate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@DocDueDate", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@dscription", dr["Item Name"].ToString()); sqlcmd.Parameters.Add("@itemcode", dr["Item Code"].ToString()); sqlcmd.Parameters.Add("@quantity", dr["Qty"].ToString()); sqlcmd.Parameters.Add("@price", dr["Rate"].ToString()); sqlcmd.Parameters.Add("@whscode", whccode); sqlcmd.Parameters.Add("@vat_percent", dr["TAX%"].ToString()); sqlcmd.Parameters.Add("@taxamount", dr["Taxable Value"].ToString()); sqlcmd.Parameters.Add("@ReferenceNo", dr["Invoce No"].ToString()); string TaxCode = dr["Tax Code"].ToString(); string B1Upload = "N"; string Processed = "N"; sqlcmd.Parameters.Add("@TaxCode", TaxCode); sqlcmd.Parameters.Add("@B1Upload", B1Upload); sqlcmd.Parameters.Add("@Processed", Processed); sqlcmd.Parameters.Add("@CreateDate", CreateDate); sqlcmd.Parameters.Add("@REMARKS", dr["Narration"].ToString()); string salestype = dr["Sales Type"].ToString(); sqlcmd.Parameters.Add("@SALETYPE", salestype); //SAPvdm.insert(sqlcmd); } //} } else { DataRow newrow1 = CustomerCodes.NewRow(); newrow1["Ledger Type"] = dr["Ledger Type"].ToString(); newrow1["Customer Name"] = dr["Customer Name"].ToString(); newrow1["Customer Code"] = dr["Customer Code"].ToString(); newrow1["Invoice Date"] = dr["Invoice Date"].ToString(); newrow1["Invoce No"] = dr["Invoce No"].ToString(); newrow1["HSN CODE"] = dr["HSN CODE"].ToString(); newrow1["Item Code"] = dr["Item Code"].ToString(); newrow1["Item Name"] = dr["Item Name"].ToString(); newrow1["Qty"] = dr["Qty"].ToString(); newrow1["Rate"] = dr["Rate"].ToString(); newrow1["Tax Code"] = dr["Tax Code"].ToString(); newrow1["Sales Type"] = dr["Sales Type"].ToString(); newrow1["TAX%"] = dr["TAX%"].ToString(); newrow1["Taxable Value"] = dr["Taxable Value"].ToString(); newrow1["WH Code"] = dr["WH Code"].ToString(); newrow1["Net Value"] = dr["Net Value"].ToString(); newrow1["Narration"] = dr["Narration"].ToString(); CustomerCodes.Rows.Add(newrow1); } } } //pnlHide.Visible = false; DataTable dtempty = new DataTable(); grdReports.DataSource = dtempty; grdReports.DataBind(); grdReports1.DataSource = CustomerCodes; grdReports1.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); } } 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 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); } } 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 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); } } 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(); } }
void GetReport() { try { lbl_msg.Text = ""; pnlHide.Visible = true; Session["RouteName"] = ddlaccountno.SelectedItem.Text; Session["IDate"] = DateTime.Now.AddDays(1).ToString("dd/MM/yyyy"); vdm = new VehicleDBMgr(); SAPdbmanger SAPvdm = new SAPdbmanger(); DateTime fromdate = DateTime.Now; DateTime todate = DateTime.Now; 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); } } string[] datetostrig = txttodate.Text.Split(' '); if (datetostrig.Length > 1) { if (datetostrig[0].Split('-').Length > 0) { string[] dates = datetostrig[0].Split('-'); string[] times = datetostrig[1].Split(':'); todate = new DateTime(int.Parse(dates[2]), int.Parse(dates[1]), int.Parse(dates[0]), int.Parse(times[0]), int.Parse(times[1]), 0); } } lbl_selfromdate.Text = fromdate.ToString("dd/MM/yyyy"); lblRoutName.Text = ddlaccountno.SelectedItem.Text; Session["xporttype"] = "TallyReceipts"; string ledger = ""; string ledgercode = ""; string WHcode = ""; cmd = new SqlCommand("SELECT sno, ladger_dr, ladger_dr_code, brach_ledger, brach_ledger_code FROM bankaccountno_master WHERE (sno = @accountno)"); cmd.Parameters.Add("@accountno", ddlaccountno.SelectedValue); DataTable dtledger = vdm.SelectQuery(cmd).Tables[0]; if (dtledger.Rows.Count > 0) { ledger = dtledger.Rows[0]["ladger_dr"].ToString(); ledgercode = dtledger.Rows[0]["ladger_dr_code"].ToString(); WHcode = dtledger.Rows[0]["brach_ledger_code"].ToString(); } cmd = new SqlCommand("SELECT collections.sno, collectionsubdetails.sno as csno, collections.accountno, collections.remarks, collections.receiptdate, CONVERT(VARCHAR(10), collections.receiptdate, 103) AS doe, headofaccounts_master.accountname,headofaccounts_master.accountcode, collectionsubdetails.headofaccount, collectionsubdetails.amount, collections.branch, branchmaster.receiptseries, branchmaster.whcode, collections.sapimport FROM collections INNER JOIN collectionsubdetails ON collections.sno = collectionsubdetails.collectionrefno INNER JOIN headofaccounts_master ON collectionsubdetails.headofaccount = headofaccounts_master.sno INNER JOIN branchmaster ON collections.subbranch = branchmaster.branchid WHERE (collections.receiptdate BETWEEN @d1 AND @d2) AND (collections.accountno = @accountno) AND (collections.sapimport = '1')"); cmd.Parameters.Add("@accountno", ddlaccountno.SelectedValue); cmd.Parameters.Add("@d1", GetLowDate(fromdate)); cmd.Parameters.Add("@d2", GetHighDate(todate)); DataTable dtsalescollection = vdm.SelectQuery(cmd).Tables[0]; dtReport = new DataTable(); dtReport.Columns.Add("Voucher Date"); dtReport.Columns.Add("Voucher No"); dtReport.Columns.Add("Voucher Type"); dtReport.Columns.Add("WH Code"); dtReport.Columns.Add("Debit Code"); dtReport.Columns.Add("Ledger (Dr)"); dtReport.Columns.Add("C WHCODE"); dtReport.Columns.Add("Credit Code"); dtReport.Columns.Add("Ledger (Cr)"); dtReport.Columns.Add("Amount"); dtReport.Columns.Add("Series"); dtReport.Columns.Add("Narration"); int i = 1; foreach (DataRow branch in dtsalescollection.Rows) { double num; string accode = branch["accountcode"].ToString(); string amount = branch["amount"].ToString(); sqlcmd = new SqlCommand("SELECT * FROM EMROJDTP WHERE AcctCode=@actcode AND Debit=@Debit AND CreateDate=@doe"); sqlcmd.Parameters.Add("@doe", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@Debit", amount); sqlcmd.Parameters.Add("@actcode", ledgercode); DataTable dtJournelexist = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtJournelexist.Rows.Count > 0) { } else { DataRow newrow = dtReport.NewRow(); string doe = branch["receiptdate"].ToString(); DateTime dtdoe = Convert.ToDateTime(doe); newrow["Voucher Date"] = dtdoe.ToString("dd-MMM-yyyy"); newrow["Voucher No"] = "BANK_REC" + branch["csno"].ToString(); newrow["Voucher Type"] = "Bank Receipt Import"; newrow["Ledger (Dr)"] = ledger; if (branch["accountname"].ToString() == "") { } else { newrow["WH Code"] = WHcode; newrow["Credit Code"] = branch["accountcode"].ToString(); newrow["Ledger (Cr)"] = branch["accountname"].ToString(); newrow["Debit Code"] = ledgercode; newrow["Ledger (Dr)"] = ledger; newrow["C WHCODE"] = branch["whcode"].ToString(); newrow["Series"] = branch["receiptseries"].ToString(); newrow["Amount"] = branch["amount"].ToString(); string rcptdate = branch["doe"].ToString(); newrow["Narration"] = branch["remarks"].ToString() + " vide Receipt No " + branch["sno"].ToString() + ",Receipt Date " + rcptdate + ",Emp Name " + Session["EmpName"].ToString(); dtReport.Rows.Add(newrow); i++; } } } grdReports.DataSource = dtReport; grdReports.DataBind(); Session["xportdata"] = dtReport; cmd = new SqlCommand("SELECT collections.sno, subaccount_collection.sno AS CSCSNO, collections.accountno, collections.remarks, collections.receiptdate, CONVERT(VARCHAR(10), collections.receiptdate, 103) AS doe, headofaccounts_master.accountname,headofaccounts_master.accountcode, collections.branch, collections.sapimport, subaccount_collection.headofaccount, subaccount_collection.amount, branchmaster.whcode, branchmaster.receiptseries FROM collections INNER JOIN subaccount_collection ON collections.sno = subaccount_collection.collectionrefno INNER JOIN headofaccounts_master ON subaccount_collection.headofaccount = headofaccounts_master.sno INNER JOIN branchmaster ON collections.subbranch = branchmaster.branchid WHERE (collections.receiptdate BETWEEN @d1 AND @d2) AND (collections.accountno = @accountno) AND (collections.sapimport = '2')"); cmd.Parameters.Add("@accountno", ddlaccountno.SelectedValue); cmd.Parameters.Add("@d1", GetLowDate(fromdate)); cmd.Parameters.Add("@d2", GetHighDate(todate)); DataTable dtsalessubcollection = vdm.SelectQuery(cmd).Tables[0]; int j = 1; foreach (DataRow branch in dtsalessubcollection.Rows) { string amount = branch["amount"].ToString(); string actcode = ""; double num; string accode = branch["accountcode"].ToString(); sqlcmd = new SqlCommand("SELECT * FROM EMROJDTP WHERE AcctCode=@actcode AND Debit=@Debit AND RefDate=@doe"); sqlcmd.Parameters.Add("@doe", GetLowDate(fromdate)); sqlcmd.Parameters.Add("@Debit", amount); sqlcmd.Parameters.Add("@actcode", ledgercode); DataTable dtJournelexist = SAPvdm.SelectQuery(sqlcmd).Tables[0]; if (dtJournelexist.Rows.Count > 0) { } else { DataRow newrow = dtReport.NewRow(); string doe = branch["receiptdate"].ToString(); DateTime dtdoe = Convert.ToDateTime(doe); newrow["Voucher Date"] = dtdoe.ToString("dd-MMM-yyyy"); newrow["Voucher No"] = "BANK_REC" + branch["CSCSNO"].ToString(); newrow["Voucher Type"] = "Bank Receipt Import"; newrow["Ledger (Dr)"] = ledger; if (branch["accountname"].ToString() == "") { } else { //newrow["WH Code"] = WHcode; //newrow["Credit Code"] = ledgercode; newrow["C WHCODE"] = branch["whcode"].ToString(); newrow["WH Code"] = WHcode; newrow["Credit Code"] = branch["accountcode"].ToString(); newrow["Ledger (Cr)"] = branch["accountname"].ToString(); newrow["Debit Code"] = ledgercode; newrow["Ledger (Dr)"] = ledger; newrow["Amount"] = branch["amount"].ToString(); string rcptdate = branch["doe"].ToString(); newrow["Narration"] = branch["remarks"].ToString() + " vide Receipt No " + branch["sno"].ToString() + ",Receipt Date " + rcptdate + ",Emp Name " + Session["EmpName"].ToString(); newrow["Series"] = branch["receiptseries"].ToString();; dtReport.Rows.Add(newrow); j++; } } } grdReports.DataSource = dtReport; grdReports.DataBind(); Session["xportdata"] = dtReport; } catch (Exception ex) { pnlHide.Visible = false; lbl_msg.Text = ex.Message; } }
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(); } }