protected void Page_Load(object sender, EventArgs e)
{
if (!HttpContext.Current.User.Identity.IsAuthenticated)
{
Response.Redirect("Login");
}
if (getUser.getBenutzer(Int32.Parse(HttpContext.Current.User.Identity.Name)).RollenID != 4) // RollenID == 4 --> User == Rektor / Wenn User kein Rektor wird ihm die Seite nicht angezeigt
{
Response.Redirect("~/error?type=" + getUser.getBenutzer(Int32.Parse(HttpContext.Current.User.Identity.Name)).RollenID);
}
string connectionString = @"data source=(LocalDB)\MSSQLLocalDB;attachdbfilename=|DataDirectory|\SchulplanerDB.mdf;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"";
//
// In a using statement, acquire the SqlConnection as a resource.
//
using (SqlConnection con = new SqlConnection(connectionString))
{
//
// Open the SqlConnection.
//
con.Open();
//
// The following code uses an SqlCommand based on the SqlConnection.
//
using (SqlCommand command = new SqlCommand("SELECT * FROM OeffentlicherKalender", con))
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
// test.Text = reader.GetString(1);
OeffentlicherKalender ok = new OeffentlicherKalender();
ok.KalenderID = reader.GetInt32(0);
ok.Name = reader.GetString(1);
ok.Beschreibung = reader.GetString(2);
// eintrag.ErinnerungsID = reader.GetInt32(5); // Im moment no Null, wills noni gmacht isch
kalender.Add(ok);
DDL_Calendar.Items.Add(new ListItem(ok.Name));
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string connectionString = @"data source=(LocalDB)\MSSQLLocalDB;attachdbfilename=|DataDirectory|\SchulplanerDB.mdf;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"";
//
// In a using statement, acquire the SqlConnection as a resource.
//
using (SqlConnection con = new SqlConnection(connectionString))
{
//
// Open the SqlConnection.
//
con.Open();
//
// The following code uses an SqlCommand based on the SqlConnection.
//
using (SqlCommand command = new SqlCommand("SELECT * FROM OeffentlicherKalender", con))
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
// test.Text = reader.GetString(1);
OeffentlicherKalender ok = new OeffentlicherKalender();
ok.KalenderID = reader.GetInt32(0);
ok.Name = reader.GetString(1);
ok.Beschreibung = reader.GetString(2);
// eintrag.ErinnerungsID = reader.GetInt32(5); // Im moment no Null, wills noni gmacht isch
kalender.Add(ok);
DDL_Calendar.Items.Add(new ListItem(ok.Name));
}
}
}
}