public ActionResult EditPrisoner(Prisoners prisoner) { var id = System.Web.HttpContext.Current.User.Identity.GetUserId(); if (ModelState.IsValid) { var history = new ChangesHistory() { Worker_Id = id, Date = DateTime.Now.Date }; _db.Entry(prisoner).State = EntityState.Modified; var prisonerChangesHistory = new PrisonerChangesHistory() { PrisonerName = prisoner.PrisonerName, PrisonerSurname = prisoner.PrisonerSurname, Pesel = prisoner.Pesel, FK_PrisonerChangesHistory_Prisoner_Id = prisoner.Prisoner_Id, Sex = prisoner.Sex, FK_PrisonerChangesHistory_ChangesHistory_Id = history.Record_Id }; _db.ChangesHistory.Add(history); _db.PrisonerChangesHistory.Add(prisonerChangesHistory); _db.SaveChanges(); return(RedirectToAction("GetPrisoners", "Prisoners")); } return(View(prisoner)); }
public ActionResult EditJudgement(EditJudgementViewModel model) { var list = _db.CategoriesOfCrimes.ToList(); ViewBag.KatList = new SelectList(list, "CategoryOfCrime_Id", "NameOfCategory"); var id = System.Web.HttpContext.Current.User.Identity.GetUserId(); if (ModelState.IsValid) { var history = new ChangesHistory { Worker_Id = id, Date = DateTime.Now.Date }; _db.Entry(model.Judgement).State = EntityState.Modified; var judgementChangesHistory = new JudgementsChangesHistory { Prisoner_id = model.Prisoner_Id, Time = model.Judgement.TimeOfJudgement, Date = model.Judgement.StartDate, FK_JudgementsChangesHistory_ChangesHistory_Id = history.Record_Id, FK_JudgementsChangesHistory_Judgements = model.Judgement.Judgement_Id, CategoryOfCrimes_Id = model.Judgement.FK_Judgements_CategoriesOfCrimes_Id }; _db.ChangesHistory.Add(history); _db.JudgementsChangesHistory.Add(judgementChangesHistory); _db.SaveChanges(); var idTemp = judgementChangesHistory.Prisoner_id; return(RedirectToAction("ReallocatePrisoner", new { id = idTemp })); } return(View(model)); }
public ActionResult ReallocatePrisoner(AllocationViewModel model) { var id = System.Web.HttpContext.Current.User.Identity.GetUserId(); var cell = _db.Cells.FirstOrDefault(x => x.Cell_Id == model.Cell_Id); if (cell == null) { return(HttpNotFound()); } var count = _db.Allocation.Count(x => x.FK_Allocation_Cells_Id == cell.Cell_Id); if (cell.IsEmpty && count < cell.Size) { var allocation = _db.Allocation.FirstOrDefault(s => s.FK_Allocation_Prisoners_Id == model.Prisoner_Id); if (allocation != null) { allocation.FK_Allocation_Cells_Id = cell.Cell_Id; _db.Entry(allocation).State = EntityState.Modified; } var history = new ChangesHistory() { Worker_Id = id, Date = DateTime.Now.Date }; var allocationHistory = new AllocationChangesHistory() { Cell_Id = cell.Cell_Id, FK_AllocationChangesHistory_ChangesHistory_Id = history.Record_Id, FK_AllocationChangesHistory_Allocation_Id = allocation.FK_Allocation_Prisoners_Id }; if (count + 1 == cell.Size) { cell.IsEmpty = false; _db.Entry(cell).State = EntityState.Modified; } if (count - 1 < cell.Size) { cell.IsEmpty = true; _db.Entry(cell).State = EntityState.Modified; } _db.ChangesHistory.Add(history); _db.AllocationChangesHistory.Add(allocationHistory); _db.SaveChanges(); return(RedirectToAction("GetPrisoners", "Prisoners")); } return(View(model)); }
public static SyncStatus GetSyncStatus(SqlBase source_con, Guid guid, SyncStatus SyncStatus) { var history = source_con.Table <SyncHistory>().FirstOrDefault(x => x.Guid == guid); if (history is null) { ChangesHistory changes = source_con.Table <ChangesHistory>().FirstOrDefault(x => x.Guid == guid); if (changes is null) { //Has been downloaded by Daemon service since daemon downloads dont get inserted here SyncStatus = SyncStatus.Done; return(SyncStatus); } if (SyncStatus == SyncStatus.Failed) { return(SyncStatus.Failed); } SyncStatus = SyncStatus.Pending; return(SyncStatus.Pending); } SyncStatus = SyncStatus.Done; return(SyncStatus.Done); }
public async Task <IActionResult> OnGetAsync(string id) { if (id == null) { return(NotFound()); } MtdStore = await _context.MtdStore.FirstOrDefaultAsync(m => m.Id == id); if (MtdStore == null) { return(NotFound()); } var user = await _userHandler.GetUserAsync(HttpContext.User); bool isViewer = await _userHandler.IsViewer(user, MtdStore.MtdForm, MtdStore.Id); IsEditor = await _userHandler.IsEditor(user, MtdStore.MtdForm, MtdStore.Id); IsInstallerOwner = await _userHandler.IsInstallerOwner(user, MtdStore.MtdForm, MtdStore.Id); if (!isViewer) { return(Forbid()); } MtdForm = await _context.MtdForm.Include(m => m.InverseParentNavigation).FirstOrDefaultAsync(x => x.Id == MtdStore.MtdForm); MtdLogDocument edited = await _context.MtdLogDocument.Where(x => x.MtdStore == MtdStore.Id).OrderByDescending(x => x.TimeCh).FirstOrDefaultAsync(); MtdLogDocument created = await _context.MtdLogDocument.Where(x => x.MtdStore == MtdStore.Id).OrderBy(x => x.TimeCh).FirstOrDefaultAsync(); StoreOwner = await _context.MtdStoreOwner.Where(x => x.Id == MtdStore.Id).FirstOrDefaultAsync(); ChangesHistory = new ChangesHistory { CreateByTime = MtdStore.Timecr.ToString() }; if (edited != null) { ChangesHistory.LastEditedUser = edited.UserName; ChangesHistory.LastEditedTime = edited.TimeCh.ToString(); } if (created != null) { if (MtdStore.Timecr.Date == created.TimeCh.Date) { ChangesHistory.CreateByUser = created.UserName; } } List <WebAppUser> webAppUsers = await _userHandler.GetUsersInGroupsAsync(user); ViewData["UsersList"] = new SelectList(webAppUsers, "Id", "Title"); ApprovalHandler approvalHandler = new ApprovalHandler(_context, MtdStore.Id); IsApprover = await approvalHandler.IsApproverAsync(user); IsFirstStage = await approvalHandler.IsFirstStageAsync(); IList <MtdApprovalStage> stages = await approvalHandler.GetStagesDownAsync(); ViewData["Stages"] = new SelectList(stages.OrderByDescending(x => x.Stage), "Id", "Name"); List <string> partIds = await approvalHandler.GetWilBeBlockedPartsIds(); BlockParts = new List <MtdFormPart>(); if (partIds.Count > 0) { BlockParts = await _context.MtdFormPart.Where(x => partIds.Contains(x.Id)).OrderBy(x => x.Sequence).ToListAsync(); } IsFormApproval = await approvalHandler.IsApprovalFormAsync(); if (IsFormApproval) { ApprovalStatus = await approvalHandler.GetStatusAsync(user); } return(Page()); }