void AddUpateBank() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbEmployee.Text.Trim())) { ep1.SetError(cmbEmployee, "Name is Required.."); cmbEmployee.Focus(); return; } if (string.IsNullOrEmpty(txtAmount.Text.Trim())) { ep1.SetError(txtAmount, "Amount is Required.."); txtAmount.Focus(); return; } int T14_WORKERID = 0, TM04_BANKID = 0; decimal dT14_AMOUNT = 0; int.TryParse(cmbEmployee.SelectedValue.ToString(), out T14_WORKERID); decimal.TryParse(txtAmount.Text.Trim(), out dT14_AMOUNT); MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; MyDa.USP_VP_ADDUPDATE_LOAN(Datalayer.iT15_LOANID, T14_WORKERID, dtpDate.Value, dT14_AMOUNT, txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iT15_LOANID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iT15_LOANID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpdateParty() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtName.Text.Trim())) { ep1.SetError(txtName, "Name is Required.."); txtName.Focus(); return; } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); decimal T001_OPENINGBAL = 0, T001_DISCOUNT = 0; decimal.TryParse(txtOpeningBal.Text.Trim(), out T001_OPENINGBAL); decimal.TryParse(txtDiscount.Text.Trim(), out T001_DISCOUNT); int TM_STATEID = 0; int.TryParse(cmbState.SelectedValue.ToString(), out TM_STATEID); int?Iout = 0; MyDa.USP_VP_ADDUPDATE_ACCOUNT(Datalayer.iT001_ACCOUNTID, txtName.Text.Trim(), txtContactPerson.Text.Trim(), txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), cmbType.SelectedItem.ToString(), txtCity.Text.Trim(), TM_STATEID, txtMobile1.Text.Trim(), txtMobile2.Text.Trim(), txtPhone.Text.Trim(), txtEmailID.Text.Trim(), T001_OPENINGBAL, txtGSTNo.Text.Trim(), txtTinNo.Text.Trim(), T001_DISCOUNT, Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iT001_ACCOUNTID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iT001_ACCOUNTID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } PopualteData(); ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpdateParty() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtName.Text.Trim())) { ep1.SetError(txtName, "Name is Required.."); txtName.Focus(); return; } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); decimal T14_DAY_PRICE = 0, T14_HOURS_PRICE = 0; decimal.TryParse(txtDayPrice.Text.Trim(), out T14_DAY_PRICE); decimal.TryParse(txtHoursPrice.Text.Trim(), out T14_HOURS_PRICE); int?Iout = 0; MyDa.USP_VP_ADDUPDATE_WORKER(Datalayer.iT14_WORKERID, txtName.Text.Trim(), txtAddress1.Text.Trim(), txtMobile1.Text.Trim(), T14_DAY_PRICE, T14_HOURS_PRICE, txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iT14_WORKERID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iT14_WORKERID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } PopualteData(); ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpdateData() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtName.Text.Trim())) { ep1.SetError(txtName, "Name is Required.."); txtName.Focus(); return; } decimal TM01_TAX_RATE = 0; decimal.TryParse(txtTaxRate.Text.Trim(), out TM01_TAX_RATE); MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; MyDa.USP_VP_ADDUPDATE_PRODUCT(Datalayer.iTM01_PRODUCTID, txtNo.Text.Trim(), txtName.Text.Trim(), chkIsSet.Checked, txtHSNCode.Text.Trim(), TM01_TAX_RATE, Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iTM01_PRODUCTID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iTM01_PRODUCTID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpdateData() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtName.Text.Trim())) { ep1.SetError(txtName, "Name is Required.."); txtName.Focus(); return; } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; MyDa.USP_VP_ADDUPDATE_EXPENSE(Datalayer.iTM05_EXPENSEID, txtName.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iTM05_EXPENSEID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iTM05_EXPENSEID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpateBank() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtBank.Text.Trim())) { ep1.SetError(txtBank, "Name is Required.."); txtBank.Focus(); return; } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; MyDa.USP_VP_ADDUPDATE_BANK(Datalayer.T010_PACKINGSLIPID, txtBank.Text.Trim(), txtAccount.Text.Trim(), txtIFSC.Text.Trim(), txtBranch.Text.Trim(), txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.T010_PACKINGSLIPID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.T010_PACKINGSLIPID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpdateData() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtName.Text.Trim())) { ep1.SetError(txtName, "Name is Required.."); txtName.Focus(); return; } decimal dTM02_PRICE1 = 0, dTM02_PRICE2 = 0; decimal.TryParse(txtPrice.Text.Trim(), out dTM02_PRICE1); int iTM02_PRODUCTSIZEID1 = 0, iTM02_PRODUCTSIZEID2 = 0; int.TryParse(lblSizeId1.Text.Trim(), out iTM02_PRODUCTSIZEID1); int.TryParse(lblSizeId2.Text.Trim(), out iTM02_PRODUCTSIZEID2); MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; MyDa.USP_VP_ADD_PRODUCT(Datalayer.iTM01_PRODUCTID, txtName.Text.Trim(), chkIsSet.Checked, txtHSNCode.Text.Trim(), dTM02_PRICE1, Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.DosenotInsertMessageBox(sPageName); } PopualteData(); ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpdatePurchase(bool IsPrint, bool IsPackingSlip) { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbName.Text.Trim())) { ep1.SetError(cmbName, "This field is required."); cmbName.Focus(); return; } if (string.IsNullOrEmpty(txtNetAmount.Text.Trim())) { ep1.SetError(txtNetAmount, "This field is required."); txtNetAmount.Focus(); return; } int T007_SALEID = Datalayer.iT012_CHALLENID; // int TM01_CUSTOMERID = 0; string T007_NO = "", T007_DETAILS = ""; int T001_ACCOUNTID = 0; decimal T007_TOTAL_AMT = 0, T007_DISCOUNT = 0, T007_TAX1RATE = 0, T007_TAX1AMOUNT = 0, T007_TAX2RATE = 0, T007_TAX2AMOUNT = 0, T007_NETAMOUNT = 0, T007_TAX; DateTime T003_DATE = dtpDate.Value; // int.TryParse(cmbCustomerName.SelectedValue.ToString(), out TM01_CUSTOMERID); T007_NO = txtBillNo.Text.Trim(); int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID); decimal.TryParse(txtTotalAmt.Text.Trim(), out T007_TOTAL_AMT); decimal.TryParse(txtDiscount.Text.Trim(), out T007_DISCOUNT); decimal.TryParse(txtTotalTaxAmount.Text.Trim(), out T007_TAX); decimal.TryParse(txtNetAmount.Text.Trim(), out T007_NETAMOUNT); T007_DETAILS = txtDetails.Text.Trim(); if (T007_SALEID > 0) { int?Iout = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_DELETE_CHALLENITEM(T007_SALEID, ref Iout); //MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); //string sSql = "DELETE FROM T003_PURCHASEITEM WHERE T002_PURCHASEID =" + T007_SALEID; //dl.ExecuteMethod(sSql); } decimal dT007_PACKING = 0, dT007_FREIGHT = 0, dT007_OTHER_EXPENSE = 0; decimal.TryParse(txtPacking.Text.Trim(), out dT007_PACKING); decimal.TryParse(txtFreight.Text.Trim(), out dT007_FREIGHT); decimal.TryParse(txtExpense.Text.Trim(), out dT007_OTHER_EXPENSE); int?T007_SALEID_out = 0; Cursor.Current = Cursors.WaitCursor; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDUPATE_CHALLEN(T007_SALEID, T001_ACCOUNTID, T007_NO, T003_DATE, txtTransport1.Text.Trim(), txtLR1.Text.Trim(), txtTransport2.Text.Trim(), txtLR2.Text.Trim(), T007_TOTAL_AMT, dT007_PACKING, dT007_FREIGHT, dT007_OTHER_EXPENSE, T007_DISCOUNT, T007_TAX, T007_NETAMOUNT, T007_DETAILS, Datalayer.iT001_COMPANYID, ref T007_SALEID_out); if (T007_SALEID_out > 0) { T007_SALEID = int.Parse(T007_SALEID_out.Value.ToString()); int?T002_PURCHASEITEMID_OUT = 0; for (int i = 0; i < dgDisplayData.Rows.Count; i++) { if (!string.IsNullOrEmpty(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_NAME"].Value))) { int TM01_PRODUCTID = 0, TM02_PRODUCTSIZEID = 0, T008_QTY = 0; decimal T008_RATE = 0, T008_NET_AMOUNT = 0; int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value), out TM01_PRODUCTID); int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["TM02_PRODUCTSIZEID"].Value), out TM02_PRODUCTSIZEID); int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_QTY"].Value), out T008_QTY); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_RATE"].Value), out T008_RATE); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_NET_AMOUNT"].Value), out T008_NET_AMOUNT); decimal T008_TOTAL_AMT = 0, T008_DISCOUNT_PER = 0, T008_DISCOUNT_AMT = 0, T008_TAX_RATE = 0, T008_TAX_AMT = 0; decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_TOTAL_AMT"].Value), out T008_TOTAL_AMT); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_DISCOUNT_PER"].Value), out T008_DISCOUNT_PER); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_DISCOUNT_AMT"].Value), out T008_DISCOUNT_AMT); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_TAX_RATE"].Value), out T008_TAX_RATE); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T008_TAX_AMT"].Value), out T008_TAX_AMT); int?T008_SALEITEMID_Out = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDUPDATE_CHALLEN_ITEM(0, T007_SALEID, TM01_PRODUCTID, TM02_PRODUCTSIZEID, T008_QTY, T008_RATE, T008_TOTAL_AMT, T008_DISCOUNT_PER, T008_DISCOUNT_AMT, T008_TAX_RATE, T008_TAX_AMT, T008_NET_AMOUNT, Datalayer.iT001_COMPANYID, ref T008_SALEITEMID_Out); } } if (Datalayer.iT012_CHALLENID == 0) { Datalayer.InsertMessageBox(sPageName); ResteData(); if (IsPrint) { Datalayer.iPrintableChallenId = T007_SALEID; frmPrintBill fmPrnt = new frmPrintBill(); fmPrnt.Show(); } if (IsPackingSlip) { DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_PRINT_CHALLEN_BILL '" + T007_SALEID + "'"); if (dt.Rows.Count > 0) { ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptPackingSlipsOnInvoice.rpt"); RptDoc.SetDataSource(dt); crystalReportViewer1.ReportSource = RptDoc; crystalReportViewer1.Refresh(); crystalReportViewer1.PrintReport(); //Datalayer.RptReport = RptDoc; //Datalayer.sReportName = "Packing Slip"; //Report.frmReportViwer fmReport = new Report.frmReportViwer(); //fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } } //DataTable dt = new DataTable(); //dt = dl.SelectMethod("exec USP_VP_GET_FULLSALEBILL '" + T003_SALEID + "'"); //if (dt.Rows.Count > 0) //{ // ReportDocument RptDoc = new ReportDocument(); // RptDoc.Load(Application.StartupPath + @"\Report\rptRetailInvoice.rpt"); // RptDoc.SetDataSource(dt); // Datalayer.RptReport = RptDoc; // Datalayer.sReportName = "Invoice"; // frmReportViewer fmReport = new frmReportViewer(); // fmReport.Show(); //} } else { Datalayer.UpdateMessageBox(sPageName); if (IsPrint) { Datalayer.iPrintableChallenId = T007_SALEID; frmPrintBill fmPrnt = new frmPrintBill(); fmPrnt.Show(); } if (IsPackingSlip) { DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_PRINT_CHALLEN_BILL '" + T007_SALEID + "'"); if (dt.Rows.Count > 0) { ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptPackingSlipsOnInvoice.rpt"); RptDoc.SetDataSource(dt); crystalReportViewer1.ReportSource = RptDoc; crystalReportViewer1.Refresh(); crystalReportViewer1.PrintReport(); //Datalayer.RptReport = RptDoc; //Datalayer.sReportName = "Packing Slip"; //Report.frmReportViwer fmReport = new Report.frmReportViwer(); //fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } } } } else { if (Datalayer.iT012_CHALLENID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } return; } ResteData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpdateData() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbItemSetName.Text.Trim())) { ep1.SetError(cmbItemSetName, "This field is Required.."); cmbItemSetName.Focus(); return; } if (string.IsNullOrEmpty(cmbItemName.Text.Trim())) { ep1.SetError(cmbItemName, "This field is Required.."); cmbItemName.Focus(); return; } if (string.IsNullOrEmpty(txtQTY.Text.Trim())) { ep1.SetError(txtQTY, "This field is Required.."); txtQTY.Focus(); return; } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; int TM01_MAIN_PRODUCTID = 0, TM01_PRODUCTID = 0, TM02_PRODUCTSIZEID = 0, TM02_MAIN_PRODUCTSIZEID = 0; int.TryParse(cmbItemSetName.SelectedValue.ToString(), out TM01_MAIN_PRODUCTID); // int.TryParse(cmbMainItemSize.SelectedValue.ToString(), out TM02_MAIN_PRODUCTSIZEID); int.TryParse(cmbItemName.SelectedValue.ToString(), out TM01_PRODUCTID); // int.TryParse(cmbItemSize.SelectedValue.ToString(), out TM02_PRODUCTSIZEID); int TM03_QTY = 0; int.TryParse(txtQTY.Text.Trim(), out TM03_QTY); MyDa.USP_VP_ADDUPDATE_PRODUCTITEM(Datalayer.iTM03_PRODUCTITEMID, TM01_MAIN_PRODUCTID, TM01_PRODUCTID, TM03_QTY, Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iTM03_PRODUCTITEMID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iTM03_PRODUCTITEMID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void Save() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbAccount.Text.Trim())) { ep1.SetError(cmbAccount, "This field is required."); cmbAccount.Focus(); return; } if (string.IsNullOrEmpty(cmbItemName.Text.Trim())) { ep1.SetError(cmbItemName, "This field is required."); cmbItemName.Focus(); return; } if (string.IsNullOrEmpty(cmbMainItemSize.Text.Trim())) { ep1.SetError(cmbMainItemSize, "This field is required."); cmbMainItemSize.Focus(); return; } if (string.IsNullOrEmpty(txtQty.Text.Trim())) { ep1.SetError(txtQty, "This field is required."); txtQty.Focus(); return; } int T004_ORDERID = 0, T001_ACCOUNTID = 0, TM01_PRODUCTID = 0, TM02_PRODUCTSIZEID = 0, T004_QTY = 0; string T004_DETAILS = ""; bool T004_IS_URGENT = false; if (chkIsUrgent.Checked) { T004_IS_URGENT = true; } int.TryParse(lblId.Text.Trim(), out T004_ORDERID); int.TryParse(cmbAccount.SelectedValue.ToString(), out T001_ACCOUNTID); int.TryParse(cmbItemName.SelectedValue.ToString(), out TM01_PRODUCTID); int.TryParse(cmbMainItemSize.SelectedValue.ToString(), out TM02_PRODUCTSIZEID); int.TryParse(txtQty.Text.Trim(), out T004_QTY); T004_DETAILS = txtDetails.Text.Trim(); MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?T004_ORDERID_out = 0; MyDa.USP_VP_ADDUPDATE_ORDER(T004_ORDERID, T001_ACCOUNTID, dtpDate.Value, TM01_PRODUCTID, TM02_PRODUCTSIZEID, T004_QTY, T004_IS_URGENT, T004_DETAILS, Datalayer.iT001_COMPANYID, ref T004_ORDERID_out); if (T004_ORDERID_out > 0) { if (T004_ORDERID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } cmbItemName.SelectedIndex = 0; txtQty.Text = ""; txtDetails.Text = ""; chkIsUrgent.Checked = false; cmbItemName.Focus(); cmbAccount.SelectedValue = T001_ACCOUNTID; PopualteData(); } else { if (T004_ORDERID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpdatePackingSlip() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbName.Text.Trim())) { ep1.SetError(cmbName, "This field is required."); cmbName.Focus(); return; } if (dgDisplayData.Rows.Count == 0) { Datalayer.InformationMessageBox("Record is required.."); } int T010_PACKINGSLIPID = Datalayer.T010_PACKINGSLIPID; // int TM01_CUSTOMERID = 0; string T010_NO = "", T010_TRANSPORT = "", T010_LRNO = ""; int T001_ACCOUNTID = 0; DateTime T003_DATE = dtpDate.Value; // int.TryParse(cmbCustomerName.SelectedValue.ToString(), out TM01_CUSTOMERID); T010_NO = txtBillNo.Text.Trim(); T010_TRANSPORT = txtTransport.Text.Trim(); T010_LRNO = txtLRNo.Text.Trim(); int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID); if (T010_PACKINGSLIPID > 0) { int?iDeletePurchaseItem_out = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_DELETE_ALL_PACKINGSLIPORDER(T010_PACKINGSLIPID, ref iDeletePurchaseItem_out); } int?T010_PACKINGSLIPID_out = 0; Cursor.Current = Cursors.WaitCursor; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDUPDATE_PACKING_SLIP(T010_PACKINGSLIPID, T001_ACCOUNTID, T010_NO, T003_DATE, T010_TRANSPORT, T010_LRNO, Datalayer.iT001_COMPANYID, ref T010_PACKINGSLIPID_out); if (T010_PACKINGSLIPID_out > 0) { T010_PACKINGSLIPID = int.Parse(T010_PACKINGSLIPID_out.Value.ToString()); int? @T011_PACKINGSLIPORDERID_OUT = 0; for (int i = 0; i < dgDisplayData.Rows.Count; i++) { if (!string.IsNullOrEmpty(Convert.ToString(dgDisplayData.Rows[i].Cells["T004_ORDERID"].Value))) { int T004_ORDERID = 0, T011_QTY = 0; int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T004_ORDERID"].Value), out T004_ORDERID); int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T004_PENDING_QTY"].Value), out T011_QTY); if (T011_QTY > 0) { int?T002_PURCHASEITEMID_Out = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDUPDATE_PACKINGSLIPORDER(0, T010_PACKINGSLIPID, T004_ORDERID, T011_QTY, Datalayer.iT001_COMPANYID, ref T002_PURCHASEITEMID_Out); } } } if (Datalayer.T010_PACKINGSLIPID == 0) { Datalayer.InsertMessageBox(sPageName); ResteData(); if (Datalayer.ShowQuestMsg("are you sure do you want to print this bill ?")) { DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_GET_PRINT_PACKING_SLIP_ONID '" + T010_PACKINGSLIPID + "'"); if (dt.Rows.Count > 0) { ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptPackingSlip.rpt"); RptDoc.SetDataSource(dt); Datalayer.RptReport = RptDoc; Datalayer.sReportName = "Packing Slip Bill"; Report.frmReportViwer fmReport = new Report.frmReportViwer(); fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } } //DataTable dt = new DataTable(); //dt = dl.SelectMethod("exec USP_VP_GET_FULLSALEBILL '" + T003_SALEID + "'"); //if (dt.Rows.Count > 0) //{ // ReportDocument RptDoc = new ReportDocument(); // RptDoc.Load(Application.StartupPath + @"\Report\rptRetailInvoice.rpt"); // RptDoc.SetDataSource(dt); // Datalayer.RptReport = RptDoc; // Datalayer.sReportName = "Invoice"; // frmReportViewer fmReport = new frmReportViewer(); // fmReport.Show(); //} } else { Datalayer.UpdateMessageBox(sPageName); this.Close(); } } else { if (Datalayer.T010_PACKINGSLIPID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } return; } } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpdateData() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbName.Text.Trim())) { ep1.SetError(cmbName, "Name is Required.."); cmbName.Focus(); return; } if (string.IsNullOrEmpty(txtPrice.Text.Trim())) { ep1.SetError(txtPrice, "Price is Required.."); txtPrice.Focus(); return; } if (string.IsNullOrEmpty(txtSize.Text.Trim())) { ep1.SetError(txtSize, "Size is Required.."); txtSize.Focus(); return; } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; int TM01_PRODUCTID = 0; int.TryParse(cmbName.SelectedValue.ToString(), out TM01_PRODUCTID); decimal TM02_PRICE = 0; decimal.TryParse(txtPrice.Text.Trim(), out TM02_PRICE); MyDa.USP_VP_ADDUPDATE_PRODUCTSIZE(Datalayer.iTM02_PRODUCTSIZEID, TM01_PRODUCTID, txtSize.Text.Trim(), TM02_PRICE, Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iTM02_PRODUCTSIZEID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iTM02_PRODUCTSIZEID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpateBank() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbName.Text.Trim())) { ep1.SetError(cmbName, "Name is Required.."); cmbName.Focus(); return; } if (string.IsNullOrEmpty(cmbType.Text.Trim())) { ep1.SetError(cmbType, "Type is Required.."); cmbType.Focus(); return; } if (string.IsNullOrEmpty(cmbPaymentType.Text.Trim())) { ep1.SetError(cmbPaymentType, "Type is Required.."); cmbPaymentType.Focus(); return; } if (string.IsNullOrEmpty(txtAmount.Text.Trim())) { ep1.SetError(txtAmount, "Amount is Required.."); txtAmount.Focus(); return; } int T001_ACCOUNTID = 0, TM04_BANKID = 0, T009_AMOUNT = 0; string T009_TYPE = cmbType.SelectedItem.ToString(); string T009_PAYMENT_TYPE = cmbPaymentType.SelectedItem.ToString(); int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID); int.TryParse(Convert.ToString(cmbBank.SelectedValue), out TM04_BANKID); int.TryParse(txtAmount.Text.Trim(), out T009_AMOUNT); MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; MyDa.USP_VP_ADDUPDATE_PAYMENT(Datalayer.iT009_PURCHASEPAYMENTID, dtpDate.Value, T001_ACCOUNTID, T009_TYPE, T009_PAYMENT_TYPE, TM04_BANKID, T009_AMOUNT, txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iT009_PURCHASEPAYMENTID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iT009_PURCHASEPAYMENTID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpateBank() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbEmployee.Text.Trim())) { ep1.SetError(cmbEmployee, "Name is Required.."); cmbEmployee.Focus(); return; } if (string.IsNullOrEmpty(txtTotalDay.Text.Trim())) { ep1.SetError(txtTotalDay, "Amount is Required.."); txtTotalDay.Focus(); return; } decimal dTotal = 0, dDedaction = 0, dSalary = 0, dLoan = 0, dPaid = 0;; int dTotalDay = 0, dTotalHours = 0; decimal dDayPrice = 0, dHoursPrice = 0; int.TryParse(txtTotalDay.Text.Trim(), out dTotalDay); int.TryParse(txtTotalHours.Text.Trim(), out dTotalHours); decimal.TryParse(lblDayPrice.Text.Trim(), out dDayPrice); decimal.TryParse(lblHoursPrice.Text.Trim(), out dHoursPrice); //decimal.TryParse(txtTotal.Text.Trim(), out dTotal); // decimal.TryParse(txtTotalDedaction.Text.Trim(), out dDedaction); decimal.TryParse(txtSalary.Text.Trim(), out dSalary); decimal.TryParse(lblLoanAmount.Text.Trim(), out dLoan); //ecimal.TryParse(txtPaidAmt.Text.Trim(), out dPaid); int T14_WORKERID = 0; int.TryParse(cmbEmployee.SelectedValue.ToString(), out T14_WORKERID); MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; MyDa.USP_VP_ADDUPDATES_SALARY(Datalayer.iT16_SALARYID, T14_WORKERID, dtpDate.Value, dTotalDay, dTotalHours, dDayPrice, dHoursPrice, dSalary, dLoan, txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iT16_SALARYID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iT16_SALARYID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void Save() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbName.Text.Trim())) { ep1.SetError(cmbName, "This field is required."); cmbName.Focus(); return; } if (dgDisplayData.Rows.Count == 0) { Datalayer.InformationMessageBox("Record is required."); return; } int T005_STOCKINID = 0, T001_ACCOUNTID = 0; string T004_DETAILS = ""; T005_STOCKINID = Datalayer.iT005_STOCKINID; int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID); T004_DETAILS = txtDetails.Text.Trim(); if (T005_STOCKINID > 0) { int?Iout = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_DELETE_STOCK_IN(T005_STOCKINID, ref Iout); } int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID); MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?T004_ORDERID_out = 0; Cursor.Current = Cursors.WaitCursor; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDUPDATE_STOCK_MASTER(T005_STOCKINID, dtpDate.Value, T001_ACCOUNTID, txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref T004_ORDERID_out); if (T004_ORDERID_out > 0) { T005_STOCKINID = int.Parse(T004_ORDERID_out.Value.ToString()); for (int i = 0; i < dgDisplayData.Rows.Count; i++) { if (!string.IsNullOrEmpty(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value))) { int TM01_PRODUCTID = 0; decimal T005_WEIGHT = 0, T005_QTY = 0; string T005_UNIT = "", T005_TYPE = ""; int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value), out TM01_PRODUCTID); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T005_QTY"].Value), out T005_QTY); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T005_WEIGHT"].Value), out T005_WEIGHT); T005_UNIT = Convert.ToString(dgDisplayData.Rows[i].Cells["T005_UNIT"].Value); T005_TYPE = Convert.ToString(dgDisplayData.Rows[i].Cells["T005_TYPE"].Value); int?T008_SALEITEMID_Out = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDUPDATE_STOCK_IN(0, T005_STOCKINID, TM01_PRODUCTID, T005_QTY, T005_UNIT, T005_TYPE, T005_WEIGHT, Datalayer.iT001_COMPANYID, ref T004_ORDERID_out); } } if (T004_ORDERID_out > 0) { if (Datalayer.iT005_STOCKINID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } ResetData(); } else { if (Datalayer.iT005_STOCKINID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } } } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpdatePurchase() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbName.Text.Trim())) { ep1.SetError(cmbName, "This field is required."); cmbName.Focus(); return; } if (string.IsNullOrEmpty(txtFinalAmount.Text.Trim())) { ep1.SetError(txtFinalAmount, "This field is required."); txtFinalAmount.Focus(); return; } int T002_PURCHASEID = Datalayer.iT002_PURCHASEID; // int TM01_CUSTOMERID = 0; string T002_NO = "", T002_DETAILS = ""; int T001_ACCOUNTID = 0, T007_PLACE_OF_SUPPLY = 0; decimal T002_TOTAL_AMT = 0, T002_DISCOUNT = 0, T002_TAX1RATE = 0, T002_TAX1AMOUNT = 0, T002_TAX2RATE = 0, T002_TAX2AMOUNT = 0, T002_TAX3RATE = 0, T002_TAX3AMOUNT = 0, T002_NETAMOUNT = 0; DateTime T003_DATE = dtpDate.Value; T002_NO = txtBillNo.Text.Trim(); int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID); int.TryParse(cmbState.SelectedValue.ToString(), out T007_PLACE_OF_SUPPLY); decimal.TryParse(txtTotalAmt.Text.Trim(), out T002_TOTAL_AMT); decimal.TryParse(txtCGST.Text.Trim(), out T002_TAX1RATE); decimal.TryParse(lblCGSTAmount.Text.Trim(), out T002_TAX1AMOUNT); decimal.TryParse(txtSGST.Text.Trim(), out T002_TAX2RATE); decimal.TryParse(lblSGSTAmount.Text.Trim(), out T002_TAX2AMOUNT); decimal.TryParse(txtIGST.Text.Trim(), out T002_TAX3RATE); decimal.TryParse(lblIGSTAmount.Text.Trim(), out T002_TAX3AMOUNT); decimal.TryParse(txtFinalAmount.Text.Trim(), out T002_NETAMOUNT); T002_DETAILS = txtDetails.Text.Trim(); if (T002_PURCHASEID > 0) { int?Iout = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_DELETE_PURCHASE_ITEM(T002_PURCHASEID, ref Iout); } int?T002_PURCHASEID_out = 0; Cursor.Current = Cursors.WaitCursor; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDUPDATE_PURCHASE(T002_PURCHASEID, T001_ACCOUNTID, T002_NO, T003_DATE, T002_TOTAL_AMT, T002_DISCOUNT, T002_TAX1RATE, T002_TAX1AMOUNT, T002_TAX2RATE, T002_TAX2AMOUNT, T002_TAX3RATE, T002_TAX3AMOUNT, T002_NETAMOUNT, T002_DETAILS, Datalayer.iT001_COMPANYID, T007_PLACE_OF_SUPPLY, ref T002_PURCHASEID_out); if (T002_PURCHASEID_out > 0) { T002_PURCHASEID = int.Parse(T002_PURCHASEID_out.Value.ToString()); for (int i = 0; i < dgDisplayData.Rows.Count; i++) { if (!string.IsNullOrEmpty(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value))) { int TM01_PRODUCTID = 0; decimal T003_RATE = 0, T003_AMOUNT = 0, T003_QTY = 0; string T003_UNIT = ""; int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value), out TM01_PRODUCTID); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T003_QTY"].Value), out T003_QTY); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T003_RATE"].Value), out T003_RATE); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T003_AMOUNT"].Value), out T003_AMOUNT); T003_UNIT = Convert.ToString(dgDisplayData.Rows[i].Cells["T003_UNIT"].Value); int?T008_SALEITEMID_Out = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDUPDATE_PURCHASEITEM(0, T002_PURCHASEID, TM01_PRODUCTID, T003_QTY, T003_UNIT, T003_RATE, T003_AMOUNT, 0, Datalayer.iT001_COMPANYID, ref T008_SALEITEMID_Out); } } if (Datalayer.iT002_PURCHASEID == 0) { Datalayer.InsertMessageBox(sPageName); ResteData(); } else { Datalayer.UpdateMessageBox(sPageName); ResteData(); } } else { if (Datalayer.iT002_PURCHASEID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } return; } } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpdatePurchase(bool IsPrint) { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbName.Text.Trim())) { ep1.SetError(cmbName, "This field is required."); cmbName.Focus(); return; } if (string.IsNullOrEmpty(txtBillNo.Text.Trim())) { ep1.SetError(txtBillNo, "This field is required."); txtBillNo.Focus(); return; } if (string.IsNullOrEmpty(cmbShippedTo.Text.Trim())) { ep1.SetError(cmbShippedTo, "This field is required."); cmbShippedTo.Focus(); return; } if (string.IsNullOrEmpty(cmbState.Text.Trim())) { ep1.SetError(cmbState, "This field is required."); cmbState.Focus(); return; } if (string.IsNullOrEmpty(cmbReverseCharges.Text.Trim())) { ep1.SetError(cmbReverseCharges, "This field is required."); cmbReverseCharges.Focus(); return; } if (string.IsNullOrEmpty(txtBillNo.Text.Trim())) { ep1.SetError(txtBillNo, "This field is required."); txtBillNo.Focus(); return; } if (string.IsNullOrEmpty(txtNetAmount.Text.Trim())) { ep1.SetError(txtNetAmount, "This field is required."); txtNetAmount.Focus(); return; } if (dgDisplayData.Rows.Count == 0) { Datalayer.InformationMessageBox("Record is required."); return; } int T007_SALEID = Datalayer.iT007_SALEID; int T001_ACCOUNTID = 0, T007_SHIPPED_TO_ID = 0, T007_PLACE_OF_SUPPLY = 0; string T007_TYPE = "", T007_NO = "", T007_TRANSPORT1 = "", T007_LR1 = "", T007_TRANSPORT2 = "", T007_LR2 = "", T007_DETAILS = "", T007_VEHICLE_NO = "", T007_IS_REVERSE_CHARGES = "", T007_E_WAY_BILL = ""; decimal T007_TOTAL_AMT = 0, T007_PACKING = 0, T007_FREIGHT = 0, T007_OTHER_EXPENSE = 0, T007_DISCOUNT = 0, T007_CGST = 0, T007_SGST = 0, T007_IGST = 0, T007_NETAMOUNT = 0, T007_REVERSE_CHARGE = 0; decimal T007_TAXABLE_AMT = 0; int.TryParse(cmbName.SelectedValue.ToString(), out T001_ACCOUNTID); T007_TYPE = cmbInvoiceType.SelectedItem.ToString(); T007_NO = txtBillNo.Text.Trim(); T007_TRANSPORT1 = txtTransport1.Text.Trim(); T007_LR1 = txtLR1.Text.Trim(); T007_TRANSPORT2 = txtTransport2.Text.Trim(); decimal.TryParse(txtTotalAmt.Text.Trim(), out T007_TOTAL_AMT); decimal.TryParse(txtCGST.Text.Trim(), out T007_CGST); decimal.TryParse(txtSGST.Text.Trim(), out T007_SGST); decimal.TryParse(txtIGST.Text.Trim(), out T007_IGST); decimal.TryParse(txtNetAmount.Text.Trim(), out T007_NETAMOUNT); decimal.TryParse(txtPacking.Text.Trim(), out T007_PACKING); decimal.TryParse(txtDiscount.Text.Trim(), out T007_DISCOUNT); decimal.TryParse(txtTaxableAMT.Text.Trim(), out T007_TAXABLE_AMT); T007_DETAILS = txtDetails.Text.Trim(); T007_VEHICLE_NO = txtVehicleNo.Text.Trim(); T007_IS_REVERSE_CHARGES = cmbReverseCharges.SelectedItem.ToString(); decimal.TryParse(txtReverseCharges.Text.Trim(), out T007_REVERSE_CHARGE); T007_E_WAY_BILL = txtEWayBill.Text.Trim(); int.TryParse(cmbShippedTo.SelectedValue.ToString(), out T007_SHIPPED_TO_ID); int.TryParse(cmbState.SelectedValue.ToString(), out T007_PLACE_OF_SUPPLY); if (T007_NETAMOUNT <= 250000 && T007_PLACE_OF_SUPPLY == 22 && T007_TYPE == "B2CL") { Datalayer.InformationMessageBox("please choose correct place of supply and provide bill value more than 2.5 lakhs"); return; } if (T007_TYPE == "B2CS" && T007_PLACE_OF_SUPPLY != 33) { Datalayer.InformationMessageBox("please choose correct place of supply."); return; } if (T007_SALEID > 0) { int?Iout = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_DELETE_SALEITEM(T007_SALEID, ref Iout); } int?T007_SALEID_out = 0; Cursor.Current = Cursors.WaitCursor; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDUPDATE_SALE(T007_SALEID, T001_ACCOUNTID, T007_TYPE, T007_NO, dtpDate.Value, T007_TRANSPORT1, T007_LR1, T007_TRANSPORT2, T007_LR2, T007_TOTAL_AMT, T007_PACKING, T007_DISCOUNT, T007_TAXABLE_AMT, T007_CGST, T007_SGST, T007_IGST, T007_NETAMOUNT, T007_DETAILS, Datalayer.iT001_COMPANYID, T007_VEHICLE_NO, T007_IS_REVERSE_CHARGES, T007_REVERSE_CHARGE, T007_E_WAY_BILL, T007_SHIPPED_TO_ID, T007_PLACE_OF_SUPPLY, dtpLRDate.Value, txtBillPrefix.Text.Trim(), txtTotalKG.Text.Trim(), ref T007_SALEID_out); if (T007_SALEID_out > 0) { T007_SALEID = int.Parse(T007_SALEID_out.Value.ToString()); int?T002_PURCHASEITEMID_OUT = 0; for (int i = 0; i < dgDisplayData.Rows.Count; i++) { if (!string.IsNullOrEmpty(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value))) { int TM01_PRODUCTID = 0; decimal T003_RATE = 0, T003_AMOUNT = 0; int T003_QTY = 0; string T003_UNIT = ""; int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["TM01_PRODUCTID"].Value), out TM01_PRODUCTID); int.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T003_QTY"].Value), out T003_QTY); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T003_RATE"].Value), out T003_RATE); decimal.TryParse(Convert.ToString(dgDisplayData.Rows[i].Cells["T003_AMOUNT"].Value), out T003_AMOUNT); T003_UNIT = Convert.ToString(dgDisplayData.Rows[i].Cells["T003_UNIT"].Value); int?T008_SALEITEMID_Out = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDPDATE_SALEITEM(0, T007_SALEID, TM01_PRODUCTID, T003_QTY, T003_RATE, T003_UNIT, T003_AMOUNT, Datalayer.iT001_COMPANYID, ref T008_SALEITEMID_Out); } } if (Datalayer.iT007_SALEID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); Datalayer.iT007_SALEID = T007_SALEID; } if (IsPrint) { Datalayer.iT007_SALEID = T007_SALEID; DAL dl = new DAL(); DataTable dt = new DataTable(); dt = dl.SelectMethod("exec USP_VP_PRINT_SALE_BILL '" + Datalayer.iT007_SALEID + "'"); if (dt.Rows.Count > 0) { //DataTable dtQTY = new DataTable(); //dtQTY = dl.SelectMethod("SELECT TM01_HSNCODE,SUM(T008_QTY)AS QTY FROM T008_SALEITEM T008 INNER JOIN TM01_PRODUCT TM01 ON TM01.TM01_PRODUCTID = T008.TM01_PRODUCTID WHERE T007_SALEID=" + Datalayer.iT007_SALEID + " GROUP BY TM01.TM01_HSNCODE "); //if (dtQTY.Rows.Count > 0) //{ // for (int i = 0; i < dt.Rows.Count; i++) // { // if (dtQTY.Rows.Count == 1) // { // dt.Rows[i]["HSNCODE1"] = dtQTY.Rows[0][0].ToString(); // dt.Rows[i]["HSNCODEQTY1"] = dtQTY.Rows[0][1].ToString(); // } // if (dtQTY.Rows.Count == 2) // { // dt.Rows[i]["HSNCODE1"] = dtQTY.Rows[0][0].ToString(); // dt.Rows[i]["HSNCODEQTY1"] = dtQTY.Rows[0][1].ToString(); // dt.Rows[i]["HSNCODE2"] = dtQTY.Rows[1][0].ToString(); // dt.Rows[i]["HSNCODEQTY2"] = dtQTY.Rows[1][1].ToString(); // } // if (dtQTY.Rows.Count == 3) // { // dt.Rows[i]["HSNCODE1"] = dtQTY.Rows[0][0].ToString(); // dt.Rows[i]["HSNCODEQTY1"] = dtQTY.Rows[0][1].ToString(); // dt.Rows[i]["HSNCODE2"] = dtQTY.Rows[1][0].ToString(); // dt.Rows[i]["HSNCODEQTY2"] = dtQTY.Rows[1][1].ToString(); // dt.Rows[i]["HSNCODE2"] = dtQTY.Rows[2][0].ToString(); // dt.Rows[i]["HSNCODEQTY2"] = dtQTY.Rows[2][1].ToString(); // } // } //} //dt.Rows[0]["BILLTYPE"] = cmbPrintMode.SelectedItem.ToString(); ; ReportDocument RptDoc = new ReportDocument(); RptDoc.Load(Application.StartupPath + @"\Report\rptInvoice.rpt"); RptDoc.SetDataSource(dt); crystalReportViewer1.ReportSource = RptDoc; crystalReportViewer1.Refresh(); crystalReportViewer1.PrintReport(); //Datalayer.RptReport = RptDoc; //Datalayer.sReportName = "Invoice Bill"; //Report.frmReportViwer fmReport = new Report.frmReportViwer(); //fmReport.Show(); } else { Datalayer.InformationMessageBox("No Record.."); } //if (Datalayer.ShowQuestMsg("are you sure do you want to print this bill ?")) //{ // Datalayer.iPrintableBillId = T007_SALEID; // frmPrintBill fmPrnt = new frmPrintBill(); // fmPrnt.Show(); //} } this.Close(); } else { if (Datalayer.iT007_SALEID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } return; } } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }