public async Task <IActionResult> Edit(int id, [Bind("Prefix,bank_id,Description,Type")] prefixcardModel prefixcardModel) { if (id != prefixcardModel.Prefix) { return(NotFound()); } if (ModelState.IsValid) { var cmdx = _jbsDB.Database; var cmd = _jbsDB.Database.GetDbConnection().CreateCommand(); try { cmdx.OpenConnection(); cmdx.BeginTransaction(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "update_bin_number"; cmd.Parameters.Clear(); cmd.Parameters.Add(new MySqlParameter("@bin_number", MySqlDbType.Int32) { Value = prefixcardModel.Prefix }); cmd.Parameters.Add(new MySqlParameter("@bank_idx", MySqlDbType.Int32) { Value = prefixcardModel.bank_id }); cmd.Parameters.Add(new MySqlParameter("@note", MySqlDbType.VarChar) { Value = prefixcardModel.Description }); cmd.Parameters.Add(new MySqlParameter("@tipe_card", MySqlDbType.Int32) { Value = prefixcardModel.Type }); await cmd.ExecuteNonQueryAsync(); cmdx.CommitTransaction(); } catch (Exception ex) { cmdx.RollbackTransaction(); throw new Exception(ex.Message); } finally { if (cmdx.CurrentTransaction != null) { cmdx.RollbackTransaction(); } cmdx.CloseConnection(); } return(RedirectToAction("Index")); } return(View(prefixcardModel)); }
public async Task <IActionResult> Create(prefixcardModel card) { var cmdx = _jbsDB.Database; var cmd = _jbsDB.Database.GetDbConnection().CreateCommand(); if (ModelState.IsValid) { try { cmdx.OpenConnection(); cmdx.BeginTransaction(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "insert_bin_number"; cmd.Parameters.Clear(); cmd.Parameters.Add(new MySqlParameter("@prefix", MySqlDbType.Int32) { Value = card.Prefix }); cmd.Parameters.Add(new MySqlParameter("@tipe", MySqlDbType.Int32) { Value = card.Type }); cmd.Parameters.Add(new MySqlParameter("@bank_idx", MySqlDbType.Int32) { Value = card.bank_id }); cmd.Parameters.Add(new MySqlParameter("@desk", MySqlDbType.VarChar) { Value = card.Description }); await cmd.ExecuteNonQueryAsync(); cmdx.CommitTransaction(); } catch (Exception ex) { cmdx.RollbackTransaction(); throw new Exception(ex.Message); } finally { if (cmdx.CurrentTransaction != null) { cmdx.RollbackTransaction(); } cmdx.CloseConnection(); } //_jbsDB.prefixcardModel.Add(card); //_jbsDB.SaveChanges(); return(RedirectToAction("Index")); } return(View(card)); }