public ActionResult SelectWarehouse(string warehouse, int lineitemid, int fileid) { if (warehouse.Length != 0 || lineitemid != 0 || fileid != 0) { try { var lineitem = _context.LineItems.FirstOrDefault(l => l.Id == lineitemid); string warehousename = ""; switch (warehouse) { case "4": warehousename = "Antrepo(Izmir)"; break; case "2": warehousename = "Warehouse Izmir"; break; case "5": warehousename = "Warehouse Istabul"; break; } var warehouseprice = GetPriceByWarehouseAndImpa(warehouse, lineitem.Impa, fileid); if (lineitem != null) { lineitem.SelectedSupplierName = warehousename; lineitem.SelectedSupplierId = warehouse; lineitem.SelectedSupplierPrice = warehouseprice; lineitem.SelectedSupplierCalculatedPrice = warehouseprice; lineitem.SelectedSupplierRemark = ""; lineitem.IsWareHouseSelected = true; _context.SaveChanges(); } var lineItem = _context.LineItems.Include("ReferanceNumber").FirstOrDefault(l => l.Id == lineitemid); var file = _context.Files.FirstOrDefault(f => f.Id == lineItem.ReferanceNumber.FileId); var lineitemsuppliers = _context.ViewSupplierPriceLineItems.Where(s => s.LineItemId == lineitemid).ToList(); var viewModelorg = new LineItemPricingEditViewModel { LineItemSuppliers = lineitemsuppliers, LineItem = lineItem, File = file }; return(Edit(viewModelorg)); } catch (Exception e) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Supplier Selection ERROR !!!" + e.Message)); } } return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Supplier Selection ERROR !!!")); }
public ActionResult SelectSupplier(int id, int lineitemid, int fileid) { if (id != 0 || lineitemid != 0 || fileid != 0) { try { var lineitem = _context.LineItems.FirstOrDefault(l => l.Id == lineitemid); var lineitemsupplier = _context.ViewSupplierPriceLineItems.Include("OfferMaster").FirstOrDefault(s => s.Id == id); if (lineitem != null) { if (lineitemsupplier != null) { lineitem.SelectedSupplierName = lineitemsupplier.SupplierName; lineitem.SelectedSupplierCurrency = lineitemsupplier.Currency; lineitem.SelectedSupplierId = lineitemsupplier.OfferMaster.SupplierId; lineitem.SelectedSupplierPrice = lineitemsupplier.SupplierPrice; lineitem.SelectedSupplierRemark = lineitemsupplier.Comment; lineitem.SelectedSupplierCalculatedPrice = lineitemsupplier.RealPrice; lineitem.SelectedSupplierTurkishDefinition = lineitemsupplier.TurkishDescription; lineitem.IsWareHouseSelected = false; _context.SaveChanges(); } } var lineItem = _context.LineItems.Include("ReferanceNumber").FirstOrDefault(l => l.Id == lineitemid); var file = _context.Files.FirstOrDefault(f => f.Id == lineItem.ReferanceNumber.FileId); var lineitemsuppliers = _context.ViewSupplierPriceLineItems.Where(s => s.LineItemId == lineitemid).ToList(); var viewModelorg = new LineItemPricingEditViewModel { LineItemSuppliers = lineitemsuppliers, LineItem = lineItem, File = file }; return(Edit(viewModelorg)); } catch (Exception e) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Supplier Selection ERROR !!!" + e.Message)); } } return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Supplier Selection ERROR !!!")); }
public ActionResult ClearSupplier(int lineitemid, int fileid) { if (lineitemid != 0) { try { var lineitem = _context.LineItems.FirstOrDefault(l => l.Id == lineitemid); if (lineitem != null) { lineitem.SelectedSupplierName = ""; lineitem.SelectedSupplierId = ""; lineitem.SelectedSupplierPrice = 0; lineitem.SelectedSupplierCalculatedPrice = 0; lineitem.SelectedSupplierRemark = ""; lineitem.IsWareHouseSelected = false; _context.SaveChanges(); } var lineItem = _context.LineItems.Include("ReferanceNumber").FirstOrDefault(l => l.Id == lineitemid); var file = _context.Files.FirstOrDefault(f => f.Id == lineItem.ReferanceNumber.FileId); var lineitemsuppliers = _context.ViewSupplierPriceLineItems.Where(s => s.LineItemId == lineitemid).ToList(); var viewModelorg = new LineItemPricingEditViewModel { LineItemSuppliers = lineitemsuppliers, LineItem = lineItem, File = file }; return(Edit(viewModelorg)); } catch (Exception e) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Supplier Selection ERROR !!!" + e.Message)); } } return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Supplier Selection ERROR !!!")); }
public ActionResult Edit(int?id, int?fileid) { if (id == null || fileid == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest, "Line item id and File id should be selected !!!")); } var lineItem = _context.LineItems.Include("ReferanceNumber").FirstOrDefault(l => l.Id == id); var file = _context.Files.FirstOrDefault(f => f.Id == lineItem.ReferanceNumber.FileId); var lineitemsuppliers = _context.ViewSupplierPriceLineItems.Where(s => s.LineItemId == id).ToList(); var viewModel = new LineItemPricingEditViewModel { LineItemSuppliers = lineitemsuppliers, LineItem = lineItem, File = file }; return(View(viewModel)); }
public ActionResult Edit(LineItemPricingEditViewModel viewModel) { if (ModelState.IsValid) { var EditedItem = _context.LineItems.First(x => x.Id == viewModel.LineItem.Id); string newimpa = viewModel.LineItem.Impa; string oldimpa = EditedItem.Impa; EditedItem.Impa = viewModel.LineItem.Impa; EditedItem.Description = viewModel.LineItem.Description; EditedItem.Number = viewModel.LineItem.Number; EditedItem.Qtty = viewModel.LineItem.Qtty; EditedItem.Unit = viewModel.LineItem.Unit; EditedItem.AltQtty = viewModel.LineItem.AltQtty; EditedItem.AltUnit = viewModel.LineItem.AltUnit; EditedItem.AltPrice = viewModel.LineItem.AltPrice; EditedItem.Remark = viewModel.LineItem.Remark; EditedItem.Price = viewModel.LineItem.Price; _context.SaveChanges(); //if impa has changed add definedsuppliers if (oldimpa != newimpa) { var oldsuppliers = _context.SupplierPriceLineItems.Where(s => s.LineItemId == EditedItem.Id).ToList(); foreach (var item in oldsuppliers) { item.Deleted = true; } var changedsuppliers = _context.LineItemSuppliers.Where(x => x.LineItem.Id == EditedItem.Id).ToList(); foreach (var item in changedsuppliers) { item.ImpaChanged = true; } _context.SaveChanges(); //tedarikçi kaydı // master kaydı var mı kontrol edilecek // fiyatlandırma için eski fiyat kayıtları girilecek var referance = _context.ReferanceNumbers.FirstOrDefault(r => r.Id == EditedItem.ReferanceNumberId); AddExistingSuppliers(EditedItem.Impa, EditedItem.Id, referance.FileId); // AddDefinedSuppliers(EditedItem.Impa, EditedItem.Id,referance.FileId).GetAwaiter(); } return(RedirectToAction("Index", new { id = viewModel.LineItem.ReferanceNumber.FileId })); } var lineItem = _context.LineItems.Include("ReferanceNumber").FirstOrDefault(l => l.Id == viewModel.LineItem.Id); var file = _context.Files.FirstOrDefault(f => f.Id == lineItem.ReferanceNumber.FileId); var lineitemsuppliers = _context.ViewSupplierPriceLineItems.Where(s => s.LineItemId == viewModel.LineItem.Id).ToList(); var viewModelorg = new LineItemPricingEditViewModel { LineItemSuppliers = lineitemsuppliers, LineItem = lineItem, File = file }; return(View(viewModelorg)); }