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;
}
}
