public static List <Benificiaries> GetUsers(string _cocno) { List <Benificiaries> users = new List <Benificiaries>(); String cmdText; MySqlDataReader reader = null; MySqlConnection con = null; con = DBConnection.GetDBConnection(); //get data from db and load... //To query data from the database using MySqlDataReader cmdText = "SELECT id,cid,firstname,middlename,lastname, relationship, address,DATE_FORMAT(birthdate,'%m-%d-%Y'),gender,phone, mobile FROM tblbenificiaries WHERE cid=@cocno"; MySqlCommand cmd = new MySqlCommand(cmdText, con); cmd.Parameters.AddWithValue("@cocno", _cocno); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Benificiaries s = new Benificiaries(reader.GetInt16(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetString(8), reader.GetString(9), reader.GetString(10)); //Console.WriteLine(reader.GetString(0) + "|" + reader.GetString(1) + "|" + reader.GetString(2)); users.Add(s); } } reader.Close(); return(users); }
private void btnB_Save_Click(object sender, EventArgs e) { var v = cbB_Month.SelectedItem as Level; int _month = v.Number; string birthdate2 = _month + "/" + cbB_Day.Text + "/" + cbB_Year.Text; if (option == 1) { DialogResult rs = MessageBox.Show("Do You Want To Add This Information?", "Confirmation", MessageBoxButtons.YesNo); if (rs == DialogResult.Yes) { Benificiaries ben = new Benificiaries(0, txtB_CID.Text, txtB_Firstname.Text, txtB_Middlename.Text, txtB_Lastname.Text, cbB_Relationship.Text, txtB_Address.Text, birthdate2, cbB_Gender.Text, txtB_Phone.Text, txtB_Mobile.Text); ben.AddNewB(); // MessageBox.Show(_birthdate, "Confirmation", MessageBoxButtons.YesNo); } } else { DialogResult rs = MessageBox.Show("Do You Want To Edit This Information?", "Confirmation", MessageBoxButtons.YesNo); if (rs == DialogResult.Yes) { Benificiaries ben = new Benificiaries(id, txtB_CID.Text, txtB_Firstname.Text, txtB_Middlename.Text, txtB_Lastname.Text, cbB_Relationship.Text, txtB_Address.Text, birthdate2, cbB_Gender.Text, txtB_Phone.Text, txtB_Mobile.Text); ben.EditB(); //MessageBox.Show(_birthdate, "df", MessageBoxButtons.YesNo); //fClient f1 = new fClient(); //this.Dispose(); //f1.ShowDialog(); } } }
private void btnB_Delete_Click(object sender, EventArgs e) { Benificiaries b = new Benificiaries(id); DialogResult rs = MessageBox.Show("Do You Want To Delete This Information?", "Confirmation", MessageBoxButtons.YesNo); if (rs == DialogResult.Yes) { b.DeleteB(); } }
public static Benificiaries GetUser(int personId) { Benificiaries p = null; string cmdText; MySqlConnection con = null; con = DBConnection.GetDBConnection(); cmdText = "SELECT * FROM tblbenificiaries"; cmdText += "WHERE id=" + personId; MySqlCommand cmd = new MySqlCommand(cmdText, con); MySqlDataReader reader = null; try { reader = cmd.ExecuteReader(); if (reader.HasRows) { reader.Read(); //call sproc and load from database... p = new Benificiaries(reader.GetInt16(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetString(8), reader.GetString(9), reader.GetString(10)); } reader.Close(); } catch (Exception err) { Console.WriteLine("Error: " + err.ToString()); } finally { con.Close(); } return(p); }
private void loadTable() { List <Benificiaries> ss = Benificiaries.GetUsers(cocno); int row = 0; dgv_Benificiaries.RowCount = 1; try { foreach (DataGridViewRow row1 in dgv_Benificiaries.Rows) { if (!row1.IsNewRow) { dgv_Benificiaries.Rows.Remove(row1); } } foreach (Benificiaries s in ss) { dgv_Benificiaries.Rows.Add(); dgv_Benificiaries[0, row].Value = s.Id; dgv_Benificiaries[1, row].Value = s.CID; dgv_Benificiaries[2, row].Value = s.Firstname; dgv_Benificiaries[3, row].Value = s.Middlename; dgv_Benificiaries[4, row].Value = s.Lastname; dgv_Benificiaries[5, row].Value = s.Relationship; dgv_Benificiaries[6, row].Value = s.Address; dgv_Benificiaries[7, row].Value = s.BirthDate; dgv_Benificiaries[8, row].Value = s.Gender; dgv_Benificiaries[9, row].Value = s.Phone; dgv_Benificiaries[10, row++].Value = s.Mobile; //id = s.Id; } } catch { } }