private void btn_Delete_Click(object sender, EventArgs e) { int id; if (string.IsNullOrWhiteSpace(tbox_DeleteID.Text) || !int.TryParse(tbox_DeleteID.Text, out id)) { MessageBox.Show("Enter valid data!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { TimetableDataContext context = new TimetableDataContext(); Student std = (from p in context.Students where p.ID == id select p).First(); context.Students.DeleteOnSubmit(std); context.SubmitChanges(); lview_Students.Items.Clear(); LoadStudents(); tbox_DeleteID.Text = ""; } catch { MessageBox.Show("Enter a valid ID!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_Accept_Click(object sender, EventArgs e) { if (!Check_Syntax()) { MessageBox.Show("Enter valid data!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } TimetableDataContext context = new TimetableDataContext(); try { Professor prof = (from p in context.Professors where p.ID == Prof_Id select p).First(); prof.Name = tbox_Name.Text; prof.Title = tbox_Title.Text; prof.Details = tbox_Details.Text; prof.Phone = tbox_Phone.Text; prof.Mail = tbox_Mail.Text; prof.Salary = int.Parse(tbox_Salary.Text); context.SubmitChanges(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_Accept_Click(object sender, EventArgs e) { if (!Check_Syntax()) { MessageBox.Show("Enter valid data!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { TimetableDataContext context = new TimetableDataContext(); int Id = 1; if (context.ClassRooms.Count() != 0) { Id = context.ClassRooms.Max(p => p.ID) + 1; } ClassRoom cls = new ClassRoom(); cls.ID = Id; cls.Name = tbox_Name.Text; cls.Description = tbox_Description.Text; context.ClassRooms.InsertOnSubmit(cls); context.SubmitChanges(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_Accept_Click(object sender, EventArgs e) { if (!Check_Syntax()) { MessageBox.Show("Enter valid data!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { TimetableDataContext context = new TimetableDataContext(); IEnumerable <Group> grup = from g in context.Groups where g.ID == int.Parse(tbox_GorupID.Text) select g; if (grup.Count() == 0) { MessageBox.Show("This group don't exist!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } int Id = 1; if (context.Students.Count() != 0) { Id = context.Students.Max(p => p.ID) + 1; } Student std = new Student(); std.ID = Id; std.Name = tbox_Name.Text; std.Group_ID = int.Parse(tbox_GorupID.Text); std.Phone = tbox_Phone.Text; std.Mail = tbox_Mail.Text; context.Students.InsertOnSubmit(std); context.SubmitChanges(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_Accept_Click(object sender, EventArgs e) { if (!Check_Syntax()) { MessageBox.Show("Enter valid data!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { TimetableDataContext context = new TimetableDataContext(); int count = (from u in context.Users where u.Username == tbox_Username.Text select u).Count(); if (count == 1) { MessageBox.Show("User already exist!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } int Id = 1; if (context.Users.Count() != 0) { Id = context.Users.Max(p => p.ID) + 1; } User usr = new User(); usr.ID = Id; usr.Username = tbox_Username.Text; usr.PasswordHash = GenerateSHA256Hash(tbox_Password.Text); context.Users.InsertOnSubmit(usr); context.SubmitChanges(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_Accept_Click(object sender, EventArgs e) { if (!Check_Syntax()) { MessageBox.Show("Enter valid data!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } try { TimetableDataContext context = new TimetableDataContext(); int Id = 1; if (context.Professors.Count() != 0) { Id = context.Professors.Max(p => p.ID) + 1; } Professor prof = new Professor(); prof.ID = Id; prof.Name = tbox_Name.Text; prof.Title = tbox_Details.Text; prof.Details = tbox_Details.Text; prof.Phone = tbox_Phone.Text; prof.Mail = tbox_Mail.Text; prof.Salary = int.Parse(tbox_Salary.Text); context.Professors.InsertOnSubmit(prof); context.SubmitChanges(); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }