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