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 List <PJVDetail> getVoucherDetails(PJVHeader pjvh) { PJVDetail Pjvd = new PJVDetail(); List <PJVDetail> PJVDetails = new List <PJVDetail>(); for (int i = 0; i < grdPRDetail.Rows.Count; i++) { try { Pjvd = new PJVDetail(); Pjvd.DocumentID = pjvh.DocumentID; Pjvd.TemporaryNo = pjvh.TemporaryNo; Pjvd.TemporaryDate = pjvh.TemporaryDate; Pjvd.AccountCode = grdPRDetail.Rows[i].Cells["AccountCode"].Value.ToString(); Pjvd.SLType = grdPRDetail.Rows[i].Cells["gSLType"].Value.ToString(); Pjvd.SLCode = grdPRDetail.Rows[i].Cells["PartyCode"].Value.ToString(); Pjvd.InvDocumentID = InvDociD; Pjvd.InvTempNo = InvTemporaryNo; Pjvd.InvTempDate = InvTemporaryDate; if (grdPRDetail.Rows[i].Cells["AmountDebit"].Value != null) { Pjvd.AmountDebit = Convert.ToDecimal(grdPRDetail.Rows[i].Cells["AmountDebit"].Value.ToString().Trim()); } else { Pjvd.AmountDebit = 0; } if (grdPRDetail.Rows[i].Cells["AmountCredit"].Value != null) { Pjvd.AmountCredit = Convert.ToDecimal(grdPRDetail.Rows[i].Cells["AmountCredit"].Value.ToString().Trim()); } else { Pjvd.AmountCredit = 0; } PJVDetails.Add(Pjvd); } catch (Exception ex) { MessageBox.Show("getVoucherDetails() : Error creating Purchase Journal Details"); //status = false; } } return(PJVDetails); }
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"); } }