public string Delete(Store st) { if (dbcontext == null) { dbcontext = new RouteOptimizationDBEntities(); } //dbcontext.Entry(st).State = EntityState.Deleted; dbcontext.Stores.Remove(st); dbcontext.SaveChanges(); return ""; }
public IEnumerable<Store> AddorUpdate(Store st) { if (dbcontext == null) { dbcontext = new RouteOptimizationDBEntities(); } if (st.StoreID > 0) { Store store; store = GetById(st.StoreID); dbcontext.Entry(store).CurrentValues.SetValues(st); // dbcontext.Entry(store).State = EntityState.Modified; } else { dbcontext.Stores.Add(st); } dbcontext.SaveChanges(); return dbcontext.Stores.ToList(); }
public string Create(string Address1,string Address2, string Postal, int Country, int Province, int City, int ID, string Name, string StoreNumber, int RetailerID, string EmailID, string Phone) { StoreDAL storeBO = new StoreDAL(); Store store = new Store(); Address ad = new Address(); ad.Address1 = Address1; ad.Address2 = Address2; ad.PostalCode = Postal; ad.CityID = City; ad.CountryID = Country; ad.ProvinceID = Province; int addid = 0; if (ModelState.IsValid) { storeBO.AddorUpdateAddress(ad); var result = db.Addresses.OrderByDescending(x => x.AddressID).First(); addid = result.AddressID; } if (!ID.Equals(0)) { store.StoreID = ID; } store.Name = Name; store.StoreNumber = StoreNumber; store.RetailerID = RetailerID; store.EmailID = EmailID; store.Phone = Phone; if (addid != 0) { store.AddressID = addid; } storeBO.AddorUpdate(store); return ("Added"); }