public ActionResult InputItem(tblItem model, int?id)
{
if (ModelState.IsValid)
{
if (id > 0)
{
var cm = db.tblItem.Where(x => x.Id == id).FirstOrDefault();
cm.Id = Convert.ToInt32(id);
cm.ItemName = model.ItemName;
cm.ItemDesc = model.ItemDesc;
cm.UOM = model.UOM;
db.Entry(cm).State = EntityState.Modified;
db.SaveChanges();
ModelState.Clear();
TempData["msg"] = "Update Succussfully";
return(RedirectToAction("ItemDetails"));
}
else
{
model.ItemName = model.ItemName;
model.ItemDesc = model.ItemDesc;
model.UOM = model.UOM;
model.Status = true;
db.tblItem.Add(model);
db.SaveChanges();
ModelState.Clear();
TempData["msg"] = " Created Successfully";
return(RedirectToAction("ItemDetails"));
}
}
return(View());
}
//-> uploadimages
public async Task <ItemViewDTO> UploadImages(ItemUploadImageDTO itemUploadImage)
{
tblItem item = db.tblItems.FirstOrDefault(r => r.item_Deleted == null && r.id == itemUploadImage.id);
if (item == null)
{
throw new HttpException((int)HttpStatusCode.NotFound, "This record does not exsists or has been deleted");
}
using (var transaction = db.Database.BeginTransaction())
{
try
{
List <sm_doc> documents = await DocumentHelper.SaveUploadImage(db, ConstantHelper.document_ItemTableID, itemUploadImage.id, itemUploadImage.base64s);
transaction.Commit();
return(await SelectByID(item.id));
}
catch (Exception ex)
{
transaction.Rollback();
throw new Exception(ex.Message);
}
}
}
public ActionResult DeleteConfirmed(int id)
{
tblItem tblItem = db.tblItems.Find(id);
db.tblItems.Remove(tblItem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult AddOrEdit(int id = 0)
{
if (id == 0)
{
using (OnlineFoodDBEntities db = new OnlineFoodDBEntities())
{
ViewBag.SubMenus = db.tblSubMenus.ToList();
ViewBag.Action = "Create New Item";
return(View(new ItemViewModel()));
}
}
else
{
using (OnlineFoodDBEntities db = new OnlineFoodDBEntities())
{
ViewBag.Action = "Edit Item";
ViewBag.Menus = db.tblSubMenus.ToList();
tblItem item = db.tblItems.Where(i => i.ItemId == id).FirstOrDefault();
ItemViewModel itemvm = new ItemViewModel();
itemvm.ItemId = item.ItemId;
itemvm.SubMenuId = Convert.ToInt32(item.SubMenuId);
itemvm.Title = item.Title;
itemvm.Price = item.Price;
itemvm.Description = item.Description;
itemvm.SmallImage = item.SmallImage;
itemvm.LargeImage = item.LargeImage;
//HttpPostedFileBase fup = Request.Files["SmallImage"];
//if(fup!=null)
//{
// if(fup.FileName!="")
// {
// fup.SaveAs(Server.MapPath("~/img/dogaccessories" + fup.FileName));
// }
//}
//HttpPostedFileBase fup1 = Request.Files["LargeImage"];
//if (fup1 != null)
//{
// if (fup1.FileName != "")
// {
// fup1.SaveAs(Server.MapPath("~/img/dogaccessories" + fup1.FileName));
// itemvm.LargeImage = item.LargeImage;
// }
//}
itemvm.IsAvailable = "Available";
ViewBag.SubMenus = db.tblSubMenus.ToList();
return(View(itemvm));
}
}
}
public ActionResult Delete(int id)
{
using (OnlineFoodDBEntities db = new OnlineFoodDBEntities())
{
tblItem sm = db.tblItems.Where(x => x.ItemId == id).FirstOrDefault();
db.tblItems.Remove(sm);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Edit([Bind(Include = "ItemId,ItemDescription,IsPicked,SectorId,InventoryId")] tblItem tblItem)
{
if (ModelState.IsValid)
{
db.Entry(tblItem).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("IndexItem", new { sectorId = tblItem.SectorId, inventoryId = tblItem.InventoryId }));
}
ViewBag.InventoryId = new SelectList(db.tblInventories, "InventoryId", "InventoryName", tblItem.InventoryId);
ViewBag.SectorId = new SelectList(db.tblSectors, "SectorId", "SectorName", tblItem.SectorId);
return(View(tblItem));
}
public ActionResult AddProduct(string code, string name, string fabric, string priceO, string discount, string priceNet, int cat, string mcat, int lotId, string articleId, string desc, string[] picsArr)
{
try
{
int assignedID = 0;
using (linqDBContext db = new linqDBContext())
{
int getCatId = (from a in db.tblMainCategories where a.name == mcat select a.id).FirstOrDefault();
tblItem it = new tblItem();
it.itemCode = code;
it.itemName = name;
it.fabric = fabric;
it.originalPrice = Convert.ToDecimal(priceO);
it.discount = Convert.ToDecimal(discount);
it.netPrice = Convert.ToDecimal(priceNet);
it.subCategory = cat;
it.mainCategory = getCatId;
it.description = desc;
it.tag = "";
it.articleId = articleId;
it.lotId = lotId;
it.date = Convert.ToDateTime(DateTime.Now.ToShortDateString());
db.tblItems.Add(it);
db.SaveChanges();
assignedID = it.id;
if (picsArr != null)
{
foreach (var item in picsArr)
{
//var physicalPath = Path.Combine(Server.MapPath(subPath), item);
tblItemPicture p = new tblItemPicture();
p.itemID = assignedID;
p.picLocation = item;
db.tblItemPictures.Add(p);
db.SaveChanges();
}
}
}
return(Json(new JsonResult()
{
Data = assignedID
}, JsonRequestBehavior.AllowGet));
}
catch (Exception x)
{
return(Json(new { status = "error", Data = x.Message }, JsonRequestBehavior.AllowGet));
}
}
//-> Edit
public async Task <ItemViewDTO> Edit(ItemEditDTO editDTO)
{
editDTO = StringHelper.TrimStringProperties(editDTO);
tblItem item = db.tblItems.FirstOrDefault(r => r.item_Deleted == null && r.id == editDTO.id);
if (item == null)
{
throw new HttpException((int)HttpStatusCode.NotFound, "This record has been deleted");
}
var checkItemGroup = await db.tblItemGroups.FirstOrDefaultAsync(x => x.itmg_Deleted == null && x.id == editDTO.itemGroup.id); // check whether itemgroup name exist or not
if (checkItemGroup == null)
{
throw new HttpException((int)HttpStatusCode.BadRequest, "Item group not exists");
}
var checkItemCode = await db.tblItems.FirstOrDefaultAsync(r => r.item_Deleted == null && r.code == editDTO.code && r.id != editDTO.id);
if (checkItemCode != null)
{
throw new HttpException((int)HttpStatusCode.BadRequest, "This item code already exsits");
}
using (var transaction = db.Database.BeginTransaction())
{
try
{
if (string.IsNullOrEmpty(editDTO.description))
{
editDTO.description = editDTO.name;
}
item = (tblItem)Helper.Helper.MapDTOToDBClass <ItemEditDTO, tblItem>(editDTO, item);
item.item_UpdatedDate = DateTime.Now;
db.Entry(item).State = EntityState.Modified;
await db.SaveChangesAsync();
//TODO : need to handle delete images or delete documents
List <sm_doc> documents = await Helper.Helper.SaveUploadImage(db, item.name, Helper.Helper.document_ItemTableID, item.id, editDTO.images);// tmp not useful , just reserve data for using in the furture
transaction.Commit();
return(await SelectByID(item.id));
}
catch (Exception ex)
{
transaction.Rollback();
throw new Exception(ex.Message);
}
}
}
public ActionResult Create([Bind(Include = "ItemId,ItemDescription,IsPicked,SectorId,InventoryId")] tblItem tblItem)
{
if (ModelState.IsValid)
{
db.tblItems.Add(tblItem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.InventoryId = new SelectList(db.tblInventories, "InventoryId", "InventoryName", tblItem.InventoryId);
ViewBag.SectorId = new SelectList(db.tblSectors, "SectorId", "SectorName", tblItem.SectorId);
return(View(tblItem));
}
// GET: Items/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblItem tblItem = db.tblItems.Find(id);
if (tblItem == null)
{
return(HttpNotFound());
}
return(View(tblItem));
}
public ActionResult Create(tblItem data)
{
//try
//{
data.dtCreationDate = DateTime.Now;
ItemRepository.Add(data);
ItemRepository.SaveChanges();
return(Ok());
//}
//catch (Exception ex)
//{
// return new HttpStatusCodeResult(HttpStatusCode.NotFound);
//}
}
private async Task SaveItemToWarehouses(tblItem item)
{
var wareHouses = await db.tblWarehouses.Where(r => r.ware_Deleted == null).ToListAsync();
foreach (var wareHouse in wareHouses)
{
var itemWareHouse = new tblItemWarehouse();
itemWareHouse.itemID = item.id;
itemWareHouse.wareHouseID = wareHouse.id;
itemWareHouse.quantity = 0;
itemWareHouse.itwh_CreatedDate = DateTime.Now;
db.tblItemWarehouses.Add(itemWareHouse);
db.SaveChanges();
}
}
public ActionResult Deleteitem(int id)
{
try
{
tblItem tb = (from p in db.tblItems where p.ItemId == id select p).SingleOrDefault();
tb.Active = false;
db.SaveChanges();
TempData["Message"] = "Delete Successfully !!";
}
catch
{
ModelState.AddModelError("", "Error Occured !");
}
return(RedirectToAction("ItemDetails"));
}
//-> create
public async Task <ItemViewDTO> Create(ItemNewDTO newDTO)
{
newDTO = StringHelper.TrimStringProperties(newDTO);
var checkItemGroup = await db.tblItemGroups.FirstOrDefaultAsync(x => x.itmg_Deleted == null && x.id == newDTO.itemGroup.id); // check whether itemgroup name exist or not
if (checkItemGroup == null)
{
throw new HttpException((int)HttpStatusCode.BadRequest, "Item group not exist");
}
var checkItemCode = await db.tblItems.FirstOrDefaultAsync(r => r.item_Deleted == null && r.code == newDTO.code); // check whether itemgroup name exist or not
if (checkItemCode != null)
{
throw new HttpException((int)HttpStatusCode.BadRequest, "This item code already exsits");
}
using (var transaction = db.Database.BeginTransaction())
{
try
{
if (string.IsNullOrEmpty(newDTO.description))
{
newDTO.description = newDTO.name;
}
tblItem item = (tblItem)Helper.Helper.MapDTOToDBClass <ItemNewDTO, tblItem>(newDTO, new tblItem());
item.item_CreatedDate = DateTime.Now;
item.cost = 0;
item.quantity = 0;
item.lastCost = 0;
db.tblItems.Add(item);
await db.SaveChangesAsync();
List <sm_doc> documents = await Helper.Helper.SaveUploadImage(db, item.name, Helper.Helper.document_ItemTableID, item.id, newDTO.images);// tmp not useful , just reserve data for using in the furture
await SaveItemToWarehouses(item);
transaction.Commit();
return(await SelectByID(item.id));
}
catch (Exception ex)
{
transaction.Rollback();
throw new Exception(ex.Message);
}
}
}
public void updateDepartment(string ItemId, string DeptId)
{
int itemid = Convert.ToInt32(ItemId);
int deptid = Convert.ToInt32(DeptId);
tblItem tb = db.tblItems.Where(a => a.ItemId == itemid).SingleOrDefault();
tb.DepartmentId = deptid;
//tb.CategoryId = tb.CategoryId;
//tb.Description = tb.Description;
//tb.ItemCode = tb.ItemCode;
//tb.ItemImage = tb.ItemImage;
//tb.Name = model.Name;
//tb.Active = model.Active;
db.SaveChanges();
TempData["item"] = "Record Updated Successfully...";
}
public tblItem Additem(int Typeid, string itemname, string SL, int isconsumable, int reorderpoint, decimal price)
{
var add = new tblItem()
{
ItemName = itemname,
TypeId = Typeid,
StorageLocation = SL,
ReorderPoint = reorderpoint,
IsConsumable = isconsumable,
ItemPrice = price,
Availablestock = 0,
Qualityinspectionstock = 0,
};
return(add);
}
public ActionResult AddItem(AddItemModel model)
{
tblItem tb = new tblItem();
var itemcheck = (from p in db.tblItems where p.Name == model.Name && p.Active == true && p.CategoryId == model.ItemCategoryId select p).SingleOrDefault();
if (itemcheck == null)
{
try
{
if (model.ItemId > 0)
{
tb = (from p in db.tblItems where p.ItemId == model.ItemId select p).SingleOrDefault();
}
tb.CategoryId = model.ItemCategoryId;
tb.Description = model.Description;
tb.ItemCode = model.ItemCode;
tb.ItemImage = Image();
tb.Name = model.Name;
tb.Active = model.Active;
tb.DepartmentId = model.DepartmentId;
if (model.ItemId > 0)
{
db.SaveChanges();
TempData["item"] = "Edit Successfully..!";
return(RedirectToAction("ItemDetails"));
}
else
{
db.tblItems.Add(tb);
db.SaveChanges();
TempData["item"] = "Record Insert Successfully..!";
return(RedirectToAction("ItemDetails"));
}
}
catch (Exception ex)
{
TempData["item"] = ex.Message;
return(RedirectToAction("ItemDetails"));
}
}
else
{
TempData["itemCreate"] = "This Item is already exist in this Category..";
return(RedirectToAction("AddItem"));
}
}
public ActionResult InputItem(int?id, string E)
{
if (id > 0 && E == "D")
{
tblItem model = db.tblItem.Find(id);
db.Entry(model).State = EntityState.Deleted;
db.SaveChanges();
TempData["msg"] = "Deleted Sucessfully!";
return(RedirectToAction("ItemDetails"));
}
else if (id > 0)
{
tblItem model = db.tblItem.Find(id);
return(View(model));
}
return(View());
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
tblItem items = new tblItem();
if (db.tblItems.Any(d => d.Title == txtTitle.Text))
{
Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('" + txtTitle.Text + " " + "already exists!" + "');", true);
}
else
{
items.Title = txtTitle.Text;
items.SubSystemId = Int32.Parse(ddlSubSystem.SelectedValue);
db.tblItems.Add(items);
db.SaveChanges();
Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('Added successfully');", true);
txtTitle.Text = "";
}
}
/// <summary>
/// Adds the item if the itemID exists
/// </summary>
/// <param name="userID">the item that is being added for the user</param>
/// <param name="item">the item that is being added</param>
/// <returns>a new shopping cart element</returns>
public tblShoppingCart AddItem(tblItem item, int userID)
{
int cartId = CartExists(item.ItemID, userID);
try
{
using (OrderDBEntities context = new OrderDBEntities())
{
if (cartId == 0)
{
tblShoppingCart newShoppingCart = new tblShoppingCart
{
Amount = item.Amount,
UserID = userID,
ItemID = item.ItemID
};
context.tblShoppingCarts.Add(newShoppingCart);
context.SaveChanges();
return(newShoppingCart);
}
else
{
tblShoppingCart shoppingCartToEdit = (from ss in context.tblShoppingCarts where ss.ShoppingCartID == cartId select ss).First();
shoppingCartToEdit.Amount = item.Amount;
shoppingCartToEdit.UserID = shoppingCartToEdit.UserID;
shoppingCartToEdit.ItemID = shoppingCartToEdit.ItemID;
shoppingCartToEdit.ShoppingCartID = cartId;
context.SaveChanges();
return(shoppingCartToEdit);
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
// GET: Items/Edit/5
public ActionResult Edit(int?id, int sectorId, int inventoryId)
{
ViewBag.SectorId = sectorId;
ViewBag.InventoryId = inventoryId;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblItem tblItem = db.tblItems.Find(id);
if (tblItem == null)
{
return(HttpNotFound());
}
ViewBag.InventoryId = new SelectList(db.tblInventories, "InventoryId", "InventoryName", tblItem.InventoryId);
ViewBag.SectorId = new SelectList(db.tblSectors, "SectorId", "SectorName", tblItem.SectorId);
return(View(tblItem));
}
/// <summary>
/// Deletes item from shopping chart
/// </summary>
/// <param name="item">the item that is being deleted</param>
/// <param name="userID">the user that has the item</param>
public void RemoveItem(tblItem item, int userID)
{
int cartId = CartExists(item.ItemID, userID);
try
{
using (OrderDBEntities context = new OrderDBEntities())
{
tblShoppingCart shoppingCartToRemove = (from r in context.tblShoppingCarts where r.ShoppingCartID == cartId select r).First();
context.tblShoppingCarts.Remove(shoppingCartToRemove);
context.SaveChanges();
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public ActionResult Create(ItemViewModel itm)
{
tblItem tb = new tblItem();
tb.ItemTitle = itm.ItemTitle;
tb.ItemPrice = itm.ItemPrice;
tb.ItemStatus = itm.ItemStatus;
tb.Description = itm.Description;
HttpPostedFileBase fup = Request.Files["ItemPhoto"];
if (fup != null)
{
tb.ItemPhoto = fup.FileName;
fup.SaveAs(Server.MapPath("~/images/Vehicle/" + fup.FileName));
}
_db.tblItems.Add(tb);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult EditItem(AddItemModel model)
{
try
{
tblItem tb = db.tblItems.Where(a => a.ItemId == model.ItemId).SingleOrDefault();
tb.CategoryId = model.ItemCategoryId;
tb.DepartmentId = model.DepartmentId;
tb.Description = model.Description;
tb.ItemCode = model.ItemCode;
tb.ItemImage = Image();
tb.Name = model.Name;
tb.Active = model.Active;
db.SaveChanges();
TempData["item"] = "Record Updated Successfully...";
return(RedirectToAction("ItemDetails"));
}
catch
{
TempData["item"] = "Record Not Updated !";
return(RedirectToAction("AddItem", new { id = model.ItemId }));
}
}
public void Additems(tblItem obj)
{
context.tblItems.Add(obj);
}
/// <summary>
///
/// </summary>
/// <param name="item"></param>
/// <returns></returns>
public bool AddEditItem(Items item)
{
tblItem tblItem = new tblItem();
if (item != null && item.ItemGuid != Guid.Empty)
{
tblItem = bringlyEntities.tblItems
.Where(x => x.FK_CreatedByGuid == UserVariables.LoggedInUserGuid && x.ItemName == item.ItemName && x.ItemGuid != item.ItemGuid)
.FirstOrDefault();
if (tblItem != null)
{
return(false);
}
else
{
tblItem.ItemGuid = item.ItemGuid;
tblItem.ItemName = item.ItemName;
tblItem.FK_CategoryGuid = item.CategoryGuid;
tblItem.FK_BusinessGuid = item.BusinessGuid;
tblItem.DeliveryCharge = item.DeliveryCharge;
tblItem.ItemImage = item.ItemImage;
tblItem.ItemName = item.ItemName;
tblItem.ItemWeight = item.ItemWeight;
tblItem.ItemSize = item.ItemSize;
tblItem.ItemPrice = item.ItemPrice;
tblItem.Discount = item.Discount;
tblItem.ModifiedDate = DateTime.Now;
tblItem.Modifiedby = UserVariables.LoggedInUserGuid;
}
}
else
{
tblItem = bringlyEntities.tblItems
.Where(x => x.FK_CreatedByGuid == UserVariables.LoggedInUserGuid && x.ItemName == item.ItemName)
.FirstOrDefault();
if (tblItem != null)
{
return(false);
}
else
{
tblItem = new tblItem();
tblItem.ItemGuid = Guid.NewGuid();
tblItem.FK_CreatedByGuid = UserVariables.LoggedInUserGuid;
tblItem.ItemName = item.ItemName;
tblItem.FK_CategoryGuid = item.CategoryGuid;
tblItem.FK_BusinessGuid = item.BusinessGuid;
tblItem.DeliveryCharge = item.DeliveryCharge;
tblItem.ItemImage = string.IsNullOrEmpty(item.ItemImage) ? DefaultImage : item.ItemImage;
tblItem.ItemWeight = item.ItemWeight;
tblItem.ItemSize = item.ItemSize;
tblItem.ItemPrice = item.ItemPrice;
tblItem.Discount = item.Discount;
tblItem.DateCreated = DateTime.Now;
tblItem.IsActive = item.IsActive;
tblItem.IsDeleted = false;
bringlyEntities.tblItems.Add(tblItem);
}
}
bringlyEntities.SaveChanges();
return(true);
}
public ActionResult AddOrEdit(ItemViewModel ivm)
{
using (OnlineFoodDBEntities db = new OnlineFoodDBEntities())
{
if (ivm.ItemId == 0)
{
tblItem itm = new tblItem();
itm.SubMenuId = Convert.ToInt32(ivm.SubMenuId);
itm.Title = ivm.Title;
itm.Price = ivm.Price;
itm.Description = ivm.Description;
HttpPostedFileBase fup = Request.Files["SmallImage"];
if (fup != null)
{
if (fup.FileName != "")
{
fup.SaveAs(Server.MapPath("~/images/ItemImages/" + fup.FileName));
itm.SmallImage = fup.FileName;
}
}
HttpPostedFileBase fup1 = Request.Files["LargeImage"];
if (fup1 != null)
{
if (fup1.FileName != "")
{
fup1.SaveAs(Server.MapPath("~/images/ItemImages/" + fup1.FileName));
itm.LargeImage = fup1.FileName;
}
}
itm.IsAvailable = "Available";
db.tblItems.Add(itm);
db.SaveChanges();
ViewBag.Message = "Updated Successfully";
}
else
{
tblItem itm = db.tblItems.Where(i => i.ItemId == ivm.ItemId).FirstOrDefault();
itm.SubMenuId = Convert.ToInt32(ivm.SubMenuId);
itm.Title = ivm.Title;
itm.Price = ivm.Price;
itm.Description = ivm.Description;
HttpPostedFileBase fup = Request.Files["SmallImage"];
if (fup != null)
{
if (fup.FileName != "")
{
fup.SaveAs(Server.MapPath("~/images/ItemImages/" + fup.FileName));
itm.SmallImage = fup.FileName;
}
}
HttpPostedFileBase fup1 = Request.Files["LargeImage"];
if (fup1 != null)
{
if (fup1.FileName != "")
{
fup1.SaveAs(Server.MapPath("~/images/ItemImages/" + fup1.FileName));
itm.LargeImage = fup1.FileName;
}
}
db.SaveChanges();
ViewBag.Message = "Updated Successfully";
}
ViewBag.SubMenus = db.tblSubMenus.ToList();
return(View(new ItemViewModel()));
}
}
public ActionResult ItemDetails()
{
var itemsKOT = (from p in dbKOT.VM_PAOItemsFood select p).ToList();
var itemsCount = (from p in db.tblItems select p).ToList().Count;
if (itemsKOT.Count > itemsCount)
{
foreach (var item in itemsKOT)
{
var itemCategoryId = (from p in db.tblCategories where p.Name == item.ItemSubGroup select p.CategoryId).FirstOrDefault();
var itemcheck = (from p in db.tblItems where p.Name == item.ItemName && p.CategoryId == itemCategoryId select p).SingleOrDefault();
if (itemcheck == null)
{
tblItem tb = new tblItem();
tb.CategoryId = itemCategoryId;
tb.DepartmentId = 2;
tb.Description = item.AdditionalDetails;
tb.ItemCode = item.ItemCode;
tb.ItemImage = "";
tb.Name = item.ItemName;
tb.Active = true;
db.tblItems.Add(tb);
db.SaveChanges();
}
}
}
List <SelectListItem> CategoryList = (from m in db.tblCategories where m.Active == true select m).AsEnumerable().Select(m => new SelectListItem()
{
Text = m.Name, Value = m.CategoryId.ToString()
}).ToList();
CategoryList.Add(new SelectListItem()
{
Text = "--Select Category-- ", Value = "0"
});
CategoryList = CategoryList.OrderBy(o => o.Value).ToList();
//CategoryList.Sort();
ViewBag.categoryLIsts = new SelectList(CategoryList, "Value", "Text", "CategoryId");
List <SelectListItem> DepartmentList = (from m in db.tbl_Department where m.Active == true select m).AsEnumerable().Select(m => new SelectListItem()
{
Text = m.Department, Value = m.DepartmentID.ToString()
}).ToList();
DepartmentList.Add(new SelectListItem()
{
Text = "--Select Department-- ", Value = "0"
});
DepartmentList = DepartmentList.OrderBy(o => o.Value).ToList();
ViewBag.departmentLists = new SelectList(DepartmentList, "Value", "Text", "DepartmentId");
var data = (from p in db.tblItems where p.Active == true select p).ToList();
//var rotiya = (from p in db.tblItems where p.Active == true && p.CategoryId==73 select p).ToList();
List <AddItemModel> List = new List <AddItemModel>();
foreach (var item in data)
{
AddItemModel model = new AddItemModel();
model.ItemCategoryId = item.CategoryId;
model.Name = item.Name;
model.Description = item.Description;
model.ItemCode = item.ItemCode;
model.ItemId = item.ItemId;
model.ItemImage = item.ItemImage;
model.DepartmentId = item.DepartmentId;
//model.MinimumQuantity = item.MinimumQuantity;
model.Name = item.Name;
//model.Unit = item.Unit;
List.Add(model);
}
return(View(List));
}
public EditPOModel()
{
Order = new PM_Order();
stock = new tblStock();
Items = new tblItem();
}
public ActionResult UpdateReceipt(ReceiptViewModel oReceiptViewModel)
{
try
{
int userId = ((tblUser)Session["Admin"]).UserId;
// updates receipt details
tblReceipt receipt = db.tblReceipts.Where(m => m.ReceiptId == oReceiptViewModel.ReceiptId).FirstOrDefault();
receipt.SupplierName = oReceiptViewModel.SupplierName;
receipt.BillingDate = oReceiptViewModel.BillingDate;
receipt.LocationName = oReceiptViewModel.LocationName;
receipt.Note = oReceiptViewModel.Note;
receipt.TotalBillAmount = oReceiptViewModel.TotalBillAmount;
db.Entry(receipt).State = EntityState.Modified;
db.SaveChanges();
// updates receipt items
if (oReceiptViewModel.ListOfReceiptItem != null)
{
foreach (var item in oReceiptViewModel.ListOfReceiptItem)
{
tblItem otblItem = db.tblItems.Where(m => m.ItemId == item.ItemId && m.ReceiptId == oReceiptViewModel.ReceiptId).FirstOrDefault();
otblItem.ItemName = item.ItemName;
otblItem.Quantity = item.Quantity;
otblItem.Price = item.Price;
db.Entry(otblItem).State = EntityState.Modified;
db.SaveChanges();
}
}
List <tblUserReceiptTag> userTags = (from d in db.tblUserReceiptTags
where d.ReceiptId == oReceiptViewModel.ReceiptId
select d).ToList();
// if user tags does not have any tags then add all items
if (userTags.Count == 0)
{
if (oReceiptViewModel.TagIds != null)
{
foreach (int tid in oReceiptViewModel.TagIds)
{
tblUserReceiptTag receiptTag = new tblUserReceiptTag();
receiptTag.TagsId = tid;
receiptTag.ReceiptId = oReceiptViewModel.ReceiptId;
receiptTag.UserId = userId;
db.tblUserReceiptTags.Add(receiptTag);
db.SaveChanges();
}
}
}
else
{
// if tagids dont have any tag then delete all tags
if (oReceiptViewModel.TagIds == null)
{
foreach (tblUserReceiptTag usertag in userTags)
{
db.tblUserReceiptTags.Remove(usertag);
db.SaveChanges();
}
}
else
{
foreach (tblUserReceiptTag usertag in userTags)
{
bool isAvailable = oReceiptViewModel.TagIds.Contains(usertag.TagsId.Value);
if (isAvailable == false)
{
tblUserReceiptTag receiptTag = (from y in db.tblUserReceiptTags
where y.TagsId == usertag.TagsId
select y).FirstOrDefault();
db.tblUserReceiptTags.Remove(receiptTag);
db.SaveChanges();
}
}
foreach (int tagId in oReceiptViewModel.TagIds)
{
var checkIsAvailable = userTags.Where(m => m.TagsId == tagId).FirstOrDefault();
// if not availble
if (checkIsAvailable == null)
{
tblUserReceiptTag receiptTag = new tblUserReceiptTag();
receiptTag.TagsId = tagId;
receiptTag.ReceiptId = oReceiptViewModel.ReceiptId;
receiptTag.UserId = userId;
db.tblUserReceiptTags.Add(receiptTag);
db.SaveChanges();
}
}
}
}
TempData["Success"] = "Receipt updated successfully.";
return(RedirectToAction("ReceiptsList", "Receipts", new { page = Convert.ToInt32(Session["page"]), search = Session["Search"], area = "Admin" }));
}
catch (Exception ex)
{
GlobalVariable.objWriteLog.PrintMessage(Server.MapPath("~/ErrorLog/"), ex.Message);
throw ex;
}
}
