public ViewResult AddRecord()
{
Record_ViewModel recordViewModel = new Record_ViewModel();
recordViewModel.allRecords = sqlRepository.GetAllRecords();
ViewBag.type = "create";
return(View("Record_view", recordViewModel));
}
public IActionResult UpdateRecord(Record_ViewModel recordViewModel)
{
Record record = new Record();
record = recordViewModel.record;
record.Silo = sqlRepository.GetAllSilos().FirstOrDefault(s => s.Name == recordViewModel.record.Silo.Name);
sqlRepository.UpdateRecord(record);
return(RedirectToAction("Record"));
}
public ViewResult Record()
{
Record_ViewModel recordViewModel = new Record_ViewModel();
//recordViewModel.allRecords = sqlRepository.GetAllRecords();
recordViewModel.siloNames = sqlRepository.GetAllSilos().Select(s => s.Name);
recordViewModel.siloName = "All";
//recordViewModel.startDate = new DateTime(2020, 10, 10);
//recordViewModel.siloName = recordViewModel.siloNames.FirstOrDefault();
return(View("Record_view", recordViewModel));
}
public ViewResult UpdateRecord(int id)
{
Record_ViewModel recordViewModel = new Record_ViewModel();
recordViewModel.allRecords = sqlRepository.GetAllRecords();
recordViewModel.record = sqlRepository.FindRecord(id);
recordViewModel.siloNames = sqlRepository.GetAllSilos().Select(s => s.Name);
ViewBag.type = "update";
return(View("Record_view", recordViewModel));
//var x = recordViewModel.allRecords.Select(r => new { r.Silo.ID, r.Silo.Name, });
}
public ViewResult Record(Record_ViewModel recordViewModel)
{
recordViewModel.siloNames = sqlRepository.GetAllSilos().Select(s => s.Name);
recordViewModel.allRecords = sqlRepository.GetAllRecords();
if (recordViewModel.siloName != null && recordViewModel.siloName != "All")
{
recordViewModel.allRecords = recordViewModel.allRecords.Where(r => r.Silo.Name == recordViewModel.siloName);
}
return(View("Record_View", recordViewModel));
}
