public async Task <IActionResult> UpdateDressDetails(EditDressDetailsModel model)
{
var sql =
@"UPDATE Dresses SET
DressName = @DressName,
DressWebpage = @DressWebpage,
Price = @Price,
ProductDescription = @ProductDescription,
DressType = @DressType,
ShopId = @ShopId,
ImageId = @ImageId,
ModifiedBy = @ModifiedBy,
ModifiedAt = @ModifiedAt
WHERE DressId = @DressId";
await connection.ExecuteAsync(sql,
new
{
model.DressId,
model.DressName,
model.DressWebpage,
model.Price,
model.ProductDescription,
DressType = MapDressType(model.DressType.Value),
ShopID = model.Shop,
ImageID = model.Image,
ModifiedBy = Guid.Empty,
ModifiedAt = DateTimeOffset.Now
},
dbTransaction
);
return(RedirectToAction(nameof(GetDressDetails)));
}
public async Task <IActionResult> EditDressDetails(Guid dressId)
{
var dress =
await connection
.QueryFirstAsync <DressQueryModel>(
"Select DressId, DressName, DressWebpage, Price, ProductDescription, DressType, ShopId, ImageId, ModifiedBy, ModifiedAt FROM Dresses WHERE DressId = @DressId",
new { DressId = dressId }, dbTransaction);
var model = new EditDressDetailsModel()
{
DressId = dress.DressId,
DressName = dress.DressName,
DressWebpage = dress.DressWebpage,
Price = dress.Price.ToString("C"),
Shop = "Need to do",
ProductDescription = dress.ProductDescription,
Image = "Need to do",
DressType = DressType.Bride,
ModifiedBy = Guid.Empty, //current user
ModifiedAt = DateTimeOffset.Now
};
return(View(model));
}
