public static bool CreateReservation(IEmployee employee, IMachine machine, DateTime day,
DateTime start, DateTime end, string jamType, string description)
{
bool result;
try
{
ReservationEntity reservationEntity = new ReservationEntity(employee.Id, machine.Id,
day, start, end, jamType, description);
result = Persistens.CreateReservationEntity(reservationEntity);
return result;
}
catch (Exception)
{
return false;
}
}
public static bool CreateReservationEntity(ReservationEntity re)
{
try
{
connectDB();
command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "int_group1_create_reservation";
command.Parameters.AddWithValue("@day", re.Day);
command.Parameters.AddWithValue("@time_start", re.Start);
command.Parameters.AddWithValue("@time_end", re.End);
command.Parameters.AddWithValue("@jam_type", re.JamType);
command.Parameters.AddWithValue("@description", re.Description);
command.Parameters.AddWithValue("@employee_id", re.User);
command.Parameters.AddWithValue("@machine_id", re.Machine);
command.ExecuteNonQuery();
return true;
}
catch (Exception)
{
return false;
}
}
public static List<ReservationEntity> GetAllReservationEntities()
{
List<ReservationEntity> reservationList = new List<ReservationEntity>();
try
{
connectDB();
command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "int_group1_get_reservation";
dataReader = command.ExecuteReader();
while (dataReader.Read())
{
int reservation_id = int.Parse(dataReader["reservation_id"].ToString());
DateTime day = DateTime.Parse(dataReader["day"].ToString());
DateTime time_start = DateTime.Parse(dataReader["time_start"].ToString());
DateTime time_end = DateTime.Parse(dataReader["time_end"].ToString());
string jam_type = dataReader["jam_type"].ToString();
string description = dataReader["description"].ToString();
int employee_id = int.Parse(dataReader["employee_id"].ToString());
int machine_id = int.Parse(dataReader["machine_id"].ToString());
ReservationEntity reservation = new ReservationEntity(employee_id, machine_id, day, time_start,
time_end, jam_type, description, reservation_id);
reservationList.Add(reservation);
}
closeDB();
return reservationList;
}
catch (Exception)
{
closeDB();
return reservationList;
}
}
public static bool UpdateReservation(IEmployee employee, IMachine machine, DateTime day,
DateTime start, DateTime end, string jamType, string description, int reservationId)
{
try
{
ReservationEntity resEnt = new ReservationEntity(employee.Id, machine.Id,
day, start, end, jamType, description, reservationId);
Persistens.UpdateReservationEntity(resEnt);
return true;
}
catch (Exception)
{
return false;
}
}