public Task <ReturnCardType> ReturnCardType(int pkCardType) { try { ReturnCardType cardType = new ReturnCardType(); using (var conn = _settings.GetConnection()) { if (conn.State == ConnectionState.Closed) { conn.Open(); } string query = $"SELECT * FROM RETORNA_TIPO_TARJETA({pkCardType});"; using (var cmd = new SqlCommand(query, conn)) { cmd.CommandType = CommandType.Text; var dr = cmd.ExecuteReader(); while (dr.Read()) { cardType.PkCode = dr.GetInt32(0); cardType.Type = dr.GetString(1); } } } return(Task.FromResult(cardType)); } catch (Exception e) { Console.WriteLine(e); return(null); } }
public async Task <ActionResult> TypeCardEdit(ReturnCardType data) { if (!ModelState.IsValid) { return(await Task.FromResult <ActionResult>(View(data))); } var result = await _updateMethods.UpdateCardType(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("TypeCardList"))); }
/// <summary> /// 获得牌型 /// </summary> /// <param name="getcdsTypeMethod"></param> public CheckCardTool(ReturnCardType getcdsTypeMethod) { _getCdsType = getcdsTypeMethod; }