private void pictureBox2_Click(object sender, EventArgs e) { if (dgStudent.CurrentRow.Index != -1) { using (hcDataContext db = new hcDataContext()) { var id = db.students.FirstOrDefault(x => x.Id.Equals(dgStudent.CurrentRow.Cells["NatID"].Value)); db.students.DeleteOnSubmit(id); db.SubmitChanges(); populate(); } } }
private void btnSignup_Click(object sender, EventArgs e) { user userModel = new user() { username = txtUsername.Text.Trim(), password = txtPassword.Text.Trim() }; if (txtPassword.Text == txtConfirmPassword.Text) { using (hcDataContext db = new hcDataContext()) { db.users.InsertOnSubmit(userModel); db.SubmitChanges(); Alert("Successfully registered", Forms.Alert.enmType.Success); login.Show(); Hide(); } } }
private void changeProfilePictureToolStripMenuItem_Click(object sender, EventArgs e) { if (openFileDialog1.ShowDialog() == DialogResult.OK) { byte[] img = File.ReadAllBytes(openFileDialog1.FileName); using (hcDataContext db = new hcDataContext()) { var userModel = db.users.Where(x => x.username == Properties.Settings.Default.currentuser).FirstOrDefault(); if (userModel != null) { userModel.profile_image = img; } db.SubmitChanges(); Byte[] data = new Byte[0]; data = (Byte[])(userModel.profile_image.ToArray()); MemoryStream mem = new MemoryStream(data); bunifuImageButton1.Image = Image.FromStream(mem); } } }
private void btnSave_Click(object sender, EventArgs e) { using (hcDataContext db = new hcDataContext()) { var studentModel = db.students.FirstOrDefault(x => x.Id == lblNatioanlId.Text.Trim()); studentModel.name = tbName.Text; studentModel.gender = ddGender.Text; studentModel.dob = DateTime.ParseExact(tbDOB.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); studentModel.nat = tbNational.Text; studentModel.nos = tbBroNum.Text; studentModel.orderrr = tbRank.Text; studentModel.address = tbCity.Text; //DAD studentModel.djob = tbDjob.Text; studentModel.dedu = tbDedu.Text; studentModel.daddress = tbDcity.Text; studentModel.dtelephone = tbDtel.Text; studentModel.dmobile = tbDmob.Text; //MOM studentModel.mjob = tbMjob.Text; studentModel.medu = tbMedu.Text; studentModel.maddress = tbMcity.Text; studentModel.mmobile = tbMmob.Text; studentModel.mname = tbMname.Text; //OTHER studentModel.withdad = cbDad.Checked == true ? true : false; studentModel.withmom = cbMum.Checked == true ? true : false; studentModel.withother = cbOther.Checked == true ? true : false; studentModel.whocare = tbWhocare.Text; studentModel.problem = tbProblem.Text; db.SubmitChanges(); } }
private void btnAdd_Click(object sender, EventArgs e) { student studentModel = new student(); try { studentModel.Id = txtNationalId.Text.Trim(); studentModel.name = txtName.Text.Trim(); studentModel.gender = cbGender.selectedValue.Trim(); studentModel.nat = txtNational.Text.Trim(); //studentModel.dob = DateTime.ParseExact(txtDOB.Text.Trim(), "d/M/yyyy", CultureInfo.InvariantCulture).Date; if (validDOB(txtDOB.Text.Trim()) != null) { studentModel.dob = validDOB(txtDOB.Text.Trim()).Value.Date; } studentModel.date = DateTime.Now.Date; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } //Validate StudentValidator validator = new StudentValidator(); var result = validator.Validate(studentModel); if (result.IsValid == false) { //foreach (ValidationFailure failure in result.Errors) //{ // //com.Alert($"{failure.ErrorMessage}", Alert.enmType.Error); // MessageBox.Show($"{failure.ErrorMessage}"); //} MessageBox.Show($"{result.Errors[0].ErrorMessage}", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); this.DialogResult = DialogResult.None; return; } //Insert using (hcDataContext db = new hcDataContext()) { try { db.students.InsertOnSubmit(studentModel); db.SubmitChanges(); } catch (DbEntityValidationException ex) { foreach (var errors in ex.EntityValidationErrors) { foreach (var validationError in errors.ValidationErrors) { // get the error message string errorMessage = validationError.ErrorMessage; MessageBox.Show(errorMessage); } } } } }