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