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 { }
}
