public ActionResult DeleteFood(int id) { FOOD food = foodDA.GetById(id); try { if (ModelState.IsValid) { foodDA.Delete(id); if (System.IO.File.Exists(Server.MapPath("~/Content/images/foods/" + food.IMAGE))) { System.IO.File.Delete(Server.MapPath("~/Content/images/foods/" + food.IMAGE)); } return(RedirectToAction("Foods", "Admin")); } else { ViewBag.Error = "Try Again."; return(View("FoodDelete", food)); } } catch (Exception ex) { ViewBag.Error = "Try Again."; return(View("FoodDelete", food)); } }
internal FOOD GetById(int id) { FOOD food = new FOOD(); using (con = new SqlConnection(connectionString)) { string sqlQuery = @"SELECT TFOOD.*, TCATEGORY.NAME AS CATEGORY_NAME, TSTATE.NAME AS STATE_NAME FROM TFOOD INNER JOIN TCATEGORY ON TCATEGORY.ID = TFOOD.CATEGORY_ID INNER JOIN TSTATE ON TSTATE.ID = TFOOD.STATE_ID WHERE TFOOD.ID=@ID"; using (SqlCommand cmd = new SqlCommand(sqlQuery, con)) { con.Open(); cmd.Parameters.AddWithValue("@ID", id); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { food.ID = (int)reader["ID"]; food.TITLE = (string)reader["TITLE"]; food.DESCRIPTION = (string)reader["DESCRIPTION"]; food.PRICE = (decimal)reader["PRICE"]; food.IMAGE = (string)reader["IMAGE"]; food.CATEGORY_ID = (int)reader["CATEGORY_ID"]; food.CATEGORY_NAME = (string)reader["CATEGORY_NAME"]; food.STATE_ID = (int)reader["STATE_ID"]; food.STATE_NAME = (string)reader["STATE_NAME"]; } con.Close(); } } return(food); }
public ActionResult Create(FOOD f, HttpPostedFileBase picture) { if (ModelState.IsValid) { var product = new FOOD(); if (picture != null) { using (var scope = new TransactionScope()) { product.FOOD_CODE = f.FOOD_CODE; product.FOOD_NAME = f.FOOD_NAME; product.DESCRIPTION = f.DESCRIPTION; product.PRICE = f.PRICE; product.STATUS = f.STATUS; product.CATEGORY_ID = f.CATEGORY_ID; model.FOODs.Add(product); model.SaveChanges(); var path = Server.MapPath(PICTURE_PATH); picture.SaveAs(path + product.ID); scope.Complete(); } } else { ModelState.AddModelError("", "Picture not found!"); } return(RedirectToAction("Index")); } return(View()); }
public bool Mail(OdersUser odersUser) { int iduser = int.Parse(odersUser.iduser); ACCOUNT account = db.ACCOUNTs.Find(iduser); if (account == null) { return(false); } MailMessage mailMessagCus = new MailMessage(ConfigurationManager.AppSettings.Get("Email"), account.EMAIL); mailMessagCus.Subject = "Gửi đơn đặt hàng"; mailMessagCus.Body = "Danh sách các món được đặt hàng bởi người dùng có id " + account.ID + " ,tên: " + account.NAME + " và email : " + account.EMAIL; double sum = 0; foreach (Oders i in odersUser.listoders) { FOOD food = new FOOD(); int tempid = int.Parse(i.id); int tempnum = int.Parse(i.number); food = db.FOODs.Find(tempid); mailMessagCus.Body = mailMessagCus.Body + "Món : Tên món ăn: " + food.NAME + " ,số lượng: " + tempnum + " , giá" + food.PRICE * tempnum; sum = sum + food.PRICE.Value * tempnum; } mailMessagCus.Body = mailMessagCus.Body + " Tổng tiền: " + sum; mailMessagCus.Body = mailMessagCus.Body + "Địa chỉ nhận đơn hàng : " + odersUser.Address + "," + odersUser.Ward + "," + odersUser.District; SmtpClient client = new SmtpClient(); client.Send(mailMessagCus); SendSMS("+84981103589", mailMessagCus.Body); return(true); }
private void ObjectListViewOnCellEditStarting(object sender, CellEditEventArgs e) { if (e.Column == olvCommand) { e.Cancel = true; if (((FOOD)e.RowObject).FOOD_NAME == String.Empty) { FOOD fOOD_ = new FOOD(); fOOD_.FOOD_NAME = "Chọn Tên Món"; demos.Insert(demos.Count - 1, fOOD_); objectListViewMonAn.SetObjects(demos); } else { objectListViewMonAn.RemoveObject(e.RowObject); demos.Remove((FOOD)e.RowObject); } } else if (e.Column == olvName) { if (((FOOD)e.RowObject).FOOD_NAME == String.Empty) { e.Cancel = true; } else { Food_Name(sender, e); } } }
public ActionResult Create([Bind(Include = "ID,FOOD_CODE,FOOD_NAME,CATEGORY_ID,DESCRIPTION,PRICE,IMAGE_URL,STATUS")] FOOD fOOD, HttpPostedFileBase picture) { if (ModelState.IsValid) { var product = new FOOD(); if (picture != null) { using (var scope = new TransactionScope()) { product.ID = fOOD.ID; product.FOOD_CODE = fOOD.FOOD_CODE; product.FOOD_NAME = fOOD.FOOD_NAME; product.CATEGORY_ID = fOOD.CATEGORY_ID; product.DESCRIPTION = fOOD.DESCRIPTION; product.PRICE = fOOD.PRICE; product.STATUS = fOOD.STATUS; db.FOODs.Add(product); db.SaveChanges(); var path = Server.MapPath(PICTURE_PATH); picture.SaveAs(path + product.ID); scope.Complete(); } } else { ModelState.AddModelError("", "Hình ảnh không được tìm thấy"); } } ViewBag.CATEGORY_ID = new SelectList(db.CATEGORies, "ID", "CATEGORY_CODE", fOOD.CATEGORY_ID); return(RedirectToAction("Index")); }
private void ValidateFood(FOOD model) { if (model.PRICE < 0) { ModelState.AddModelError("PRICE", "Giá không hợp lệ"); } if (model.FOOD_NAME == null) { ModelState.AddModelError("FOOD_NAME", "Vui lòng nhập tên món ăn"); } else { if (model.FOOD_NAME.Trim() == "") { ModelState.AddModelError("FOOD_NAME", "Vui lòng nhập tên món ăn"); } } if (model.DESCRIPTION == null) { ModelState.AddModelError("DESCRIPTION", "Vui lòng nhập mô tả"); } else { if (model.DESCRIPTION.Trim() == "") { ModelState.AddModelError("DESCRIPTION", "Vui lòng nhập mô tả"); } } }
public IHttpActionResult PutFOOD(int id, FOOD fOOD) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != fOOD.FoodID) { return(BadRequest()); } db.Entry(fOOD).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!FOODExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public Boolean Insert_Food(FOOD food, List <FOOD_RESOURCE> fOODs) { List <FOOD_RESOURCE> temp = new List <FOOD_RESOURCE>(fOODs); temp.RemoveAt(temp.Count - 1); return(DAODishes.Instance.Insert_Food(food, temp)); }
public ActionResult Edit(int id, [Bind(Include = "ID,FOOD_CODE,FOOD_NAME,CATEGORY_ID,DESCRIPTION,PRICE,IMAGE_URL,STATUS")] FOOD fOOD, HttpPostedFileBase picture) { if (ModelState.IsValid) { var product = db.FOODs.Find(id); if (ModelState.IsValid) { using (var scope = new TransactionScope()) { product.ID = fOOD.ID; product.FOOD_CODE = fOOD.FOOD_CODE; product.FOOD_NAME = fOOD.FOOD_NAME; product.CATEGORY_ID = fOOD.CATEGORY_ID; product.DESCRIPTION = fOOD.DESCRIPTION; product.PRICE = fOOD.PRICE; product.STATUS = fOOD.STATUS; db.Entry(product).State = EntityState.Modified; db.SaveChanges(); if (picture != null) { var path = Server.MapPath(PICTURE_PATH); picture.SaveAs(path + product.ID); } scope.Complete(); return(RedirectToAction("Index")); } } db.Entry(fOOD).State = EntityState.Modified; } ViewBag.CATEGORY_ID = new SelectList(db.CATEGORies, "ID", "CATEGORY_CODE", fOOD.CATEGORY_ID); return(View(fOOD)); }
public static bool Insert(int id, String foodName, int foodPrice, int foodTypeId, String foodImage, String foodDetail) { bool flag = true; try { _db = new FoodStoreEntities(); var food = new FOOD(); var foodType = FoodTypeController.Get(foodTypeId, _db); food.ID = id; food.Name = foodName; food.Price = foodPrice; food.Detail = foodDetail; food.Image = foodImage; food.FOODTYPE = foodType; food.Alias = StringOperation.GetAlias(id, foodName); _db.AddToFOODs(food); _db.SaveChanges(); } catch (Exception) { flag = false; throw; } return flag; }
public ActionResult Edit(int id, FOOD f, HttpPostedFileBase picture) { if (ModelState.IsValid) { var product = model.FOODs.FirstOrDefault(x => x.ID == id); using (var scope = new TransactionScope()) { product.FOOD_CODE = f.FOOD_CODE; product.FOOD_NAME = f.FOOD_NAME; product.DESCRIPTION = f.DESCRIPTION; product.CATEGORY = f.CATEGORY; product.PRICE = f.PRICE; product.STATUS = f.STATUS; model.SaveChanges(); if (picture != null) { var path = Server.MapPath(PICTURE_PATH); picture.SaveAs(path + product.ID); } scope.Complete(); } return(RedirectToAction("Index")); } return(View()); }
private void ValidateProduct(FOOD food) { if (food.PRICE < 0) { ModelState.AddModelError("PRICE", "PRICE is less than zero"); } }
public ActionResult Create(FOOD fOOD, HttpPostedFileBase Picture) { if (ModelState.IsValid) { if (Picture != null) { using (var scope = new TransactionScope()) { fOOD.STATUS = true; db.FOODs.Add(fOOD); db.SaveChanges(); var path = Server.MapPath(PICTURE_PATH); Picture.SaveAs(path + fOOD.ID); scope.Complete(); return(RedirectToAction("Index")); } } else { ModelState.AddModelError("", "Picture not found!"); } } ViewBag.CATEGORY_ID = new SelectList(db.CATEGORies, "ID", "CATEGORY_NAME", fOOD.CATEGORY_ID); return(View(fOOD)); }
public ActionResult DeleteConfirmed(int id) { FOOD fOOD = db.FOODSet.Find(id); db.FOODSet.Remove(fOOD); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,foodname,foodcalorie,foodaddress")] FOOD fOOD) { if (ModelState.IsValid) { db.Entry(fOOD).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(fOOD)); }
public ActionResult Edit([Bind(Include = "ID,FOOD_CODE,FOOD_NAME,CATEGORY_ID,DESCRIPTION,PRICE,IMAGE_URL,STATUS")] FOOD fOOD) { if (ModelState.IsValid) { db.Entry(fOOD).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CATEGORY_ID = new SelectList(db.CATEGORies, "ID", "CATEGORY_CODE", fOOD.CATEGORY_ID); return(View(fOOD)); }
public ActionResult FoodDelete(int id) { if (Session["ID"] == null) { return(RedirectToAction("Index")); } FOOD food = foodDA.GetById(id); return(View(food)); }
private string createBiGFood(string result) { FOOD item = DATA._FOOD.Last(); string i1 = item.mainImg; string sname = DATA.imageDict[i1]; string imglistprefix = "data\\food"; result = result.Replace("$fooddate", item.date.ToString("yyyy-MM-dd")); result = result.Replace("$foodimagesrc", imglistprefix + "\\" + item.Id + "\\" + i1); return(result); }
public IHttpActionResult GetFOOD(int id) { FOOD fOOD = db.FOODs.Find(id); if (fOOD == null) { return(NotFound()); } return(Ok(fOOD)); }
public ActionResult Create([Bind(Include = "Id,foodname,foodcalorie,foodaddress")] FOOD fOOD) { if (ModelState.IsValid) { db.FOODSet.Add(fOOD); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(fOOD)); }
public override void Eat(Food food) { if (food.Type() == "Meet") { FOOD.Add(food); } else { base.RaiseWrongFoodProvided(food); } }
public IHttpActionResult PostFOOD(FOOD fOOD) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.FOODs.Add(fOOD); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = fOOD.FoodID }, fOOD)); }
public ActionResult Edit(FOOD f, HttpPostedFileBase picture) { var fileName = Path.GetFileName(picture.FileName); var directoryToSave = Server.MapPath(Url.Content("~/Images/")); var pathToSave = Path.Combine(directoryToSave, fileName); picture.SaveAs(pathToSave); f.IMAGE_URL = Path.Combine("/Images/", fileName); model.Entry(f).State = System.Data.Entity.EntityState.Modified; model.SaveChanges(); return(RedirectToAction("Index")); }
private void frmAddMenu_Load(object sender, EventArgs e) { FOOD fOOD_ = new FOOD(); fOOD_.FOOD_NAME = ""; demos.Add(fOOD_); if (!addFlag) { demos = BUSMenu.Instance.Get_Food(menu.ID); demos.Add(fOOD_); } objectListViewMonAn.SetObjects(demos); }
public ActionResult FoodUpdate(int id) { if (Session["ID"] == null) { return(RedirectToAction("Index")); } FOOD food = foodDA.GetById(id); PopulateStateDropdownList(food.STATE_ID); PopulateCategoryDropdownList(food.CATEGORY_ID); return(View(food)); }
// GET: FOODs/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } FOOD fOOD = db.FOODSet.Find(id); if (fOOD == null) { return(HttpNotFound()); } return(View(fOOD)); }
public IHttpActionResult DeleteFOOD(int id) { FOOD fOOD = db.FOODs.Find(id); if (fOOD == null) { return(NotFound()); } db.FOODs.Remove(fOOD); db.SaveChanges(); return(Ok(fOOD)); }
// GET: Admin/FOODs/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } FOOD fOOD = db.FOODs.Find(id); if (fOOD == null) { return(HttpNotFound()); } ViewBag.CATEGORY_ID = new SelectList(db.CATEGORies, "ID", "CATEGORY_CODE", fOOD.CATEGORY_ID); return(View(fOOD)); }
public bool Rec_Food(Survey _surv) { int surveyID = Convert.ToInt32(_surv.S_ID); int Q_ID = Convert.ToInt32(_surv.ID); using (EventrixDBDataContext db = new EventrixDBDataContext()) { try { int _query = (from res in db.FOODs where res.S_Id.Equals(surveyID) select res).Count(); if (_query == 0) //Create New Answer { FOOD toinsert = new FOOD(); toinsert.S_Id = _surv.S_ID; toinsert.Very_Dissatisfied = _surv.veryDissatisfied; toinsert.Dissatisfied = _surv.Dissatisfied; toinsert.Neutral = _surv.Neutral; toinsert.Very_Satisfied = _surv.VerySatisfied; toinsert.Satisfied = _surv.Satisfied; db.FOODs.InsertOnSubmit(toinsert); db.SubmitChanges(); return(true); } else //Update Record { FOOD query = (from res in db.FOODs where res.S_Id.Equals(surveyID) select res).First(); query.Very_Dissatisfied += _surv.veryDissatisfied; query.Dissatisfied += _surv.veryDissatisfied; query.Neutral += _surv.Neutral; query.Satisfied += _surv.Satisfied; query.Very_Satisfied += _surv.VerySatisfied; db.SubmitChanges(); return(true); } } catch (Exception) { return(false); } }; }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(400, "Bad Request")); } var listFoods = getFoods(); FOOD food = listFoods.FirstOrDefault(f => f.ID == id); if (food == null) { return(HttpNotFound("Not Found")); } ViewBag.NameFood = food.FOOD_NAME; ViewData["list"] = model.FOODs.Where(x => x.ID == id).ToList <FOOD>(); return(View(food)); }