public void Update(ActionReservation actRes) { using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); MySqlCommand command = new MySqlCommand(UPDATE_ActionReservation, conn); command.Parameters.AddWithValue("@act_reservation_date", actRes.act_reservation_date); command.Parameters.AddWithValue("@act_reservation_client_came", actRes.act_reservation_client_came); command.Parameters.AddWithValue("@action_id", actRes.action_id); command.Parameters.AddWithValue("@client_id", actRes.client_id); /* Executes the command */ command.ExecuteNonQuery(); } }
public List<ActionReservation> SelectAll() { List<ActionReservation> actResList = new List<ActionReservation>(); using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); MySqlCommand command = new MySqlCommand(SELECT_ALL, conn); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { ActionReservation actRes = new ActionReservation(); actRes.act_reservation_id = reader.GetInt32(0); actRes.act_reservation_date = reader.GetDateTime(1); actRes.act_reservation_client_came = reader.GetBoolean(2); actRes.action_id = reader.GetInt32(3); actRes.client_id = reader.GetInt32(4); actResList.Add(actRes); } } return actResList; }
public ActionReservation SelectOne(int ActionReservationId) { ActionReservation actRes = new ActionReservation(); using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); MySqlCommand command = new MySqlCommand(SELECT_ONE, conn); command.Parameters.AddWithValue("@ActionReservation_id", ActionReservationId); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { actRes.act_reservation_id = reader.GetInt32(0); actRes.act_reservation_date = reader.GetDateTime(1); actRes.act_reservation_client_came = reader.GetBoolean(2); actRes.action_id = reader.GetInt32(3); actRes.client_id = reader.GetInt32(4); } reader.Close(); } return actRes; }
public void InsertActionReservation(ActionReservation actRes) { // Nejprve overime, zda ma klient aktivni ucet. Client c = new ClientTable().SelectOne(actRes.client_id); if (c.client_is_active == false) throw new MembershipExpiredException("Platnost clenstvi vyprsela."); using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); MySqlCommand command = new MySqlCommand(INSERT_ActionReservation, conn); /* Add parameters into the command */ command.Parameters.AddWithValue("@act_reservation_date", actRes.act_reservation_date); command.Parameters.AddWithValue("@act_reservation_client_came", actRes.act_reservation_client_came); command.Parameters.AddWithValue("@action_id", actRes.action_id); command.Parameters.AddWithValue("@client_id", actRes.client_id); /* Executes the command */ command.ExecuteNonQuery(); } }