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