Beispiel #1
0
        }//End of Load

        public List <Billing_Partial> GetPaymentPartial()
        {
            try
            {
                //prepare connection string
                using (MySqlConnection con = new MySqlConnection(GOCSystem2018.Config.GetConnectionString()))
                {
                    //try to open connection
                    con.Open();

                    //prepare sql query
                    string sql = "SELECT * FROM billing_partial WHERE regNo=@regNo;";

                    MySqlCommand cmd = new MySqlCommand(sql, con);
                    cmd.Parameters.AddWithValue("regNo", regNo);

                    MySqlDataReader reader = cmd.ExecuteReader();

                    //loop while have record
                    while (reader.Read())
                    {
                        //instantiate model
                        Billing_Partial bill = new Billing_Partial();
                        //prepare properties
                        bill.enStatus = reader["Enrollment_status"].ToString();
                        billingPartials.Add(bill);
                    }
                }
            }
            catch (MySqlException ex)
            {
                MessageBox.Show("ERROR : " + ex.ToString(), "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            return(billingPartials);
        }
Beispiel #2
0
        public List <Billing_Partial> GetMonthlyDue()
        {
            try
            {
                //prepare connection string
                using (MySqlConnection con = new MySqlConnection(GOCSystem2018.Config.GetConnectionString()))
                {
                    //try to open connection
                    con.Open();

                    //prepare sql query
                    string sql = "SELECT * FROM billing_partial WHERE RegNo =@regNo;";

                    MySqlCommand cmd = new MySqlCommand(sql, con);
                    cmd.Parameters.AddWithValue("regNo", regNo);

                    MySqlDataReader reader = cmd.ExecuteReader();

                    //loop while have record
                    while (reader.Read())
                    {
                        //instantiate model
                        Billing_Partial billingPartial = new Billing_Partial();

                        //prepare properties

                        //billingPartial.id = Convert.ToInt32(reader["id"].ToString());
                        billingPartial.enStatus = reader["enrollment_status"].ToString();
                        //billingPartial.oRNo = reader["or_no"].ToString();
                        //billingPartial.idNo = reader["idno"].ToString();
                        //billingPartial.full_name = reader["full_name"].ToString();
                        billingPartial.downPayment = reader["dp"].ToString();
                        billingPartial.p1          = reader["1p"].ToString();
                        billingPartial.p2          = reader["2p"].ToString();
                        billingPartial.p3          = reader["3p"].ToString();
                        billingPartial.p4          = reader["4p"].ToString();
                        billingPartial.p5          = reader["5p"].ToString();
                        billingPartial.p6          = reader["6p"].ToString();
                        billingPartial.p7          = reader["7p"].ToString();
                        billingPartial.p8          = reader["8p"].ToString();
                        billingPartial.p9          = reader["9p"].ToString();
                        billingPartial.p10         = reader["10p"].ToString();
                        billingPartial.balance     = reader["balance"].ToString();

                        billingPartials.Add(billingPartial);
                    }
                }
            }
            catch (MySqlException ex)
            {
                MessageBox.Show("ERROR : " + ex.ToString(), "System Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
            return(billingPartials);
        }