private void Save_Click(object sender, EventArgs e) { try { _a.InsertPaymentDetails("Customer", txt_Amount.Text, cmb_PaymentType.Text, lbl_id.Text, dtp_Date.Value.ToString("dd/MM/yyyy"), txt_ReceiptNo.Text); MessageBox.Show("Payment Saved"); } catch (Exception ex) { _e.AddException(ex, "Customer Payment"); } try { DialogResult dr = MessageBox.Show("Do You want to print Receipt", "", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { Report.CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new Report.CrystalReport.frm_ReportViewer(); SendData _obj = new SendData(_objfrm_ReportViewer.PaymentReceipt); _obj(txt_ReceiptNo.Text, "Customer"); } } catch (Exception ex) { _e.AddException(ex, "Customer Payment/Print"); } MessageBox.Show("Done"); Clear(); }
private void bttn_Sale_Click(object sender, EventArgs e) { string BillNo = txt_BillNo.Text; MessageBox.Show("Do you Want to Continue With Bill Amount of ₹ " + txt_NetAmt.Text.ToString()); if (cmb_Name.Text != "" || txt_ContactNo.Text != "") { if (!_Cust.checkCustomerAccount(cmb_Name.Text)) { txt_AccNo.Text = _objSQLHelper.gmGetMstID("C", "0"); _Cust.AddCustomerDetails(txt_AccNo.Text, cmb_Name.Text, txt_Address.Text, txt_MobileNo.Text, txt_ContactNo.Text); } } try { for (int i = 0; i < dgv_ItemInfo.Rows.Count; i++) { string Category = Convert.ToString(dgv_ItemInfo.Rows[i].Cells["Category"].Value); string SubCategory = Convert.ToString(dgv_ItemInfo.Rows[i].Cells["SubCategory"].Value); string Amount = Convert.ToString(dgv_ItemInfo.Rows[i].Cells["SellingAmt"].Value); //string narration = Convert.ToString(dgv_ItemInfo.Rows[i].Cells[" "].Value); BillNo = Convert.ToString(txt_BillNo.Text); string AccNo = Convert.ToString(txt_AccNo.Text); string size = Convert.ToString(dgv_ItemInfo.Rows[i].Cells["size"].Value); if (dgv_ItemInfo.Rows[i].Cells["BarcodeNo"].Value == "" || dgv_ItemInfo.Rows[i].Cells["BarcodeNo"].Value == string.Empty) { _Sale.AddItemDetails(Category, SubCategory, Amount, size, " ", BillNo, AccNo, dtp_Date.Value.ToString("dd/MM/yyyy"), "Sale"); } else { _Sale.UpdateItem(Convert.ToString(dgv_ItemInfo.Rows[i].Cells["BarcodeNo"].Value), txt_BillNo.Text); } } _Sale.AddBillDetails(txt_BillNo.Text, txt_AccNo.Text, txt_TotalAmt.Text, txt_Vat.Text, txt_NetAmt.Text, " ", dtp_Date.Value.ToString("dd/MM/yyyy")); } catch (Exception ex) { _error.AddException(ex, "Sale"); } _Sale.PrintBill(BillNo); MessageBox.Show("Sale Successfully Done"); Masterclear(); this.BringToFront(); }
private void bttn_Edit_Click(object sender, EventArgs e) { string BillNo = dgv_Bill.Rows[dgv_Bill.CurrentRow.Index].Cells["BillNo"].Value.ToString(); string type = dgv_Bill.Rows[dgv_Bill.CurrentRow.Index].Cells["Type"].Value.ToString(); string SrNo = dgv_Bill.Rows[dgv_Bill.CurrentRow.Index].Cells["SrNo"].Value.ToString(); _sale.DeleteBillRecord(SrNo, BillNo); try { if (type == "GST") { frm_SaleForm _form = new frm_SaleForm(BillNo, "Deleted"); _form.ShowDialog(); } if (type == "Estimate") { frm_SaleEstimate _form = new frm_SaleEstimate(BillNo, "Deleted"); _form.ShowDialog(); } } catch (Exception ex) { _error.AddException(ex, "ChangeBill"); MessageBox.Show(ex.Message); } }
private void Calculate() { double total = 0; double CGSTAmt = 0; double SGSTAmt = 0; double IGSTAmt = 0; try { for (int i = 0; i < dgv_ItemInfo.Rows.Count; i++) { total += Math.Round(Convert.ToDouble(dgv_ItemInfo.Rows[i].Cells["TotalAmt"].Value), 2); CGSTAmt += Math.Round(Convert.ToDouble(dgv_ItemInfo.Rows[i].Cells["CGST"].Value), 2); SGSTAmt += Math.Round(Convert.ToDouble(dgv_ItemInfo.Rows[i].Cells["SGST"].Value), 2); IGSTAmt += Math.Round(Convert.ToDouble(dgv_ItemInfo.Rows[i].Cells["IGST"].Value), 2); } txt_TotalAmt.Text = total.ToString(); lbl_CGSTValue.Text = CGSTAmt.ToString(); lbl_SGSTValue.Text = SGSTAmt.ToString(); lbl_IGSTValue.Text = IGSTAmt.ToString(); txt_NetAmt.Text = txt_BillAmt.Text = Convert.ToString(_common.sumGridViewColumn(dgv_ItemInfo, "TotalPrice")); } catch (Exception ex) { _error.AddException(ex, "Purchase"); } }
private void Masterclear() { cmb_Name.ResetText(); txt_Address.ResetText(); txt_BillNo.ResetText(); txt_City.ResetText(); txt_ContactNo.ResetText(); txt_MobileNo.ResetText(); txt_PaidAmt.Text = "0"; txt_VatValue.Text = Convert.ToString(dtsett.Rows[0]["TaxPer"]); txt_Vat.ResetText(); txt_Qty.Text = "1"; txt_SellingAmt.Text = "0"; txt_PurchaseAmt.Text = "0"; txt_Vat.Text = "0"; txt_TotalAmt.Text = "0"; txt_BalAmt.Text = "0"; dgv_ItemInfo.Rows.Clear(); txt_NetAmt.Text = "0"; try { txt_AccNo.Text = _objSQLHelper.gmGetMstID("P", "0"); } catch (Exception ex) { _error.AddException(ex, "Purchase"); } chbk_barcode.Checked = true; }
private void Save_Click(object sender, EventArgs e) { try { _a.InsertPaymentDetails("Supplier", txt_Amount.Text, cmb_PaymentType.Text, lbl_id.Text, dtp_Date.Value.ToString("dd/MM/yyyy"), txt_ReceiptNo.Text); MessageBox.Show("Payment Saved"); Clear(); } catch (Exception ex) { _e.AddException(ex, "Supplier Payment"); } }
private void bttn_Print_Click(object sender, EventArgs e) { try { Report.CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new Report.CrystalReport.frm_ReportViewer(); SendData _obj = new SendData(_objfrm_ReportViewer.GSTReport); _obj(GST, "Supplier", dtp_From.Value.ToString("dd/MM/yyyy"), dtp_to.Value.ToString("dd/MM/yyyy")); } catch (Exception ex) { MessageBox.Show(ex.Message); _error.AddException(ex, "Supplier GST Report"); } }
private void bttn_print_Click(object sender, EventArgs e) { try { Report.CrystalReport.frm_ReportViewer _objfrm_ReportViewer = new Report.CrystalReport.frm_ReportViewer(); SendData _obj = new SendData(_objfrm_ReportViewer.MonthlyGST); _obj(Sale, Purchase, cmb_month.Text); } catch (Exception ex) { MessageBox.Show(ex.Message); _error.AddException(ex, "Supplier GST Report"); } }
private void bttn_yes_Click(object sender, EventArgs e) { try { string script = File.ReadAllText(Environment.CurrentDirectory + "/Scripts/" + "Delete Query.sql"); _sql.ExecuteScalar(script); MessageBox.Show("Data Deleted Succesfully"); this.Close(); } catch (Exception ex) { _error.AddException(ex, "Delete Data"); MessageBox.Show(ex.Message); } }
private void GetReport() { int j = 0; try { DataTable Bill = _sale.GetCustomerReport(dtp_from.Value.ToString("dd/MM/yyyy"), dtp_to.Value.ToString("dd/MM/yyyy"), "GST"); if (Bill.Rows.Count > 0) { for (j = 0; j < Bill.Rows.Count; j++) { string HSNAll = _sale.GetAllHSNSale(Bill.Rows[j]["BillNo"].ToString()); if (Bill.Rows.Count != 0) { dgv_SupplierBill.Rows.Add(); dgv_SupplierBill.Rows[j].Cells["SrNo"].Value = Convert.ToString(j + 1); dgv_SupplierBill.Rows[j].Cells["BillNo"].Value = Bill.Rows[j]["BillNo"].ToString(); dgv_SupplierBill.Rows[j].Cells["Date"].Value = Bill.Rows[j]["Date"].ToString(); dgv_SupplierBill.Rows[j].Cells["SupplierName"].Value = Bill.Rows[j]["CustomerName"].ToString(); dgv_SupplierBill.Rows[j].Cells["GSTIN"].Value = Bill.Rows[j]["GSTIN"].ToString(); dgv_SupplierBill.Rows[j].Cells["HSNCode"].Value = HSNAll; dgv_SupplierBill.Rows[j].Cells["BillAmt"].Value = Bill.Rows[j]["Amount"].ToString(); dgv_SupplierBill.Rows[j].Cells["CGST"].Value = Bill.Rows[j]["CGST"].ToString(); dgv_SupplierBill.Rows[j].Cells["SGST"].Value = Bill.Rows[j]["SGST"].ToString(); dgv_SupplierBill.Rows[j].Cells["IGST"].Value = Bill.Rows[j]["IGST"].ToString(); dgv_SupplierBill.Rows[j].Cells["TotalAmt"].Value = Bill.Rows[j]["GrandAmt"].ToString(); } else { MessageBox.Show("Customer Details Missing"); } } } j = j + 1; dgv_SupplierBill.Rows.Add(2); dgv_SupplierBill.Rows[j].Cells["HSNCode"].Value = "Total"; dgv_SupplierBill.Rows[j].Cells["BillAmt"].Value = _common.sumGridViewColumn(dgv_SupplierBill, "BillAmt"); dgv_SupplierBill.Rows[j].Cells["CGST"].Value = _common.sumGridViewColumn(dgv_SupplierBill, "CGST"); dgv_SupplierBill.Rows[j].Cells["SGST"].Value = _common.sumGridViewColumn(dgv_SupplierBill, "SGST"); dgv_SupplierBill.Rows[j].Cells["IGST"].Value = _common.sumGridViewColumn(dgv_SupplierBill, "IGST"); dgv_SupplierBill.Rows[j].Cells["TotalAmt"].Value = _common.sumGridViewColumn(dgv_SupplierBill, "TotalAmt"); } catch (Exception ex) { _error.AddException(ex, "CustomerGSTReport"); } }
private void dgv_Category_CellClick(object sender, DataGridViewCellEventArgs e) { try { bttn_Update.Enabled = true; bttn_Delete.Enabled = true; bttn_Add.Enabled = false; if (e.RowIndex > -1 && e.ColumnIndex >= -1) { lbl_SrNo.Text = dgv_Category.Rows[dgv_Category.CurrentRow.Index].Cells["SrNo"].Value.ToString(); txt_Category.Text = dgv_Category.Rows[dgv_Category.CurrentRow.Index].Cells["Category"].Value.ToString(); } } catch (Exception ex) { _e.AddException(ex, "Category"); } }
private void Calculate() { double total = 0; try { for (int i = 0; i < dgv_ItemInfo.Rows.Count; i++) { total += Math.Round(Convert.ToDouble(dgv_ItemInfo.Rows[i].Cells["TotalAmt"].Value), 2); } txt_TotalAmt.Text = total.ToString(); txt_NetAmt.Text = txt_BillAmt.Text = Convert.ToString(_common.sumGridViewColumn(dgv_ItemInfo, "TotalPrice")); } catch (Exception ex) { _error.AddException(ex, "Sale"); } }
private void bttn_print_Click(object sender, EventArgs e) { try { if (txt_type.Text == "GST") { frm_SaleForm _form = new frm_SaleForm(bill.Text, "Update"); _form.ShowDialog(); } if (txt_type.Text == "Estimate") { frm_SaleEstimate _form = new frm_SaleEstimate(bill.Text, "Update"); _form.ShowDialog(); } } catch (Exception ex) { _error.AddException(ex, "ChangeBill"); MessageBox.Show(ex.Message); } //_s.PrintBillThermal(cmb_BillNo.Text); }
/// <summary> public void CustomerBill(string BillNo, string Type) { string company = "SELECT * from CompanyMaster"; DataTable dt_CompanyInfo = _objsqlhelper.GetDataTable(company); string BillingDetails = "Select * from CustomerBill Where BillNo='" + BillNo + "' and (PermanentDelete = 0 or PermanentDelete is Null) "; DataTable dt_BillingDetails = _objsqlhelper.GetDataTable(BillingDetails); string BillType, PayType; if (dt_BillingDetails.Rows[0]["State"].ToString() == dt_CompanyInfo.Rows[0]["State"].ToString()) { BillType = "GST_Interstate"; } else { BillType = "GST_OtherState"; } string crname = "Select SaleBill from CrystalReport Where Type='" + BillType + "'"; string str_crname = _objsqlhelper.ExecuteScalar(crname); ReportDocument _objReport = new ReportDocument(); _objReport.Load(Environment.CurrentDirectory + "\\" + str_crname); _objReport.Database.Tables["CompanyInfo"].SetDataSource(dt_CompanyInfo); _objReport.Database.Tables["CustomerBill"].SetDataSource(dt_BillingDetails); DataTable dt_CustomerInfo = _sales.GetCustomerByBill(BillNo); _objReport.Database.Tables["CustomerDetails"].SetDataSource(dt_CustomerInfo); DataTable dt_ItemsDetails = _sales.GetBillItem(BillNo, "Sale"); _objReport.Database.Tables["BillItem"].SetDataSource(dt_ItemsDetails); string qty = Convert.ToString(_common.sumDataTableColumn(dt_ItemsDetails, "Qty")); DataTable dt_Payment = _a.getpaymentByBill(BillNo, "Sale", "0"); _objReport.Database.Tables["Payment"].SetDataSource(dt_Payment); try { string Balance = Convert.ToString(_sales.GetBalance(dt_CustomerInfo.Rows[0]["CustId"].ToString(), "Sale")); _objReport.SetParameterValue("Balance", Balance); } catch (Exception ex) { _error.AddException(ex, "ReportViewer"); MessageBox.Show(ex.ToString()); } try { PayType = "Cash"; if (dt_Payment.Rows.Count > 0) { if (dt_BillingDetails.Rows[0]["BillAmount"] == dt_Payment.Rows[0]["Amt"]) { PayType = "Cash"; } else { PayType = "Credit"; } } _objReport.SetParameterValue("Type", PayType); } catch (Exception ex) { _error.AddException(ex, "ReportViewer"); } try { double inword = Convert.ToDouble(dt_BillingDetails.Rows[0]["BillAmount"].ToString()); inword = Math.Round(inword); int number = Convert.ToInt32(inword); string inwordsString = _objCommon.NumberToWords(number); _objReport.SetParameterValue("inwords", inwordsString); } catch (Exception ex) { _error.AddException(ex, "ReportViewer"); } try { _objReport.SetParameterValue("Qty", qty); } catch (Exception ex) { _error.AddException(ex, "ReportViewer"); } if (Type == "Print") { if (_objPrinterSetting.ShowDialog() == DialogResult.OK) { try { int Copies = _objPrinterSetting.copies; _objReport.PrintOptions.PrinterName = _objPrinterSetting.PrinterName; _objReport.PrintToPrinter(Copies, true, 0, 0); printresult = true; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } if (printresult == true) { printresult = false; } } else { crReportViewer.ReportSource = _objReport; crReportViewer.Show(); return; } } else { crReportViewer.ReportSource = _objReport; crReportViewer.Show(); return; } }
private void btn_Save_Click(object sender, EventArgs e) { if (check()) { try { string VouchertypeID = _objCommon.getALLTableDetails(sTableName: TableNames.VoucherType, sColomnName: "VoucherTypeName", sColumnValue: "Receipt Voucher").Rows[0]["VoucherTypeID"].ToString(); string TransactionLedgerID = null; bool Payformstatus = true; if (Convert.ToDouble(txtAmount.Text) > 0) { DialogResult dr = MessageBox.Show("Amount to be Payed :" + txtAmount.Text + "\n\n Do You Want To Continue", "JMS Says ", MessageBoxButtons.YesNo); if (dr == DialogResult.Yes) { if (datasv.PaymentForm == "1") { frm_PaymentOptionForReceiptVoucher form = new frm_PaymentOptionForReceiptVoucher ( Amountpaid: txtAmount.Text, billno: txtReceiptNo.Text, Accountno: "", Date: txtDate.Text, CustomerType: CustomerType.ReceiptVoucher, OperationType: OperationType.Create ); form.ShowDialog(); Payformstatus = true; TransactionLedgerID = form.TransactionLedgerID; PaymentIDs = form.PaymentIDs; if (form.ReturnStatus == false) { Payformstatus = false; } } else if (datasv.PaymentForm == "0") { Payformstatus = true; } } else if (dr == DialogResult.No) { Payformstatus = false; } } int ReceiptMasterID = _objCreditDebit.addReceiptVoucher ( ReceiptNo: txtReceiptNo.Text, Date: txtDate.Text, CashOrBankID: TransactionLedgerID.ToString(), AccountLedgerID: CmbAccountLedger.SelectedValue.ToString(), Amount: txtAmount.Text, Narration: txtNarration.Text ); if (txtAmount.Text != "" && txtAmount.Text != "0") { _objCommon.updatePaymentDetailByPaymentID(ColumnName: "VoucherTypeId", columnValue: VouchertypeID, paymentid: PaymentIDs[0]); _objCommon.updatePaymentDetailByPaymentID(ColumnName: "VoucherId", columnValue: ReceiptMasterID.ToString(), paymentid: PaymentIDs[0]); if (PaymentIDs[1] != 0) { _objCommon.updatePaymentDetailByPaymentID(ColumnName: "VoucherTypeId", columnValue: VouchertypeID, paymentid: PaymentIDs[1]); _objCommon.updatePaymentDetailByPaymentID(ColumnName: "VoucherId", columnValue: ReceiptMasterID.ToString(), paymentid: PaymentIDs[1]); } //acount ledger creditdebit With payment by cash /bank _ObjSalesCommon.insertcreditDebitWithPayment(customerLedgerID: CmbAccountLedger.SelectedValue.ToString(), VouchertypeID: VouchertypeID, sbillno: ReceiptMasterID.ToString(), transactionLedgerID: TransactionLedgerID, AmountPaid: txtAmount.Text, Narration: "", Date: txtDate.Text, name: CmbAccountLedger.Text.Trim()); } MessageBox.Show("Data Inserted...!"); MasterClear(); } catch (Exception ex) { MessageBox.Show(ex.Message); _error.AddException(ex, FormName); } } else { } }
private void Masterclear() { cmb_Name.ResetText(); cmb_State.SelectedIndex = 26; txt_Address.ResetText(); txt_City.ResetText(); txt_ContactNo.ResetText(); txt_BillNo.ResetText(); txt_PAN.ResetText(); txt_GSTIN.ResetText(); txt_TotalAmt.Text = "0"; txt_CGSTValue.Text = ""; txt_SGSTValue.Text = ""; txt_IGSTValue.Text = ""; txt_NetAmt.Text = "0"; txt_PaidAmt.Text = "0"; txt_BalAmt.Text = "0"; txt_OtherCharges.Text = "0"; cmb_PayMode.SelectedIndex = 0; dgv_ItemInfo.Rows.Clear(); Clear(); cmb_Name.DataSource = _objCustmor.getSupplierName(); cmb_Name.SelectedIndex = -1; txt_PurchaseRef.Text = _objSQLHelper.GetMaxID("PR", "0"); try { lbl_AccNo1.Text = _objSQLHelper.GetMaxID("P", "0"); } catch (Exception ex) { _error.AddException(ex, "Purchase"); } }