/// <summary>
/// به روز رسانی تعداد آیتم های برای هر محصول در یک فاکتور
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <SweetAlertExtenstion> UpdateCountAllItems(ShopOrderUpdateFromSite model, string title)
{
string query = "";
try
{
query += $"update ShopOrder set title = '{title}' where Id = {model.ShopOrderId} ;";
if (model.ListProducts != null)
{
foreach (var item in model.ListProducts)
{
query += $"update ShopProduct set Count = {item.Count} where ShopOrderId = {model.ShopOrderId} and ProductId = {item.ProductId} ;";
}
}
await _connection.QueryAsync(query + "select * from Log");
return(SweetAlertExtenstion.Ok());
}
catch (Exception e)
{
return(SweetAlertExtenstion.Error());
}
}
/// <summary>
/// به روز رسانی تعداد آیتم های برای هر محصول در یک فاکتور
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <SweetAlertExtenstion> UpdateCountAllItems(ShopOrderUpdateFromSite model)
{
try
{
string query = "";
foreach (var item in model.ListProducts)
{
query += $"update ShopProduct set Count = {item.Count} where ShopOrderId = {model.ShopOrderId} and ProductId = {item.ProductId} ;";
}
await _connection.QueryAsync(query);
return(SweetAlertExtenstion.Ok());
}
catch (Exception e)
{
return(SweetAlertExtenstion.Error());
}
}
public async Task <IActionResult> EditShopOrder(ShopOrderUpdateFromSite model, string urlBack, string inputTitle)
{
TempData.AddResult(await _shopProductRepository.UpdateCountAllItems(model, inputTitle));
return(RedirectToAction(urlBack, new { id = model.ShopOrderId }));
}