private void bttn_save_Click(object sender, EventArgs e) { try { if (check()) { int finalcialYearId = _onjFinancialYear.getSelectedFinancialYearId(); string transaction_type; if (rdcredit.Checked == true) { transaction_type = rdcredit.Text; } else { transaction_type = rdDebit.Text; } //_objga.insertAccountLedger(txt_name.Text, dtAccGroup.Rows[0]["srno"].ToString(),txt_OpeningBal.Text, transaction_type); _objBalanceSheet.insertAccountLedger(txt_name.Text, cmb_AccountGroup.SelectedValue.ToString(), txt_OpeningBal.Text, transaction_type, txt_Nar.Text, txt_NOB.Text, txt_ChequeId.Text, dateTimePicker_addDate.Text, finalcialYearId); MessageBox.Show("Saved Successfully"); fillgrid(); clearall(); } else { MessageBox.Show("Add Each Detail"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void bttn_save_Click(object sender, EventArgs e) { try { int finalcialYearId = _onjFinancialYear.getSelectedFinancialYearId(); string masterid = _objCredit.insertCreditDebitmaster(txt_amount.Text, txt_narration.Text, dtp_date.Text, finalcialYearId); DataTable dt = _objCredit.getallAccountLedgerDetails(); int ledgerid = 0; for (int j = 0; j < dt.Rows.Count; j++) { if (dt.Rows[j]["Name"].ToString().Trim() == "Cash") { ledgerid = Convert.ToInt32(dt.Rows[j][0]); } } _objCredit.insertCreditDebitDetails(masterid, ledgerid.ToString(), "0", txt_amount.Text, txt_chequeNo.Text, dtp_chequeDate.Text, dtp_date.Text, "Dr", cmb_AcountLedger.Text); _objCredit.insertCreditDebitDetails(masterid, cmb_AcountLedger.SelectedValue.ToString(), txt_amount.Text, "0", txt_chequeNo.Text, txt_chequeNo.Text, dtp_date.Text, "Cr", cmb_AcountLedger.Text); MessageBox.Show("Data Saved Successfully"); clearAllFields(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void bttn_Update_Click(object sender, EventArgs e) { // string receipt_no; if (txt_pavtiNoAdd.Text != "" && txt_pavtiNoRelease.Text != "") { int finalcialYearId = _onjFinancialYear.getSelectedFinancialYearId(); string gn = _objGirviAdd.get_InvoiceNo(); //receipt_no = _objGirviAdd.getReceiptNo("GRT-" + _objFinancialYear.getSelectedFinancialYear().Rows[0]["startyear"].ToString().Substring(8) + "/" + _objFinancialYear.getSelectedFinancialYear().Rows[0]["endyear"].ToString().Substring(8) + "%"); //receipt_no = "GRT-" + _objFinancialYear.getSelectedFinancialYear().Rows[0]["startyear"].ToString().Substring(8) + "/" + _objFinancialYear.getSelectedFinancialYear().Rows[0]["endyear"].ToString().Substring(8) + "-" + receipt_no; DataTable OldDetails = _objGirviAdd.getGirviByInvoiceNo(txt_Srno.Text); string olddetailsdata = OldDetails.Rows[0]["updated_girvi_no"].ToString(); string newdetails; if (OldDetails.Rows[0]["updated_girvi_no"].ToString() != "") { newdetails = OldDetails.Rows[0]["updated_girvi_no"].ToString() + "." + OldDetails.Rows[0]["receipt_no"].ToString() + "," + OldDetails.Rows[0]["GirviRecordNo"].ToString() + "," + OldDetails.Rows[0]["Amount"].ToString() + "," + OldDetails.Rows[0]["Date_of_deposit"].ToString(); } else { newdetails = OldDetails.Rows[0]["receipt_no"].ToString() + "," + OldDetails.Rows[0]["GirviRecordNo"].ToString() + "," + OldDetails.Rows[0]["Amount"].ToString() + "," + OldDetails.Rows[0]["Date_of_deposit"].ToString(); } // string receipt_norelease = _objGirviAdd.getReceiptNoRelease("GRS-" + _objFinancialYear.getSelectedFinancialYear().Rows[0]["startyear"].ToString().Substring(8) + "/" + _objFinancialYear.getSelectedFinancialYear().Rows[0]["endyear"].ToString().Substring(8) + "%"); // receipt_norelease = "GRS-" + _objFinancialYear.getSelectedFinancialYear().Rows[0]["startyear"].ToString().Substring(8) + "/" + _objFinancialYear.getSelectedFinancialYear().Rows[0]["endyear"].ToString().Substring(8) + "-" + receipt_norelease; _objGirviRelease.updateGirviMasterData(txt_Srno.Text, gn, dtp_DateOfRelease.Text); _objGirviRelease.SetReleasemaster(txt_khatawaniNo.Text, txt_Srno.Text, txt_Loanamount.Text, no_of_days, int_rate, txt_TotalAmount.Text, dtp_DateOfRelease.Text, txt_InterestAmount.Text, txt_pavtiNoRelease.Text, finalcialYearId, ""); _objGirviAdd.addGirviMaster(gn, txt_khatawaniNo.Text, int_rate, dtp_DateOfRelease.Text, txt_PayAmount.Text, dtp_Duration.Text, newdetails, Actual_int_rate, reason, "", txt_pavtiNoAdd.Text, purpose_of_loan, loantype, finalcialYearId, ""); DataTable dt = _objGirviRelease.getGirviData(txt_Srno.Text); for (int i = 0; i < dgv_ItemDetail.Rows.Count; i++) { _objGirviAdd.addGirviItemMaster(gn, dt.Rows[i]["metal_type"].ToString(), dt.Rows[i]["metal_type"].ToString(), dt.Rows[i]["item_type"].ToString(), dt.Rows[i]["gross_wt"].ToString(), dt.Rows[i]["reduce_wt"].ToString(), dt.Rows[i]["net_wt"].ToString(), dt.Rows[i]["wt_in_percent"].ToString(), dt.Rows[i]["fine_wt"].ToString(), dt.Rows[i]["Total_Quantity"].ToString(), dt.Rows[i]["current_rate"].ToString(), dt.Rows[i]["amount"].ToString(), ""); } _objGirviAdd.updateGirviNumber(gn); MessageBox.Show("Girvi No: " + txt_Srno.Text + " Updated to " + gn); this.Close(); } }