public Task <ReturnDiscount> ReturnDiscount(int pkDiscount)
{
try
{
ReturnDiscount discount = new ReturnDiscount();
using (var conn = _settings.GetConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string query = $"SELECT * FROM RETORNA_DESCUENTO({pkDiscount});";
using (var cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
var dr = cmd.ExecuteReader();
while (dr.Read())
{
discount.PkCode = dr.GetInt32(0);
discount.Code = dr.GetString(1);
discount.Description = dr.GetString(2);
discount.Available = dr.GetInt32(3);
discount.Percentage = dr.GetInt32(4);
}
}
}
return(Task.FromResult(discount));
}
catch (Exception e)
{
Console.WriteLine(e);
return(null);
}
}
public Task <ActionResult> DiscountEdit(ReturnDiscount discount)
{
var result = _updateMethods.UpdateDiscount(new DiscountCupons
{
PkCode = discount.PkCode
, Description = discount.Description
, NewCupons = discount.Available
}).Result;
if (result)
{
return(Task.FromResult <ActionResult>(RedirectToAction("DiscountList")));
}
ModelState.AddModelError(key: "", errorMessage: "Ha ocurrido un error.\n");
return(Task.FromResult <ActionResult>(View()));
}
