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