public ActionResult MainTableSave(MainTable mainTable)
{
if (!ModelState.IsValid)
{
var viewModel = new MainTableFormViewModel
{
MainTable = mainTable,
Plcs = _context.Plcs.ToList(),
Units = _context.Units.ToList(),
Labels = _context.Labels.ToList(),
Titles = _context.Titles.ToList()
};
return(View("MainTableForm", viewModel));
}
if (mainTable.Id == 0)
{
_context.MainTables.Add(mainTable);
_context.SaveChanges();
//duplicate new id parameter to IdAsc for asc or desc
var mainTableInDb = _context.MainTables.Single(c => c.Id == mainTable.Id);
mainTableInDb.IdAsc = mainTable.Id;
// _context.SaveChanges();
// populate MainTablePropertie table
var viewModel = new MainTablePropertie
{
MainTablePropertieId = mainTable.Id,
SclMax = 100,
SclMin = 0,
IsCutOffMax = false,
CutOffMax = 100,
IsCutOffMin = false,
CutOffMin = 0
};
_context.MainTableProperties.Add(viewModel);
_context.SaveChanges();
}
else
{
var mainTableInDb = _context.MainTables.Single(c => c.Id == mainTable.Id);
mainTableInDb.LabelId = mainTable.LabelId;
mainTableInDb.PlcId = mainTable.PlcId;
mainTableInDb.UnitId = mainTable.UnitId;
mainTableInDb.TitleId = mainTable.TitleId;
mainTableInDb.IsContainer = mainTable.IsContainer;
mainTableInDb.Container = mainTable.Container;
_context.SaveChanges();
}
// _context.SaveChanges();
return(RedirectToAction("MainTable", "Parameters"));
}
public ActionResult MainTableNew()
{
var units = _context.Units.ToList();
var plcs = _context.Plcs.ToList();
var titles = _context.Titles.ToList();
var labels = _context.Labels.ToList();
var viewModel = new MainTableFormViewModel
{
MainTable = new MainTable(),
Units = units,
Plcs = plcs,
Titles = titles,
Labels = labels
};
return(View("MainTableForm", viewModel));
}
public ActionResult MainTableEdit(int id)
{
var mainTables = _context.MainTables.SingleOrDefault(c => c.Id == id);
if (mainTables == null)
{
return(HttpNotFound());
}
var viewModel = new MainTableFormViewModel
{
MainTable = mainTables,
Plcs = _context.Plcs.ToList(),
Labels = _context.Labels.ToList(),
Titles = _context.Titles.ToList(),
Units = _context.Units.ToList()
};
return(View("MainTableForm", viewModel));
}
