public async Task <IActionResult> Edit(Guid id, [Bind("ScheduledOn,ScheduledBy,Comments,GitHash,Name,IsActive")] ChecklistEntity checklistEntity) { if (id != checklistEntity.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(checklistEntity); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ChecklistEntityExists(checklistEntity.Id)) { return(NotFound()); } throw; } return(RedirectToAction(nameof(Index))); } return(View(checklistEntity)); }
public HrmResultEntity <bool> SaveChecklist(ChecklistEntity checklist, List <ChecklistDetailType> checklistdetail, string dbName) { var par = new DynamicParameters(); par.Add("@Id", checklist.Id); par.Add("@Name", checklist.Name); par.Add("@Note", checklist.Note); par.Add("@CreatedBy", checklist.CreatedBy); par.Add("@UpdatedBy", checklist.UpdatedBy); par.Add("@DbName", dbName); par.Add("@Checklistdetail", checklistdetail.ConvertToUserDefinedDataTable(), DbType.Object); return(Procedure("Checklist_Update_SaveFullChecklist", par)); }
public async Task <IActionResult> Create([Bind("SeletedTemplate,Name,IsActive,ScheduleFor,GitHash,Comments")] CreateChecklistViewModel viewModel) { if (!ModelState.IsValid) { var templates = _context.ChecklistTemplates .Where(x => x.IsActive) .Include(x => x.Environment) .Select(x => new SelectListItem { Text = $"{x.Environment.Name} - {x.Name}", Value = x.Id.ToString() }).ToList(); viewModel.Templates = templates; return(View(viewModel)); } var selectedTemplate = await _context.ChecklistTemplates .Include(x => x.TemplateTasks) .ThenInclude(x => x.Task) .Include(x => x.Environment) .SingleOrDefaultAsync(x => x.Id == viewModel.SeletedTemplate); if (selectedTemplate == null) { var templates = _context.ChecklistTemplates .Where(x => x.IsActive) .Include(x => x.Environment) .Select(x => new SelectListItem { Text = $"{x.Environment.Name} - {x.Name}", Value = x.Id.ToString() }).ToList(); viewModel.Templates = templates; return(View(viewModel)); } var checklistEntity = new ChecklistEntity { IsActive = viewModel.IsActive, Name = viewModel.Name, Comments = viewModel.Comments, ScheduledOn = viewModel.ScheduleFor, ScheduledBy = viewModel.ScheduleFor.HasValue ? User.Identity.Name : null, GitHash = viewModel.GitHash, Environment = selectedTemplate.Environment }; _context.Add(checklistEntity); await _context.SaveChangesAsync(); var checklistTasks = selectedTemplate.TemplateTasks .Select(x => new ChecklistTaskEntity { Id = Guid.NewGuid(), Task = x.Task, SortOrder = x.SortOrder, Checklist = checklistEntity }) .ToList(); foreach (var checklistTask in checklistTasks) { _context.ChecklistTasks.Add(checklistTask); } await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); }
public string SaveChecklist(ChecklistEntity checklist, List <Hrm.Repository.Type.ChecklistDetailType> checklistdetail) { var response = this._checklistRepository.SaveChecklist(checklist, checklistdetail, _dbName); return(JsonConvert.SerializeObject(response)); }