// GET: ServingSize
public ActionResult Index()
{
int OrgId = OrderType.CurrOrgId();
List <HG_Items> ServingItems = new HG_Items().GetAll(OrgId, 2);
return(View(ServingItems));
}
public JsonResult AddItemToOrder(Int64 OID, Int64 ItemId)
{
var UserInfo = Request.Cookies["UserInfo"];
var UserId = int.Parse(UserInfo["UserCode"]);
HG_Items ObjItem = new HG_Items().GetOne(ItemID: ItemId);
HG_OrderItem OrderItem = new HG_OrderItem()
{
FID = ObjItem.ItemID,
Price = ObjItem.Price,
Count = 0,
IsAddon = "0",
OID = OID,
Status = 4,
TickedNo = 0,
OrgId = ObjItem.OrgID,
ChefSeenBy = UserId,
OrderDate = DateTime.Now,
UpdatedBy = 0,
UpdationDate = DateTime.Now,
OrdById = UserId,
TaxInItm = ObjItem.Tax,
CostPrice = ObjItem.CostPrice
};
OrderItem.Save();
OrderItem.CostPrice = OrderItem.Price;
OrderItem.Price = 0.00;
OrderItem.ItemNam = ObjItem.Items;
return(Json(new { msg = OrderItem }, JsonRequestBehavior.AllowGet));
}
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));
}
// GET: HG_Items index
public ActionResult Index()
{
HG_Items Objitem = new HG_Items();
List <HG_Items> Listitem = Objitem.GetAll();
return(View(Listitem));
}
public ActionResult ItemAvaiBility()
{
HG_Items Objitem = new HG_Items();
List <HG_Items> Listitem = Objitem.GetAll();
Listitem = Listitem.OrderByDescending(x => x.ItemAvaibility).ToList();
return(View(Listitem));
}
public ActionResult ShowServingSize()
{
int OrgId = OrderType.CurrOrgId();
//List<ServingSize> servingSizes = ServingSize.GetAll(OrgId);
List <HG_Items> ServingItems = new HG_Items().GetAll(OrgId, 2);
return(View(ServingItems));
}
//Addon Items Index
public ActionResult AddOnItmIndex(int CatId)
{
HG_Items Objitem = new HG_Items();
List <HG_Items> Listitem = Objitem.GetAll(Type: 2);
Listitem = Listitem.FindAll(x => x.CategoryID == CatId);
return(View(Listitem));
}
public ActionResult AddOfrItem(int Itemid)
{
HG_Items objitem = new HG_Items().GetOne(Itemid);
ItemOffer itemOffers = new ItemOffer();
itemOffers.ItemId = objitem.ItemID;
itemOffers.ItemName = objitem.Items;
itemOffers.TotalItemPrice = objitem.Price;
return(View("OfferItm", itemOffers));
}
public ActionResult CreateEdit(int ID)
{
HG_Items Objitem = new HG_Items();
if (ID > 0)
{
Objitem = Objitem.GetOne(ID);
}
return(View(Objitem));
}
public ActionResult CreateServingSize(int ItemId)
{
HG_Items ObjItem = new HG_Items();
if (ItemId > 0)
{
ObjItem = new HG_Items().GetOne(ItemId);
}
ObjItem.Type = 2;
return(View(ObjItem));
}
public ActionResult NewAddOnItem(Int64 ItemId)
{
HG_Items ObjItem = new HG_Items().GetOne(ItemId);
AddOnItems AddOnItemList = new AddOnItems();
AddOnItemList.ItemId = ObjItem.ItemID;
AddOnItemList.Title = ObjItem.Items;
AddOnItemList.CostPrice = ObjItem.CostPrice;
AddOnItemList.Tax = ObjItem.Tax;
AddOnItemList.Price = ObjItem.Price;
return(View("AddOnItem", AddOnItemList));
}
public ActionResult NewAddonSS(int SSID)
{
HG_Items ObjItem = new HG_Items().GetOne(SSID);
AddOnItems AddOnItemList = new AddOnItems();
AddOnItemList.ItemId = ObjItem.ItemID;
AddOnItemList.Title = ObjItem.Items;
AddOnItemList.CostPrice = ObjItem.CostPrice;
AddOnItemList.Tax = ObjItem.Tax;
AddOnItemList.Price = ObjItem.Price;
AddOnItemList.IsServingAddon = true;
return(View("AddOnItem", AddOnItemList));
}
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 Delete(int ID)
{
List <HG_Items> Itemlist = new HG_Items().GetAll();
Itemlist = Itemlist.FindAll(x => x.CategoryID == ID);
if (Itemlist.Count > 0)
{
return(Json(new { msg = "Category Already Used in Item List " }, JsonRequestBehavior.AllowGet));
}
List <OrderMenuCategory> listitem = OrderMenuCategory.GetAll(CategoryId: ID);
if (listitem.Count > 0)
{
return(Json(new { msg = "Category Already Used in Order Menu Category " }, JsonRequestBehavior.AllowGet));
}
else
{
int i = HG_Category.Dell(ID);
}
return(Json(new { data = "1" }, JsonRequestBehavior.AllowGet));
}
public ActionResult Delete(System.Int64 ID)
{
List <HG_OrderItem> orderList = new HG_OrderItem().GetAll();
orderList = orderList.FindAll(x => x.FID == ID);
if (orderList.Count > 0)
{
return(Json(new { msg = "Item Already Used in Orders" }, JsonRequestBehavior.AllowGet));
}
List <OrdMenuCtgItems> listitem = OrdMenuCtgItems.GetAll(ItemId: ID);
if (listitem.Count > 0)
{
return(Json(new { msg = "Item Already Used in Order Menu " }, JsonRequestBehavior.AllowGet));
}
else
{
int i = HG_Items.Dell(ID);
}
return(Json(new { data = "1" }, JsonRequestBehavior.AllowGet));
}
// GET: AdminApi
public JObject GetSeating(int OrgId = 0)
{
List <HG_Items> ListItems = new List <HG_Items>();
List <HG_Category> MenuList = new List <HG_Category>();
if (OrgId <= 0)
{
OrgId = OrderType.CurrOrgId();
}
if (OrgId > 0)
{
ListItems = new HG_Items().GetAll(OrgId);
ListItems = ListItems.FindAll(x => x.ItemAvaibility == 0);// only available items
MenuList = new HG_Category().GetAll(OrgId: OrgId);
}
JObject ProcedureParm = new JObject();
var CurrDate = DateTime.Now;
var Todate = new DateTime(CurrDate.Year, CurrDate.Month, CurrDate.Day, 23, 59, 00);
ProcedureParm.Add("FromDate", CurrDate.ToString("MM/dd/yyyy"));
ProcedureParm.Add("Todate", Todate.ToString("MM/dd/yyyy HH:mm:ss"));
ProcedureParm.Add("Orgid", OrgId);
List <TblData> RunningOrds = TblData.GetAll("GetRunningOrder", ProcedureParm);
HG_OrganizationDetails ObjOrg = new HG_OrganizationDetails().GetOne(OrgId);
List <Seating> Listseating = Seating.GetSeating(OrgId);
JObject JobjResonse = new JObject();
JArray SeatingArray = new JArray();
JArray TakeAwayItem = new JArray();
List <HG_Floor_or_ScreenMaster> FlrScr = new HG_Floor_or_ScreenMaster().GetAll(int.Parse(ObjOrg.OrgTypes), OrgId);
foreach (var ObjSeating in Listseating)
{
JObject jObject = new JObject();
jObject.Add("Table_or_SheetName", ObjSeating.Seatting);
jObject.Add("Table_or_RowID", ObjSeating.SeatId);
jObject.Add("Otp", ObjSeating.Otp);
jObject.Add("SeatName", ObjSeating.SeatName);
jObject.Add("ScrnFlr", ObjSeating.FSName);
jObject.Add("RowSide", ObjSeating.RowSideName);
jObject.Add("Floor_or_ScreenId", ObjSeating.FSIS);
JArray MenuJarray = new JArray();
var order = RunningOrds.Find(x => x.getVal <Int64>("Table_or_SheatId") == ObjSeating.SeatId && x.getVal <int>("TableOtp") == ObjSeating.Otp);
if (order != null && order.getVal <Int64>("OID") > 0)
{
jObject.Add("CurrOID", order.getVal <Int64>("OID"));
jObject.Add("Status", 3);//table is booked
}
else
{
jObject.Add("CurrOID", 0);
jObject.Add("Status", 1);//table is free;
}
double CurrentTableAmt = 0.00;
string Cmobile = "";
string Cname = "";
int ContactId = 0;
if (order != null)
{
if (order.getVal <int>("ContactId") > 0)
{
LocalContacts localContacts = LocalContacts.GetOne(order.getVal <int>("ContactId"));
Cmobile = localContacts.MobileNo;
Cname = localContacts.Cust_Name;
ContactId = localContacts.ContctID;
}
else
{
vw_HG_UsersDetails ObjUser = new vw_HG_UsersDetails().GetSingleByUserId((int)order.getVal <Int64>("CID"));
if (ObjUser != null && ObjUser.UserCode > 0 && ObjUser.UserType == "CUST")
{
Cmobile = ObjUser.UserId;
Cname = ObjUser.UserName;
ContactId = -1;// minus show dont edit this. Order Palced By Customer
}
}
if (order.getVal <int>("PaymentStatus") == 0)
{
CurrentTableAmt += order.getVal <double>("OrdAmt");
}
}
if (ObjSeating.FSIS > 0) // not takeaway
{
jObject.Add("Type", 1); //Seat and table;
List <OrderMenuCategory> ListCategry = OrderMenuCategory.GetAll(ObjSeating.OMID);
List <OrdMenuCtgItems> ListMenuItems = OrdMenuCtgItems.GetAll(ObjSeating.OMID);
ListCategry = ListCategry.FindAll(x => x.Status == true);
ListCategry = ListCategry.OrderBy(x => x.OrderNo).ToList();
ListMenuItems = ListMenuItems.FindAll(x => x.Status == true);
HashSet <int> ItemIdHash = new HashSet <int>(ListItems.Select(x => x.ItemID).ToArray());
ListMenuItems = ListMenuItems.FindAll(x => ItemIdHash.Contains((int)x.ItemId));
int count = 0;
foreach (var OrderMenuObj in ListCategry)
{
double MenuItemPrice = 0.00;
var OrderMenuItems = ListMenuItems.FindAll(x => x.OrdMenuCatId == OrderMenuObj.id);
if (OrderMenuItems.Count > 0)
{
JObject JobjMenu = new JObject();
JArray jarrayItem = new JArray();
JobjMenu.Add("MenuId", OrderMenuObj.CategoryId);
JobjMenu.Add("Name", OrderMenuObj.DisplayName);
JobjMenu.Add("MenuIndex", count++);
int ItemiIndex = 0;
OrderMenuItems = OrderMenuItems.OrderBy(x => x.OrderNo).ToList();
foreach (var MenuItmObj in OrderMenuItems)
{
var Items = ListItems.Find(x => x.ItemID == MenuItmObj.ItemId);
int CurrCount = 0;
JObject objItem = new JObject();
objItem.Add("IID", Items.ItemID);
objItem.Add("ItemName", Items.Items);
objItem.Add("ItemPrice", Items.Price);
objItem.Add("ItemQuntity", Items.Qty);
objItem.Add("ItemImage", Items.Image);
objItem.Add("ItemCartValue", CurrCount);
objItem.Add("MenuId", Items.CategoryID);
objItem.Add("ItemIndex", ItemiIndex++);
objItem.Add("ItemMode", Items.ItemMode);
objItem.Add("CostPrice", Items.CostPrice);// without gst
objItem.Add("Tax", Items.Tax);
objItem.Add("Info", Items.ItemDiscription);
//check addon or Serving Size or Both apply in current item
List <AddOnn> Addons = AddOns.GetAddonsAndMultiSSize(Items);
if (Addons.Count > 0)
{
objItem.Add("Addons", JArray.FromObject(Addons));
}
jarrayItem.Add(objItem);
MenuItemPrice += Items.Price * CurrCount;
}
JobjMenu.Add("MenuItemCount", OrderMenuItems.Count);
JobjMenu.Add("MenuItems", jarrayItem);
// JobjMenu.Add("MenuItmPrice", MenuItemPrice);
//JobjMenu.Add("TableAmt", CurrentTableAmt);
JobjMenu.Add("ContactId", ContactId);
JobjMenu.Add("Mobile", Cmobile);
JobjMenu.Add("CName", Cname);
MenuJarray.Add(JobjMenu);
}
}
}
else
{
jObject.Add("Type", 3);//take away
if (TakeAwayItem.Count == 0)
{
int count = 0;
foreach (HG_Category menu in MenuList)
{
double MenuItemPrice = 0.00;
List <HG_Items> ItemListByMenu = ListItems.FindAll(x => x.CategoryID == menu.CategoryID);
if (ItemListByMenu.Count > 0)
{
JObject JobjMenu = new JObject();
JArray jarrayItem = new JArray();
JobjMenu.Add("MenuId", menu.CategoryID);
JobjMenu.Add("Name", menu.Category);
JobjMenu.Add("MenuIndex", count++);
int ItemiIndex = 0;
foreach (var Items in ItemListByMenu)
{
int CurrCount = 0;
JObject objItem = new JObject();
objItem.Add("IID", Items.ItemID);
objItem.Add("ItemName", Items.Items);
objItem.Add("ItemPrice", Items.Price);
objItem.Add("ItemQuntity", Items.Qty);
objItem.Add("ItemImage", Items.Image);
objItem.Add("ItemCartValue", CurrCount);
objItem.Add("MenuId", Items.CategoryID);
objItem.Add("ItemIndex", ItemiIndex++);
objItem.Add("CostPrice", Items.CostPrice);// without gst
objItem.Add("Tax", Items.Tax);
objItem.Add("ItemMode", Items.ItemMode);
objItem.Add("Info", Items.ItemDiscription);
//check addon or Serving Size or Both apply in current item
List <AddOnn> Addons = AddOns.GetAddonsAndMultiSSize(Items);
if (Addons.Count > 0)
{
objItem.Add("Addons", JArray.FromObject(Addons));
}
jarrayItem.Add(objItem);
MenuItemPrice += Items.Price * CurrCount;
}
JobjMenu.Add("MenuItemCount", ItemListByMenu.Count);
JobjMenu.Add("MenuItems", jarrayItem);
//JobjMenu.Add("MenuItmPrice", MenuItemPrice);
//JobjMenu.Add("TableAmt", CurrentTableAmt);
JobjMenu.Add("ContactId", ContactId);
JobjMenu.Add("Mobile", Cmobile);
JobjMenu.Add("CName", Cname);
TakeAwayItem.Add(JobjMenu);
}
}
}
MenuJarray = TakeAwayItem;
}
jObject.Add("MenuItems", MenuJarray);
jObject.Add("SeatingAmt", CurrentTableAmt);
SeatingArray.Add(jObject);
}
JobjResonse.Add("Seating", SeatingArray);
JobjResonse.Add("FlrScrList", JArray.FromObject(FlrScr));
JobjResonse.Add("UserCode", OrderType.UserCode());
JobjResonse.Add("OrgType", ObjOrg.OrgTypes);// restuarant / theataer
JobjResonse.Add("OrgId", OrgId);
return(JobjResonse);
}
//=========FEEDBACK API===========
public JObject FeedBack(Int64 OID, int CID)
{
HG_Orders hG_Orders = new HG_Orders().GetOne(OID);
HG_Tables_or_Sheat Seating = new HG_Tables_or_Sheat().GetOne(hG_Orders.Table_or_SheatId);
JObject respose = new JObject();
if (Seating.FDBKId > 0)// feedback applied in seating
{
FeedbkForm feedbkForm = FeedbkForm.GetOne(Seating.FDBKId);
List <FeedBackQue> feedBackQues = FeedBackQue.GetAll(feedbkForm.Id);
feedBackQues = feedBackQues.FindAll(x => x.Status);
feedBackQues = feedBackQues.OrderBy(x => x.OrderNo).ToList();
respose.Add("Status", 200);
JArray jArray = new JArray();
foreach (var question in feedBackQues)
{
JObject jObject = new JObject();
jObject.Add("QID", question.ID);
jObject.Add("Title", question.Title);
jObject.Add("QuestionType", question.QuestionType);
jObject.Add("FeedBkFormID", question.FeedBkFormID);
if (question.Title.Contains("ITEM FEEDBACK") && (question.QuestionType == 0 || question.QuestionType == 3))
{
jObject["Title"] = "ITEM FEEDBACK";
List <HG_OrderItem> hG_OrderItems = new HG_OrderItem().GetAll(OID);
hG_OrderItems = hG_OrderItems.FindAll(x => x.Status == 3);
hG_OrderItems = hG_OrderItems.FindAll(x => x.OrdById == CID);
JArray itemfeedbks = new JArray();
for (int i = 0; i < hG_OrderItems.Count; i++)
{
HG_Items Objfood = new HG_Items().GetOne(hG_OrderItems[i].FID);
JObject ItemJobj = new JObject();
ItemJobj.Add("ItmId", hG_OrderItems[i].FID);//FID is ItemId
ItemJobj.Add("ItmName", Objfood.Items);
itemfeedbks.Add(ItemJobj);
}
jObject.Add("Items", itemfeedbks);
}
if (question.QuestionType == 1)
{
List <FeedbkObj> objectivesList = FeedbkObj.GetAll(question.ID);
FeedbkObj firstt = objectivesList.FirstOrDefault();
jObject.Add("ObjectiveType", firstt.ObjectiveType);
jObject.Add("Objectives", JArray.FromObject(objectivesList));
}
jArray.Add(jObject);
}
//=====add customer review comment in last at feedback
JObject jObject2 = new JObject();
jObject2.Add("QID", 0);
jObject2.Add("Title", "");
jObject2.Add("QuestionType", 5);
jObject2.Add("FeedBkFormID", 0);
jArray.Add(jObject2);
respose.Add("Questions", jArray);
}
else
{
respose.Add("Status", 400);
}
return(respose);
}
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));
}
