public ActionResult Index()
{
//var prod = null;
HomeData data = new HomeData();
data.Today = DateTime.Now;
DayProduction dProd = new DayProduction();
dProd.Location = "Sülm";
dProd.LstProdDetail = new List <Detail>();
data.Production = dProd;
view_dailyProduction prodList = new view_dailyProduction();
using (KTBDataManagerEntities context = new KTBDataManagerEntities())
{
var prod = from p in context.view_dailyProduction where p.PROD_DATE == new DateTime(2018, 4, 27).Date
select new
{
article = p.ARTICLE,
unit = p.UNIT,
value = p.VALUE,
location = p.LOCATION
};
foreach (var pr in prod)
{
dProd.LstProdDetail.Add(new Detail()
{
Name = pr.article, Unit = pr.unit, Value = (decimal)pr.value
});
}
}
return(View(data));
}
public async Task <IActionResult> Create(ProductProdactionViewModel productProdactionViewModel)
{
DayProduction dayProduction = _context.DayProductions.Where(d => d.Date.Equals(productProdactionViewModel.Date)).FirstOrDefault();
if (dayProduction == null)
{
_context.DayProductions.Add(new DayProduction {
Date = productProdactionViewModel.Date
});
await _context.SaveChangesAsync();
dayProduction = _context.DayProductions.Where(d => d.Date.Equals(productProdactionViewModel.Date)).FirstOrDefault();
}
ProductsProduction productsProduction = productProdactionViewModel.ProductsProduction;
productsProduction.DayProductionId = dayProduction.DayProductionId;
_context.Add(productsProduction);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
public async Task <IActionResult> Edit(int id, ProductProdactionViewModel productProdactionViewModel)
{
if (id != productProdactionViewModel.ProductsProduction.ProductProductionId)
{
return(NotFound());
}
DayProduction dayProduction = _context.DayProductions.Where(d => d.Date.Equals(productProdactionViewModel.Date)).FirstOrDefault();
if (dayProduction == null)
{
_context.DayProductions.Add(new DayProduction {
Date = productProdactionViewModel.Date
});
await _context.SaveChangesAsync();
dayProduction = _context.DayProductions.Where(d => d.Date.Equals(productProdactionViewModel.Date)).FirstOrDefault();
}
ProductsProduction productsProduction = productProdactionViewModel.ProductsProduction;
productsProduction.DayProductionId = dayProduction.DayProductionId;
try
{
_context.Update(productsProduction);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ProductsProductionExists(productsProduction.ProductProductionId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
