public string Delete(Retailer st) { if (db == null) { db = new RouteOptimizationDBEntities(); } db.Retailers.Remove(st); db.SaveChanges(); return ""; }
public IEnumerable<Roster> AddorUpdate(Roster rt, int[] orderID, int userID) { if (db == null) { db = new RouteOptimizationDBEntities(); } if (rt.RosterID > 0) { Roster roster; roster = GetById(rt.RosterID); db.Entry(roster).CurrentValues.SetValues(rt); } else { db.Rosters.Add(rt); } db.SaveChanges(); var id = rt.RosterID; RosterOrder ro = new RosterOrder(); for (int i = 0; i < orderID.Length; i++) { ro.RosterID = id; ro.OrderID = orderID[i]; db.RosterOrders.Add(ro); db.SaveChanges(); var res=(from order in db.Orders where order.OrderID == ro.OrderID select order).SingleOrDefault(); res.Status = "REC"; db.SaveChanges(); } var ua = (from user in db.UserAvailabilities where user.UserID == userID select user).SingleOrDefault(); ua.Status = "OC"; db.SaveChanges(); return db.Rosters.ToList(); }
// GET: Main public ActionResult Index() { RouteOptimizationDBEntities db=new RouteOptimizationDBEntities(); if (Session["UserName"] != null) { string s=Session["UserName"].ToString(); List<User> res = (from r in db.Users where r.EmailID.Equals(s) select r).ToList(); Session["Name"]= res[0].FirstName.ToString() + " " + res[0].LastName.ToString(); } return View(); }
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 void DeleteP(Int64 id) { if (db == null) { db = new RouteOptimizationDBEntities(); } var temp = (from x in db.Retailers where x.RetailerID == id select x).FirstOrDefault(); db.Retailers.Remove(temp); db.SaveChanges(); }
public string DeleteP(Int64 id) { if (dbcontext == null) { dbcontext = new RouteOptimizationDBEntities(); } var temp = (from x in dbcontext.Stores where x.StoreID == id select x).FirstOrDefault(); dbcontext.Stores.Remove(temp); dbcontext.SaveChanges(); return ""; }
public Roster GetById(Int64 Id) { if (db == null) { db = new RouteOptimizationDBEntities(); } var result = (from roster in db.Rosters where roster.RosterID == Id select roster).FirstOrDefault<Roster>(); if (result != null) { return result; } else { return null; } }
public IEnumerable<Retailer> AddorUpdate(Retailer rt) { if (db == null) { db = new RouteOptimizationDBEntities(); } if (rt.RetailerID > 0) { Retailer retailer; retailer = GetById(rt.RetailerID); db.Entry(retailer).CurrentValues.SetValues(rt); } else { db.Retailers.Add(rt); } db.SaveChanges(); return db.Retailers.ToList(); }
public IEnumerable<Address> AddorUpdateAddress(Address st) { if (dbcontext == null) { dbcontext = new RouteOptimizationDBEntities(); } if (st.AddressID > 0) { Address store; store = GetAddById(st.AddressID); dbcontext.Entry(store).CurrentValues.SetValues(st); // dbcontext.Entry(store).State = EntityState.Modified; } else { dbcontext.Addresses.Add(st); } dbcontext.SaveChanges(); return dbcontext.Addresses.ToList(); }
public Store GetById(Int64 Id) { if (dbcontext == null) { dbcontext = new RouteOptimizationDBEntities(); } var result = (from store in dbcontext.Stores where store.StoreID == Id select store).FirstOrDefault<Store>(); if (result != null) { return result; } else { return null; } }