public IActionResult Create(Guid?id)
{
var x = db.TblTempRows.Find(id);
if (x == null)
{
x = new web_db._temp.TblTempRow();
}
return(View(x));
}
public IActionResult Create(web_db._temp.TblTempRow temp)
{
if (ModelState.IsValid)
{
var x = db.TblTempRows.Any(a => a.Id == temp.Id);
if (x == false)
{
temp.Id = Guid.NewGuid();
temp.DateAdd = DateTime.Now;
db.TblTempRows.Add(temp);
}
else
{
db.TblTempRows.Update(temp);
}
db.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
return(View(temp));
}
public IActionResult addTempRow(Guid?id, Guid?idTemp, string?location)
{
var model = db.TblTempRows.Include(a => a.FktempNavigation).SingleOrDefault(a => a.Id == id);
if (model == null)
{
var lll = Models.cl._ListLocation.Single(a => a.CodeFull == location);
var l = Models.cl.GuidToLocationId(lll.Id);
model = new web_db._temp.TblTempRow
{
FkLocation1 = l[0],
FkLocation2 = l[1],
FkLocation3 = l[2],
Fktemp = idTemp.Value,
FktempNavigation = db.TblTemps.Find(idTemp),
Location = location,
};
}
var ll = new[] { model.FkLocation1, model.FkLocation2, model.FkLocation3 };
var rows = db.TblTempRows.Where(a => a.Fktemp == model.Fktemp && ll.Contains(a.FkLocation1) && ll.Contains(a.FkLocation2) && ll.Contains(a.FkLocation3)).AsEnumerable();
if ((id.HasValue == false) && db.TblTemps.Find(model.Fktemp).FkuserTaiid.HasValue == true)
{
if (rows.Any())
{
return(RedirectToAction("addTempRow", new { id = rows.First().Id }));
}
else
{
return(Content("داده وجود ندارد"));
}
}
ViewBag.rows = rows;
return(View(model));
}
public IActionResult addTempRow(web_db._temp.TblTempRow model)
{
if (db.TblTemps.Find(model.Fktemp).FkuserTaiid.HasValue == false)
{
if (db.TblTempRows.Any(a => a.Id == model.Id))
{
model.FkUserEdit = User._getuserid();
model.DateEdit = DateTime.Now;
db.TblTempRows.Update(model);
}
else
{
model.Id = Guid.NewGuid();
model.FkUserAdd = User._getuserid().Value;
model.DateAdd = DateTime.Now;
db.TblTempRows.Add(model);
}
}
db.SaveChanges();
return(RedirectToAction("Temp", new { id = model.Fktemp }));
}
