/// <summary>
/// Handle department list change
/// Get available from selected department
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void departmentList_SelectedIndexChanged(object sender, EventArgs e)
{
var departmentId = int.Parse(departmentList.SelectedValue);
CourseList.DataSource = course.GetCourseByDepartmentId(departmentId);
CourseList.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string pagename = Path.GetFileName(Request.PhysicalPath);
if (Session["admin"] != null)
{
string action = Request.QueryString["action"];
id = int.Parse(Request.QueryString["Timetableid"]);
if (!IsPostBack)
{
DBFunctions db = new DBFunctions();
if (action == "update")
{
CourseList.DataSource = db.getcourselist();
CourseList.DataValueField = "ID";
CourseList.DataTextField = "Course";
CourseList.DataBind();
// Courses_tbl course = db.getcourses(id);
TimeTable_tbl ds = db.getTimeTable(id);
DropDownDay.SelectedValue = ds.Day;
STime.Text = ds.StartTime;
ETime.Text = ds.EndTime;
TeacherList.SelectedValue = ds.Teacher;
}
else
{
}
}
}
else
{
Response.Redirect("Login.aspx?Redirecturl=" + pagename);
}
}
private void LoadCourses()
{
using (MySqlConnection sqlCon = new MySqlConnection(conn))
{
DataTable courses = new DataTable();
sqlCon.Open();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT name FROM courses", conn);
adapter.Fill(courses);
CourseList.DataSource = courses;
CourseList.DataTextField = "name";
CourseList.DataValueField = "name";
CourseList.DataBind();
}
}
private void GetStudentInfo()
{
string studentID = Session["currentStudentID"] as string;
int sID;
int.TryParse(studentID, out sID);
//get student info from the database
SqlCommand comm = new SqlCommand("Select * from Students " +
"where Students.StudentID = @sID;", connection);
comm.Parameters.Add("@sID", System.Data.SqlDbType.Int);
comm.Parameters["@sID"].Value = sID;
try
{
connection.Open();
SqlDataReader reader = comm.ExecuteReader();
if (reader.Read())
{
//setName
stName.Text = reader["FirstMidName"] + " " + reader["LastName"];
//setID
stID.Text = reader["StudentID"] + "";
//setDate
stDate.Text = reader["EnrollmentDate"] + "";
}
reader.Close();
//setCourse
SqlCommand comm2 = new SqlCommand("SELECT * FROM dbo.Courses " +
"INNER JOIN dbo.Enrollments ON dbo.Courses.CourseID = dbo.Enrollments.CourseID " +
"WHERE dbo.Enrollments.StudentID = @sID;", connection);
comm2.Parameters.Add("@sID", System.Data.SqlDbType.Int);
comm2.Parameters["@sID"].Value = sID;
reader = comm2.ExecuteReader();
CourseList.DataSource = reader;
CourseList.DataBind();
reader.Close();
}
catch
{
Response.Write("Error");
}
}
private void CourseBindList()
{
int StudentID = Convert.ToInt32(Request.QueryString["StudentID"]);
string connectionString = ConfigurationManager.ConnectionStrings["Assginment_03"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand comm = new SqlCommand("SELECT * FROM Courses WHERE CourseID IN (SELECT CourseID FROM Enrollments WHERE StudentID=" + StudentID + ")", conn);
try
{
// Open the connection
conn.Open();
SqlDataReader reader = comm.ExecuteReader();
CourseList.DataSource = reader;
CourseList.DataBind();
reader.Close();
}
finally
{
conn.Close();
}
}
private void CourseBindList()
{
int CourseID = Convert.ToInt32(Request.QueryString["CourseID"]);
string connectionString = ConfigurationManager.ConnectionStrings["Assginment_03"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand comm = new SqlCommand("select * from Students where StudentID in (select StudentID from Enrollments where CourseID=@CourseID)", conn);
comm.Parameters.AddWithValue("@CourseID", CourseID);
try
{
conn.Open();
SqlDataReader reader = comm.ExecuteReader();
CourseList.DataSource = reader;
CourseList.DataBind();
reader.Close();
}
finally
{
conn.Close();
}
}
protected void StudentGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int StudentID = Convert.ToInt32(Request.QueryString["StudentID"]);
string connectionString = ConfigurationManager.ConnectionStrings["Assginment_03"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
SqlCommand comm = new SqlCommand("delete from Enrollments where StudentID = @StudentID", conn);
comm.Parameters.AddWithValue("@StudentID", StudentID);
comm = new SqlCommand("delete from Students where StudentID = @StudentID", conn);
comm.Parameters.AddWithValue("@StudentID", StudentID);
try
{
conn.Open();
SqlDataReader reader = comm.ExecuteReader();
CourseList.DataSource = reader;
CourseList.DataBind();
reader.Close();
}
finally
{
conn.Close();
Response.Redirect("Default.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string pagename = Path.GetFileName(Request.PhysicalPath);
if (Session["admin"] != null)
{
if (!IsPostBack)
{
for (int i = 1; i <= 31; i++)
{
dropdownDate.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
for (int i = 1; i <= 12; i++)
{
DropDownMonth.Items.Add(new ListItem(i.ToString(), i.ToString()));
}
DBFunctions db = new DBFunctions();
int pageStart = 1;
int pageEnd = 10;
if (Request.QueryString.ToString().Contains("page"))
{
page = Convert.ToInt32(Request.QueryString["page"].ToString());
pageEnd = pageSize * page;
pageStart = (pageEnd - pageSize) + 1;
}
List <DateSheet_tbl> ds = new List <DateSheet_tbl>();
ds = db.getDateSheetlist(pageStart, pageEnd);
literalStart.Text = pageStart.ToString();
literalEnd.Text = pageEnd.ToString();
int tmpPageEnd = 0;
tmpPageEnd = pageEnd;
pageEnd = db.getDateSheet_Count();
if (pageEnd > 10)
{
literalTotal.Text = pageEnd.ToString();
int pagett = 0;
pagett = Convert.ToInt16(literalEnd.Text);
if (pagett > pageEnd)
{
literalEnd.Text = pageEnd.ToString();
}
}
else
{
if (pageEnd == 0)
{
literalStart.Text = "";
}
literalTotal.Text = pageEnd.ToString();
literalEnd.Text = pageEnd.ToString();
}
string tmpUrl = string.Empty;
tmpUrl = "AddDateSheet.aspx?" + Request.QueryString.ToString();
if (tmpUrl.Contains("?page"))
{
tmpUrl = tmpUrl.Remove(tmpUrl.IndexOf("?page"));
}
StringBuilder listingString = new StringBuilder();
if (ds != null)
{
loadDateSheet(ds);
}
if (pageEnd > 10)
{
StringBuilder paging = new StringBuilder();
int counterPage = 1;
int totalPages = 1;
totalPages = (pageEnd / 10) + 1;
string urlMain = string.Empty;
urlMain = Request.Url.ToString();
if (urlMain.Contains("?page"))
{
urlMain = urlMain.Remove(urlMain.IndexOf("?page"));
}
for (int i = 1; i <= totalPages; i++)
{
string newPageString = string.Empty;
if (i == 1)
{
newPageString = "<li><a aria-label=\"First\" href=\"" + urlMain + "\" ><<</a></li>";
if (page == i)
{
newPageString += "<li><a style=\"color:#000000;background: #f0f0f0;\" href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>";
}
else
{
newPageString += "<li><a href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>";
}
}
else if (i == totalPages)
{
if (page == i)
{
newPageString += "<li><a style=\"color:#000000;background: #f0f0f0;\" href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>";
}
else
{
newPageString += "<li><a href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>";
}
newPageString += "<li><a aria-label=\"Last\" href=\"" + urlMain + "?page=" + totalPages + "\" >>></a></li>";
}
else
{
if (page == i)
{
newPageString += "<li><a style=\"color:#000000;background: #f0f0f0;\" href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>";
}
else
{
newPageString += "<li><a href=\"" + urlMain + "?page=" + i + "\" >" + i + "</a></li>";
}
}
counterPage++;
paging.Append(newPageString);
}
literalPaging.Text = paging.ToString();
}
CourseList.DataSource = db.getcourselist();
CourseList.Items.Add("----------");
CourseList.DataTextField = "Course";
CourseList.DataValueField = "ID";
CourseList.DataBind();
}
}
else
{
Response.Redirect("Login.aspx?Redirecturl=" + pagename);
}
}
private void BindList()
{
ListControl.DataBind(CourseLogic.GetAll().ToList());
}
