public Prenotation(Prenotation prenotation)
{
PrenotationCode = prenotation.PrenotationCode;
DateTime = prenotation.DateTime;
UsernameUser = prenotation.UsernameUser;
EventCode = prenotation.EventCode;
}
public Ticket(Prenotation p, Event e, Film f, Reservation r) : this()
{
Prenotation = p;
Event = e;
Film = f;
Reservation = r;
}
/*
* Get the list containing the tickets of a user
*/
public List <Ticket> GetTicketsList(string username)
{
// Database connection
using (SqlConnection connection = DatabaseHandler.GetConnection())
{
// Define a new list of Users
List <Ticket> ticketsList = new List <Ticket>();
connection.Open();
// Start a local transaction.
SqlTransaction transaction = connection.BeginTransaction();
SqlCommand command = connection.CreateCommand();
// Assign both transaction object and connection to Command object
command.Connection = connection;
command.Transaction = transaction;
try{
// Insert the Ticket in the list
command.Parameters.Clear();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "Cinema.VisualizzaPrenotazione";
command.Parameters.Add("@Username", SqlDbType.VarChar).Value = username;
using (SqlDataReader reader = command.ExecuteReader()) {
while (reader.Read())
{
Prenotation p = new Prenotation();
p.PrenotationCode = reader.GetInt32(0);
p.DateTime = reader.GetDateTime(1);
p.UsernameUser = reader.GetString(2);
p.EventCode = reader.GetInt32(3);
Event e = new Event();
e.EventCode = reader.GetInt32(3);
e.DateTime = reader.GetDateTime(5);
e.HallCode = reader.GetInt32(6);
e.Price = reader.GetDecimal(7);
Film f = new Film();
f.Title = reader.GetString(4);
Reservation r = new Reservation();
r.PlaceNumber = reader.GetInt32(8);
ticketsList.Add(new Ticket(p, e, f, r));
}
}
// Attempt to commit the transaction.
transaction.Commit();
return(ticketsList);
}
catch (Exception ex) {
Console.WriteLine("Commit Exception Type: {0}", ex.GetType());
Console.WriteLine(" Message: {0}", ex.Message);
// Attempt to roll back the transaction.
try {
transaction.Rollback();
}
catch (Exception ex2) {
// This catch block will handle any errors that may have occurred
// on the server that would cause the rollback to fail
Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType());
Console.WriteLine(" Message: {0}", ex2.Message);
}
return(new List <Ticket>()
{
});
}
}
}
/*
* Add a Prenotation into the database.
*
* @return true if the operation success, false if not
*/
public bool AddPrenotation(DateTime dateTime, string usernameUser, int eventCode, int placeNumber)
{
using (SqlConnection connection = DatabaseHandler.GetConnection()) {
// Bool value for user subscription
// true if the user is subscribed, false otherwise
bool IsSubscribed = GetSubscription(usernameUser);
decimal price = 6.40M;
connection.Open();
// Start a local transaction.
SqlTransaction transaction = connection.BeginTransaction();
SqlCommand command = connection.CreateCommand();
// Assign both transaction object and connection to Command object
command.Connection = connection;
command.Transaction = transaction;
try {
// If the User is not subscribed take the price from the event, if he is
// insert the price of the ticket at 6,40€
if (!IsSubscribed)
{
command.CommandText = "SELECT Cinema.Evento.Prezzo FROM Cinema.Evento WHERE Cinema.Evento.CodiceEvento = @CodiceEvento";
command.Parameters.Add("@CodiceEvento", SqlDbType.Int).Value = eventCode;
using (SqlDataReader reader = command.ExecuteReader()) {
while (reader.Read())
{
price = reader.GetDecimal(0);
}
}
}
// Reset the Parameters
command.Parameters.Clear();
// Insert the Prenotation into the database
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "Cinema.AddNewPrenotazione";
command.Parameters.Add("@DataOra", SqlDbType.DateTime).Value = dateTime;
command.Parameters.Add("@Username_UtenteFree", SqlDbType.VarChar).Value = usernameUser;
command.Parameters.Add("@Codice_Evento", SqlDbType.Int).Value = eventCode;
command.Parameters.Add("@Prezzo", SqlDbType.Decimal).Value = price;
command.Parameters.Add("@CodicePrenotazione", SqlDbType.Int).Direction = ParameterDirection.Output;
command.ExecuteNonQuery();
// Create a Prenotation Object
Prenotation prenotation = new Prenotation(Convert.ToInt32(command.Parameters["@CodicePrenotazione"].Value),
dateTime, usernameUser, eventCode);
// Initialize a int value to check if the Stored Procedure success
var returnParameter1 = command.Parameters.Add("@ReturnVal", SqlDbType.Int);
returnParameter1.Direction = ParameterDirection.ReturnValue;
//Reset the parameters
command.Parameters.Clear();
// Insert data in Reserve table in the database
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "Cinema.AddNewRiserva";
command.Parameters.Add("@Numero_Posto", SqlDbType.Int).Value = placeNumber;
command.Parameters.Add("@Codice_Prenotazione", SqlDbType.Int).Value = prenotation.PrenotationCode;
command.ExecuteNonQuery();
// Initialize a int value to check if the Stored Procedure success
var returnParameter2 = command.Parameters.Add("@ReturnVal", SqlDbType.Int);
returnParameter2.Direction = ParameterDirection.ReturnValue;
// Commit the transaction
transaction.Commit();
// If both the int value > 0 the Stored Procedure both success
if (returnParameter1.Direction > 0 && returnParameter2.Direction > 0)
{
return(true);
}
else
{
command.Parameters.Clear();
return(false);
}
}
catch (SqlException ex) {
Console.WriteLine("\nCommit Exception Type: {0}", ex.GetType());
Console.WriteLine(" Message: {0}", ex.Message);
// Attempt to roll back the transaction.
try {
transaction.Rollback();
}
catch (Exception ex2) {
// This catch block will handle any errors that may have occurred
// on the server that would cause the rollback to fail
Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType());
Console.WriteLine(" Message: {0}", ex2.Message);
}
return(false);
}
}
}
