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