Exemplo n.º 1
0
        ///<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();
        }
Exemplo n.º 2
0
        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();
        }