private void populate()
{
dgStudent.AutoGenerateColumns = false;
using (hcDataContext db = new hcDataContext())
{
dgStudent.DataSource = db.students;
bunifuCircleProgress1.Visible = false;
}
}
private void loadProfileImage()
{
using (hcDataContext db = new hcDataContext())
{
var result = db.users.Where(x => x.username == Properties.Settings.Default.currentuser).Select(x => x.profile_image).FirstOrDefault();
if (result != null)
{
bunifuImageButton1.Image = com.byteToImage(result.ToArray());
}
}
}
private void dgStudent_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (dgStudent.CurrentRow.Index > -1)
{
using (hcDataContext db = new hcDataContext())
{
student result = db.students.FirstOrDefault(x => x.Id.Equals(dgStudent.CurrentRow.Cells["NatID"].Value));
mainForm.removeForm();
Form form = new StudentMain(result, mainForm);
form.Dock = DockStyle.Fill;
mainForm.showForm(form);
}
}
}
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 btnSignin_Click(object sender, EventArgs e)
{
try
{
//string sql = "SELECT COUNT(*) FROM users WHERE username=@username AND password=@password";
//using (SqlCeConnection conn = new SqlCeConnection(com.getConnectionString()))
//{
// using (SqlCeCommand cmd = new SqlCeCommand(sql, conn))
// {
// cmd.Parameters.AddWithValue("@username", txtUsername.Text);
// cmd.Parameters.AddWithValue("@password", txtPassword.Text);
// conn.Open();
// var reader = cmd.ExecuteScalar().ToString();
// if (reader == "1")
// {
// Main main = new Main();
// main.Show();
// this.Hide();
// }
// else
// {
// MessageBox.Show(Properties.strings.login_msg_invlidUaernamePassword);
// }
// }
using (hcDataContext db = new hcDataContext())
{
var count = db.users.Where(x => x.username == txtUsername.Text.Trim() && x.password == txtPassword.Text.Trim()).Count();
if (count > 0)
{
Properties.Settings.Default.currentuser = txtUsername.Text.Trim();
Properties.Settings.Default.Save();
MainForm main = new MainForm();
main.Show();
this.Hide();
}
else if (count == 0)
{
userModel = db.users.Where(x => x.username == txtUsername.Text.Trim()).FirstOrDefault();
if (userModel == null)
{
//MessageBox.Show("user not found");
com.Alert("User Not Found", Alert.enmType.Error);
}
else
{
if (userModel.password != txtPassword.Text.Trim())
{
//MessageBox.Show("wrong password");
com.Alert("Wrong Password", Alert.enmType.Error);
}
}
}
}
}
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);
}
}
}
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message, "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
}
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);
}
}
}
}
}
