public ActionResult ChangeStateWork([Bind(Include = "WorkListId,DateIn,DateOut,DateModifcation,Deadline,QueryId,WorkTypeId,PersonExecId,StateWorkId,Verification,Comment")] jWorkList jWorkList)
{
if (ModelState.IsValid)
{
db.Entry(jWorkList).State = EntityState.Modified;
if (jWorkList.StateWorkId == db.hStateWork.First(m => m.Description == "Выполнена").StateWorkId || jWorkList.StateWorkId == db.hStateWork.First(m => m.Description == "Отклонена").StateWorkId)
{
jWorkList.DateOut = DateTime.Parse(DateTime.Today.ToShortDateString());
}
if (Convert.ToInt32(TempData["oldState"]) != jWorkList.StateWorkId)
{
jJournal jJur = new jJournal();
jJur.Date = DateTime.Now;
jJur.EventTypeId = db.hEventType.First(m => m.Description == "Смена статуса работы").EventTypeId;
jJur.WorkListId = jWorkList.WorkListId;
jJur.PersonId = User.Identity.GetUserId();
jJur.QueryID = jWorkList.QueryId;
hStateWork oldst = db.hStateWork.Find(Convert.ToInt32(TempData["oldState"]));
hStateWork newst = db.hStateWork.Find(jWorkList.StateWorkId);
jJur.Description = "c " + oldst.Description + " на " + newst.Description;
CloseQuery(jWorkList.QueryId);
db.jJournal.Add(jJur);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PersonExecId = new SelectList(db.AspNetUsers, "Id", "Fio", jWorkList.PersonExecId);
ViewBag.StateWorkId = new SelectList(db.hStateWork, "StateWorkId", "Description", jWorkList.StateWorkId);
ViewBag.WorkTypeId = new SelectList(db.hWorkType, "WorkTypeId", "Description", jWorkList.WorkTypeId);
ViewBag.QueryId = new SelectList(db.jQuery, "QueryId", "Text", jWorkList.QueryId);
return(View(jWorkList));
}
public ActionResult DeleteConfirmed(int id)
{
hStateWork hStateWork = db.hStateWork.Find(id);
db.hStateWork.Remove(hStateWork);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "StateWorkId,Description")] hStateWork hStateWork)
{
if (ModelState.IsValid)
{
db.Entry(hStateWork).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hStateWork));
}
public ActionResult Create([Bind(Include = "StateWorkId,Description")] hStateWork hStateWork)
{
if (ModelState.IsValid)
{
db.hStateWork.Add(hStateWork);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hStateWork));
}
// GET: hStateWorks/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
hStateWork hStateWork = db.hStateWork.Find(id);
if (hStateWork == null)
{
return(HttpNotFound());
}
return(View(hStateWork));
}
