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