public void DeleteStudentRecord(Models.StudentInformation_Result studentcontactperson)
{
//List<StudentInformation_Result> students = new List<StudentInformation_Result>();
//using (SqlConnection myCon = new SqlConnection("Data Source=DESKTOP-50L3KE8\\SQLEXPRESS;Initial Catalog=DB_Class;Integrated Security=True"))
//{
// SqlCommand cmd = new SqlCommand("Delete FROM Student where StudentID = " + studentcontactperson.StudentID);
// cmd.Connection = myCon;
// myCon.Open();
// cmd.ExecuteNonQuery();
// myCon.Close();
//}
DB_ClassEntities db_dlt = new DB_ClassEntities();
var students = db_dlt.Students.FirstOrDefault(s => s.StudentID == studentcontactperson.StudentID);
if (students != null)
{
db_dlt.Students.Remove(students);
db_dlt.SaveChanges();
}
}
public void DeleteParentRecord(int id)
{
DB_ClassEntities db_dlt = new DB_ClassEntities();
var students = db_dlt.Contact_Person.FirstOrDefault(s => s.Contact_PersonID == id);
if (students != null)
{
db_dlt.Contact_Person.Remove(students);
db_dlt.SaveChanges();
}
}
