public Car(string _code, string _model, SqlDate _creation_date, string _driver_id) { code = _code; model = _model; creation_date = _creation_date; driver_id = _driver_id; }
public Track(ATM[] atms_c, bool idDone_c, SqlDate date_C, string carID_c, string empID_c, string mgrID_c) { atms = atms_c; is_done = idDone_c; date = date_C; car_id = carID_c; employee_id = empID_c; manager_id = mgrID_c; }
public void makeWithdrawal(string atmID, SqlDate date, int amount) { connect(); int avilableMoney = getAvilableMoney(atmID); if (amount < avilableMoney) { string createWithdrawal = $"INSERT INTO Withdrawals (amount, date, Atms_id) VALUES({ amount }, '{ date.ToString() }', { atmID })"; string updateATMRecord = $"UPDATE atms SET live_money_avilable = { avilableMoney } - { amount } WHERE id = { atmID }"; MySqlCommand createWithdrawalCmd = new MySqlCommand(createWithdrawal, conn); MySqlCommand updateAtmCmd = new MySqlCommand(updateATMRecord, conn); createWithdrawalCmd.CommandType = CommandType.Text; updateAtmCmd.CommandType = CommandType.Text; if (conn != null) { try { conn.Open(); createWithdrawalCmd.ExecuteNonQuery(); updateAtmCmd.ExecuteNonQuery(); conn.Close(); } catch (MySqlException ex) { conn.Close(); throw ex; } } else { throw new Exception("Connection with database didn't established, Please try again"); } } else { Console.WriteLine("Sorry but you can't withdrawal from this Atm this amount of money"); } }
public Employee(string _id, string _name, SqlDate _birthDate, string _role, string _username, string _phone_number, string _gender, Address _address) { if (_id.Length == 9) { id = _id; } else { throw new Exception("Inserted id is not vaild"); } name = _name; birthDate = _birthDate; role = _role; username = _username; password = "******"; phone_number = _phone_number; email = $"{username}@nsec.com"; gender = _gender; address = _address; }
public Employee( string _id, string _name, SqlDate _birthDate, string _role, string _username, string _password, string _phone_number, string _gender, Address _address ) { id = _id; name = _name; birthDate = _birthDate; role = _role; username = _username; password = password; phone_number = _phone_number; email = $"{username}@nsec.com"; gender = _gender; address = _address; }
public Track[] getTracksByDate(SqlDate date) { connect(); string allTracksAtDateQuery = $"SELECT * FROM Tracks WHERE date = '{ date.ToString() }'"; MySqlCommand allTracksCmd = new MySqlCommand(allTracksAtDateQuery, conn); allTracksCmd.CommandType = CommandType.Text; if (conn != null) { try { conn.Open(); // Find all Tracks at specific date DataTable dataTable = new DataTable(); dataTable.Load(allTracksCmd.ExecuteReader()); var rows = dataTable.AsEnumerable().ToArray(); List <Track> allTracks = new List <Track>(); for (int i = 0; i < rows.Length; i++) { allTracks.Add(getTrackByID(rows[i]["id"].ToString())); } conn.Close(); return(allTracks.ToArray()); } catch (MySqlException ex) { conn.Close(); throw ex; } } throw new Exception("Connection with database didn't established, Please try again"); }