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