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