protected async Task OnFileSelected(InputFileChangeEventArgs eventArgs, AuditItemModel auditItem) { foreach (var file in eventArgs.GetMultipleFiles()) { auditItem.Photos.Add(new AuditItemPhotoModel { Name = $"audit_{Guid.NewGuid()}", File = file, ContentType = file.ContentType, Content = await file.GetResizedImageAsync(1000, _cancellationTokenSource.Token), PreviewUrl = await file.GetPreviewUrlAsync(300, _cancellationTokenSource.Token) }); } }
public static AuditItemDto CreateDto(this AuditItemModel model) { var dto = new AuditItemDto { Order = model.Order, Title = model.Title, IsCheckedAvailable = model.IsCheckedAvailable, IsChecked = model.IsChecked, IsCommentsAvailable = model.IsCommentsAvailable, Comments = model.Comments, IsPhotoAvailable = model.IsPhotoAvailable, Photos = model.Photos.Select(x => x.CreateDto()).ToList() }; return(dto); }
public static AuditItemModel CreateModel(this AuditItemDto dto) { var model = new AuditItemModel { Order = dto.Order, Title = dto.Title, IsCheckedAvailable = dto.IsCheckedAvailable, IsChecked = dto.IsChecked, IsCommentsAvailable = dto.IsCommentsAvailable, Comments = dto.Comments, IsPhotoAvailable = dto.IsPhotoAvailable, Photos = dto.Photos.Select(x => x.CreateModel()).ToList() }; return(model); }
public JsonResult Update(AuditItemViewModel model) { try { AuditItemModel auditItemModel = auditItemBll.GetModel(model.ItemID); auditItemModel.AuditID = model.AuditID; auditItemModel.AuditRuleID = model.AuditRuleID; auditItemModel.Status = model.Status; auditItemModel.Evidence = model.Evidence; auditItemModel.Comments = model.Comments; auditItemBll.Update(auditItemModel); return(Json(new { code = 200 })); } catch (Exception ex) { return(Json(new { code = 500, msg = ex.Message })); } }
public int Insert(AuditItemModel model) { string sql = "INSERT INTO [AuditItem]([AuditID],[AuditRuleID],[Status],[Evidence],[Comments]) VALUES(@AuditID,@AuditRuleID,@Status,@Evidence,@Comments)"; SqlParameter[] parameters = { new SqlParameter("@AuditID", SqlDbType.Int), new SqlParameter("@AuditRuleID", SqlDbType.Int), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@Evidence", SqlDbType.NVarChar), new SqlParameter("@Comments", SqlDbType.NVarChar), }; parameters[0].Value = model.AuditID == null ? (object)DBNull.Value : model.AuditID; parameters[1].Value = model.AuditRuleID == null ? (object)DBNull.Value : model.AuditRuleID; parameters[2].Value = model.Status == null ? (object)DBNull.Value : model.Status; parameters[3].Value = model.Evidence == null ? (object)DBNull.Value : model.Evidence; parameters[4].Value = model.Comments == null ? (object)DBNull.Value : model.Comments; return(DbHelperSQL.ExecuteSql(sql, parameters)); }
public JsonResult Delete(int itemID) { try { AuditItemModel model = auditItemBll.GetModel(itemID); if (model != null) { auditItemBll.Delete(itemID); } else { return(Json(new { code = 500, msg = "parms is null" })); } return(Json(new { code = 200 })); } catch (Exception ex) { return(Json(new { code = 500, msg = ex.Message })); } }
public int Update(AuditItemModel model) { string sql = "UPDATE [AuditItem] SET [AuditID]=@AuditID,[AuditRuleID]=@AuditRuleID,[Status]=@Status,[Evidence]=@Evidence,[Comments]=@Comments WHERE ItemID=@ItemID"; SqlParameter[] parameters = { new SqlParameter("@ItemID", SqlDbType.Int), new SqlParameter("@AuditID", SqlDbType.Int), new SqlParameter("@AuditRuleID", SqlDbType.Int), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@Evidence", SqlDbType.NVarChar), new SqlParameter("@Comments", SqlDbType.NVarChar), }; parameters[0].Value = model.ItemID; parameters[1].Value = model.AuditID == null ? (object)DBNull.Value : model.AuditID; parameters[2].Value = model.AuditRuleID == null ? (object)DBNull.Value : model.AuditRuleID; parameters[3].Value = model.Status == null ? (object)DBNull.Value : model.Status; parameters[4].Value = model.Evidence == null ? (object)DBNull.Value : model.Evidence; parameters[5].Value = model.Comments == null ? (object)DBNull.Value : model.Comments; return(DbHelperSQL.ExecuteSql(sql, parameters)); }
public AuditItemModel DataRowToModel(DataRow row) { AuditItemModel model = new AuditItemModel(); if (row == null) { return(model); } if (row["ItemID"] != null && row["ItemID"].ToString() != "") { model.ItemID = int.Parse(row["ItemID"].ToString()); } if (row["AuditID"] != null && row["AuditID"].ToString() != "") { model.AuditID = int.Parse(row["AuditID"].ToString()); } if (row["AuditRuleID"] != null && row["AuditRuleID"].ToString() != "") { model.AuditRuleID = int.Parse(row["AuditRuleID"].ToString()); } if (row["Status"] != null && row["Status"].ToString() != "") { model.Status = int.Parse(row["Status"].ToString()); } if (row["Evidence"] != null && row["Evidence"].ToString() != "") { model.Evidence = row["Evidence"].ToString(); } if (row["Comments"] != null && row["Comments"].ToString() != "") { model.Comments = row["Comments"].ToString(); } return(model); }
public int Update(AuditItemModel model) { return(dal.Update(model)); }
public int Insert(AuditItemModel model) { return(dal.Insert(model)); }
public static AuditItemModel WithAttachments(this AuditItemModel model) { model.IsPhotoAvailable = true; return(model); }
public static AuditItemModel WithComments(this AuditItemModel model) { model.IsCommentsAvailable = true; return(model); }