public void DeleteStudent(int id)
{
var db = new OOPServerEntities3();
var student = db.Students.Find(id);
db.Students.Remove(student);
db.SaveChanges();
}
private void GrdFaculty_CellClick(object sender, DataGridViewCellEventArgs e)
{
var db = new OOPServerEntities3();
string Facultyname = this.grdFaculty.CurrentRow.Cells[0].Value.ToString();
Faculty faculty = db.Faculties.Single(x => x.Faculty_Name.Equals(Facultyname));
this.txtFacultyName.Text = faculty.Faculty_Name;
}
private void GrdClass_CellClick(object sender, DataGridViewCellEventArgs e)
{
var db = new OOPServerEntities3();
string classname = this.grdClass.CurrentRow.Cells[0].Value.ToString();
Class @class = db.Classes.Single(x => x.Name.Equals(classname));
this.txtClassName.Text = @class.Name;
}
public void DeleteFacuty(int id)
{
var db = new OOPServerEntities3();
var @Faculty = db.Faculties.Find(id);
db.Faculties.Remove(@Faculty);
db.SaveChanges();
}
public void DeleteClass(int id)
{
var db = new OOPServerEntities3();
var @class = db.Classes.Find(id);
db.Classes.Remove(@class);
db.SaveChanges();
}
private void LoadAllFaculty()
{
var db = new OOPServerEntities3();
this.grdFaculty.DataSource = db.Faculties.Select(x => new
{
FacultyName = x.Faculty_Name
}).ToList();
this.grdFaculty.Columns[0].HeaderText = "Faculty name";
}
private void BtnUpdateClass_Click(object sender, EventArgs e)
{
try
{
var db = new OOPServerEntities3();
string classname = this.grdClass.CurrentRow.Cells[0].Value.ToString();
Class @class = db.Classes.Single(x => x.Name.Equals(classname));
@class.Name = this.txtClassName.Text;
db.SaveChanges();
this.LoadAllClass();
MessageBox.Show("Update Class Successfully");
}
catch
{
MessageBox.Show("Update Class Failed");
}
}
public void UpdateStudent(int id, string code, string name, DateTime birthday, int class_id, string email, string hometown, int faculty, double averageScore)
{
var db = new OOPServerEntities3();
var student = db.Students.Find(id);
student.Code = code;
student.Name = name;
student.Birthday = birthday;
student.Class_id = class_id;
student.Email = email;
student.Home_Town = hometown;
student.Faculty_ID = faculty;
student.Average_Score = averageScore;
db.Entry(student).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
private void BtnUpdateFaculty_Click(object sender, EventArgs e)
{
try
{
var db = new OOPServerEntities3();
string facultyname = this.grdFaculty.CurrentRow.Cells[0].Value.ToString();
Faculty faculty = db.Faculties.Single(x => x.Faculty_Name.Equals(facultyname));
faculty.Faculty_Name = this.txtFacultyName.Text;
db.SaveChanges();
this.LoadAllFaculty();
MessageBox.Show("Update Faculty Successfully");
}
catch
{
MessageBox.Show("Update Faculty Failed");
}
}
private void BtnAddFaculty_Click(object sender, EventArgs e)
{
try
{
var db = new OOPServerEntities3();
Faculty faculty = new Faculty();
faculty.Faculty_Name = this.txtFacultyName.Text;
db.Faculties.Add(faculty);
db.SaveChanges();
this.LoadAllFaculty();
MessageBox.Show("Add Faculty Successfully");
}
catch
{
MessageBox.Show("Add Faculty Failed");
}
}
private void BtnAddClass_Click(object sender, EventArgs e)
{
try
{
var db = new OOPServerEntities3();
Class @class = new Class();
@class.Name = this.txtClassName.Text;
db.Classes.Add(@class);
db.SaveChanges();
this.LoadAllClass();
MessageBox.Show("Add Class Successfully");
}
catch
{
MessageBox.Show("Add Class Failed");
}
}
public void CreateStudent(string code, string name, DateTime birthday, int class_id, string email, string hometown, int faculty, double averageScore)
{
var student = new Student();
student.Code = code;
student.Name = name;
student.Birthday = birthday;
student.Class_id = class_id;
student.Email = email;
student.Home_Town = hometown;
student.Faculty_ID = faculty;
student.Average_Score = averageScore;
var db = new OOPServerEntities3();
db.Students.Add(student);
db.SaveChanges();
}
private void LoadAllClass()
{
var db = new OOPServerEntities3();
this.grdClass.DataSource = db.Classes.Select(x => new
{
Name = x.Name
}).ToList();
this.grdClass.Columns[0].HeaderText = "Class name";
//var classes = this.Business.GetClasses();
//var classViews = new ClassView[classes.Length];
//for (int i = 0; i < classViews.Length; i++)
//{
// classViews[i] = new ClassView(classes[i]);
//}
//this.grdClass.DataSource = classViews;
}
private void BtnDeleteFaculty_Click(object sender, EventArgs e)
{
var db = new OOPServerEntities3();
string facultyname = this.grdFaculty.CurrentRow.Cells[0].Value.ToString();
DialogResult dr = MessageBox.Show("Are you sure to delete this", "Confirm", MessageBoxButtons.YesNo);
if (dr == System.Windows.Forms.DialogResult.Yes)
{
try
{
Faculty faculty = db.Faculties.Single(x => x.Faculty_Name.Equals(facultyname));
db.Faculties.Remove(faculty);
db.SaveChanges();
this.LoadAllFaculty();
MessageBox.Show("Delete successfully");
}
catch
{
MessageBox.Show("Delete failed");
}
}
}
public Class[] GetClasses()
{
var db = new OOPServerEntities3();
return(db.Classes.ToArray());
}
public Faculty GetFaculty(int id)
{
var db = new OOPServerEntities3();
return(db.Faculties.Find(id));
}
public Student[] getSort()
{
var db = new OOPServerEntities3();
return(db.Students.ToArray());
}
public Student GetStudent(int id)
{
var db = new OOPServerEntities3();
return(db.Students.Find(id));
}
public Faculty[] getFacultyes()
{
var db = new OOPServerEntities3();
return(db.Faculties.ToArray());
}
public Class GetClass(int id)
{
var db = new OOPServerEntities3();
return(db.Classes.Find(id));
}