public ActionResult SaveSS(HG_Items Objitem) { if (Objitem.Qty == null) { Objitem.Qty = ""; } if (Objitem.Items == null) { return(Json(new { msg = "Select Item Category Name" })); } if (Objitem.ItemDiscription == null) { Objitem.ItemDiscription = ""; } if (Objitem.Type == 0) { Objitem.Type = 2; } if (Objitem.OrgID == 0) { var OrgObj = Request.Cookies["UserInfo"]; Objitem.OrgID = int.Parse(OrgObj["OrgId"]); } if (Objitem.Image == null) { Objitem.Image = ""; } if (Objitem.ItemMode == null) { Objitem.ItemMode = "1"; } Objitem.Save(); return(Json(new { data = Objitem }, JsonRequestBehavior.AllowGet)); }
public JObject ChangeItemAvability(Int64 ItemId, bool Status) { HG_Items ObjItem = new HG_Items().GetOne(ItemId); int Avaiblity = Status ? 0 : 1; JObject jObject = new JObject(); if (ObjItem.ItemID > 0) { ObjItem.ItemAvaibility = Avaiblity; ObjItem.Save(); jObject.Add("Status", 200); } else { jObject.Add("Status", 400); } return(jObject); }
public ActionResult CreateEdit(HG_Items Objitem, System.Web.HttpPostedFileBase FoodImg) { bool ApplyServingSize = false; if (Objitem.Qty == null) { Objitem.Qty = ""; } if (Objitem.ItemDiscription == null) { Objitem.ItemDiscription = ""; } if (Objitem.Type == 0) { Objitem.Type = 1; } if (Objitem.OrgID == 0) { var OrgObj = Request.Cookies["UserInfo"]; Objitem.OrgID = int.Parse(OrgObj["OrgId"]); } if (Objitem.ApplyAddOn == 2 && Objitem.AddOnCatId == 0) { return(Json(new { msg = "Select Addon Category " })); } if (Objitem.CategoryID == 0) { return(Json(new { msg = "Select Item Category Name" })); } Objitem.EntryBy = Convert.ToInt32(Request.Cookies["UserInfo"]["UserCode"]); //check for category change and apply it to OrderMenu Section if (Objitem.ItemID > 0) { HG_Items OldObjItem = new HG_Items().GetOne(Objitem.ItemID); if (OldObjItem.CategoryID != Objitem.CategoryID) { List <OrdMenuCtgItems> ListItemsinCategory = OrdMenuCtgItems.GetAll(ItemId: Objitem.ItemID); List <OrderMenuCategory> MenuCategoryList = OrderMenuCategory.GetAll(CategoryId: Objitem.CategoryID); foreach (var CtgItem in ListItemsinCategory) { foreach (var MenuCategory in MenuCategoryList) { List <OrdMenuCtgItems> MenuCategoryItems = OrdMenuCtgItems.GetAll(MenuCatTblId: MenuCategory.id); if (MenuCategoryItems.Count > 0) { var ItemExist = MenuCategoryItems.Find(x => x.ItemId == CtgItem.ItemId); if (ItemExist == null) { CtgItem.OrderNo = MenuCategoryItems.Count + 1; CtgItem.OrdMenuCatId = MenuCategory.id; CtgItem.OderMenuId = MenuCategory.OrderMenuid; CtgItem.save(); } } } } } } else { ApplyServingSize = true; } int i = Objitem.Save(); if (i > 0 && ApplyServingSize) { AddOns Addon = AddOns.ServingAddonList.Find(x => x.OrgID == Objitem.OrgID); if (Addon != null && Addon.AddonnList.Count > 0) { Addon.AddOnCatorItmId = Objitem.ItemID; CreateEditAddOn(Addon); AddOns.ServingAddonList.RemoveAll(x => x.OrgID == Objitem.OrgID); } // } if (i > 0 && FoodImg != null) { FoodImg.SaveAs(System.IO.Path.Combine(Server.MapPath("~/FoodImg/"), i + ".jpg")); } if (Objitem.Image.Equals("")) { Objitem.Image = "/FoodImg/" + i + ".jpg"; if (Objitem.Save() < 1) { return(Json(new { msg = "Error in Update Items" })); } } HG_Category hG_Category = new HG_Category().GetOne(Objitem.CategoryID); Objitem.Categoryname = hG_Category.Category; return(Json(new { data = Objitem }, JsonRequestBehavior.AllowGet)); }
public JsonResult Upload(int OrgID, System.Web.HttpPostedFileBase UplXl) { string Msg = "Uploaded Successfully"; if (OrgID <= 0) { return(Json(new { msg = "Select Organization First" })); } if (UplXl == null) { return(Json(new { msg = "Upload Excel File First" })); } try { var userInfo = Request.Cookies["UserInfo"]; var EntryBy = int.Parse(userInfo["UserCode"]); UplXl.SaveAs(System.IO.Path.Combine(Server.MapPath("~/Image/"), UplXl.FileName)); var DT = ReadExl.ReadExcelFileDT("~/Image/" + UplXl.FileName); if (DT.Rows.Count > 0) { HG_OrganizationDetails ObjOrg = new HG_OrganizationDetails().GetOne(OrgID); List <HG_Category> ListCategory = new HG_Category().GetAll(ObjOrg.OrgID); List <HG_Items> ListItem = new HG_Items().GetAll(ObjOrg.OrgID); for (int i = 1; i < DT.Rows.Count; i++) { string CategoryName = (DT.Rows[i][0] == null ? "" : DT.Rows[i][0].ToString()); string ItmName = (DT.Rows[i][1] == null ? "" : DT.Rows[i][1].ToString().Trim()); string ItmMode = (DT.Rows[i][2] == null ? "1" : DT.Rows[i][2].ToString().Replace(" ", "")); string Discriptn = (DT.Rows[i][3] == null ? "" : DT.Rows[i][3].ToString()); string CostPriceStr = (DT.Rows[i][4] == null ? "0.0" : DT.Rows[i][4].ToString().Replace(" ", "")); string Taxstr = (DT.Rows[i][5] == null ? "0.0" : DT.Rows[i][5].ToString().Replace(" ", "")); double CostPrice = double.Parse(CostPriceStr); double Tax = double.Parse(Taxstr); double TaxAmt = (CostPrice * Tax) / 100; double price = CostPrice + TaxAmt; if (ItmMode.ToUpper() == "VEG") { ItmMode = "1"; } else if (ItmMode.ToUpper() == "NON-VEG") { ItmMode = "2"; } HG_Category ObjCategory = ListCategory.Find(x => x.Category.ToUpper() == CategoryName.ToUpper()); if (ObjCategory == null && CategoryName.Replace(" ", "") != "") { ObjCategory = new HG_Category() { Category = CategoryName, OrgID = ObjOrg.OrgID, CategoryID = 0, CategoryType = 1, EntryBy = EntryBy }; ObjCategory.Save(); ListCategory.Add(ObjCategory); } HG_Items ObjItem = ListItem.Find(x => x.Items.ToUpper() == ItmName.ToUpper()); if (ObjItem == null && ItmName.Replace(" ", "") != "" && ObjCategory != null) { ObjItem = new HG_Items() { ItemID = 0, CategoryID = ObjCategory.CategoryID, Items = ItmName, ItemMode = ItmMode, ItemDiscription = Discriptn, CostPrice = CostPrice, Tax = Tax, Price = price, ApplyAddOn = 1, Image = "" , EntryBy = EntryBy, OrgID = OrgID, Qty = "", Type = 1, Status = true }; ObjItem.Save(); ListItem.Add(ObjItem); } else if (ObjItem != null && ItmName.Replace(" ", "") != "" && ObjCategory != null) { ObjItem.Items = ItmName; ObjItem.ItemMode = ItmMode; if ((ObjItem.CostPrice != CostPrice) || (ObjItem.Tax != Tax)) { ObjItem.CostPrice = CostPrice; ObjItem.Tax = Tax; ObjItem.Price = price; } ObjItem.ItemDiscription = Discriptn; ObjItem.Save(); ListItem.Add(ObjItem); } else if (ItmName.Replace(" ", "") == "" || ObjCategory == null) { Msg = "Uploaded Successfully With Some Data Missing"; } } } else { return(Json(new { msg = "No Any Row Founds" })); } } catch (Exception e) { return(Json(new { msg = "Error " + e.Message })); } return(Json(new { msg = Msg }, JsonRequestBehavior.AllowGet)); }