//metodo para ingresar el deposito, recibe la conexion y un objeto cliente que contiene todos los datos necesarios //el metodo retorna un numero // 1 = ingresado correctamente public static int addDeposit(MySqlConnection Connection, DepositWithoutAccount deposit) { MySqlCommand command = new MySqlCommand( String.Format("INSERT INTO DepositWithoutAccount (Employee_idEmployee, DestinyAccount, Date, Quantity, Name, CancelTransaction) VALUES ({0}, {1}, '{2}', {3}, '{4}', false)", deposit.idEmployee, deposit.destinyAccount, deposit.date, deposit.quantity, deposit.name), Connection); int OK = command.ExecuteNonQuery(); /// if OK = 1 it's ok /// if OK = 0 error return(OK); }
public static IList <DepositWithoutAccount> showCanceled(MySqlConnection Connection) { List <DepositWithoutAccount> depositList = new List <DepositWithoutAccount>(); MySqlCommand command = new MySqlCommand(String.Format("SELECT * FROM DepositWithoutAccount WHERE CancelTransaction = true"), Connection); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { DepositWithoutAccount deposit = new DepositWithoutAccount(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetString(3), reader.GetFloat(4), reader.GetString(5), reader.GetBoolean(6)); depositList.Add(deposit); } return(depositList); }