///<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();
}
