protected void RoutineAddBtn_Click(object sender, EventArgs e) { RFV_ClassList.Enabled = true; RFV_FacultyList.Enabled = true; //RFV_section_drp.Enabled = true; RFV_Semester_drp.Enabled = true; RFV_subjectlist_drp.Enabled = true; RFV_YearList.Enabled = true; Page.Validate(); if (Page.IsValid) { if (ClassList.SelectedIndex != 0 && FacultyList.SelectedIndex != 0 && Semester_drp.SelectedIndex != 0 && subjectlist_drp.SelectedIndex != 0 && YearList.SelectedIndex != 0) { Routine routine = new Routine { Fid = Convert.ToInt16(FacultyList.SelectedValue), ClassId = Convert.ToInt16(ClassList.SelectedValue), EnrollYear = YearList.SelectedItem.Text, Semester = Semester_drp.SelectedItem.Text, SubjectID = subjectlist_drp.SelectedItem.Value, SectionName = section_drp.SelectedItem.Text }; int added = CCMSBusinessLayer.AddRoutine(routine); if (added > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "Success !! ", "alert('Routine details has been added.');", true); } connectionString = ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString; string sqlQuery = "Select routine.routineId, Users.FirstName + ' ' +Users.LastName as FacultyName, class.ClassName, routine.SectionName, Syllabus.Subject_Name from routine " + "inner join Users on routine.Fid = Users.UserID " + "join class on routine.ClassId = class.ClassId " + "join Syllabus on routine.SubjectId=Syllabus.Subject_Code order by Subject_Name;"; using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand(sqlQuery, con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); RoutineGridView.DataSource = rdr; RoutineGridView.DataBind(); } } clear(); } }
public void deleteRow(object sender, GridViewDeleteEventArgs e) { int id = e.RowIndex; SqlConnection con = new SqlConnection(connectionString); GridViewRow row = RoutineGridView.Rows[id] as GridViewRow; int routineId = Convert.ToInt32(row.Cells[0].Text); String query = "Delete from routine where routineId = @routineId"; SqlParameter[] parameter = new SqlParameter[1]; Routine routine = new Routine { Fid = routineId }; parameter[0] = new SqlParameter("@routineId", routine.Fid); int result = DataService.WriteToDB(query, parameter); if (result == 1) { connectionString = ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString; string sqlQuery = "Select routine.routineId, Users.FirstName + ' ' +Users.LastName as FacultyName, class.ClassName, routine.SectionName, Syllabus.Subject_Name from routine " + "inner join Users on routine.Fid = Users.UserID " + "join class on routine.ClassId = class.ClassId " + "join Syllabus on routine.SubjectId=Syllabus.Subject_Code order by Subject_Name;"; using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand(sqlQuery, conn); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); RoutineGridView.DataSource = rdr; RoutineGridView.DataBind(); ContentPlaceHolder mcon = new ContentPlaceHolder(); mcon = (ContentPlaceHolder)Master.FindControl("pageContent2"); mcon.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { connectionString = ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString; string sqlQuery = "select routine.routineId, faculty.FirstName + ' ' + faculty.LastName as FacultyName from routine inner join faculty on routine.Fid = faculty.FId"; using (SqlConnection con = new SqlConnection(connectionString)) { //DataTable fullTable = new DataTable(); SqlCommand cmd = new SqlCommand(sqlQuery, con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); //fullTable.Columns.Add(dcol1); //Persist the table in the Session object. RoutineGridView.DataSource = rdr; RoutineGridView.DataBind(); } } }
protected void populateData() { connectionString = ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString; string sqlQuery = "Select routine.routineId, Users.FirstName + ' ' +Users.LastName as FacultyName, class.ClassName, routine.SectionName, Syllabus.Subject_Name from routine " + "inner join Users on routine.Fid = Users.UserID " + "join class on routine.ClassId = class.ClassId " + "join Syllabus on routine.SubjectId=Syllabus.Subject_Code order by Subject_Name;"; using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand(sqlQuery, con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); RoutineGridView.DataSource = rdr; RoutineGridView.DataBind(); } ContentPlaceHolder mcon = new ContentPlaceHolder(); mcon = (ContentPlaceHolder)Master.FindControl("pageContent2"); mcon.Visible = true; }
public void showClasses() { ContentPlaceHolder mcon = new ContentPlaceHolder(); mcon = (ContentPlaceHolder)Master.FindControl("pageContent2"); mcon.Visible = true; RFV_FacultyList.Enabled = false; RFV_ClassList.Enabled = false; RFV_YearList.Enabled = false; RFV_Semester_drp.Enabled = false; //RFV_section_drp.Enabled = false; RFV_subjectlist_drp.Enabled = false; Page.Validate(); connectionString = ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString; string sqlQuery = "Select routine.routineId, Users.FirstName + ' ' +Users.LastName as FacultyName, class.ClassName, routine.SectionName, routine.Semester from routine " + "inner join Users on routine.Fid = Users.UserID " + "join class on routine.ClassId = class.ClassId;"; using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand(sqlQuery, conn); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); RoutineGridView.DataSource = rdr; RoutineGridView.DataBind(); } RFV_FacultyList.Enabled = true; RFV_ClassList.Enabled = true; RFV_YearList.Enabled = true; RFV_Semester_drp.Enabled = true; //RFV_section_drp.Enabled = true; RFV_subjectlist_drp.Enabled = true; }
protected void RoutineGrid_Edit(object sender, GridViewEditEventArgs e) { RoutineGridView.EditIndex = e.NewEditIndex; RoutineGridView.DataBind(); }