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