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