///<summary> ///PHARMACIST_HOLIDAYS /// </summary> public static void insert2PHARMACIST_HOLIDAYS(PHARMACIST_HOLIDAYS newPHARMACIST_HOLIDAYS) { string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString(); ECMSDataContext db = new ECMSDataContext(connectString); //Add new PHARMACIST_HOLIDAYS to database db.PHARMACIST_HOLIDAYS.InsertOnSubmit(newPHARMACIST_HOLIDAYS); //Save changes to Database. db.SubmitChanges(); }
public static void updatePHARMACIST_HOLIDAYS(string str_id, PHARMACIST_HOLIDAYS updatePHARMACIST_HOLIDAYS) { string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString(); ECMSDataContext db = new ECMSDataContext(connectString); //Get PHARMACIST_HOLIDAYS for update PHARMACIST_HOLIDAYS oldPHARMACIST_HOLIDAYS = db.PHARMACIST_HOLIDAYS.FirstOrDefault(e => e.id.Equals(str_id)); oldPHARMACIST_HOLIDAYS = updatePHARMACIST_HOLIDAYS; //Save changes to Database. db.SubmitChanges(); }