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);
}
