///<summary> ///EXAMINATIONS /// </summary> public static void insert2examination(EXAMINATIONS newExamination) { string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString(); ECMSDataContext db = new ECMSDataContext(connectString); //Add new EXAMINATIONS to database db.EXAMINATIONS.InsertOnSubmit(newExamination); //Save changes to Database. db.SubmitChanges(); }
public static void updateexamination(string str_id, EXAMINATIONS newExamination) { string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString(); ECMSDataContext db = new ECMSDataContext(connectString); //Get EXAMINATIONS for update EXAMINATIONS oldExamination = db.EXAMINATIONS.FirstOrDefault(e => e.id.Equals(str_id)); oldExamination = newExamination; //Save changes to Database. db.SubmitChanges(); }
public static void deleteexamination(string str_id) { string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString(); ECMSDataContext db = new ECMSDataContext(connectString); //Get EXAMINATIONS to Delete EXAMINATIONS deleteEXAMINATIONS = db.EXAMINATIONS.FirstOrDefault(e => e.id.Equals(str_id)); //Delete EXAMINATIONS db.EXAMINATIONS.DeleteOnSubmit(deleteEXAMINATIONS); //Save changes to Database. db.SubmitChanges(); }