public Task <ReturnPriceType> ReturnPriceType(int pkPriceType)
{
try
{
ReturnPriceType priceType = new ReturnPriceType();
using (var conn = _settings.GetConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string query = $"SELECT * FROM RETORNA_TIPO_PRECIO({pkPriceType});";
using (var cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
var dr = cmd.ExecuteReader();
while (dr.Read())
{
priceType.PkCode = dr.GetInt32(0);
priceType.Code = (dr.IsDBNull(1) ? null: dr.GetString(1));
priceType.Type = dr.GetString(2);
}
}
}
return(Task.FromResult(priceType));
}
catch (Exception e)
{
Console.WriteLine(e);
return(null);
}
}
public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
{
ReturnPriceType returnPriceType = (ReturnPriceType)value;
string para = parameter.ToString();
if (returnPriceType == ReturnPriceType.InputPrice)
{
return(para == "Input" ? Visibility.Visible : Visibility.Collapsed);
}
else
{
return(para == "Input" ? Visibility.Collapsed : Visibility.Visible);
}
}
public async Task <ActionResult> PriceTypeEdit(ReturnPriceType priceType)
{
var result = await _updateMethods.UpdatePriceType(priceType.PkCode, priceType.Type);
var returnPriceType = await _returnMethods.ReturnPriceType(priceType.PkCode);
if (result)
{
return(await Task.FromResult <ActionResult>(RedirectToAction("PriceTypeList")));
}
ModelState.AddModelError(key: "", errorMessage: "Ha ocurrido un error.\n");
return(View(returnPriceType));
}
