private void btnSave_Click(object sender, EventArgs e) { if (toOtherFees == true) { if (Convert.ToDouble(txtAmountGiven.Text) < Convert.ToDouble(lblAmount_Due.Text)) { MessageBox.Show("Please check the payment", "GOC_INFO_SYS", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { Billing_Other_Fees fee = new Billing_Other_Fees(); fee.GocNumber = GOCNo; fee.OrNo = txtORNo.Text; fee.GLevel = GLEVEL; fee.Uniform = txtUniform.Text; fee.Books = txtBooks.Text; fee.Locker = txtLocker.Text; fee.Save(); } } else//for Enrollment Fees { } }
}//End of Load public List <Billing_Other_Fees> GetById() { 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_other_fees WHERE gocNumber =@gocNumber;"; MySqlCommand cmd = new MySqlCommand(sql, con); cmd.Parameters.AddWithValue("gocNumber", gocNumber); MySqlDataReader reader = cmd.ExecuteReader(); //loop while have record while (reader.Read()) { //instantiate model Billing_Other_Fees other = new Billing_Other_Fees(); //prepare properties other.gocNumber = reader["gocNumber"].ToString(); other.orNo = reader["orno"].ToString(); other.gLevel = reader["grade_level"].ToString(); other.uniform = reader["uniform"].ToString(); other.books = reader["books"].ToString(); other.locker = reader["locker"].ToString(); otherFees.Add(other); } } } catch (MySqlException ex) { MessageBox.Show("ERROR : " + ex.ToString(), "GOCINFOSYS", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(otherFees); }