private SqlCommand buildCommand(SqlCommand command, DataLayer.Models.ShowDTO show) { command.Parameters.AddWithValue("ID", show.ID); command.Parameters.AddWithValue("NumberOfTickets", show.NumberOfTickets); command.Parameters.AddWithValue("Genre", show.Genre); command.Parameters.AddWithValue("Date", show.Date.ToString()); command.Parameters.AddWithValue("Distribution", show.Distribution); command.Parameters.AddWithValue("Title", show.Title); return(command); }
public DataLayer.Models.ShowDTO map(ServicesLayer.Models.ShowModel model) { DataLayer.Models.ShowDTO dto = new DataLayer.Models.ShowDTO(); dto.ID = model.ID; dto.Title = model.Title; dto.Genre = model.Genre; dto.Distribution = model.Distribution; dto.Date = model.Date; dto.NumberOfTickets = model.NumberOfTickets; return(dto); }
public ServicesLayer.Models.ShowModel map(DataLayer.Models.ShowDTO dto) { ServicesLayer.Models.ShowModel model = new ServicesLayer.Models.ShowModel(); model.ID = dto.ID; model.Title = dto.Title; model.Genre = dto.Genre; model.Distribution = dto.Distribution; model.Date = dto.Date; model.NumberOfTickets = dto.NumberOfTickets; return(model); }
public bool create(DataLayer.Models.ShowDTO show) { try { SqlCommand command = buildCommand(new SqlCommand(), show); 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 Shows (Title,Genre,Distribution,Date,NumberOfTickets) VALUES (@Title,@Genre,@Distribution,@Date,@NumberOfTickets)"; command.ExecuteNonQuery(); command.Connection.Close(); //to be optimized inMemoryShows = new List <Models.ShowDTO>(); getAllFromDB(); return(true); } catch { } return(false); }
public bool update(DataLayer.Models.ShowDTO show) { try { SqlCommand command = buildCommand(new SqlCommand(), show); 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 Shows Set Title= @Title,Genre=@Genre,Distribution=@Distribution,Date=@Date,NumberOfTickets=@NumberOfTickets where ID=@ID"; command.ExecuteNonQuery(); command.Connection.Close(); //update DTO //DataLayer.Models.ShowDTO showOld = inMemoryShows.Find(x => x.ID == show.ID); // showOld = show; //to be checked inMemoryShows = new List <Models.ShowDTO>(); getAllFromDB(); return(true); } catch { } return(false); }