public Task <ReturnLineType> ReturnLineType(int pkLineType)
{
try
{
ReturnLineType lineType = new ReturnLineType();
using (var conn = _settings.GetConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string query = $"SELECT * FROM RETORNA_TIPO_LINEA({pkLineType});";
using (var cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
var dr = cmd.ExecuteReader();
while (dr.Read())
{
lineType.PkCode = dr.GetInt32(0);
lineType.Code = (dr.IsDBNull(1) ? null : dr.GetString(1));
lineType.Type = dr.GetString(2);
}
}
}
return(Task.FromResult(lineType));
}
catch (Exception e)
{
Console.WriteLine(e);
return(null);
}
}
public async Task <ActionResult> LineTypeEdit(ReturnLineType data)
{
if (!ModelState.IsValid)
{
return(await Task.FromResult <ActionResult>(View(data)));
}
var result = await _updateMethods.UpdateLineType(data.PkCode, data.Type);
if (!result)
{
ModelState.AddModelError(key: "", errorMessage: "Ha ocurrido un error.\n");
return(await Task.FromResult <ActionResult>(View(data)));
}
return(await Task.FromResult <ActionResult>(RedirectToAction("LineTypeList")));
}
