public ActionResult simulator() { //var importClient = db.Import.OrderByDescending(d => d.Date).Where(c => c.Type == TypeImport.Client).First(); //var proc = db.assort.Where(a => a.ImportId == importClient.Id).GroupBy(e => e.Ean13); List <AssortViewModelcs> Lassort = new List <AssortViewModelcs>(); Import import = this.db.Import.OrderByDescending(d => d.Date).Where(c => c.Type == TypeImport.Client).OrderByDescending(d => d.Date).First(); var proc = db.Procurement.ToList().GroupBy(e => e.Ean13); using (var context = new ScanDbContext()) { Lassort = context.Database .SqlQuery <AssortViewModelcs>("GETSimulator") .ToList(); } List <SimulationViewModel> LSimulationViewModel = new List <SimulationViewModel>(); foreach (var item in Lassort) { SimulationViewModel sm = new SimulationViewModel(); sm.Ean13 = item.Ean13; sm.label = item.Label; sm.StockReel = item.quantity; //sm.Price = item.Price; sm.OrderedQte = 0; sm.QteSales = 0; sm.M1 = 0; sm.M2 = 0; sm.M3 = 0; LSimulationViewModel.Add(sm); } return(PartialView("_simulator", LSimulationViewModel)); }
// GET: Scan public ActionResult Diff() { List <Import> imports = new List <Import>(); List <ImportViewModel> Limports = new List <ImportViewModel>(); imports = this.db.Import.ToList(); List <ScanViewModel> LscanviewModel = new List <ScanViewModel>(); using (var context = new ScanDbContext()) { LscanviewModel = context.Database .SqlQuery <ScanViewModel>("GETScanViewModel") .ToList(); } foreach (Import import in imports) { ImportViewModel importViewModel = new ImportViewModel() { Id = import.Id, ClientId = import.ClientId, //Assort = LassortViewModel, Scans = LscanviewModel.Where(i => i.importID == import.Id).ToList(), Date = import.Date.ToShortDateString(), Type = import.Type }; Limports.Add(importViewModel); } return(View("Import", Limports)); }
public ActionResult DeleteImport(int Id) { var import = new Import { Id = Id }; List <ScanViewModel> LscanviewModel = new List <ScanViewModel>(); using (var context = new ScanDbContext()) { LscanviewModel = context.Database .SqlQuery <ScanViewModel>("GETScanViewModel") .ToList(); } List <ScanViewModel> scanViewModels = LscanviewModel.Where(s => s.importID == Id).ToList(); ImportViewModel importmodel = new ImportViewModel() { Id = import.Id, ClientId = import.ClientId, Scans = scanViewModels, Type = import.Type, Date = import.Date.ToShortDateString() }; db.Entry(import).State = EntityState.Deleted; db.SaveChanges(); return(Json(importmodel)); }
public async Task <ActionResult> Create(OperationViewModel operationViewModel) { await importImmo(operationViewModel.files[0]); using (var context = new ScanDbContext()) { var beginDate = new SqlParameter("@beginDate", operationViewModel.beginDate); var endDate = new SqlParameter("@endDate", operationViewModel.endDate); var operations = await Task.Run(() => context.Database .SqlQuery <Operation>("ImportImmo @beginDate, @endDate", beginDate, endDate).ToList()); } List <OperationViewModel> operationViewModels = new List <OperationViewModel>(); foreach (var operation in db.Operation.ToList().OrderByDescending(o => o.RecordDate)) { OperationViewModel operationView = new OperationViewModel() { Id = operation.Id, beginDate = operation.beginDate, endDate = operation.endDate, Number = operation.Number }; operationViewModels.Add(operationView); } return(await Task.Run(() => RedirectToAction("DisplayOperation", "Scan"))); }
public ActionResult Details(int Id) { List <ScanViewModel> LscanviewModel = new List <ScanViewModel>(); using (var context = new ScanDbContext()) { LscanviewModel = context.Database .SqlQuery <ScanViewModel>("GETScanViewModel") .ToList(); } Import import = this.db.Import.ToList().Where(i => i.Id == Id).FirstOrDefault(); List <ScanViewModel> scanViewModels = LscanviewModel.Where(s => s.importID == Id).ToList(); return(View("Details", scanViewModels)); }
public ActionResult selectByCategorie(string categorie) { List <ResultScan> LresultScan = new List <ResultScan>(); List <assort> Lassort = new List <assort>(); Import import = this.db.Import.OrderByDescending(d => d.Date).Where(c => c.Type == TypeImport.Scan).OrderByDescending(d => d.Date).First(); using (var context = new ScanDbContext()) { var ImportId = new SqlParameter("@ImportId", import.Id); LresultScan = context.Database .SqlQuery <ResultScan>("GETScanResult @ImportId", ImportId) .ToList(); } List <ResultScan> resultCategorie = LresultScan.Where(c => c.catégorie == categorie).ToList(); return(Json(resultCategorie, JsonRequestBehavior.AllowGet));; }
public ActionResult DisplayCounting(Guid OperationId) { List <CountingProductFileViewModel> LCounting = new List <CountingProductFileViewModel>(); if (OperationId != Guid.Empty) { using (var context = new ScanDbContext()) { var operationId = new SqlParameter("@OperationId", OperationId); LCounting = context.Database .SqlQuery <CountingProductFileViewModel>("GetCountingProductFile @OperationId", operationId) .ToList(); } } return(View(LCounting)); }
public ActionResult DisplayResult() { List <ResultScan> LresultScan = new List <ResultScan>(); List <assort> Lassort = new List <assort>(); if (this.db.Import.Count() > 0) { Import import = this.db.Import.OrderByDescending(d => d.Date).Where(c => c.Type == TypeImport.Scan).OrderByDescending(d => d.Date).First(); using (var context = new ScanDbContext()) { var ImportId = new SqlParameter("@ImportId", import.Id); LresultScan = context.Database .SqlQuery <ResultScan>("GETScanResult @ImportId", ImportId) .ToList(); } } return(View(LresultScan)); }