protected void Page_Load(object sender, EventArgs e)
{
var announcementList = new List <Announcement>();
SqlConnection myConnection;
using (myConnection = new SqlConnection(System.Configuration.ConfigurationManager
.ConnectionStrings["localdbConnectionString1"].ConnectionString))
{
myConnection.Open();
string query = " SELECT *" +
" FROM [dbo].[Announcements] a";
SqlCommand command = new SqlCommand(query, myConnection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
// Create a list of 'QuizQuestion', in the 'categoryQuestions' variable.
while (reader.Read())
{
var id = int.Parse(reader["Id"].ToString());
var description = reader["Description"].ToString();
var startDate = DateTime.Parse(reader["StartDate"].ToString()).ToShortDateString();
var endDate = DateTime.Parse(reader["EndDate"].ToString()).ToShortDateString();
announcementList.Add(new Announcement(id, description, startDate, endDate));
}
}
AnnouncementRepeater.DataSource = announcementList;
AnnouncementRepeater.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
var announcementList = new List <Announcement>();
//String permission = (String)Session["permission"];
String permission = Kali_Web.Account.Login.globaldbpermission;
if (permission == null || permission == "")
{
Response.Redirect("/Account/Login.aspx");
}
else if (permission == "lecturer")
{
Response.Redirect("HomeLect.aspx");
}
String sessionemail = (String)Session["email"];
SqlConnection myConnection;
using (myConnection = new SqlConnection(System.Configuration.ConfigurationManager
.ConnectionStrings["localdbConnectionString1"].ConnectionString))
{
myConnection.Open();
string query = "SELECT * FROM [User] WHERE [Email_Address] = @email";
SqlCommand myCommand = new SqlCommand(query, myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@email", sessionemail);
SqlDataReader reader = myCommand.ExecuteReader();
if (reader.Read())
{
VAA.Visible = (Boolean)reader["VAAccess"];
IGA.Visible = (Boolean)reader["IGAccess"];
PWA.Visible = (Boolean)reader["PWAccess"];
}
}
using (myConnection = new SqlConnection(System.Configuration.ConfigurationManager
.ConnectionStrings["localdbConnectionString1"].ConnectionString))
{
myConnection.Open();
string query = " SELECT *" +
" FROM [dbo].[Announcements] a";
SqlCommand command = new SqlCommand(query, myConnection);
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var id = int.Parse(reader["Id"].ToString());
var description = reader["Description"].ToString();
var startDate = DateTime.Parse(reader["StartDate"].ToString()).ToShortDateString();
var endDate = DateTime.Parse(reader["EndDate"].ToString()).ToShortDateString();
announcementList.Add(new Announcement(id, description, startDate, endDate));
}
}
AnnouncementRepeater.DataSource = announcementList;
AnnouncementRepeater.DataBind();
}
using (myConnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["localdbConnectionString1"].ConnectionString))
{
string query = "SELECT COUNT(DISTINCT Category) AS Count FROM [QuizzResult] WHERE [UserId] = (SELECT Id FROM [User] WHERE [Email_Address]= @email)";
//string query = "SELECT COUNT(DISTINCT Category) AS Count FROM [QuizzResult] WHERE [UserId] = 4";
SqlCommand myCommand = new SqlCommand(query, myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@email", sessionemail);
myConnection.Open();
SqlDataReader reader = myCommand.ExecuteReader();
if (reader.Read())
{
double noOfTest = double.Parse(reader["Count"].ToString());
double percentage = (noOfTest / 3) * 100;
HtmlGenericControl div = new HtmlGenericControl("div");
div.Attributes.Add("id", "bar");
div.Attributes.Add("Style", "background-color: #0a0; width:" + percentage + "% ; text-align:center; text-color:#000;");
HtmlGenericControl divTxt = new HtmlGenericControl("div");
divTxt.Attributes.Add("id", "barTxt");
divTxt.InnerHtml = Math.Truncate(percentage) + "%";
divTxt.Attributes.Add("Style", "text=align:center;");
div.Controls.Add(divTxt);
meter.Controls.Add(div);
}
}
}