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