public ActionResult DeleteConfirmed(int id)
{
Models.ShoppingList shoppingListModel = db.ShoppingLists.Find(id);
db.ShoppingLists.Remove(shoppingListModel);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IHttpActionResult PutShoppingList(int id, Models.ShoppingList shoppingList)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != shoppingList.Id)
{
return(BadRequest());
}
db.Entry(shoppingList).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ShoppingListExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void SeedData()
{
var shoppingList = new Models.ShoppingList()
{
Name = "Sample list",
SecretUrl = "SampleList",
Active = true,
Items = new List <Item>()
{
new Item()
{
Name = "Eggs",
Amount = 18,
Unit = "piece"
},
new Item()
{
Name = "Milk",
Amount = 8,
Unit = "liter"
},
new Item()
{
Name = "Cheese",
Amount = 0.3M,
Unit = "kg"
}
}
};
_contextProvider.Context.Set <Models.ShoppingList>().Add(shoppingList);
_contextProvider.Context.SaveChanges();
}
public void SeedData()
{
var shoppingList = new Models.ShoppingList()
{
Name = "Sample list",
SecretUrl = "SampleList",
Active = true,
Items = new List<Item>()
{
new Item()
{
Name = "Eggs",
Amount = 18,
Unit = "piece"
},
new Item()
{
Name = "Milk",
Amount = 8,
Unit = "liter"
},
new Item()
{
Name = "Cheese",
Amount = 0.3M,
Unit = "kg"
}
}
};
_contextProvider.Context.Set<Models.ShoppingList>().Add(shoppingList);
_contextProvider.Context.SaveChanges();
}
public ActionResult AddItem(string item)
{
using (SmartShoppingEntities db = new SmartShoppingEntities())
{
if (User.Identity.IsAuthenticated)
{
string aspid = User.Identity.GetUserId();
MemberID = db.Members.Where(m => m.Id == aspid).Select(m => m.Member_ID).First();
}
ShoppingList slist = new Models.ShoppingList();
if (System.Web.HttpContext.Current.Session["PListID"] == null)
{
slist.PList_ID = db.PList.Where(m => m.Member_ID == MemberID).Select(m => m.PList_ID).First();;
}
else
{
slist.PList_ID = (int)System.Web.HttpContext.Current.Session["PListID"];
}
slist.ListName = item;
slist.Active = true;
db.Entry(slist).State = EntityState.Added;
db.SaveChanges();
return(RedirectToAction("ShoppingListP", new { id = slist.PList_ID }));
}
}
// POST: api/ShoppingList
public IEnumerable Post([FromBody] Models.ShoppingList newList)
{
newList.Id = shoppingLists.Count;
shoppingLists.Add(newList);
return(shoppingLists);
}
public ActionResult Edit([Bind(Include = "ShoppingListId,UserId,Name,Color,CreatedUtc,ModifiedUtc")] Models.ShoppingList shoppingListModel)
{
if (ModelState.IsValid)
{
db.Entry(shoppingListModel).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(shoppingListModel));
}
// GET: api/ShoppingList/5
public IHttpActionResult Get(int id)
{
Models.ShoppingList result = shoppingLists.FirstOrDefault(s => s.Id == id);
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
public IHttpActionResult PostShoppingList(Models.ShoppingList shoppingList)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.ShoppingLists.Add(shoppingList);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = shoppingList.Id }, shoppingList));
}
public IHttpActionResult DeleteShoppingList(int id)
{
Models.ShoppingList shoppingList = db.ShoppingLists.Find(id);
if (shoppingList == null)
{
return(NotFound());
}
db.ShoppingLists.Remove(shoppingList);
db.SaveChanges();
return(Ok(shoppingList));
}
public IActionResult CreateShoppingList(ShoppingListViewModel model)
{
if (ModelState.IsValid)
{
//TODO: add methods to validate selecteddays format
var daysArray = Array.ConvertAll(model.SelectedDays.Trim().Split(','), int.Parse);
var dietCalendar = new DietCalendar(model.SelectedFile);
var shoppingList = new Models.ShoppingList(dietCalendar, daysArray);
return(View(shoppingList));
}
return(View("Index"));
}
// GET: ShoppingListModel/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Models.ShoppingList shoppingListModel = db.ShoppingLists.Find(id);
if (shoppingListModel == null)
{
return(HttpNotFound());
}
return(View(shoppingListModel));
}
public ActionResult AddFromDetail(int id, int?no, int?by)
{
using (SmartShoppingEntities db = new SmartShoppingEntities())
{
if (User.Identity.IsAuthenticated)
{
string aspid = User.Identity.GetUserId();
MemberID = db.Members.Where(m => m.Id == aspid).Select(m => m.Member_ID).First();
}
//存到我的購物清單
int plistID = db.PList.Where(m => m.Member_ID == MemberID && m.ListName == "我的購物清單").Select(p => p.PList_ID).FirstOrDefault();
if (plistID == 0)//幫他創一個
{
PList pl = new PList();
pl.Member_ID = MemberID;
pl.ListName = "我的購物清單";
pl.PList_ID = db.PList.Max(m => m.PList_ID) + 1;
plistID = pl.PList_ID;
db.Entry(pl).State = EntityState.Added;
}
ShoppingList sl = new Models.ShoppingList();
sl.PList_ID = plistID;
sl.Products = db.Products.Where(p => p.Product_ID == id).First();
sl.RepeatNumber = no;
sl.RepeatBy = by;
sl.ListName = sl.Products.Categories.CategoryName;
sl.Active = true;
if (no != 0)
{
if (by == 1)//月
{
sl.NextDate = DateTime.Today.AddMonths((int)no);
}
else if (by == 2)//周
{
sl.NextDate = DateTime.Today.AddDays((int)(7 * no));
}
else if (by == 3)//日
{
sl.NextDate = DateTime.Today.AddDays((int)no);
}
}
db.Entry(sl).State = EntityState.Added;
db.SaveChanges();
return(Content(sl.Products.ProductName + "已加入您的智慧清單"));
}
}
public IHttpActionResult GetShoppingList(int id)
{
Models.ShoppingList shoppingList = db.ShoppingLists
.Where(s => s.Id == id)
.Include(s => s.Items)
.FirstOrDefault();
if (shoppingList == null)
{
return(NotFound());
}
return(Ok(shoppingList));
}
// DELETE: api/Item/5
public IHttpActionResult Delete(int id)
{
Models.ShoppingList shoppingList = ShoppingListController.shoppingLists[0];
Item item = shoppingList.Items.FirstOrDefault(i => i.Id == id);
if (item == null)
{
return(NotFound());
}
shoppingList.Items.Remove(item);
return(Ok(shoppingList));
}
// GET: ShoppingListModel/Details/5
public ActionResult Details(int?id)
{
//replace with shoppinglistitem index
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Models.ShoppingList shoppingListModel = db.ShoppingLists.Find(id);
if (shoppingListModel == null)
{
return(HttpNotFound());
}
//var i = new ShoppingListItem {ShoppingListId = id.Value};
return(View(shoppingListModel));
}
// POST: api/Item
public IHttpActionResult Post([FromBody] Item item)
{
Models.ShoppingList shoppingList =
ShoppingListController.shoppingLists
.Where(s => s.Id == item.ShoppingListId)
.FirstOrDefault();
if (shoppingList == null)
{
return(NotFound());
}
shoppingList.Items.Add(item);
item.Id = shoppingList.Items.Max(i => i.Id) + 1;
return(Ok(shoppingList));
}
// POST: api/Item
public IHttpActionResult Post([FromBody] Models.item item)
{
//this can be accessed if the list is static in the shopingListctr
Models.ShoppingList shoppingList = ShoppingListController.
shoppingLists.Where(s => s.Id == item.ShoppingListId).
FirstOrDefault();
if (shoppingList == null)
{
return(NotFound());
}
//shoppingList.Items.Add(item);
//to give unique id for the items
item.Id = shoppingList.Items.Max(i => i.Id) + 1;
shoppingList.Items.Add(item);
return(Ok(shoppingList));
}
public IHttpActionResult DeleteItem(int id)
{
Item item = db.Items.Find(id);
if (item == null)
{
return(NotFound());
}
Models.ShoppingList shoppingList = db.ShoppingLists
.Where(s => s.Id == item.ShoppingListId)
.Include(s => s.Items)
.FirstOrDefault();
db.Items.Remove(item);
db.SaveChanges();
return(Ok(shoppingList));
}
public IHttpActionResult PostItem(Item item)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
Models.ShoppingList shoppingList = db.ShoppingLists
.Where(s => s.Id == item.ShoppingListId)
.Include(s => s.Items)
.FirstOrDefault();
if (shoppingList == null)
{
return(NotFound());
}
db.Items.Add(item);
db.SaveChanges();
return(Ok(shoppingList));
}
// PUT: api/Item/5
public IHttpActionResult Put(int id, [FromBody] Models.item item)
{
//this can be accessed if the list is static in the shopingListctr
Models.ShoppingList shoppingList = ShoppingListController.
shoppingLists.Where(s => s.Id == item.ShoppingListId).
FirstOrDefault();
if (shoppingList == null)
{
return(NotFound());
}
Models.item changedItem = shoppingList.Items.Where(i => i.Id == id).FirstOrDefault();
if (changedItem == null)
{
return(NotFound());
}
//set the property of the value that was given by the api
changedItem.Checked = item.Checked;
return(Ok(shoppingList));
}
// PUT: api/Item/5
public IHttpActionResult Put(int id, [FromBody] Item item)
{
Models.ShoppingList shoppingList =
ShoppingListController.shoppingLists
.Where(s => s.Id == item.ShoppingListId)
.FirstOrDefault();
if (shoppingList == null)
{
return(NotFound());
}
Item changedItem = shoppingList.Items.Where(i => i.Id == id).FirstOrDefault();
if (changedItem == null)
{
return(NotFound());
}
changedItem.Checked = item.Checked;
return(Ok(shoppingList));
}
