public HttpResponseMessage GetStockByID(HttpRequestMessage request, int ID) { StockRepository stockRepo = new StockRepository(); tbStock result = stockRepo.GetDataSet().Where(a => a.IsDeleted != true && a.ID == ID).FirstOrDefault(); return(request.CreateResponse <tbStock>(HttpStatusCode.OK, result)); }
public HttpResponseMessage UpsertItem(HttpRequestMessage request, tbItem tbItem) { ItemRepository itemRepo = new ItemRepository(); StockRepository stockRepo = new StockRepository(); tbItem UpdatedEntity = null; tbStock tbstock = new tbStock(); if (tbItem.ID > 0) { UpdatedEntity = itemRepo.update(tbItem); } else { tbItem.UniqueID = Guid.NewGuid(); tbItem.IsDeleted = false; tbItem.Accesstime = DateTime.UtcNow.ToLocalTime(); UpdatedEntity = itemRepo.Add(tbItem); tbstock.ItemGUID = tbItem.UniqueID; tbstock.CinemaID = 0; tbstock.IsDeleted = false; tbstock.Accesstime = DateTime.UtcNow.ToLocalTime(); tbstock.StockStatus = "Stock Register"; tbstock.StockQty = 0; tbstock.ThresholdQty = 0; stockRepo.Add(tbstock); } return(request.CreateResponse <tbItem>(HttpStatusCode.OK, UpdatedEntity)); }
//UpSertStock public async Task <ActionResult> UpSertStock(tbStock tbStock) { var url = "api/Stock/UpsertStock"; tbStock result = await APIRequest <tbStock> .Post(url, tbStock); if (result != null) { return(Json("Success", JsonRequestBehavior.AllowGet)); } else { return(Json("Fail", JsonRequestBehavior.AllowGet)); } }
public HttpResponseMessage UpsertInventory(HttpRequestMessage request, tbInventory tbInventory) { Context ctx = new Context(); InventoryRepository inventoryRepo = new InventoryRepository(ctx); StockRepository stockRepo = new StockRepository(ctx); tbInventory UpdatedEntity = null; //if (tbInventory.ID > 0) //{ // UpdatedEntity = inventoryRepo.update(tbInventory); //} if (tbInventory.TransactionType == "2") //Transaction Type : Justifity { tbStock tbStock = stockRepo.GetDataSet().Where(a => a.IsDeleted != true && a.ItemGUID == tbInventory.ItemGUID).FirstOrDefault(); if (tbStock.StockQty >= tbInventory.Qty)// Check the given quantity is enough or not in the stock table. { tbInventory.FlowType = "Justify"; tbInventory.Accesstime = DateTime.UtcNow.ToLocalTime(); tbInventory.IsDeleted = false; tbInventory.UniqueID = Guid.NewGuid(); tbInventory.TotalItemPrice = Convert.ToDecimal(tbInventory.ItemPrice * tbInventory.Qty); UpdatedEntity = inventoryRepo.Add(tbInventory); tbStock tbStock1 = stockRepo.GetDataSet().Where(a => a.IsDeleted != true && a.ItemGUID == tbInventory.ItemGUID).FirstOrDefault(); tbStock1.StockQty -= tbInventory.Qty; stockRepo.update(tbStock1); } else { return(request.CreateResponse <tbInventory>(HttpStatusCode.OK, UpdatedEntity));; } } else { tbInventory.FlowType = "StockIn"; tbInventory.Accesstime = DateTime.UtcNow.ToLocalTime(); tbInventory.IsDeleted = false; tbInventory.UniqueID = Guid.NewGuid(); tbInventory.TotalItemPrice = Convert.ToDecimal(tbInventory.ItemPrice * tbInventory.Qty); UpdatedEntity = inventoryRepo.Add(tbInventory); tbStock tbStock = stockRepo.GetDataSet().Where(a => a.IsDeleted != true && a.ItemGUID == tbInventory.ItemGUID).FirstOrDefault(); tbStock.StockQty += tbInventory.Qty; stockRepo.update(tbStock); } return(request.CreateResponse <tbInventory>(HttpStatusCode.OK, UpdatedEntity)); }
//_StockForm public async Task <ActionResult> _StockForm(string FormType, int ID) { tbStock tbStock = new tbStock(); if (FormType == "Add") { return(PartialView("_StockForm", tbStock)); } else { string url = string.Format("api/Stock/GetStockByID?ID={0}", ID); tbStock result = await APIRequest <tbStock> .Get(url); return(PartialView("_StockForm", result)); } }
public HttpResponseMessage UpsertStock(HttpRequestMessage request, tbStock tbStock) { StockRepository stockRepo = new StockRepository(); tbStock UpdatedEntity = null; if (tbStock.ID > 0) { UpdatedEntity = stockRepo.update(tbStock); } else { tbStock.IsDeleted = false; tbStock.Accesstime = DateTime.UtcNow.ToLocalTime(); UpdatedEntity = stockRepo.Add(tbStock); } return(request.CreateResponse <tbStock>(HttpStatusCode.OK, UpdatedEntity)); }
public HttpResponseMessage UpsertOrderDetail(HttpRequestMessage request, string items) { #region Instances Context ctx = new Context(); ItemRepository itemRepo = new ItemRepository(ctx); StockRepository stockRepo = new StockRepository(ctx); OrderRepository orderRepo = new OrderRepository(ctx); OrderDetailRepository orderDetailRepo = new OrderDetailRepository(ctx); InventoryRepository inventoryRepo = new InventoryRepository(ctx); tbItem tbItem = new tbItem(); tbStock tbStock = new tbStock(); tbInventory tbInventory = new tbInventory(); tbOrder tbOrder = new tbOrder(); tbOrderDetail tbOrderDetail = new tbOrderDetail(); tbOrder UpdatedOrder = null; tbOrderDetail UpdatedEntity = null; decimal totalPrice = 0; string voucherCode = Guid.NewGuid().ToString(); #endregion #region insert order table tbOrder.StaffGUID = "Default"; tbOrder.StaffName = "Default"; tbOrder.CinemaId = 1; tbOrder.CinemaName = ""; tbOrder.VoucherCode = voucherCode; tbOrder.Accesstime = DateTime.UtcNow.ToLocalTime(); tbOrder.IsDeleted = false; tbOrder.TotalPrice = totalPrice; tbOrder.CreatedAt = DateTime.UtcNow.ToLocalTime(); tbOrder.Status = "Default"; tbOrder.ServiceFees = 0; tbOrder.SubTotalPrice = tbOrder.TotalPrice; tbOrder.TotalTax = 0; tbOrder.TaxIncluded = false; tbOrder.Currency = ""; tbOrder.TotalDiscounts = 0; tbOrder.TotalItemPrice = tbOrder.TotalPrice; tbOrder.DiscountCode = ""; tbOrder.Remark = ""; UpdatedOrder = orderRepo.Add(tbOrder); #endregion List <string> itemList = items.Split(',').ToList(); foreach (string item in itemList) { string[] idVal = item.Split('|').ToArray(); string itemGUID = idVal[0]; int qty = Convert.ToInt32(idVal[1]); tbItem = itemRepo.GetDataSet().Where(a => a.IsDeleted != true && a.UniqueID.ToString() == itemGUID).FirstOrDefault(); //if(tbStock.StockQty>=qty) //{ } #region Add order detail. tbOrderDetail.ItemID = tbItem.ID; tbOrderDetail.ItemName = tbItem.Item; tbOrderDetail.ItemPrice = tbItem.SellingPrice; tbOrderDetail.ItemQty = qty; tbOrderDetail.TotalPrice = tbOrderDetail.ItemPrice * qty; totalPrice += Convert.ToDecimal(tbOrderDetail.TotalPrice); tbOrderDetail.VoucherCode = voucherCode; tbOrderDetail.OrderID = UpdatedOrder.ID; tbOrderDetail.CinemaID = tbOrder.CinemaId; tbOrderDetail.CinemaName = tbOrder.CinemaName; tbOrderDetail.IsDeleted = false; UpdatedEntity = orderDetailRepo.Add(tbOrderDetail); #endregion #region update stock table. tbStock = stockRepo.GetDataSet().Where(s => s.IsDeleted != true && s.ItemGUID.ToString() == itemGUID && s.CinemaID == tbOrder.CinemaId).FirstOrDefault(); tbStock.StockQty = tbStock.StockQty - qty; tbStock.Accesstime = DateTime.UtcNow.ToLocalTime(); stockRepo.update(tbStock); #endregion #region update inventory table. tbInventory.FlowType = "StockOut"; tbInventory.ItemPrice = tbItem.SellingPrice; tbInventory.TotalItemPrice = totalPrice; tbInventory.IsDeleted = false; tbInventory.Accesstime = DateTime.UtcNow.ToLocalTime(); tbInventory.UniqueID = Guid.NewGuid(); tbInventory.ItemGUID = tbItem.UniqueID; tbInventory.ItemName = tbItem.Item; tbInventory.TransactionType = "3"; //TransactionType:3 (StockOut) tbInventory.CinemaID = tbOrder.CinemaId; tbInventory.Qty = qty; inventoryRepo.Add(tbInventory); #endregion } #region update total price to order table tbOrder = orderRepo.GetDataSet().Where(x => x.IsDeleted != true && x.VoucherCode == voucherCode).FirstOrDefault(); tbOrder.TotalPrice = totalPrice; tbOrder.TotalItemPrice = totalPrice; orderRepo.update(tbOrder); #endregion return(request.CreateResponse <tbOrderDetail>(HttpStatusCode.OK, UpdatedEntity)); }