private void tsbSave_Click(object sender, EventArgs e)
        {
            Cursor.Current = Cursors.WaitCursor;
            try
            {
                if (txtPurpose.Text.Equals(""))
                {
                    throw new Exception("Please indicate purpose of disbursement");
                }
                double total = 0;
                List <PaymentDetail> disburseDetail = new List <PaymentDetail>();
                foreach (DataGridViewRow row in dgvSource.Rows)
                {
                    string rowvalue = (string)row.Cells["colDisburse"].Value;
                    if (!string.IsNullOrWhiteSpace(rowvalue))
                    {
                        double val    = 0;
                        bool   isGood = Double.TryParse(row.Cells["colDisburse"].Value.ToString(), out val);
                        if (isGood)
                        {
                            total += val;
                            PaymentDetail pd = new PaymentDetail();
                            pd.Code   = row.Cells["CODE"].Value.ToString();
                            pd.Amount = val;
                            disburseDetail.Add(pd);
                        }
                        else
                        {
                            throw new Exception("Please check entered amount.");
                        }
                    }
                }

                if (total == 0 || disburseDetail.Count == 0)
                {
                    throw new Exception("Please allocate some amount for disbursement");
                }

                if (new Disbursement().SaveDisbursement(txtPurpose.Text.Trim(), total, disburseDetail))
                {
                    MessageBox.Show("Disbursement saved.");
                    tsbClear.PerformClick();
                }
                else
                {
                    throw new Exception("Error occurs in disbursement");
                }
            }
            catch (MySqlException ex)
            {
                if (ex.Number == 1042)
                {
                    MessageBox.Show("Database server is offline. Contact administrator.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    MessageBox.Show(ex.Number + ": " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            catch (Exception ex)
            {
                Cursor.Current = Cursors.Default;
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            Cursor.Current = Cursors.Default;
        }
Exemple #2
0
        public MonthlyDetailReport(ReportViewer rv, string report, DateTime dateTime, int paytype, MonthlyReportType monthlyReportType) : base(rv, report)
        {
            List <LedgerItem> ledgerItems = new List <LedgerItem>();
            DataTable         fees;

            if (paytype == 1)
            {
                fees = new Fee().GetAllStandardFees();
            }
            else if (paytype == 2)
            {
                fees = new MonthlyDetail().GetAllNonStandardFees();
            }
            else
            {
                fees = new MonthlyDetail().GetAllOtherFees();
            }

            DataTable payments   = new MonthlyDetail().GetAllPaymentsInMonth(dateTime, paytype, monthlyReportType);
            DataTable payDetails = new DataTable();

            List <LedgerItem> ledger = new List <LedgerItem>();

            foreach (DataRow prow in payments.Rows)
            {
                long id = Convert.ToInt64(prow["ID"]);
                payDetails = new MonthlyDetail().GetPaymentDetailById(id);
                List <PaymentDetail> paylist = new List <PaymentDetail>();
                foreach (DataRow plist in payDetails.Rows)
                {
                    PaymentDetail pd = new PaymentDetail();
                    pd.Code   = plist["CODE"].ToString();
                    pd.Amount = Convert.ToDouble(plist["AMOUNT"]);
                    paylist.Add(pd);
                }

                //check if item is present in pay type, this is good for fees that have categories transfered
                foreach (PaymentDetail pitem in paylist)
                {
                    bool present = false;
                    foreach (DataRow row in fees.Rows)
                    {
                        if (row["CODE"].ToString().Equals(pitem.Code))
                        {
                            present = true;
                            break;
                        }
                    }

                    if (!present)
                    {
                        DataRow   dr = fees.NewRow();
                        DataTable dt = new DataTable();
                        dt = new Fee().GetFeeByCode(pitem.Code);
                        foreach (DataRow drow in dt.Rows)
                        {
                            dr[0] = drow["feecode"].ToString();
                            dr[1] = drow["feename"].ToString();
                            dr[2] = drow["shortname"].ToString();
                            dr[3] = Convert.ToInt16(drow["feetype"]);
                        }

                        fees.Rows.Add(dr);
                    }
                }

                foreach (DataRow row in fees.Rows)
                {
                    LedgerItem ledgerItem = new LedgerItem();
                    ledgerItem.FeeCode     = row["CODE"].ToString();
                    ledgerItem.FeeName     = row["SHORT NAME"].ToString();
                    ledgerItem.OrNumber    = prow["OR"].ToString();
                    ledgerItem.PaymentDate = Convert.ToDateTime(prow["DATE"]);
                    //ledgerItem.AssessmentAmount = Convert.ToDouble(row["AMOUNT"]);
                    //ledgerItem.AssessmentTotal = Assess.Total;

                    foreach (PaymentDetail det in paylist)
                    {
                        if (ledgerItem.FeeCode.Equals(det.Code))
                        {
                            ledgerItem.PaidAmount = det.Amount;
                            break;
                        }
                        else
                        {
                            ledgerItem.PaidAmount = 0;
                        }
                    }

                    ledger.Add(ledgerItem);
                }
            }

            MonthlyReportTitle title;

            if (monthlyReportType == MonthlyReportType.HSStandard)
            {
                title = new MonthlyReportTitle("STANDARD SCHOOL FEES: JHS, Elem, Pre-school");
            }
            else if (monthlyReportType == MonthlyReportType.HSNonStandard)
            {
                title = new MonthlyReportTitle("NON-STANDARD SCHOOL FEES: JHS, Elem, Pre-school");
            }
            else if (monthlyReportType == MonthlyReportType.SHSStandard)
            {
                title = new MonthlyReportTitle("STANDARD SCHOOL FEES: Senior High School");
            }
            else if (monthlyReportType == MonthlyReportType.SHSNonStandard)
            {
                title = new MonthlyReportTitle("NON-STANDARD SCHOOL FEES: Senior High School");
            }
            else if (monthlyReportType == MonthlyReportType.AllStandard)
            {
                title = new MonthlyReportTitle("STANDARD SCHOOL FEES: All Department");
            }
            else if (monthlyReportType == MonthlyReportType.AllNonStandard)
            {
                title = new MonthlyReportTitle("NON-STANDARD SCHOOL FEES: All Department");
            }
            else if (monthlyReportType == MonthlyReportType.HSOtherType)
            {
                title = new MonthlyReportTitle("OTHER SCHOOL FEES: JHS, Elem, Pre-school");
            }
            else if (monthlyReportType == MonthlyReportType.SHSOtherType)
            {
                title = new MonthlyReportTitle("OTHER SCHOOL FEES: Senior High School");
            }
            else
            {
                title = new MonthlyReportTitle("OTHER SCHOOL FEES: All Department");
            }

            List <MonthlyReportTitle> titles = new List <MonthlyReportTitle>();

            titles.Add(title);

            ReportDataSource dsReport = new ReportDataSource();

            dsReport.Name  = "dsPayment";
            dsReport.Value = ledger;
            RViewer.LocalReport.DataSources.Add(dsReport);

            ReportDataSource dsTitle = new ReportDataSource();

            dsTitle.Name  = "dsTitle";
            dsTitle.Value = titles;
            RViewer.LocalReport.DataSources.Add(dsTitle);
        }
Exemple #3
0
        private void tsbSave_Click(object sender, EventArgs e)
        {
            try
            {
                Cursor.Current = Cursors.WaitCursor;
                if (txtOR.Text.Trim().Equals("") || txtCash.Text.Trim().Equals("") || !Double.TryParse(txtCash.Text.Trim(), out double res))
                {
                    throw new Exception("Please fill important fields.");
                }

                List <PaymentDetail> paymentItems = new List <PaymentDetail>();

                foreach (DataGridViewRow row in dgvBalance.Rows)
                {
                    string value = (string)row.Cells["txtPayment"].Value;
                    if (!string.IsNullOrWhiteSpace(value))
                    {
                        if (!Double.TryParse(value, out double val))
                        {
                            dgvBalance.CurrentCell = row.Cells["txtPayment"];
                            dgvBalance.BeginEdit(true);
                            throw new Exception("Invalid amount.");
                        }

                        if (Convert.ToDouble(row.Cells["txtPayment"].Value) > Convert.ToDouble(row.Cells["BALANCE"].Value))
                        {
                            dgvBalance.CurrentCell = row.Cells["txtPayment"];
                            dgvBalance.BeginEdit(true);
                            throw new Exception("Amount entered is higher than the balance.");
                        }

                        if (Convert.ToDouble(row.Cells["txtPayment"].Value) > 0)
                        {
                            PaymentDetail feeObj = new PaymentDetail();
                            feeObj.Code   = row.Cells["CODE"].Value.ToString();
                            feeObj.Amount = Convert.ToDouble(row.Cells["txtPayment"].Value);
                            paymentItems.Add(feeObj);
                        }
                    }
                }

                double paymentTotal = 0;
                if (paymentItems.Count > 0 && Double.TryParse(lblTotal.Text.Trim(), out paymentTotal) && paymentTotal > 0)
                {
                    int paymenttype = 0;
                    if (cmbPaymentType.SelectedIndex == 0)
                    {
                        paymenttype = 1;
                    }
                    else if (cmbPaymentType.SelectedIndex == 1)
                    {
                        paymenttype = 2;
                    }
                    else if (cmbPaymentType.SelectedIndex == 2)
                    {
                        paymenttype = 3;
                    }
                    else if (cmbPaymentType.SelectedIndex == 3)
                    {
                        paymenttype = 4;
                    }

                    Payment payment = new Payment(id_assessment, txtOR.Text.Trim(), Convert.ToDouble(lblTotal.Text.Trim()), (MdiParent as frmMDI).LoginUser.Username, paymenttype);
                    payment.PaymentDetail = paymentItems;
                    if (payment.SavePayment())
                    {
                        DialogResult dlg = MessageBox.Show("Payment save successful.\nPlease insert Official Receipt(OR) for printing", "Payment", MessageBoxButtons.OK, MessageBoxIcon.Question);
                        if (dlg == DialogResult.OK)
                        {
                            frmReport frReport;
                            if (cmbPaymentType.SelectedIndex == 0)
                            {
                                frReport = new frmReport(ReportTypes.OR);
                            }
                            else if (cmbPaymentType.SelectedIndex == 1 || cmbPaymentType.SelectedIndex == 3)
                            {
                                frReport = new frmReport(ReportTypes.OFOR);
                            }
                            else
                            {
                                frReport = new frmReport(ReportTypes.PTAOR);
                            }

                            frReport.Payer     = Payer;
                            frReport.ORNumber  = txtOR.Text.Trim();
                            frReport.MdiParent = MdiParent;
                            frReport.Show();
                        }
                        tsbClear.PerformClick();
                    }
                    else
                    {
                        throw new Exception("Error in saving this payment.");
                    }
                }

                Cursor.Current = Cursors.Default;
            }
            catch (MySqlException ex)
            {
                if (ex.Number == 1042)
                {
                    MessageBox.Show("Database server is offline. Contact administrator.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
                else
                {
                    MessageBox.Show(ex.Number + ": " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            catch (Exception ex)
            {
                Cursor.Current = Cursors.Default;
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Exemple #4
0
        public LedgerReport(ReportViewer rv, string report, Student student) : base(rv, report)
        {
            Registration Reg    = new Registration().GetRegistration(student.Id);
            Assessment   Assess = new Assessment().GetAssessment(Reg.Id);

            DataTable payments  = new Ledger().GetAllPaymentPerAccount(Assess.Id);
            DataTable payDetail = new DataTable();

            List <LedgerItem> ledger = new List <LedgerItem>();

            foreach (DataRow prow in payments.Rows)
            {
                long id = Convert.ToInt64(prow["ID"]);
                payDetail = new Ledger().GetPaymentDetailById(id);
                List <PaymentDetail> paylist = new List <PaymentDetail>();
                foreach (DataRow plist in payDetail.Rows)
                {
                    PaymentDetail pd = new PaymentDetail();
                    pd.Code   = plist["CODE"].ToString();
                    pd.Amount = Convert.ToDouble(plist["AMOUNT"]);
                    paylist.Add(pd);
                }

                foreach (DataRow row in Assess.AssessmentDetail.Rows)
                {
                    LedgerItem ledgerItem = new LedgerItem();
                    ledgerItem.FeeCode          = row["CODE"].ToString();
                    ledgerItem.FeeName          = row["FEE"].ToString();
                    ledgerItem.OrNumber         = prow["OR"].ToString();
                    ledgerItem.PaymentDate      = Convert.ToDateTime(prow["PAYMENT DATE"]);
                    ledgerItem.AssessmentAmount = Convert.ToDouble(row["AMOUNT"]);
                    ledgerItem.AssessmentTotal  = Assess.Total;

                    foreach (PaymentDetail det in paylist)
                    {
                        if (ledgerItem.FeeCode.Equals(det.Code))
                        {
                            ledgerItem.PaidAmount = det.Amount;
                            break;
                        }
                        else
                        {
                            ledgerItem.PaidAmount = 0;
                        }
                    }
                    ledger.Add(ledgerItem);
                }
            }


            List <PaymentDetail> assList = new List <PaymentDetail>();

            foreach (DataRow row in Assess.AssessmentDetail.Rows)
            {
                PaymentDetail pd = new PaymentDetail();
                pd.Code   = row["CODE"].ToString();
                pd.Name   = row["FEE"].ToString();
                pd.Amount = Convert.ToDouble(row["AMOUNT"]);
                assList.Add(pd);
            }

            List <Student> studList = new List <Student>();

            studList.Add(student);
            ReportDataSource dsStud = new ReportDataSource();

            dsStud.Name  = "dsStudent";
            dsStud.Value = studList;
            RViewer.LocalReport.DataSources.Add(dsStud);

            ReportDataSource dsLedger = new ReportDataSource();

            dsLedger.Name  = "dsPayment";
            dsLedger.Value = ledger;
            RViewer.LocalReport.DataSources.Add(dsLedger);
        }