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