// INSERT INTO a_Supplier VALUE a_Supplier
        public void CreateNewa_Supplier(a_SupplierViewModel a_Supplier)
        {
            using (ShopDBEntities db = new ShopDBEntities())
            {
                Xsis_Shop_Models.a_Supplier Model = new Xsis_Shop_Models.a_Supplier();
                Model.Code = a_Supplier.Code;
                Model.Name = a_Supplier.Name;
                Model.City = a_Supplier.City;

                db.a_Supplier.Add(Model);
                db.SaveChanges();
            }
        }
        // UPDATE
        public void Updatea_Supplier(a_SupplierViewModel a_Supplier)
        {
            using (ShopDBEntities db = new ShopDBEntities())
            {
                Xsis_Shop_Models.a_Supplier Model = new Xsis_Shop_Models.a_Supplier();
                Model.ID   = a_Supplier.ID;
                Model.Code = a_Supplier.Code;
                Model.Name = a_Supplier.Name;
                Model.City = a_Supplier.City;

                db.Entry(Model).State = EntityState.Modified;
                db.SaveChanges();
            }
        }