protected void Page_Load(object sender, EventArgs e)
{
ValidateEmployee val = new ValidateEmployee();
if (!val.IsEmployee(Context.User.Identity.Name))
{
Response.Redirect("default.aspx");
}
SQLConnector con = new SQLConnector();
List <ResourceScreeningDTO> lisResScre = new List <ResourceScreeningDTO>();
lisResScre = con.GetAll("ResourceScreening").Cast <ResourceScreeningDTO>().ToList();
//Lav table
HtmlGenericControl table = new HtmlGenericControl("TABLE");
table.Attributes["class"] = "table table-hover";
BodyDiv.Controls.Add(table);
//Lav header
ResourceScreeningDTO dummy = new ResourceScreeningDTO();
TableRow HeaderRow = new TableRow();
foreach (PropertyInfo pi in dummy.GetType().GetProperties())
{
TableCell HeaderCell = new TableCell
{
Text = pi.Name
};
HeaderRow.Cells.Add(HeaderCell);
}
Reservation.Rows.Add(HeaderRow);
foreach (ResourceScreeningDTO lisRow in lisResScre)
{
TableRow CurrentRow = new TableRow();
TableCell FirstCell = new TableCell
{
Text = lisRow.FirstName
};
CurrentRow.Cells.Add(FirstCell);
foreach (PropertyInfo pi in lisRow.GetType().GetProperties())
{
if (pi.Name != "FirstName")
{
TableCell CurrentCell = new TableCell
{
Text = Convert.ToString(pi.GetValue(lisRow))
};
CurrentRow.Cells.Add(CurrentCell);
}
}
Reservation.Rows.Add(CurrentRow);
}
}
//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);
}
