public Task <ActionResult> ConsecutiveEdit(ReturnConsecutive consecutive)
{
var result = _updateMethods.UpdateConsecutive(new ConsecutiveEdit
{
PkCode = consecutive.PkCode
,
Prefix = consecutive.Prefix
}).Result;
if (!result)
{
ModelState.AddModelError(key: "", errorMessage: "Ha ocurrido un error.\n");
}
else
{
ModelState.AddModelError(key: "", errorMessage: "Guardado con exito.\n");
}
return(Task.FromResult <ActionResult>(RedirectToAction("ConsecutiveList")));
}
public Task <ReturnConsecutive> ReturnConsecutive(int pkConsecutive)
{
try
{
ReturnConsecutive consecutive = new ReturnConsecutive();
using (var conn = _settings.GetConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string query = $"SELECT * FROM RETORNA_CONSECUTIVO({pkConsecutive});";
using (var cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
var dr = cmd.ExecuteReader();
while (dr.Read())
{
consecutive.PkCode = dr.GetInt32(0);
consecutive.Type = dr.GetInt32(1);
consecutive.IdConsecutive = dr.GetInt32(2);
consecutive.HasPrefix = dr.GetBoolean(3);
consecutive.Prefix = (dr.IsDBNull(4) ? null : dr.GetString(4));
consecutive.NumConsecutive = dr.GetInt32(5);
}
}
}
return(Task.FromResult(consecutive));
}
catch (Exception e)
{
Console.WriteLine(e);
return(null);
}
}
