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