public ServiceResult DeleteTheater(TheaterDTO dto) { ServiceResult serviceResult; _uow.BeginTran(); try { Theater theater = _uow.GetRepository <Theater>().Get(dto.Id); DtoToTheater(dto, theater); theater.IsDeleted = true; Theater deletedTheater = _uow.GetRepository <Theater>().Update(theater); if (deletedTheater != null) { _lc.AddLog <Theater>(theater, ProcessTypeEnum.Delete, theater.Id); _uow.Commit(); serviceResult = new ServiceResult("Salon başarıyla silindi.", ResultState.Success); } else { serviceResult = new ServiceResult("Yapılacak bir işlem kaydına rastlanamadı.", ResultState.Warning); } } catch (Exception ex) { _uow.Rollback(); serviceResult = new ServiceResult("Hata..", ResultState.Error); } return(serviceResult); }
public TheaterDTO GetOneTheater(Guid Id) { Theater theater = _uow.GetRepository <Theater>().Get(Id); TheaterDTO dto = new TheaterDTO(); TheaterToDto(theater, dto); return(dto); }
public async Task <TheaterDTO> UpdateTheater(int id, TheaterDTO theaterDTO) { var theater = _mapper.Map <Theater>(theaterDTO); theater.Id = id; await _theatersRepository.UpdateAsync(theater); return(_mapper.Map <TheaterDTO>(theater)); }
private void BtnDelete_Click(object sender, EventArgs e) { TheaterDTO dto = lstTheaters.SelectedItem as TheaterDTO; bool result = _tc.DeleteTheater(dto); if (result) { MessageBox.Show("Salon başarıyla silindi."); } }
public async Task <IActionResult> UpdateTheater(int id, TheaterDTO theaterDTO) { var updatedTheater = await _theaterService.UpdateTheater(id, theaterDTO); if (updatedTheater == null) { return(NotFound()); } return(Ok(updatedTheater)); }
public IActionResult AddTheaterAndAddress([FromBody] TheaterDTO addTheaterDTO) { var added = _theaterService.AddTheater(addTheaterDTO); if (added == null) { return(BadRequest()); } return(Ok(added)); }
public TheaterDTO AddTheater(TheaterDTO theaterDTO) { var theater = _mapper.Map <Theater>(theaterDTO); _theatersRepository.Insert(theater); _theatersRepository.Save(); return(_mapper.Map <TheaterDTO>(theater)); }
private List <TheaterDTO> TheaterToDto(IEnumerable <Theater> theaters) { List <TheaterDTO> result = new List <TheaterDTO>(); foreach (var theater in theaters) { TheaterDTO dto = new TheaterDTO(); TheaterToDto(theater, dto); result.Add(dto); } return(result); }
public bool UpdateTheater(TheaterDTO dto) { Theater theater = _uow.GetRepository <Theater>().Get(dto.Id); DtoToTheater(dto, theater); theater.UpdatedDate = DateTime.Now; Theater updatedTheater = _uow.GetRepository <Theater>().Update(theater); if (updatedTheater != null) { return(true); } return(false); }
public bool DeleteTheater(TheaterDTO dto) { Theater theater = _uow.GetRepository <Theater>().Get(dto.Id); DtoToTheater(dto, theater); theater.IsDeleted = true; Theater deletedTheater = _uow.GetRepository <Theater>().Update(theater); if (deletedTheater != null) { return(true); } return(false); }
private void TheaterToDto(Theater theater, TheaterDTO dto) { dto.Id = theater.Id; dto.TheaterName = theater.TheaterName; dto.IsActive = theater.IsActive; foreach (var item in theater.Seats) { SeatDTO dtoSeat = new SeatDTO(); dtoSeat.Id = item.Id; dtoSeat.SeatNo = item.SeatNo; dtoSeat.SeatTypeNo = item.SeatTypeNo; dto.Seats.Add(dtoSeat); } }
private void BtnAdd_Click(object sender, EventArgs e) { #region Validation if (string.IsNullOrWhiteSpace(txtTheaterName.Text)) { MessageBox.Show("Salon adı alanı boş bırakılamaz."); } #endregion TheaterDTO dto = new TheaterDTO() { TheaterName = txtTheaterName.Text }; bool result = _tc.AddTheater(dto); if (result) { MessageBox.Show("Salon başarıyla eklendi."); } }
public bool AddTheater(TheaterDTO dto) { Theater theater = new Theater() { Id = Guid.NewGuid(), TheaterName = dto.TheaterName, IsActive = true, CreatedDate = DateTime.Now, UserId = SessionHelper.CurrentUser.Id, }; Theater addedTheater = _uow.GetRepository <Theater>().Add(theater); if (addedTheater != null) { return(true); } return(false); }
//Henter alt fra et tablenavn public List <object> GetAll(string TableName, string ColumnToCheckName = null, string ValueToMatch = null, Type Type = null) { List <object> LisReturn = new List <object>(); string FilterString = string.Empty; if (ColumnToCheckName != null && ValueToMatch != null && Type != null) { if (Type == typeof(decimal)) { FilterString = (" WHERE " + ColumnToCheckName + " = " + ValueToMatch.Replace(",", ".")); } else if (Type == typeof(string)) { FilterString = (" WHERE " + ColumnToCheckName + " = '" + ValueToMatch + "'"); } else if (Type == typeof(bool)) { FilterString = (" WHERE " + ColumnToCheckName + " = " + (Convert.ToBoolean(ValueToMatch) ? 1 : 0)); } else if (Type == typeof(DateTime)) { FilterString = (" WHERE " + ColumnToCheckName + " = '" + Convert.ToDateTime(ValueToMatch).ToString("yyyy-MM-dd HH:mm:ss.fffffff") + "'"); } else if (Type == typeof(int)) { FilterString = (" WHERE " + ColumnToCheckName + " = " + ValueToMatch); } } try { using (SqlConnection Con = new SqlConnection(ConfigConnectionString)) { Con.Open(); string CommandString = "SELECT * FROM " + TableName + FilterString; using (SqlCommand Com = new SqlCommand(CommandString, Con)) { using (SqlDataReader reader = Com.ExecuteReader()) { while (reader.Read()) { bool Skip = false; object ObjReturn = new object(); switch (TableName) { case "Movie": MovieDTO Movie = new MovieDTO(); ObjReturn = Movie; break; case "Reservation": ReservationDTO Reservation = new ReservationDTO(); ObjReturn = Reservation; break; case "Resource": ResourceDTO Resource = new ResourceDTO(); ObjReturn = Resource; break; case "Screening": ScreeningDTO Screening = new ScreeningDTO(); ObjReturn = Screening; break; case "Seat": SeatDTO Seat = new SeatDTO(); ObjReturn = Seat; break; case "Theater": TheaterDTO Theater = new TheaterDTO(); ObjReturn = Theater; break; case "MovieScreening": MovieScreeningDTO MovieScreening = new MovieScreeningDTO(); ObjReturn = MovieScreening; break; case "ResourceScreening": ResourceScreeningDTO ResourceScreening = new ResourceScreeningDTO(); ObjReturn = ResourceScreening; break; default: ObjReturn = null; Skip = true; break; } if (!Skip) { //Løber igennem properties og sætter property til værdien den finder i rækkens felt med samme kolonnenavn som propertyname foreach (PropertyInfo pi in ObjReturn.GetType().GetProperties()) { pi.SetValue(ObjReturn, reader.GetValue(reader.GetOrdinal(pi.Name))); } LisReturn.Add(ObjReturn); } } } } } } catch (Exception Ex) { LisReturn.Add(Ex); } return(LisReturn); }
private void TheaterToDto(Theater theater, TheaterDTO dto) { dto.Id = theater.Id; dto.TheaterName = theater.TheaterName; }
private void DtoToTheater(TheaterDTO dto, Theater theater) { theater.Id = dto.Id; theater.TheaterName = dto.TheaterName; }
public ServiceResult AddTheater(TheaterDTO dto) { ServiceResult serviceResult; _uow.BeginTran(); try { #region Validation Theater validation = _uow.GetRepository <Theater>().GetSpesific(t => t.TheaterName == dto.TheaterName && t.IsDeleted == false); if (validation != null) { serviceResult = new ServiceResult("Aynı isimde bir salon eklenemez.", ResultState.Warning); return(serviceResult); } #endregion Theater theater = new Theater() { Id = Guid.NewGuid(), TheaterName = dto.TheaterName, IsActive = true, CreatedDate = DateTime.Now, UserId = SessionHelper.CurrentUser.Id, }; ICollection <Seat> seats = _uow.GetRepository <Seat>().Get(s => s.IsDeleted == false); if (seats.Count == 0) { List <Seat> newseats = new List <Seat>(); //A for (int i = 1; i < 9; i++) { Seat seat = new Seat(); seat.Id = Guid.NewGuid(); seat.SeatTypeNo = SeatTypeEnum.A; seat.SeatNo = i; seat.CreatedDate = DateTime.Now; seat.IsActive = true; seat.IsDeleted = false; newseats.Add(seat); } //B for (int i = 1; i < 9; i++) { Seat seat = new Seat(); seat.Id = Guid.NewGuid(); seat.SeatTypeNo = SeatTypeEnum.B; seat.SeatNo = i; seat.CreatedDate = DateTime.Now; seat.IsActive = true; seat.IsDeleted = false; newseats.Add(seat); } //C for (int i = 1; i < 9; i++) { Seat seat = new Seat(); seat.Id = Guid.NewGuid(); seat.SeatTypeNo = SeatTypeEnum.C; seat.SeatNo = i; seat.CreatedDate = DateTime.Now; seat.IsActive = true; seat.IsDeleted = false; newseats.Add(seat); } //D for (int i = 1; i < 9; i++) { Seat seat = new Seat(); seat.Id = Guid.NewGuid(); seat.SeatTypeNo = SeatTypeEnum.D; seat.SeatNo = i; seat.CreatedDate = DateTime.Now; seat.IsActive = true; seat.IsDeleted = false; newseats.Add(seat); } //E for (int i = 1; i < 9; i++) { Seat seat = new Seat(); seat.Id = Guid.NewGuid(); seat.SeatTypeNo = SeatTypeEnum.E; seat.SeatNo = i; seat.CreatedDate = DateTime.Now; seat.IsActive = true; seat.IsDeleted = false; newseats.Add(seat); } foreach (var seat in newseats) { _uow.GetRepository <Seat>().Add(seat); } seats = _uow.GetRepository <Seat>().Get(s => s.IsDeleted == false); } foreach (var item in seats) { theater.Seats.Add(item); } Theater addedTheater = _uow.GetRepository <Theater>().Add(theater); if (addedTheater != null) { _lc.AddLog <Theater>(theater, ProcessTypeEnum.Add, theater.Id); _uow.Commit(); serviceResult = new ServiceResult("Salon başarıyla eklendi.", ResultState.Success); } else { serviceResult = new ServiceResult("Yapılacak bir işlem kaydına rastlanamadı.", ResultState.Warning); } } catch (Exception ex) { _uow.Rollback(); serviceResult = new ServiceResult("Hata..", ResultState.Error); } return(serviceResult); }
private void BtnUpdate_Click(object sender, EventArgs e) { TheaterDTO dto = lstTheaters.SelectedItem as TheaterDTO; this.MdiBroShow <FormTheaterUpdate, TheaterDTO>(dto); }
protected void SeedButton_Click(object sender, EventArgs e) { SQLConnector con = new SQLConnector(); //Henter alt ud fra respektive tabeller List <MovieDTO> lisMovies = new List <MovieDTO>(); lisMovies = con.GetAll("Movie").Cast <MovieDTO>().ToList(); List <ResourceDTO> lisResource = new List <ResourceDTO>(); lisResource = con.GetAll("Resource").Cast <ResourceDTO>().ToList(); List <TheaterDTO> lisTheater = new List <TheaterDTO>(); lisTheater = con.GetAll("Theater").Cast <TheaterDTO>().ToList(); List <ScreeningDTO> lisScreening = new List <ScreeningDTO>(); lisScreening = con.GetAll("Screening").Cast <ScreeningDTO>().ToList(); //Skaber objekter i respektive elementer MovieDTO movie2 = new MovieDTO() { Title = "Title Only", Description = "Description Only", PosterFileName = "PosterFileName Only", Price = 13.37M }; ResourceDTO resource = new ResourceDTO() { LoginName = "BoNi", LoginPassword = "******", FirstName = "Bo", LastName = "Nielsen", Employee = false, Email = "*****@*****.**" }; TheaterDTO theater = new TheaterDTO() { Name = "Sal 1", NumberOfSeats = 40 }; ScreeningDTO screening = new ScreeningDTO() { MovieId = 1, TheaterId = 1, StartDate = DateTime.Now, EndDate = DateTime.Now.AddHours(3), AvailableSeats = 40 }; movie2 = (MovieDTO)con.CreateObject(movie2); resource = (ResourceDTO)con.CreateObject(resource); theater = (TheaterDTO)con.CreateObject(theater); screening = (ScreeningDTO)con.CreateObject(screening); //Eksempel på hente alle screenings med MovieId = 3 List <ScreeningDTO> lisTestScreening = new List <ScreeningDTO>(); lisTestScreening = con.GetAll("Screening", "MovieId", "3", typeof(int)).Cast <ScreeningDTO>().ToList(); //Henter alle resources (brugere) med Employee = 1, dvs ansatte/admins List <ResourceDTO> lisTestResource = new List <ResourceDTO>(); lisTestResource = con.GetAll("Resource", "Employee", "true", typeof(bool)).Cast <ResourceDTO>().ToList(); //Eksempel på updating af et objekt MovieDTO movie3 = new MovieDTO() { Id = 1, Title = "UPDATED Title Only", Description = "UPDATED Description Only", PosterFileName = "UPDATED PosterFileName Only", Price = 1113.37M }; movie3 = (MovieDTO)con.UpdateObject(movie3); string tempString = string.Empty; foreach (var item in lisMovies) { foreach (var pi in item.GetType().GetProperties()) { tempString += pi.Name + ": " + Convert.ToString(pi.GetValue(item)) + "<br />"; } } //Anden test TestLabel.Text = tempString; }
public FormTheaterUpdate(TheaterDTO dto) { InitializeComponent(); _dto = dto; _tc = new TheaterController(); }
//Henter en række fra et tablenavn hvor id findes public object Get(string TableName, int Id) { object ObjReturn = new object(); switch (TableName) { case "Movie": MovieDTO Movie = new MovieDTO(); ObjReturn = Movie; break; case "Reservation": ReservationDTO Reservation = new ReservationDTO(); ObjReturn = Reservation; break; case "Resource": ResourceDTO Resource = new ResourceDTO(); ObjReturn = Resource; break; case "Screening": ScreeningDTO Screening = new ScreeningDTO(); ObjReturn = Screening; break; case "Seat": SeatDTO Seat = new SeatDTO(); ObjReturn = Seat; break; case "Theater": TheaterDTO Theater = new TheaterDTO(); ObjReturn = Theater; break; case "MovieScreening": MovieScreeningDTO MovieScreening = new MovieScreeningDTO(); ObjReturn = MovieScreening; break; default: ObjReturn = null; break; } if (ObjReturn != null) { try { using (SqlConnection con = new SqlConnection(ConfigConnectionString)) { con.Open(); using (SqlCommand com = new SqlCommand("SELECT * FROM " + TableName + " where id = " + Id.ToString(), con)) { using (SqlDataReader reader = com.ExecuteReader()) { while (reader.Read()) { //Løber igennem properties og sætter property til værdien den finder i rækkens felt med samme kolonnenavn som propertyname foreach (PropertyInfo pi in ObjReturn.GetType().GetProperties()) { pi.SetValue(ObjReturn, reader.GetValue(reader.GetOrdinal(pi.Name))); } } } } } } catch (Exception Ex) { return(Ex); } } return(ObjReturn); }