public List <TrainerModel> loadAllTrainersFromDataBase() { List <TrainerModel> trainerList = new List <TrainerModel>(); try { using (OracleConnection connection = new OracleConnection(OracleSQLConnector.GetConnectionString())) { connection.Open(); OracleCommand cmd; string sql = String.Format("select * from trainer_table"); cmd = new OracleCommand(sql, connection); cmd.CommandType = CommandType.Text; OracleDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { TrainerModel trainer = new TrainerModel(); trainer.setID(reader.GetInt32(0)); trainer.setFirstName(reader.GetString(1)); trainer.setLastName(reader.GetString(2)); trainer.setEmailAddress(reader.GetString(3)); trainer.setPhoneNumber(reader.GetString(4)); try { trainer.setPricePerhour(reader.GetInt32(5)); } catch { trainer.setPricePerhour(0); } try { trainer.setImageBlob((byte[])reader["image"]); } catch { //trainer.setImageBlob(null); } trainerList.Add(trainer); } } finally { reader.Close(); } } }catch { } return(trainerList); }
/// <summary> /// Load currently logged in Trainer Data /// </summary> /// <returns></returns> public TrainerModel loadTrainerFromDataBase() { TrainerModel trainer = new TrainerModel(); try { using (OracleConnection connection = new OracleConnection(OracleSQLConnector.GetConnectionString())) { connection.Open(); OracleCommand cmd; string sql = String.Format("select * from trainer_table WHERE id = {0}", GlobalClass.getTrainerID()); cmd = new OracleCommand(sql, connection); cmd.CommandType = CommandType.Text; OracleDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { trainer = new TrainerModel(reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4)); try { trainer.setPricePerhour(reader.GetInt32(5)); } catch { trainer.setPricePerhour(0); } try { trainer.setImageBlob((byte[])reader["image"]); } catch { trainer.setImageBlob(null); } } } finally { reader.Close(); } } } catch { } return(trainer); }
public List <MeetModel> loadAllMeetingsFromDataBase(int ID, String tableName) { List <MeetModel> meetingList = new List <MeetModel>(); try { using (OracleConnection connection = new OracleConnection(OracleSQLConnector.GetConnectionString())) { connection.Open(); OracleCommand cmd; string sql = String.Format("select * from meet_table WHERE {1}_table_id = {0}", ID, tableName); cmd = new OracleCommand(sql, connection); cmd.CommandType = CommandType.Text; OracleDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { MeetModel meeting = new MeetModel( reader.GetInt32(0), reader.GetInt32(5), reader.GetInt32(6), reader.GetInt32(7), reader.GetDateTime(1), reader.GetInt32(2), reader.GetInt32(3), reader.GetInt32(4)); if (meeting.DateAndHour > DateTime.Now) { meetingList.Add(meeting); } } } finally { reader.Close(); } } } catch { } return(meetingList); }
public bool insertMeetingToDBReturnItsID(MeetModel meet) { try { using (OracleConnection connection = new OracleConnection(OracleSQLConnector.GetConnectionString())) { try { connection.Open(); OracleCommand cmd = new OracleCommand(); String sql = String.Format("INSERT INTO meet_table (date_and_time, duration, accepted, isnew, user_table_id, trainer_table_id, place_table_id) VALUES (TO_DATE('{0}', 'DD/MM/YYYY HH24:MI:SS'), {1}, {2}, {3}, {4}, {5}, {6})", meet.DateAndHour, meet.Duration, meet.Accepted, meet.New, meet.IDUser, meet.IDTrainer, meet.IDPlace); cmd = new OracleCommand(sql, connection); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); //Console.WriteLine("1213231"); } catch (Exception e) { // Extract some information from this exception, and then // throw it to the parent method. if (e.Source != null) { Console.WriteLine("IOException source: {0}", e.Source); } return(false); } finally { connection.Close(); } } return(true); }catch { return(false); } }
/// <summary> /// Loads current logged in User Data /// </summary> /// <returns></returns> public UserModel loadUserFromDataBase() { UserModel user = new UserModel(); try { using (OracleConnection connection = new OracleConnection(OracleSQLConnector.GetConnectionString())) { connection.Open(); OracleCommand cmd; string sql = String.Format("select * from user_table WHERE id = {0}", GlobalClass.getUserID()); cmd = new OracleCommand(sql, connection); cmd.CommandType = CommandType.Text; OracleDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { // firstname last name email phone number image user = new UserModel(reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), (byte[])reader["image"]); } } catch { user = new UserModel(reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), null); } finally { reader.Close(); } } } catch { } return(user); }
/// <summary> /// Loads all places for currently logged in traienr /// </summary> /// <returns></returns> public List <PlaceModel> loadPlacesFromDataBase() { List <PlaceModel> placesList = new List <PlaceModel>(); try { using (OracleConnection connection = new OracleConnection(OracleSQLConnector.GetConnectionString())) { connection.Open(); OracleCommand cmd; string sql = String.Format("select * from place_table WHERE trainer_table_id = {0}", GlobalClass.getTrainerID()); cmd = new OracleCommand(sql, connection); cmd.CommandType = CommandType.Text; OracleDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { PlaceModel place = new PlaceModel(); place.setID(reader.GetInt32(0)); place.setCity(reader.GetString(1)); place.setPostCode(reader.GetString(2)); place.setStreet(reader.GetString(3)); place.setDescription(reader.GetString(4)); placesList.Add(place); } } finally { reader.Close(); } } }catch { } return(placesList); }
public PlaceModel loadPlaceFromDataBase(int placeID) { PlaceModel place = new PlaceModel(); try { using (OracleConnection connection = new OracleConnection(OracleSQLConnector.GetConnectionString())) { connection.Open(); OracleCommand cmd; string sql = String.Format("select * from place_table WHERE id = {0}", placeID); cmd = new OracleCommand(sql, connection); cmd.CommandType = CommandType.Text; OracleDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { place.setID(reader.GetInt32(0)); place.setCity(reader.GetString(1)); place.setPostCode(reader.GetString(2)); place.setStreet(reader.GetString(3)); place.setDescription(reader.GetString(4)); } } finally { reader.Close(); } } }catch { } return(place); }