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