public ActionResult ChangeStatusQuery([Bind(Include = "QueryId,DateOut,DateIn,DateModification,DeadLine,Text,StateId,PersonId,PersonSpId")] jQuery jQuery)
{
if (ModelState.IsValid)
{
db.Entry(jQuery).State = EntityState.Modified;
if (jQuery.StateId == db.hState.First(m => m.Description == "Выполнена").StateId || jQuery.StateId == db.hState.First(m => m.Description == "Отклонена").StateId)
{
jQuery.DateOut = DateTime.Parse(DateTime.Today.ToShortDateString());
}
if (Convert.ToInt32(TempData["oldState"]) != jQuery.StateId)
{
jJournal jJur = new jJournal();
jJur.Date = DateTime.Now;
jJur.EventTypeId = db.hEventType.First(m => m.Description == "Смена статуса заявки").EventTypeId;
jJur.WorkListId = null;
jJur.PersonId = User.Identity.GetUserId();
jJur.QueryID = jQuery.QueryId;
hState oldst = db.hState.Find(Convert.ToInt32(TempData["oldState"]));
hState newst = db.hState.Find(jQuery.StateId);
jJur.Description = "c " + oldst.Description + " на " + newst.Description;
db.jJournal.Add(jJur);
}
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PersonId = new SelectList(db.AspNetUsers, "Id", "Fio", jQuery.PersonId);
ViewBag.PersonSpId = new SelectList(db.AspNetUsers, "Id", "Fio", jQuery.PersonSpId);
ViewBag.StateId = new SelectList(db.hState, "StateId", "Description", jQuery.StateId);
return(View(jQuery));
}
public ActionResult Edit([Bind(Include = "WorkListId,DateIn,DateOut,DateModifcation,Deadline,QueryId,WorkTypeId,PersonExecId,StateWorkId,Verification,Comment")] jWorkList jWorkList)
{
if (ModelState.IsValid)
{
db.Entry(jWorkList).State = EntityState.Modified;
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 Edit([Bind(Include = "Id,Email,EmailConfirmed,PasswordHash,SecurityStamp,PhoneNumber,PhoneNumberConfirmed,TwoFactorEnabled,LockoutEndDateUtc,LockoutEnabled,AccessFailedCount,UserName,Fio")] AspNetUsers aspNetUsers)
{
if (ModelState.IsValid)
{
db.Entry(aspNetUsers).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(aspNetUsers));
}
public ActionResult Edit([Bind(Include = "EventTypeId,Description")] hEventType hEventType)
{
if (ModelState.IsValid)
{
db.Entry(hEventType).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(hEventType));
}
public ActionResult Edit([Bind(Include = "WorkTypeId,Description,SkillId")] hWorkType hWorkType)
{
if (ModelState.IsValid)
{
db.Entry(hWorkType).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SkillId = new SelectList(db.hSkill, "SkillId", "Description", hWorkType.SkillId);
return(View(hWorkType));
}
public ActionResult Edit([Bind(Include = "UserId,RoleId,UserRoleId")] AspNetUserRoles aspNetUserRoles)
{
if (ModelState.IsValid)
{
db.Entry(aspNetUserRoles).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RoleId = new SelectList(db.AspNetRoles, "Id", "Name", aspNetUserRoles.RoleId);
ViewBag.UserId = new SelectList(db.AspNetUsers, "Id", "Fio", aspNetUserRoles.UserId);
return(View(aspNetUserRoles));
}
public ActionResult Edit([Bind(Include = "SkillListId,SkillId,PersonId")] jSkillList jSkillList)
{
if (ModelState.IsValid)
{
db.Entry(jSkillList).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SkillId = new SelectList(db.hSkill, "SkillId", "Description", jSkillList.SkillId);
ViewBag.PersonId = new SelectList(db.AspNetUsers, "Id", "Fio", jSkillList.PersonId);
return(View(jSkillList));
}
public ActionResult Edit([Bind(Include = "Date,EventTypeId,WorkListId,Description,JournalId,PersonId,QueryID")] jJournal jJournal)
{
if (ModelState.IsValid)
{
db.Entry(jJournal).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PersonId = new SelectList(db.AspNetUsers, "Id", "Email", jJournal.PersonId);
ViewBag.EventTypeId = new SelectList(db.hEventType, "EventTypeId", "Description", jJournal.EventTypeId);
ViewBag.WorkListId = new SelectList(db.jWorkList, "WorkListId", "PersonExecId", jJournal.WorkListId);
return(View(jJournal));
}
