/// <summary>
/// Creates a customer in the database
/// </summary>
/// <param name="customer"></param>
/// <returns></returns>
public int CreateCustomer(Customer customer)
{
int affectedRows;
dataAccessLayer.BeginTransaction();
try
{
dataAccessLayer.CreateParameters(7);
dataAccessLayer.AddParameters(0, "ID", customer.ID);
dataAccessLayer.AddParameters(1, "CustomerName", customer.name);
dataAccessLayer.AddParameters(2, "Email", customer.email);
dataAccessLayer.AddParameters(3, "Phone", customer.phone);
dataAccessLayer.AddParameters(4, "Address", customer.Address);
dataAccessLayer.AddParameters(5, "Gender", customer.Gender);
dataAccessLayer.AddParameters(6, "Age", customer.Age);
affectedRows = dataAccessLayer.ExecuteQuery("spCreateCustomer", CommandType.StoredProcedure);
dataAccessLayer.CommitTransaction();
}
catch (Exception e)
{
dataAccessLayer.RollbackTransaction();
Console.WriteLine(e);
return(-1);
}
return(affectedRows);
}
public int createShow(Show show)
{
try
{
dataAccessLayer.BeginTransaction();
dataAccessLayer.CreateParameters(6);
dataAccessLayer.AddParameters(0, "Title", show.title);
dataAccessLayer.AddParameters(1, "ImgUrl", show.imgUrl);
dataAccessLayer.AddParameters(2, "Hall_ID", show.hall.hallNum);
List <string> date_strings = new List <string>();
show.dates.ForEach(d => date_strings.Add(d.ToString("yyyy-MM-dd hh:mm:ss")));
string dates = string.Join(",", date_strings);
dataAccessLayer.AddParameters(3, "Dates", dates);
dataAccessLayer.AddParameters(4, "basePrice", show.basePrice);
dataAccessLayer.AddParameters(5, "description", show.description);
int affectedRows = dataAccessLayer.ExecuteQuery("spCreateShow", CommandType.StoredProcedure);
dataAccessLayer.CommitTransaction();
return(affectedRows);
}
catch (Exception e)
{
dataAccessLayer.RollbackTransaction();
Console.WriteLine(e);
return(-1);
}
}
public int createTheater(Theater theater)
{
try
{
dataAccessLayer.BeginTransaction();
dataAccessLayer.CreateParameters(3);
dataAccessLayer.AddParameters(0, "Theater", theater.name);
dataAccessLayer.AddParameters(1, "Address", theater.address);
dataAccessLayer.AddParameters(2, "Active", theater.active);
int affectedRows = dataAccessLayer.ExecuteQuery("spCreateTheater", CommandType.StoredProcedure);
dataAccessLayer.CommitTransaction();
return(affectedRows);
}
catch (Exception e)
{
dataAccessLayer.RollbackTransaction();
Console.WriteLine(e);
return(-1);
}
}
/// <summary>
/// Delete a specific booking
/// </summary>
/// <param name="bookingID"></param>
/// <returns></returns>
public int DeleteBooking(int bookingID)
{
try
{
dataAccessLayer.BeginTransaction();
dataAccessLayer.CreateParameters(1);
dataAccessLayer.AddParameters(0, "BookingID", bookingID);
int affectedRows = dataAccessLayer.ExecuteQuery("spDeleteBooking", CommandType.StoredProcedure);
dataAccessLayer.CommitTransaction();
return(affectedRows);
}
catch (Exception e)
{
dataAccessLayer.RollbackTransaction();
Console.WriteLine(e);
return(-1);
}
}
public int createHall(Hall hall)
{
try
{
dataAccessLayer.BeginTransaction();
dataAccessLayer.CreateParameters(4);
dataAccessLayer.AddParameters(0, "HallNum", hall.hallNum);
dataAccessLayer.AddParameters(1, "Theater", hall.theater.name);
dataAccessLayer.AddParameters(2, "SeatCount", hall.seats);
dataAccessLayer.AddParameters(3, "RowCount", hall.rows);
int affectedRows = dataAccessLayer.ExecuteQuery("spCreateHall", CommandType.StoredProcedure);
dataAccessLayer.CommitTransaction();
return(affectedRows);
}
catch (Exception e)
{
dataAccessLayer.RollbackTransaction();
Console.WriteLine(e);
return(-1);
}
}