Ejemplo n.º 1
0
        private void dgvAssessDetail_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                if (dgvAssessDetail.SelectedRows.Count == 0)
                {
                    throw new Exception("No data is selected");
                }

                DialogResult dlg = MessageBox.Show("Are you sure to delete this fee?", "Delete Fee", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
                if (dlg == DialogResult.Yes)
                {
                    if (lblStatus.Text.Equals("ENROLLED"))
                    {
                        dlg = MessageBox.Show("Student is officially enrolled, delete may cause inconsistency of record associations to payment. Are you sure?", "Delete Fee", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
                        if (dlg == DialogResult.No)
                        {
                            return;
                        }
                    }
                    Cursor.Current = Cursors.WaitCursor;
                    string code  = dgvAssessDetail.SelectedRows[0].Cells["CODE"].Value.ToString();
                    long   idass = Convert.ToInt64(lblRegId.Tag);

                    AssessmentDetail assdetail     = new AssessmentDetail();
                    bool             deletesuccess = assdetail.DeleteAssessmentDetail(idass, code);
                    dgvAssessDetail.DataSource = assdetail.GetAssessmentDetail(idass);
                    RefreshDetails();

                    Cursor.Current = Cursors.Default;
                    if (deletesuccess)
                    {
                        MessageBox.Show("Delete successful");
                    }
                }
            }
            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)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 2
0
        private void dgvFees_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            try
            {
                if (dgvFees.SelectedRows.Count == 0 || string.IsNullOrEmpty(lblRegId.Text))
                {
                    throw new Exception("No data is selected");
                }

                string code  = dgvFees.SelectedRows[0].Cells["CODE"].Value.ToString();
                string name  = dgvFees.SelectedRows[0].Cells["FEE"].Value.ToString();
                long   idass = Convert.ToInt64(lblRegId.Tag);

                double amount = Convert.ToDouble(Microsoft.VisualBasic.Interaction.InputBox("Enter amount for " + name, "Input Amount", "0"));
                Cursor.Current = Cursors.WaitCursor;

                AssessmentDetail assdetail = new AssessmentDetail();
                bool             success   = assdetail.AddAssessmentDetail(idass, code, amount);
                if (!success)
                {
                    throw new Exception("Duplicate fee in assessment");
                }
                else
                {
                    dgvAssessDetail.DataSource = assdetail.GetAssessmentDetail(idass);
                    RefreshDetails();
                    MessageBox.Show("Add successful");
                }
                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)
            {
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Ejemplo n.º 3
0
        private void btnSubtract_Click(object sender, EventArgs e)
        {
            try
            {
                if (lblRegId.Text.Trim().Equals("") || txtDiscount.Text.Trim().Equals(""))
                {
                    throw new Exception("Nothing to update");
                }

                double discount = 0;
                if (!Double.TryParse(txtDiscount.Text.Trim(), out discount))
                {
                    throw new Exception("Invalid discount or subsidy value.");
                }

                int discounttype = 0;
                if (rbSubsidy.Checked)
                {
                    discounttype = 1;
                }

                long   id      = new Assessment().GetAssessment(Convert.ToInt64(lblRegId.Text.Trim())).Id;
                double tuition = 0;
                bool   tbool   = Double.TryParse(lblTuition.Text.Trim(), out tuition);
                if (!tbool || tuition == 0)
                {
                    throw new Exception("Invalid tuition amount");
                }

                bool success = new AssessmentDetail().UpdateTuition(id, tuition - discount, discount, discounttype);
                if (success)
                {
                    Assessment asses = new Assessment().GetAssessment(Convert.ToInt64(lblRegId.Text.Trim()));
                    dgvAssessDetail.DataSource         = asses.AssessmentDetail;
                    dgvAssessDetail.Columns[0].Width   = 75;
                    dgvAssessDetail.Columns[1].Width   = 300;
                    dgvAssessDetail.Columns[2].Width   = 75;
                    dgvAssessDetail.Columns[3].Visible = false; //feetype
                    dgvAssessDetail.Columns[2].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
                    dgvAssessDetail.Columns[2].DefaultCellStyle.Format    = string.Format("N2");

                    RefreshDetails();

                    MessageBox.Show("Assessment update successful!");
                }
                else
                {
                    throw new Exception("Updating this assessment failed, server might be offline or nothing to update.");
                }
            }
            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)
            {
                txtDiscount.Text = string.Empty;
                MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }