public StudentDataManagement()
{
using (SchoolDbEntities db = new SchoolDbEntities())
{
_students = db.Students.ToList();
}
}
public void AddRecord(Student t)
{
using (SchoolDbEntities db = new SchoolDbEntities())
{
db.Students.Add(t);
db.SaveChanges();
}
}
public void DeleteRecord(int id)
{
using (SchoolDbEntities db = new SchoolDbEntities())
{
var d = db.Students.Where(s => s.Id == id).FirstOrDefault();
db.Students.Remove(d);
db.SaveChanges();
}
}
private void btndelete_Click(object sender, EventArgs e)
{
var students = new StudentsBusiness();
students.DataObject = new StudentDataManagement();
int id = Convert.ToInt32(txtId.Text);
students.Delete(id);
SchoolDbEntities db = new SchoolDbEntities();
dataGridView1.DataSource = db.Students.ToList();
}
private void btnsave_Click(object sender, EventArgs e)
{
var students = new StudentsBusiness();
students.DataObject = new StudentDataManagement();
Student s = new Student
{
FirstName = txtFirstName.Text,
LastName = txtLastName.Text,
Department = txtDepartment.Text
};
students.Add(s);
SchoolDbEntities db = new SchoolDbEntities();
dataGridView1.DataSource = db.Students.ToList();
}
