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"))); }