private void btnUpdate_Click(object sender, EventArgs e) { try { if (!verifyAndReworkVoucherDetailGridRows()) { MessageBox.Show("Validation Failed for Purhcase journal Detail"); return; } if (JVdocID == "PJV") { PJVHeader pjvh = new PJVHeader(); pjvh.TemporaryNo = Convert.ToInt32(txtTemporarryNo.Text); pjvh.TemporaryDate = dtTempDate.Value; pjvh.DocumentID = JVdocID; List <PJVDetail> PJVList = getVoucherDetails(pjvh); if (Convert.ToDecimal(txtTotalCreditAmnt.Text) != Convert.ToDecimal(txtTotalDebitAmnt.Text)) { MessageBox.Show("Debit and Credit total should be equal."); return; } if (InvAmount != Convert.ToDouble(txtTotalCreditAmnt.Text)) { MessageBox.Show("Journal amount should be equal to invoice amount."); return; } if (PJVDB.UpdatePJVHeaderDetailDuringApproveInvoiceIN(PJVList, pjvh)) { MessageBox.Show("Purchase journal updated."); } } else if (JVdocID == "SJV") { SJVHeader sjvh = new SJVHeader(); sjvh.TemporaryNo = Convert.ToInt32(txtTemporarryNo.Text); sjvh.TemporaryDate = dtTempDate.Value; sjvh.DocumentID = JVdocID; List <SJVDetail> SJVList = getSalesVoucherDetails(sjvh); if (Convert.ToDecimal(txtTotalCreditAmnt.Text) != Convert.ToDecimal(txtTotalDebitAmnt.Text)) { MessageBox.Show("Debit and Credit total should be equal."); return; } if (InvAmount != Convert.ToDouble(txtTotalCreditAmnt.Text)) { MessageBox.Show("Journal amount should be equal to invoice amount."); return; } if (SJVDB.UpdateSJVHeaderDetailDuringApproveInvoiceIN(SJVList, sjvh)) { MessageBox.Show("Sales journal updated."); } } } catch (Exception ex) { MessageBox.Show("Failed to update"); } }
private void ShowAllDetails() { try { if (JVdocID == "PJV") { invoiceinheader iih = new invoiceinheader(); iih.DocumentID = InvDociD; iih.TemporaryNo = InvTemporaryNo; iih.TemporaryDate = InvTemporaryDate; PJVHeader pjvh = PJVDB.getPJVHeaderPerInvoiceIN(iih); if (pjvh.TemporaryNo == 0) { MessageBox.Show("PJV Not prepared"); return; } txtTemporarryNo.Text = pjvh.TemporaryNo.ToString(); dtTempDate.Value = pjvh.TemporaryDate; txtJournalNo.Text = pjvh.JournalNo.ToString(); dtJournalDate.Value = pjvh.JournalDate; txtINVTempNo.Text = pjvh.InvTempNo.ToString(); dtINVTempDate.Value = pjvh.InvTempDate; txtnarration.Text = pjvh.Narration.ToString(); List <PJVDetail> PJVDetail = PJVDB.getPJVDetail(pjvh); grdPRDetail.Rows.Clear(); int i = 0; decimal totCredit = 0; decimal totDebit = 0; foreach (PJVDetail vd in PJVDetail) { AddPRDetailRow(); grdPRDetail.Rows[i].Cells["AccountCode"].Value = vd.AccountCode; grdPRDetail.Rows[i].Cells["AccountName"].Value = vd.AccountName; grdPRDetail.Rows[i].Cells["AmountDebit"].Value = vd.AmountDebit; totDebit = totDebit + vd.AmountDebit; grdPRDetail.Rows[i].Cells["AmountCredit"].Value = vd.AmountCredit; totCredit = totCredit + vd.AmountCredit; grdPRDetail.Rows[i].Cells["PartyCode"].Value = vd.SLCode; grdPRDetail.Rows[i].Cells["PartyName"].Value = vd.SLName; grdPRDetail.Rows[i].Cells["gSLType"].Value = vd.SLType; i++; } txtTotalCreditAmnt.Text = totCredit.ToString(); txtTotalDebitAmnt.Text = totDebit.ToString(); txtAmountInWords.Text = NumberToString.convert(txtTotalDebitAmnt.Text); } else if (JVdocID == "SJV") { invoiceoutheader ioh = new invoiceoutheader(); ioh.DocumentID = InvDociD; ioh.TemporaryNo = InvTemporaryNo; ioh.TemporaryDate = InvTemporaryDate; SJVHeader sjvh = SJVDB.getSJVHeaderPerInvoiceOut(ioh); if (sjvh.TemporaryNo == 0) { MessageBox.Show("SJV Not prepared"); return; } txtTemporarryNo.Text = sjvh.TemporaryNo.ToString(); dtTempDate.Value = sjvh.TemporaryDate; txtJournalNo.Text = sjvh.JournalNo.ToString(); dtJournalDate.Value = sjvh.JournalDate; txtINVTempNo.Text = sjvh.InvTempNo.ToString(); dtINVTempDate.Value = sjvh.InvTempDate; txtnarration.Text = sjvh.Narration.ToString(); List <SJVDetail> SJVdetail = SJVDB.getSJVDetail(sjvh); grdPRDetail.Rows.Clear(); int i = 0; decimal totCredit = 0; decimal totDebit = 0; foreach (SJVDetail vd in SJVdetail) { AddPRDetailRow(); grdPRDetail.Rows[i].Cells["AccountCode"].Value = vd.AccountCode; grdPRDetail.Rows[i].Cells["AccountName"].Value = vd.AccountName; grdPRDetail.Rows[i].Cells["AmountDebit"].Value = vd.AmountDebit; totDebit = totDebit + vd.AmountDebit; grdPRDetail.Rows[i].Cells["AmountCredit"].Value = vd.AmountCredit; totCredit = totCredit + vd.AmountCredit; grdPRDetail.Rows[i].Cells["PartyCode"].Value = vd.SLCode; grdPRDetail.Rows[i].Cells["PartyName"].Value = vd.SLName; grdPRDetail.Rows[i].Cells["gSLType"].Value = vd.SLType; i++; } txtTotalCreditAmnt.Text = totCredit.ToString(); txtTotalDebitAmnt.Text = totDebit.ToString(); txtAmountInWords.Text = NumberToString.convert(txtTotalDebitAmnt.Text); } } catch (Exception ex) { MessageBox.Show("Error in showing details"); } }