protected void ScreeningCreate_Click(object sender, EventArgs e)
{
//Create Screening in DB
SQLConnector con = new SQLConnector();
ScreeningDTO newScreening = new ScreeningDTO
{
MovieId = Convert.ToInt32(MovieDropDownList.Text),
TheaterId = Convert.ToInt32(TheaterDropDownList.Text),
StartDate = Convert.ToDateTime(InputStartDate.Value.ToString()),
EndDate = Convert.ToDateTime(InputEndDate.Value.ToString()),
AvailableSeats = Convert.ToInt32(InputSeats.Value)
};
newScreening = (ScreeningDTO)(con.CreateObject(newScreening));
//Show the Created Screening on site.
string strTemp = string.Empty;
object obj = newScreening;
foreach (PropertyInfo pi in obj.GetType().GetProperties())
{
strTemp += pi.Name + ": " + pi.GetValue(obj) + "<br />";
}
VisVisningLabel.Text = strTemp;
}
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;
}
//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);
}
//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);
}
