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));
}
