private SqlCommand buildCommand(SqlCommand command, DataLayer.Models.TicketDTO Ticket)
{
command.Parameters.AddWithValue("ID", Ticket.ID);
command.Parameters.AddWithValue("ShowID", Ticket.ShowID);
command.Parameters.AddWithValue("Row", Ticket.Row);
command.Parameters.AddWithValue("Seat", Ticket.Seat);
return(command);
}
public TicketDTO map(TicketModel model)
{
DataLayer.Models.TicketDTO dto = new DataLayer.Models.TicketDTO();
dto.ID = model.ID;
dto.ShowID = model.ShowID;
dto.Row = model.Row;
dto.Seat = model.Seat;
return(dto);
}
public bool create(DataLayer.Models.TicketDTO Ticket)
{
try
{
SqlCommand command = buildCommand(new SqlCommand(), Ticket);
command.Connection = new SqlConnection("Data Source=198.38.83.33;Initial Catalog=geluvac_assignment1;User ID=geluvac_andreitudorica;Password=Andrei1234");
command.Connection.Open();
command.CommandText = "INSERT INTO Tickets (ShowID,Row,Seat) VALUES (@ShowID,@Row,@Seat)";
command.ExecuteNonQuery();
command.Connection.Close();
//to be optimized
inMemoryTickets = new List <Models.TicketDTO>();
getAllFromDB();
return(true);
}
catch { }
return(false);
}
public bool update(DataLayer.Models.TicketDTO Ticket)
{
try
{
SqlCommand command = buildCommand(new SqlCommand(), Ticket);
command.Connection = new SqlConnection("Data Source=198.38.83.33;Initial Catalog=geluvac_assignment1;User ID=geluvac_andreitudorica;Password=Andrei1234");
command.Connection.Open();
command.CommandText = "UPDATE Tickets Set ShowID= @ShowID,Row=@Row,Seat=@Seat where ID=@ID";
command.ExecuteNonQuery();
command.Connection.Close();
//update DTO
//DataLayer.Models.TicketDTO TicketOld = inMemoryTickets.Find(x => x.ID == Ticket.ID);
// TicketOld = Ticket;
//to be checked
inMemoryTickets = new List <Models.TicketDTO>();
getAllFromDB();
return(true);
}
catch { }
return(false);
}
