public bool DeleteTicketss(TicketsMember ticketsMember)
{
return(_ticketsRepository.DeleteTickets(new TicketsMemberDAO
{
TicketId = ticketsMember.TicketId
}));
}
public bool InsertTicketss(TicketsMember ticketsMember)
{
return(_ticketsRepository.InsertTickets(new TicketsMemberDAO
{
SessionId = ticketsMember.SessionId,
Row = ticketsMember.Row,
Seat = ticketsMember.Seat,
Zone = ticketsMember.Zone,
Recall = ticketsMember.Recall,
Booking = ticketsMember.Booking
}));
}
public ValidationResultString InsertTicketss(TicketsMember ticketsMember)
{
if (sqlConnect.GetConnect)
{
sqlConnect.OpenConn();
}
ValidationResultString result = new ValidationResultString()
{
IsValid = true
};
try
{
string commPart = "INSERT INTO maindb.\"Tickets\" ( \"SessionId\", \"Row\", \"Seat\", \"Zone\", \"Booking\", \"Recall\") VALUES " +
" (@1, @2, @3, @4, @5, @6)";
NpgsqlCommand command = new NpgsqlCommand(commPart, sqlConnect.GetNewSqlConn().GetConn);
command.Parameters.AddWithValue("@1", Convert.ToInt32(ticketsMember.SessionId));
command.Parameters.AddWithValue("@2", Convert.ToInt32(ticketsMember.Row));
command.Parameters.AddWithValue("@3", Convert.ToInt32(ticketsMember.Seat));
command.Parameters.AddWithValue("@4", Convert.ToInt32(ticketsMember.Zone));
command.Parameters.AddWithValue("@5", ticketsMember.Booking);
command.Parameters.AddWithValue("@6", Convert.ToInt32(ticketsMember.Recall));
NpgsqlDataReader readerTable = command.ExecuteReader();
readerTable.Close();
}
catch (Npgsql.PostgresException exp)
{
return(new ValidationResultString
{
Errors = new List <string> {
exp.SqlState
}
});
}
finally
{
if (!sqlConnect.GetConnect)
{
sqlConnect.CloseConn();
}
}
return(result);
}
public ValidationResultString DeleteTicketss(TicketsMember ticketsMember)
{
if (sqlConnect.GetConnect)
{
sqlConnect.OpenConn();
}
ValidationResultString result = new ValidationResultString()
{
IsValid = true
};
try
{
string commPart = "DELETE FROM maindb.\"Tickets\" WHERE \"TicketID\"=@1";
NpgsqlCommand command = new NpgsqlCommand(commPart, sqlConnect.GetNewSqlConn().GetConn);
command.Parameters.AddWithValue("@1", Convert.ToInt32(ticketsMember.TicketId));
NpgsqlDataReader readerTable = command.ExecuteReader();
readerTable.Close();
}
catch (Npgsql.PostgresException exp)
{
return(new ValidationResultString
{
Errors = new List <string> {
exp.SqlState
}
});
}
finally
{
if (!sqlConnect.GetConnect)
{
sqlConnect.CloseConn();
}
}
return(result);
}
public bool InsertTickets(TicketsMember ticketsMember)
{
var res = InsertTicketss(ticketsMember);
return(res.IsValid);
}
public ValidationResultString UpdateTicketss(TicketsMember ticketsMember)
{
if (sqlConnect.GetConnect)
{
sqlConnect.OpenConn();
}
ValidationResultString result = new ValidationResultString()
{
IsValid = true
};
try
{
string commPart = " UPDATE maindb.\"Tickets\" " +
" SET \"SessionId\" = @1, \"Row\" = @2, " +
"\"Seat\" = @3, \"Zone\" = @4, \"Booking\" = @5, \"Recall\" = @6 " +
" WHERE \"TicketID\" = @8;";
NpgsqlCommand command = new NpgsqlCommand(commPart, sqlConnect.GetNewSqlConn().GetConn);
command.Parameters.AddWithValue("@1", Convert.ToInt32(ticketsMember.SessionId));
command.Parameters.AddWithValue("@2", Convert.ToInt32(ticketsMember.Row));
command.Parameters.AddWithValue("@3", Convert.ToInt32(ticketsMember.Seat));
command.Parameters.AddWithValue("@4", Convert.ToInt32(ticketsMember.Zone));
command.Parameters.AddWithValue("@5", Convert.ToBoolean(ticketsMember.Booking));
if (ticketsMember.Recall == String.Empty)
{
command.Parameters.AddWithValue("@6", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@6", Convert.ToInt32(ticketsMember.Recall));
}
command.Parameters.AddWithValue("@7", Convert.ToInt32(ticketsMember.TicketId));
NpgsqlDataReader readerTable = command.ExecuteReader();
readerTable.Close();
}
catch (Npgsql.PostgresException exp)
{
return(new ValidationResultString
{
Errors = new List <string> {
exp.SqlState
}
});
}
finally
{
if (!sqlConnect.GetConnect)
{
sqlConnect.CloseConn();
}
}
return(result);
}
public bool UpdateTickets(TicketsMember ticketsMember)
{
var res = UpdateTicketss(ticketsMember);
return(res.IsValid);
}
public bool DeleteTickets(TicketsMember ticketsMember)
{
var res = DeleteTicketss(ticketsMember);
return(res.IsValid);
}
