private void btnsave_Click(object sender, EventArgs e)
{
Member m = new Member();
m.memid = txtid.Text;
m.fullname = txtlname.Text + ", " + txtfname.Text + " " + txtmname.Text;
m.gender = cbogender.Text;
m.birthdate = dtBday.Value;
m.contactno = txtcontactno.Text;
m.address = txtaddress.Text;
m.occupation = txtoccupation.Text;
m.status = "ACTIVE"; //STATUS = ACTIVE, STAFF, WITHDRAWN
m.typeofmembership = cbomembershiptype.Text; // REGULAR, ASSOCIATE
m.email = txtemail.Text;
m.tinno = txttinno.Text;
if (pbEmpPic.Image != null)
{
long filesize;
MemoryStream mstream = new MemoryStream();
pbEmpPic.Image.Save(mstream, System.Drawing.Imaging.ImageFormat.Jpeg);
Byte[] arrImage = mstream.GetBuffer();
filesize = mstream.Length;
m.pic = arrImage;
}
if(m.save()){
MessageBox.Show("Successful", "Saving...", MessageBoxButtons.OK,MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
this.Parent.Height = 0;
this.Parent.Controls.Clear();
this.Dispose();
}
else{
Logger.WriteErrorLog(db.err.ToString());
MessageBox.Show("Error : " + db.err.ToString() , "Saving...", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
}
private void btnMigrate_Click(object sender, EventArgs e)
{
DataTable dt = dTable;
dtmigrated = dt.Clone();
dtmigrated.Rows.Clear();
foreach (DataRow row in dt.Rows)
{
Member m = new Member();
m.memid = row["Membership_Registry_Number"].ToString();
m.fullname = row["Name of Member"].ToString();
m.address = row["Address"].ToString();
m.email = row["Email"].ToString();
m.acceptance_date = Convert.ToDateTime(row["Acceptance_Date"].ToString());
m.contactno = row["Contact_No"].ToString();
m.occupation = row["Occupation"].ToString();
m.status = "ACTIVE"; //STATUS = ACTIVE, STAFF, WITHDRAWN
m.typeofmembership = "REGULAR"; // REGULAR, ASSOCIATE
if (m.save())
{
System.Diagnostics.Debug.WriteLine(m.memid + "-" + m.fullname + " -->Record Saved");
}
else {
System.Diagnostics.Debug.WriteLine("Error :" + db.err.Message);
}
}
bs = new BindingSource();
bs.DataSource = dtmigrated;
}