/// <summary> /// </summary> /// <param name="obj"></param> /// <returns></returns> public long Add(ExpectedReceiptLine obj) { var expectedReceiptLine = _db.ExpectedReceiptLines.FirstOrDefault(x => x.ExpectedReceiptId == obj.ExpectedReceiptId && x.ItemCode == obj.ItemCode); if (expectedReceiptLine != null) { if (expectedReceiptLine.IsActive) { expectedReceiptLine.Quantity += obj.Quantity; } else { expectedReceiptLine.Quantity = obj.Quantity; expectedReceiptLine.UpdatedBy = obj.UpdatedBy; expectedReceiptLine.ExpiryDate = obj.ExpiryDate; expectedReceiptLine.IsActive = true; } _db.Entry(expectedReceiptLine).State = EntityState.Modified; _db.SaveChanges(); } else { _db.ExpectedReceiptLines.Add(obj); _db.SaveChanges(); } return(obj.Id); }
public bool Update(ExpectedReceiptLine obj) { //var getObj = GetById(obj.Id); //_db.Entry(getObj).State = System.Data.Entity.EntityState.Detached; _db.Entry(obj).State = EntityState.Modified; //_db.ExpectedReceiptLines.Attach(obj); _db.SaveChanges(); return(true); }
public bool UpdateLine(ExpectedReceiptLineBindingModel bindingModel) { Product product = _productRepository.GetByProductCode(bindingModel.ProductCode); Uom uom = _uomRepository.GetByDescription(bindingModel.UomDescription); Item item = _itemService.GetByItemCode(bindingModel.ItemCode, bindingModel.CustomerId); ExpectedReceiptLine expectedReceiptLine = new ExpectedReceiptLine { Id = (int)bindingModel.Id, ExpectedReceiptId = (int)bindingModel.ExpectedReceiptId, Line = bindingModel.Line, Batch = bindingModel.Batch, ProductId = product?.Id, Quantity = bindingModel.Quantity, BrandId = bindingModel.BrandId, ItemCode = bindingModel.ItemCode, ItemId = item?.Id, ItemDescription = bindingModel.ItemDescription, ExpiryDate = bindingModel.ExpiryDate, UomId = uom?.Id, CustomerId = bindingModel.CustomerId, IsItemExist = bindingModel.IsItemExist, IsActive = bindingModel.IsActive, IsChecked = bindingModel.IsChecked, DateCreated = bindingModel.DateCreated, DateUpdated = bindingModel.DateUpdated, CreatedBy = bindingModel.CreatedBy, UpdatedBy = bindingModel.UpdatedBy, StatusId = bindingModel.StatusId }; //return _expectedReceiptLineRepository.Update(expectedReceiptLine); if (IsDuplicateLine(expectedReceiptLine.ItemCode, expectedReceiptLine.Id, expectedReceiptLine.CustomerId) == false) { return(_expectedReceiptLineRepository.Update(expectedReceiptLine)); } else { return(false); } }
public bool UpdateLine(object obj) { var objModel = JObject.Parse(obj.ToString()); var bindingModel = objModel.ToObject <ExpectedReceiptLineBindingModel>(); Product product = _productRepository.GetByProductCode(bindingModel.ProductCode); var expectedReceiptLine = new ExpectedReceiptLine { Id = bindingModel.Id, ExpectedReceiptId = (int)bindingModel.ExpectedReceiptId, ProductId = product?.Id, UomId = bindingModel.UomId, Quantity = bindingModel.Quantity, BrandId = bindingModel.BrandId, Batch = bindingModel.Batch, ItemCode = bindingModel.ItemCode, ItemId = bindingModel.ItemId, Line = bindingModel.Line, ItemDescription = bindingModel.ItemDescription, ExpiryDate = bindingModel.ExpiryDate, Comments = bindingModel.Comments, Image = bindingModel.Image, CustomerId = bindingModel.CustomerId, IsItemExist = bindingModel.IsItemExist, IsActive = bindingModel.IsActive, IsChecked = bindingModel.IsChecked, DateCreated = bindingModel.DateCreated, DateUpdated = bindingModel.DateUpdated, CreatedBy = bindingModel.CreatedBy, UpdatedBy = bindingModel.UpdatedBy, StatusId = bindingModel.StatusId }; return(_expectedReceiptLineRepository.Update(expectedReceiptLine)); }
public async Task <ActionResult> Create([Bind(Include = "ExpectedReceiptId, CustomerId ProductId, UomId, CustomerId, Line, ProductCode, ItemDescription, ItemCode, ItemId, Batch, ExpiryDate," + " Quantity,UomDescription, BrandId, BrandName, IsChecked, ReferenceNumber, GoodsReceivedNumber, StatusCode, IsActive, CreatedBy, DateCreated, IsItemExist, StatusId")] ExpectedReceiptLine expectedReceiptLine) { expectedReceiptLine.IsChecked = false; expectedReceiptLine.IsActive = true; expectedReceiptLine.CreatedBy = CookieHelper.EmailAddress; expectedReceiptLine.IsItemExist = true; var url = "api/GoodsIn/ExpectedReceipt/Lines/Add"; var response = await HttpClientHelper.ApiCall(url, Method.POST, expectedReceiptLine); if (response.StatusCode == HttpStatusCode.Forbidden) { TempData["Message"] = expectedReceiptLine.ItemCode + " is already exist! Please check and try again."; TempData["MessageAlert"] = "warning"; return(RedirectToAction("Index")); } if (response.IsSuccessful) { TempData["Message"] = expectedReceiptLine.ItemDescription + " successfully created!"; TempData["MessageAlert"] = "success"; return(RedirectToAction("Index", new { id = expectedReceiptLine.ExpectedReceiptId, GoodsReceivedNumber = expectedReceiptLine.GoodsReceivedNumber, StatusCode = expectedReceiptLine.StatusCode, IsActive = expectedReceiptLine.IsActive })); } else { Error("An error has occurred"); Log.Error(string.Format(Type.GetType(typeof(ExpectedReceiptLinesController).Name) + "||Create||Expected Receipt Lines ID::{0}||API Response::{1}", expectedReceiptLine.Id, response)); return(RedirectToAction("Index", new { id = expectedReceiptLine.ExpectedReceiptId, GoodsReceivedNumber = expectedReceiptLine.GoodsReceivedNumber, StatusCode = expectedReceiptLine.StatusCode, IsActive = expectedReceiptLine.IsActive })); } return(PartialView(expectedReceiptLine)); //using (var client = new HttpClient()) //{ // var url = new Uri(ConfigHelper.BaseUrl) + "api/GoodsIn/ExpectedReceipt/Lines/Add"; // client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", CookieHelper.Token); // HttpResponseMessage responseMessage = await client.PostAsJsonAsync(url, expectedReceiptLine); // if (responseMessage.StatusCode == HttpStatusCode.Forbidden) // { // TempData["Message"] = expectedReceiptLine.ItemCode + " is already exist! Please check and try again."; // TempData["MessageAlert"] = "warning"; // return RedirectToAction("Index"); // } // if (responseMessage.IsSuccessStatusCode) // { // TempData["Message"] = "Line Successfully Created"; // TempData["MessageAlert"] = "success"; // return RedirectToAction("Index", "ExpectedReceiptLines", new { id = expectedReceiptLine.ExpectedReceiptId, GoodsReceivedNumber = expectedReceiptLine.GoodsReceivedNumber , StatusCode = expectedReceiptLine.StatusCode }); // } // else // { // Error("An error has occurred"); // Log.Error(string.Format(Type.GetType(typeof(ExpectedReceiptLinesController).Name) + "||Create||Expected Receipt Lines ID::{0}||API Response::{1}", expectedReceiptLine.Id, responseMessage)); // return RedirectToAction("Index", "ExpectedReceiptLines", new { id = expectedReceiptLine.ExpectedReceiptId, GoodsReceivedNumber = expectedReceiptLine.GoodsReceivedNumber, StatusCode = expectedReceiptLine.StatusCode }); // } //} //return PartialView(expectedReceiptLine); }
public void Detach(ExpectedReceiptLine obj) { _db.Entry(obj).State = EntityState.Detached; }
public bool Update(ExpectedReceiptLine obj) { return(_ExpectedReceiptLineRepository.Update(obj)); }
public long Add(ExpectedReceiptLine ExpectedReceiptLine) { return(_ExpectedReceiptLineRepository.Add(ExpectedReceiptLine)); }
public long AddLine(ExpectedReceiptLineBindingModel bindingModel) { Product product = _productRepository.GetByProductCode(bindingModel.ProductCode); Uom uom = _uomRepository.GetByDescription(bindingModel.UomDescription); var expectedReceiptLine = new ExpectedReceiptLine { ExpectedReceiptId = (int)bindingModel.ExpectedReceiptId, ProductId = product?.Id, UomId = uom?.Id, Quantity = bindingModel.Quantity, BrandId = bindingModel.BrandId, Batch = bindingModel.Batch, ItemCode = bindingModel.ItemCode, ItemId = bindingModel.ItemId, Line = bindingModel.Line, ItemDescription = bindingModel.ItemDescription, ExpiryDate = bindingModel.ExpiryDate, Comments = bindingModel.Comments, Image = bindingModel.Image, CustomerId = bindingModel.CustomerId, IsItemExist = bindingModel.IsItemExist, IsActive = bindingModel.IsActive, IsChecked = bindingModel.IsChecked, DateCreated = bindingModel.DateCreated, DateUpdated = bindingModel.DateUpdated, CreatedBy = bindingModel.CreatedBy, UpdatedBy = bindingModel.UpdatedBy, StatusId = 32 }; //var expectedReceiptLineId = _expectedReceiptLineRepository.Add(expectedReceiptLine); if (IsDuplicateLine(expectedReceiptLine.ItemCode, expectedReceiptLine.Id, expectedReceiptLine.CustomerId) == false) { return(_expectedReceiptLineRepository.Add(expectedReceiptLine)); } else { Expression <Func <ExpectedReceiptLine, bool> > res = x => x.ItemCode.ToLower() == expectedReceiptLine.ItemCode.ToLower() && x.CustomerId == expectedReceiptLine.CustomerId && x.IsActive == false; var getResult = _expectedReceiptLineRepository.Get(res); if (getResult != null) { expectedReceiptLine.Id = getResult.Id; expectedReceiptLine.IsActive = true; expectedReceiptLine.StatusId = 32; _expectedReceiptLineRepository.Detach(expectedReceiptLine); _expectedReceiptLineRepository.Update(expectedReceiptLine); return(expectedReceiptLine.Id); } else { return(0); } } ////Add Quantity on Items assign it to put away //if (expectedReceiptLineId != 0) //{ // Item item = _itemRepository.GetById(bindingModel.Id); // item.Qty += expectedReceiptLine.Quantity; // _itemRepository.Update(item); // //return expectedReceiptLineId; //} //return expectedReceiptLineId; }
public bool UpdateLine(ExpectedReceiptLine expectedReceiptLine) { return(_expectedReceiptLineRepository.Update(expectedReceiptLine)); }
public long AddLine(ExpectedReceiptLine expectedReceiptLine) { return(_expectedReceiptLineRepository.Add(expectedReceiptLine)); }