///<summary> ///DOCTOR_OPENTIMES /// </summary> public static void insert2doctimes(DOCTOR_OPENTIMES newDoctime) { string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString(); ECMSDataContext db = new ECMSDataContext(connectString); //Add new DOCTOR_OPENTIMES to database db.DOCTOR_OPENTIMES.InsertOnSubmit(newDoctime); //Save changes to Database. db.SubmitChanges(); }
public static void updatedoctime(string str_id, DOCTOR_OPENTIMES updateDoctime) { string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString(); ECMSDataContext db = new ECMSDataContext(connectString); //Get DOCTOR_OPENTIMES for update DOCTOR_OPENTIMES oldDoctime = db.DOCTOR_OPENTIMES.FirstOrDefault(e => e.id.Equals(str_id)); oldDoctime = updateDoctime; //Save changes to Database. db.SubmitChanges(); }
public static void deleteDoctime(string str_id) { string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString(); ECMSDataContext db = new ECMSDataContext(connectString); //Get DOCTOR_OPENTIMES to Delete DOCTOR_OPENTIMES deleteDoctime = db.DOCTOR_OPENTIMES.FirstOrDefault(e => e.id.Equals(str_id)); //Delete DOCTOR_OPENTIMES db.DOCTOR_OPENTIMES.DeleteOnSubmit(deleteDoctime); //Save changes to Database. db.SubmitChanges(); }