protected void ddlselectoption_SelectedIndexChanged(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(ddlselectoption.SelectedItem.Value))
{
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.EmployeeID = AppSessions.EmpolyeeID;
DataSet dsSelect = new DataSet();
dsSelect = obj_BAL_Teacher_Dashboard.BAL_Select_Chapters_Topics_By_CoveredStatus(obj_Teacher_Dashboard, ddlselectoption.SelectedItem.Value);
GVChapter.DataSource = dsSelect.Tables[0];
GVChapter.DataBind();
if (dsSelect.Tables[0].Rows.Count > 0)
{
btnsearcksubmit.Enabled = true;
}
else
{
btnsearcksubmit.Enabled = false;
}
}
else
{
GVChapter.DataSource = null;
GVChapter.DataBind();
btnsearcksubmit.Enabled = false;
}
}
public void Applied_Chapter_Topics()
{
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.DivisionID = Convert.ToInt16(Session["DivisionID"]);
obj_Teacher_Dashboard.EmployeeID = Convert.ToInt64(Session["EmpolyeeID"]);
obj_Teacher_Dashboard.SchoolID = Convert.ToInt64(Session["SchoolID"]);
obj_Teacher_Dashboard.Month = Convert.ToInt16(ddlMonthYear.SelectedValue);
String[] Year = ddlMonthYear.SelectedItem.ToString().Split('-');
obj_Teacher_Dashboard.Year = Convert.ToInt32(Year[1]);
DataSet dsSelect = new DataSet();
dsSelect = obj_BAL_Teacher_Dashboard.BAL_Select_Applied_Rescheduling_Data_Of_Teacher(obj_Teacher_Dashboard);
if (dsSelect.Tables[0].Rows.Count > 0)
{
grvReschedulingData.DataSource = dsSelect.Tables[0];
grvReschedulingData.DataBind();
}
else
{
grvReschedulingData.DataSource = null;
grvReschedulingData.DataBind();
}
}
public void Fill_Rescheduling_Chapter_Topic()
{
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.DivisionID = Convert.ToInt16(Session["DivisionID"]);
obj_Teacher_Dashboard.EmployeeID = Convert.ToInt64(Session["EmpolyeeID"]);
obj_Teacher_Dashboard.SchoolID = Convert.ToInt64(Session["SchoolID"]);
DataSet dsSelect = new DataSet();
dsSelect = obj_BAL_Teacher_Dashboard.BAL_Select_Rescheduling_Data(obj_Teacher_Dashboard);
if (dsSelect.Tables[0].Rows.Count > ((int)EnumFile.AssignValue.Zero))
{
gvRescheduing.DataSource = dsSelect;
gvRescheduing.DataBind();
}
else
{
gvRescheduing.DataSource = null;
gvRescheduing.DataBind();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.ChapterID = Convert.ToInt64(ddlChapter.SelectedValue);
obj_Teacher_Dashboard.TopicID = Convert.ToInt64(ddlTopic.SelectedValue);
int bmssctid = obj_BAL_Teacher_Dashboard.BAL_Select_BMS_SCTID(obj_Teacher_Dashboard);
if (bmssctid > (int)EnumFile.AssignValue.Zero)
{
Session["ChapterTopic"] = ddlChapter.SelectedItem.ToString() + " >> " + ddlTopic.SelectedItem.ToString();
Session["BMSSCTID"] = bmssctid;
String Path1 = Server.MapPath("../EduResource/" + bmssctid);
if (Directory.Exists(Path1))
{
Response.Redirect("EducationalResource.aspx?Type=Student");
}
else
{
WebMsg.Show("No Educational Resource Available.");
}
}
else
{
WebMsg.Show("No Educational Resource Available.");
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
BtnPDF.Visible = false;
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.SchoolID = Convert.ToInt64(Session["SchoolID"]);
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.DivisionID = Convert.ToInt16(Session["DivisionID"]);
obj_Teacher_Dashboard.EmployeeID = Convert.ToInt64(Session["EmpolyeeID"]);
obj_Teacher_Dashboard.ChapterID = Convert.ToInt64(ddlChapter.SelectedValue);
obj_Teacher_Dashboard.TopicID = Convert.ToInt64(ddlTopic.SelectedValue);
Int64 bmssctid = Convert.ToInt64(obj_BAL_Teacher_Dashboard.Get_BMSSCTID(obj_Teacher_Dashboard));
if (bmssctid == ((int)EnumFile.AssignValue.Zero))
{
WebMsg.Show("BMSSCT does not exists.");
}
else
{
obj_Teacher_Dashboard.BMSSCTID = Convert.ToInt64(bmssctid);
DataSet dsStudentList = new DataSet();
dsStudentList = obj_BAL_Teacher_Dashboard.Get_Student_ExamSummary_Report(obj_Teacher_Dashboard);
if (dsStudentList.Tables[0].Columns.Contains("NoData"))
{
GridStudentList.DataSource = null;
GridStudentList.DataBind();
WebMsg.Show("No Data Found.");
BtnPDF.Visible = false;
return;
}
if (dsStudentList.Tables[0].Rows.Count > 0 && dsStudentList.Tables.Count > 0)
{
GridStudentList.DataSource = dsStudentList.Tables[0];
GridStudentList.DataBind();
Session["StudentResult"] = dsStudentList.Tables[0];
Session["ChapName"] = ddlChapter.SelectedItem.ToString();
Session["TopicName"] = ddlTopic.SelectedItem.ToString();
Session["ExamName"] = "";
Session["ToatlQues"] = "";
Session["ToatlMarks"] = "";
BtnPDF.Visible = true;
}
else
{
GridStudentList.DataSource = null;
GridStudentList.DataBind();
WebMsg.Show("No Data Found.");
BtnPDF.Visible = false;
}
}
}
public void BAL_SYS_Delete_Student_Result(Teacher_Dashboard TD)
{
DAL_Teacher_Dashboard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("ExamID", TD.ExamID));
DAL_Teacher_Dashboard.DAL_InsertUpdate("PROC_Delete_StudentResultData", arrParameter);
}
public void fill_ALL_Covered_Chaptes_Topics()
{
rblChapters.SelectedValue = "2";
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.DivisionID = Convert.ToInt16(Session["DivisionID"]);
obj_Teacher_Dashboard.EmployeeID = Convert.ToInt64(Session["EmpolyeeID"]);
obj_Teacher_Dashboard.SchoolID = Convert.ToInt64(Session["SchoolID"]);
DataSet dsSelect = new DataSet();
dsSelect = obj_BAL_Teacher_Dashboard.BAL_Select_Covered_Syllabus(obj_Teacher_Dashboard);
if (dsSelect.Tables.Count == ((int)EnumFile.AssignValue.One))
{
if (dsSelect.Tables[0].Rows[0]["NoRecord"].ToString().Equals("0"))
{
WebMsg.Show("No Chapter available.");
DropDownList[] disddl = { ddlChapter, ddlTopic };
DisableDropDwon(disddl);
}
}
else if (dsSelect.Tables.Count > ((int)EnumFile.AssignValue.Zero) && dsSelect.Tables[0].Rows.Count > ((int)EnumFile.AssignValue.Zero))
{
ddlChapter.DataSource = dsSelect.Tables[0];
ddlChapter.DataTextField = "Chapter";
ddlChapter.DataValueField = "ChapterID";
ddlChapter.DataBind();
ddlChapter.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), new ListItem("-- Select --"));
DropDownList[] disddl = { ddlChapter, ddlTopic };
EnableDropDwon(disddl);
ViewState["TopicTable"] = (DataTable)dsSelect.Tables[1];
ddlTopic.DataSource = dsSelect.Tables[1];
ddlTopic.DataTextField = "Topic";
ddlTopic.DataValueField = "TopicID";
ddlTopic.DataBind();
ddlTopic.Items.Insert(Convert.ToInt32(EnumFile.AssignValue.Zero), new ListItem("-- Select --"));
ddlTopic.SelectedIndex = Convert.ToInt32(EnumFile.AssignValue.Zero);
}
else
{
DropDownList[] disddl = { ddlChapter, ddlTopic };
DisableDropDwon(disddl);
}
}
public DataSet BAL_Select_Chapters_Topics_By_CoveredStatus(Teacher_Dashboard TD, string status)
{
DAL_Teacher_Dashboard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("BMSID", TD.BMSID));
arrParameter.Add(new parameter("SubjectID", TD.SubjectID));
arrParameter.Add(new parameter("EmployeeID", TD.EmployeeID));
arrParameter.Add(new parameter("Status", status));
return(DAL_Teacher_Dashboard.DAL_Select("sys_chapter_getchapterlistbycoveredstatus", arrParameter));
}
public int BAL_IsCLassTeacher_Select(Teacher_Dashboard TD)
{
DAL_Teacher_Dashboard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("BMSID", TD.BMSID));
arrParameter.Add(new parameter("EmployeeID", TD.EmployeeID));
arrParameter.Add(new parameter("DivisionID", TD.DivisionID));
arrParameter.Add(new parameter("SchoolID", TD.SchoolID));
return(DAL_Teacher_Dashboard.executescalre("PROC_IsClassTeacher", arrParameter));
}
public int Get_BMSSCTID(Teacher_Dashboard TD)
{
DAL_Teacher_Dashboard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("BMSID", TD.BMSID));
arrParameter.Add(new parameter("SubjectID", TD.SubjectID));
arrParameter.Add(new parameter("ChapterID", TD.ChapterID));
arrParameter.Add(new parameter("TopicID", TD.TopicID));
return(DAL_Teacher_Dashboard.executescalre("PROC_Select_BMS_SCTID", arrParameter));
}
public DataSet Get_Student_ExamSummary_Report(Teacher_Dashboard TD)
{
DAL_Teacher_Dashboard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("SchoolID", TD.SchoolID));
arrParameter.Add(new parameter("BMSID", TD.BMSID));
arrParameter.Add(new parameter("BMSSCTID", TD.BMSSCTID));
arrParameter.Add(new parameter("DivisionID", TD.DivisionID));
return(DAL_Teacher_Dashboard.DAL_Select("Proc_Select_Studets_ExamSummary_Report", arrParameter));
}
public DataSet Get_Exams(Teacher_Dashboard TD)
{
DAL_Teacher_Dashboard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("BMSSCTID", TD.BMSSCTID));
arrParameter.Add(new parameter("SchoolID", TD.SchoolID));
arrParameter.Add(new parameter("EmployeeID", TD.EmployeeID));
arrParameter.Add(new parameter("DivisionID", TD.DivisionID));
return(DAL_Teacher_Dashboard.DAL_Select("Proc_Select_Exams", arrParameter));
}
public DataSet BAL_Select_BMS_SCTID_Demo(Teacher_Dashboard TD)
{
DAL_Teacher_Dashboard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("BMSID", TD.BMSID));
arrParameter.Add(new parameter("SubjectID", TD.SubjectID));
arrParameter.Add(new parameter("ChapterID", TD.ChapterID));
arrParameter.Add(new parameter("TopicID", TD.TopicID));
return(DAL_Teacher_Dashboard.DAL_Select("PROC_Select_BMS_SCTID_Demo", arrParameter));
}
public void fill_Covered_Syllabus()
{
tvSyllabus.Nodes.Clear();
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.DivisionID = Convert.ToInt16(Session["DivisionID"]);
obj_Teacher_Dashboard.EmployeeID = Convert.ToInt64(Session["EmpolyeeID"]);
obj_Teacher_Dashboard.SchoolID = Convert.ToInt64(Session["SchoolID"]);
DataSet dsSelect = new DataSet();
dsSelect = obj_BAL_Teacher_Dashboard.BAL_Select_Covered_Syllabus(obj_Teacher_Dashboard);
if (dsSelect.Tables.Count > ((int)EnumFile.AssignValue.Zero))
{
DataTable dtChapter = new DataTable();
DataTable dtTopic = new DataTable();
dtChapter = dsSelect.Tables[0];
dtTopic = dsSelect.Tables[1];
if (dtChapter.Rows.Count > ((int)EnumFile.AssignValue.Zero) && dtTopic.Rows.Count > ((int)EnumFile.AssignValue.Zero))
{
foreach (DataRow c in dtChapter.Rows)
{
TreeNode ParentNode = new TreeNode();
ParentNode.Text = c["Chapter"].ToString();
ParentNode.Value = c["ChapterID"].ToString();
tvSyllabus.Nodes.Add(ParentNode);
foreach (DataRow d in dtTopic.Select("ChapterID = " + Convert.ToInt32(c["ChapterID"].ToString())))
{
TreeNode ChildNode = new TreeNode();
ChildNode.Text = d["Topic"].ToString();
ChildNode.Value = d["TopicID"].ToString();
ParentNode.ChildNodes.Add(ChildNode);
}
}
}
else
{
tvSyllabus.Nodes.Clear();
}
}
else
{
tvSyllabus.Nodes.Clear();
}
}
public DataSet BAL_Select_Covered_Syllabus(Teacher_Dashboard TD)
{
DAL_Teacher_Dashboard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("BMSID", TD.BMSID));
arrParameter.Add(new parameter("SubjectID", TD.SubjectID));
arrParameter.Add(new parameter("DivisionID", TD.DivisionID));
arrParameter.Add(new parameter("EmplyeeID", TD.EmployeeID));
arrParameter.Add(new parameter("SchoolID", TD.SchoolID));
return(DAL_Teacher_Dashboard.DAL_Select("PROC_Select_Covered_Syllabus", arrParameter));
}
public DataSet BAL_Select_Rescheduling_Data(Teacher_Dashboard TD)
{
DAL_Teacher_Dashboard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("BMSID", TD.BMSID));
arrParameter.Add(new parameter("SubjectID", TD.SubjectID));
arrParameter.Add(new parameter("DivisionID", TD.DivisionID));
arrParameter.Add(new parameter("EmployeeID", TD.EmployeeID));
arrParameter.Add(new parameter("SchoolID", TD.SchoolID));
return(DAL_Teacher_Dashboard.DAL_Select("Proc_Select_Rescheduling_Data", arrParameter));
}
public DataSet BAL_Select_Chapters_Topics(Teacher_Dashboard TD)
{
DAL_Teacher_Dashboard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("BMSID", TD.BMSID));
arrParameter.Add(new parameter("SubjectID", TD.SubjectID));
arrParameter.Add(new parameter("DivisionID", TD.DivisionID));
arrParameter.Add(new parameter("EmplyeeID", TD.EmployeeID));
arrParameter.Add(new parameter("SchoolID", TD.SchoolID));
return(DAL_Teacher_Dashboard.DAL_Select("PROC_Select_Chapter_Topic_BasedOn_SeqNo", arrParameter));
}
public int BAL_Insert_Exam(Teacher_Dashboard TD)
{
DAL_Teacher_Dashboard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("ExamName", TD.ExamName));
arrParameter.Add(new parameter("BMSSCTID", TD.BMSSCTID));
arrParameter.Add(new parameter("SchoolID", TD.SchoolID));
arrParameter.Add(new parameter("EmployeeID", TD.EmployeeID));
arrParameter.Add(new parameter("DivisionID", TD.DivisionID));
arrParameter.Add(new parameter("TotalQues", TD.TotalQues));
arrParameter.Add(new parameter("TotalMarks", TD.TotalMarks));
return(DAL_Teacher_Dashboard.executescalre("Proc_Insert_Exam_Entry", arrParameter));
}
public int BAL_Insert_Rescheduling_BMSSCT(Teacher_Dashboard TD)
{
DAL_Teacher_Dashboard = new DataAccess();
arrParameter = new ArrayList();
arrParameter.Add(new parameter("BMSID", TD.BMSID));
arrParameter.Add(new parameter("SubjectID", TD.SubjectID));
arrParameter.Add(new parameter("DivisionID", TD.DivisionID));
arrParameter.Add(new parameter("ChapterID", TD.ChapterID));
arrParameter.Add(new parameter("TopicID", TD.TopicID));
arrParameter.Add(new parameter("SchoolID", TD.SchoolID));
arrParameter.Add(new parameter("EmployeeID", TD.EmployeeID));
return(DAL_Teacher_Dashboard.executescalre("Proc_Insert_Rescheduling_BMSSCT", arrParameter));
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.SchoolID = Convert.ToInt64(Session["SchoolID"]);
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.DivisionID = Convert.ToInt16(Session["DivisionID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.ChapterID = Convert.ToInt64(ddlChapter.SelectedValue);
obj_Teacher_Dashboard.TopicID = Convert.ToInt64(ddlTopic.SelectedValue);
obj_Teacher_Dashboard.ExamID = Convert.ToInt64(ddlExam.SelectedValue);
int bmssctid = obj_BAL_Teacher_Dashboard.BAL_Select_BMS_SCTID(obj_Teacher_Dashboard);
ViewState["BMSSCT"] = bmssctid;
DataSet dsStudentList = new DataSet();
dsStudentList = obj_BAL_Teacher_Dashboard.Get_StudentList(obj_Teacher_Dashboard);
//TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmpolyeeID), Convert.ToInt16(AppSessions.DivisionID), "ResultEntryPage", "BtnSubmit", "click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.ResultEntryPage),"", Convert.ToInt32(Session["BMSSCTID"]));
TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmpolyeeID), Convert.ToInt16(AppSessions.DivisionID), "ResultEntryPage", "BtnSubmit", "Click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.StudentListPopulatedForExam), "BMSSCT ID = " + bmssctid + " Exam Name : " + ddlExam.SelectedItem.ToString() + " Exam Marks : " + TxtTotalMarks.Text, bmssctid);
if (dsStudentList.Tables[0].Rows.Count > 0)
{
GridStudentList.Visible = true;
btnSave.Visible = true;
BtnPDF.Visible = true;
Session["ChapName"] = ddlChapter.SelectedItem.ToString();
Session["TopicName"] = ddlTopic.SelectedItem.ToString();
Session["ExamName"] = ddlExam.SelectedItem.ToString();
Session["ToatlQues"] = TxtTotalQuestions.Text;
Session["ToatlMarks"] = TxtTotalMarks.Text;
Session["StudentResult"] = dsStudentList.Tables[0];
GridStudentList.DataSource = dsStudentList.Tables[0];
GridStudentList.DataBind();
}
else
{
GridStudentList.DataSource = null;
GridStudentList.DataBind();
GridStudentList.Visible = false;
btnSave.Visible = false;
BtnPDF.Visible = false;
WebMsg.Show("No student available.");
}
}
public void fill_Covered_Chapters_Topics()
{
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.DivisionID = Convert.ToInt16(Session["DivisionID"]);
obj_Teacher_Dashboard.EmployeeID = Convert.ToInt64(Session["EmpolyeeID"]);
obj_Teacher_Dashboard.SchoolID = Convert.ToInt64(Session["SchoolID"]);
DataSet dsSelect = new DataSet();
dsSelect = obj_BAL_Teacher_Dashboard.BAL_Select_Covered_Chapters_Topics(obj_Teacher_Dashboard);
if (dsSelect.Tables.Count == ((int)EnumFile.AssignValue.One))
{
if (dsSelect.Tables[0].Rows[0]["NoRecord"].ToString().Equals("0"))
{
lblLastChapterName.Text = "-";
lblLastTopicName.Text = "-";
}
}
else if (dsSelect.Tables.Count > ((int)EnumFile.AssignValue.Zero))
{
if (dsSelect.Tables[0].Rows.Count > ((int)EnumFile.AssignValue.Zero))
{
lblLastChapterName.Text = dsSelect.Tables[0].Rows[0]["Chapter"].ToString();
}
else
{
lblLastChapterName.Text = "-";
}
if (dsSelect.Tables[1].Rows.Count > ((int)EnumFile.AssignValue.Zero))
{
lblLastTopicName.Text = dsSelect.Tables[1].Rows[0]["Topic"].ToString();
}
else
{
lblLastTopicName.Text = "-";
}
}
else
{
lblLastChapterName.Text = "-";
lblLastTopicName.Text = "-";
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.ChapterID = Convert.ToInt64(ddlChapter.SelectedValue);
obj_Teacher_Dashboard.TopicID = Convert.ToInt64(ddlTopic.SelectedValue);
int bmssctid = obj_BAL_Teacher_Dashboard.BAL_Select_BMS_SCTID(obj_Teacher_Dashboard);
//TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmpolyeeID), Convert.ToInt16(AppSessions.DivisionID), "TeacherDashboard", "btnSubmit", "Click", Convert.ToDateTime(System.DateTime.Now), Session.SessionID, "click on submit button", "Submit Successfully.", bmssctid);
TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmpolyeeID), Convert.ToInt16(AppSessions.DivisionID), "TeacherDeshboard", "btnSubmit", "Click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.ActivityStarted), "BMSSCT ID : " + bmssctid, bmssctid);
if (bmssctid > (int)EnumFile.AssignValue.Zero)
{
Session["ChapterTopic"] = ddlChapter.SelectedItem.ToString() + " >> " + ddlTopic.SelectedItem.ToString();
Session["Chapter"] = ddlChapter.SelectedItem.ToString();
Session["BMSSCTID"] = bmssctid;
String Path1 = Server.MapPath("../EduResource/" + bmssctid);
this.Title = "Epathshala - " + bmssctid;
if (Directory.Exists(Path1) == false)
{
Path1 = Server.MapPath("../EduResource/NoContent");
}
if (Directory.Exists(Path1))
{
Response.Redirect("EducationalResource.aspx?Type=Teacher", false);
}
else
{
WebMsg.Show(bmssctid.ToString() + ": No Educational resource available.");
}
}
else
{
WebMsg.Show(bmssctid.ToString() + ": No Educational resource available.");
}
}
public void Fill_Chart_Data()
{
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.DivisionID = Convert.ToInt16(Session["DivisionID"]);
obj_Teacher_Dashboard.EmployeeID = Convert.ToInt64(Session["EmpolyeeID"]);
obj_Teacher_Dashboard.SchoolID = Convert.ToInt64(Session["SchoolID"]);
DataSet dsSelect = new DataSet();
dsSelect = obj_BAL_Teacher_Dashboard.BAL_Select_Chart_Data(obj_Teacher_Dashboard);
if (dsSelect.Tables[0].Rows.Count > ((int)EnumFile.AssignValue.Zero))
{
LblCoveredChapter.Visible = true;
LblUncoveredChapter.Visible = true;
Int32 CoveredChapters = Convert.ToInt32(dsSelect.Tables[0].Rows[0]["Covered"].ToString());
Int32 UncoveredChapters = 100 - CoveredChapters;
LblCoveredChapter.Width = CoveredChapters * 2;
LblUncoveredChapter.Width = UncoveredChapters * 2;
lblCovered.Text = Convert.ToString(CoveredChapters) + "%";
lblUncovered.Text = Convert.ToString(UncoveredChapters) + "%";
lblCovered1.Text = Convert.ToString(CoveredChapters) + "%";
lblUncovered1.Text = Convert.ToString(UncoveredChapters) + "%";
}
else
{
LblCoveredChapter.Visible = false;
LblUncoveredChapter.Visible = false;
LblCoveredChapter.Text = "";
LblUncoveredChapter.Text = "";
}
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
ArrayList alistContacts = new ArrayList();
string Body = string.Empty;
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.DivisionID = Convert.ToInt16(Session["DivisionID"]);
obj_Teacher_Dashboard.EmployeeID = Convert.ToInt64(Session["EmpolyeeID"]);
obj_Teacher_Dashboard.SchoolID = Convert.ToInt64(Session["SchoolID"]);
obj_Teacher_Dashboard.ChapterID = Convert.ToInt64(ddlChapter.SelectedValue);
obj_Teacher_Dashboard.TopicID = Convert.ToInt64(ddlTopic.SelectedValue);
int result = obj_BAL_Teacher_Dashboard.BAL_Insert_Rescheduling_BMSSCT(obj_Teacher_Dashboard);
int bmssctid = obj_BAL_Teacher_Dashboard.BAL_Select_BMS_SCTID(obj_Teacher_Dashboard);
TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmpolyeeID), Convert.ToInt16(AppSessions.DivisionID), "ReschedulingChapterTopicPage", "BtnSubmit", "Click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.ReschedulingRequestSubmited), "Request for Rescheduling BMSSCT ID : " + bmssctid, bmssctid);
if (result == ((int)EnumFile.AssignValue.One))
{
alistContacts = GetEmailAddress();
Body = GenerateEmailBody();
EmailUtility.SendEmail(alistContacts, "Rescheduling request notification", Body);
WebMsg.Show("Rescheduling request sent successfully.");
Applied_Chapter_Topics();
}
else if (result == ((int)EnumFile.AssignValue.Zero))
{
WebMsg.Show("This Chapter, Topic are already requested for Rescheduling.");
}
DropDownList[] disddl3 = { ddlChapter, ddlTopic };
DisableDropDwon(disddl3);
DropDownList[] disddl = { ddlChapter };
EnableDropDwon(disddl);
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.DivisionID = Convert.ToInt16(Session["DivisionID"]);
obj_Teacher_Dashboard.EmployeeID = Convert.ToInt64(Session["EmpolyeeID"]);
obj_Teacher_Dashboard.SchoolID = Convert.ToInt64(Session["SchoolID"]);
obj_Teacher_Dashboard.ChapterID = Convert.ToInt64(ddlChapter.SelectedValue);
obj_Teacher_Dashboard.TopicID = Convert.ToInt64(ddlTopic.SelectedValue);
obj_Teacher_Dashboard.ExamName = TxtExamName.Text;
obj_Teacher_Dashboard.TotalQues = Convert.ToInt32(TxtTotalQuestions.Text);
obj_Teacher_Dashboard.TotalMarks = Convert.ToInt32(TxtTotalMarks.Text);
int bmssctid = obj_BAL_Teacher_Dashboard.Get_BMSSCTID(obj_Teacher_Dashboard);
if (bmssctid == ((int)EnumFile.AssignValue.Zero))
{
WebMsg.Show("BMSSCT does not exists.");
}
else
{
TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmpolyeeID), Convert.ToInt16(AppSessions.DivisionID), "ExamEntryPage", "BtnSubmit", "Click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.ExamCreatedSuccessfully), "BMSSCT ID = " + bmssctid + " Exam Name : " + TxtExamName.Text + " Exam Marks : " + TxtTotalMarks.Text, bmssctid);
obj_Teacher_Dashboard.BMSSCTID = Convert.ToInt64(bmssctid);
int result = obj_BAL_Teacher_Dashboard.BAL_Insert_Exam(obj_Teacher_Dashboard);
if (result == ((int)EnumFile.AssignValue.One))
{
WebMsg.Show("Exam entry has been entered successfully.");
}
else if (result == ((int)EnumFile.AssignValue.Zero))
{
WebMsg.Show("This exam entry already exists.");
}
}
ClearControls();
}
public void IsClassTeacher()
{
int IsclassTeacher = Convert.ToInt32(EnumFile.ClassTeacher.IsNotClassTeacher);
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.EmployeeID = Convert.ToInt64(Session["EmpolyeeID"]);
obj_Teacher_Dashboard.DivisionID = Convert.ToInt16(Session["DivisionID"]);
obj_Teacher_Dashboard.SchoolID = Convert.ToInt64(Session["SchoolID"]);
IsclassTeacher = obj_BAL_Teacher_Dashboard.BAL_IsCLassTeacher_Select(obj_Teacher_Dashboard);
if (IsclassTeacher == Convert.ToInt32(EnumFile.ClassTeacher.IsClassTeacher))
{
btnAttendance.Text = "Take Attendance";
}
else
{
btnAttendance.Text = "View Attendance";
}
}
private void BindFeedbackQuestion()
{
try
{
ActivityFeedbackRaing obj_Activity_Feedback_Rating = new ActivityFeedbackRaing();
SYS_Role_BLogic obj_SYS_Role_BLogic = new SYS_Role_BLogic();
int BMSID = obj_SYS_Role_BLogic.BAL_Select_BMS(Convert.ToInt16(ddlBoard.SelectedValue), Convert.ToInt16(ddlMedium.SelectedValue), Convert.ToInt16(ddlStandard.SelectedValue));
Teacher_Dashboard obj_Teacher_Dashboard;
Teacher_Dashboard_BLogic obj_BAL_Teacher_Dashboard;
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(BMSID);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(ddlsubject.SelectedValue.ToString());
obj_Teacher_Dashboard.ChapterID = Convert.ToInt64(ddlchapter.SelectedValue.ToString());
obj_Teacher_Dashboard.TopicID = Convert.ToInt64(ddltopic.SelectedValue.ToString());
bmssctid = obj_BAL_Teacher_Dashboard.BAL_Select_BMS_SCTID(obj_Teacher_Dashboard);
// ds_ActivityFeedback = obj_Activity_Feedback_Rating.GetActivityFeedback(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(bmssctid));
double[] totalavg;
int[] star;
int rowcount = ds_ActivityFeedback.Tables[3].Rows.Count + ds_ActivityFeedback.Tables[4].Rows.Count;
int row_count = 0;
totalavg = new double[rowcount];
//star = new int[Convert.ToInt32(dt1.Rows[0]["QuestionCount"].ToString()) + 2];
star = new int[6];
if (ds_ActivityFeedback.Tables[3].Rows.Count > 0)
{
QuestionCount = Convert.ToInt32(ds_ActivityFeedback.Tables[3].Rows[0]["QuestionCount"].ToString());
for (int cnt = 0; cnt < ds_ActivityFeedback.Tables[3].Rows.Count; cnt++)
{
TotalRating1 = Convert.ToInt32(ds_ActivityFeedback.Tables[3].Rows[cnt]["Rating"].ToString());
if (TotalRating1 != 0)
{
totalavg[row_count] = (TotalRating1 / Convert.ToDouble(ds_ActivityFeedback.Tables[3].Rows[cnt]["Rating"].ToString()));
row_count = row_count + 1;
}
}
}
if (ds_ActivityFeedback.Tables[4].Rows.Count > 0)
{
QuestionCount = Convert.ToInt32(ds_ActivityFeedback.Tables[4].Rows[0]["QuestionCount"].ToString());
for (int cnt = 0; cnt < ds_ActivityFeedback.Tables[4].Rows.Count; cnt++)
{
TotalRating1 = Convert.ToInt32(ds_ActivityFeedback.Tables[4].Rows[cnt]["Rating"].ToString());
if (TotalRating1 != 0)
{
totalavg[row_count] += (TotalRating1 / Convert.ToDouble(ds_ActivityFeedback.Tables[4].Rows[cnt]["QuestionCount"].ToString()));
row_count = row_count + 1;
}
}
}
for (int avgcnt = 0; avgcnt < totalavg.Length; avgcnt++)
{
int roundavg = Convert.ToInt32(Math.Round(totalavg[avgcnt]));
if (roundavg == 1)
{
OneStar += 1.0;
star[roundavg] = Convert.ToInt32(Math.Round((OneStar * 100 / row_count)));
lbl1star.Text = star[roundavg].ToString() + "%";
}
else if (roundavg == 2)
{
Twostar += 1;
star[roundavg] = Convert.ToInt32(Math.Round((Twostar * 100 / row_count)));
lbl2star.Text = star[roundavg].ToString() + "%";
}
else if (roundavg == 3)
{
Threestar += 1;
star[roundavg] = Convert.ToInt32(Math.Round((Threestar * 100 / row_count)));
lbl3star.Text = star[roundavg].ToString() + "%";
}
else if (roundavg == 4)
{
Fourstar += 1;
star[roundavg] = Convert.ToInt32(Math.Round((Fourstar * 100 / row_count)));
lbl4star.Text = star[roundavg].ToString() + "%";
}
else if (roundavg == 5)
{
Fivestar += 1;
star[roundavg] = Convert.ToInt32(Math.Round((Fivestar * 100 / row_count)));
lbl5star.Text = star[roundavg].ToString() + "%";
}
}
pnlreport.Visible = true;
}
catch (Exception ex)
{
}
}
protected void ddlTopic_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlTopic.SelectedIndex > 0)
{
DropDownList[] disddl = { ddlExam };
DisableDropDwon(disddl);
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Teacher_Dashboard.DivisionID = Convert.ToInt16(Session["DivisionID"]);
obj_Teacher_Dashboard.EmployeeID = Convert.ToInt64(Session["EmpolyeeID"]);
obj_Teacher_Dashboard.SchoolID = Convert.ToInt64(Session["SchoolID"]);
obj_Teacher_Dashboard.ChapterID = Convert.ToInt64(ddlChapter.SelectedValue);
obj_Teacher_Dashboard.TopicID = Convert.ToInt64(ddlTopic.SelectedValue);
Int64 bmssctid = Convert.ToInt64(obj_BAL_Teacher_Dashboard.Get_BMSSCTID(obj_Teacher_Dashboard));
if (bmssctid == ((int)EnumFile.AssignValue.Zero))
{
WebMsg.Show("BMSSCT does not exists.");
}
else
{
obj_Teacher_Dashboard.BMSSCTID = Convert.ToInt64(bmssctid);
DataSet ds = new DataSet();
ds = obj_BAL_Teacher_Dashboard.Get_Exams(obj_Teacher_Dashboard);
DataTable dt = ds.Tables[0];
ViewState["ExamTable"] = dt;
ddlExam.Items.Clear();
if (dt.Rows.Count > 0)
{
ddlExam.DataSource = dt;
ddlExam.DataTextField = "ExamName";
ddlExam.DataValueField = "ExamID";
ddlExam.DataBind();
}
ddlExam.Items.Insert(0, new System.Web.UI.WebControls.ListItem("-- Select --"));
DropDownList[] disddl1 = { ddlExam };
EnableDropDwon(disddl1);
}
}
else
{
DropDownList[] disddl1 = { ddlExam };
DisableDropDwon(disddl1);
TxtTotalQuestions.Text = "0";
TxtTotalMarks.Text = "0";
GridStudentList.DataSource = null;
GridStudentList.DataBind();
GridStudentList.Visible = false;
btnSave.Visible = false;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.ExamID = Convert.ToInt64(ViewState["ExamID"]);
obj_BAL_Teacher_Dashboard.BAL_SYS_Delete_Student_Result(obj_Teacher_Dashboard);
DataTable TbStudent = new DataTable("StudentExam");
TbStudent.Columns.Add("ExamID", typeof(Int64));
TbStudent.Columns.Add("StudentID", typeof(Int64));
TbStudent.Columns.Add("RightAnswers", typeof(System.String));
TbStudent.Columns.Add("WorngAnswers", typeof(Int32));
TbStudent.Columns.Add("Total", typeof(Int32));
TbStudent.Columns.Add("CreatedBy", typeof(Int64));
for (int i = 0; i < GridStudentList.Rows.Count; i++)
{
DataRow dr = TbStudent.NewRow();
dr["ExamID"] = Convert.ToInt64(ViewState["ExamID"]);
dr["StudentID"] = Convert.ToInt64(GridStudentList.DataKeys[i].Values["StudentID"].ToString());
TextBox tb1 = (TextBox)GridStudentList.Rows[i].Cells[2].FindControl("TxtRightMarks");
if (tb1.Text.ToString().Equals("A"))
{
dr["RightAnswers"] = "A";
dr["WorngAnswers"] = Convert.ToInt32("0");
}
else if (tb1.Text.ToString().Equals("Z"))
{
dr["RightAnswers"] = "Z";
dr["WorngAnswers"] = Convert.ToInt32("0");
}
else
{
dr["RightAnswers"] = Convert.ToInt32(tb1.Text);
dr["WorngAnswers"] = Convert.ToInt32(Convert.ToInt32(ViewState["TotalMarks"]) - Convert.ToInt32(tb1.Text));
}
dr["Total"] = Convert.ToInt32(ViewState["TotalMarks"]);
dr["CreatedBy"] = Convert.ToInt64(Session["EmpolyeeID"]);
TbStudent.Rows.Add(dr);
}
if (TbStudent.Rows.Count > ((int)EnumFile.AssignValue.Zero))
{
try
{
TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmpolyeeID), Convert.ToInt16(AppSessions.DivisionID), "ResultEntryPage", "btnSave", "click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.ExamResultSaved), "BMSSCT ID : " + Convert.ToInt32(ViewState["BMSSCTID"]) + " Exam Name : " + ddlExam.SelectedItem.ToString(), Convert.ToInt32(ViewState["BMSSCTID"]));
string con = ConfigurationManager.AppSettings["EpathshalaStudentCon"];
using (SqlBulkCopy copy = new SqlBulkCopy(con))
{
//copy.ColumnMappings.Add(0, 0);
copy.ColumnMappings.Add(0, 1); //ExamID
copy.ColumnMappings.Add(1, 2); //StudentID
copy.ColumnMappings.Add(2, 3); //RightAnswers
copy.ColumnMappings.Add(3, 4); //WorngAnswers
copy.ColumnMappings.Add(4, 5); //Total
copy.ColumnMappings.Add(5, 8); //CreatedBy
copy.DestinationTableName = "Student_Exam_Result";
copy.WriteToServer(TbStudent);
}
WebMsg.Show("Result inserted successfully.");
}
catch (Exception ex)
{
WebMsg.Show("Error in inserting the result.");
}
}
else
{
WebMsg.Show("There is no data to be set.");
}
ClearControls();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (Session["DEMOBMSID"] != null)
{
Teacher_Dashboard_BLogic obj_BAL_Teacher_Dashboard;
Teacher_Dashboard obj_Teacher_Dashboard;
obj_BAL_Teacher_Dashboard = new Teacher_Dashboard_BLogic();
obj_Teacher_Dashboard = new Teacher_Dashboard();
obj_Teacher_Dashboard.BMSID = Convert.ToInt64(Session["DEMOBMSID"]);
obj_Teacher_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectIDDemo"]);
obj_Teacher_Dashboard.ChapterID = Convert.ToInt64(ddlChapter.SelectedValue);
obj_Teacher_Dashboard.TopicID = Convert.ToInt64(ddlTopic.SelectedValue);
DataSet dsDemoData = new DataSet();
dsDemoData = obj_BAL_Teacher_Dashboard.BAL_Select_BMS_SCTID_Demo(obj_Teacher_Dashboard);
int bmssctid = Convert.ToInt32(dsDemoData.Tables[0].Rows[0]["BMSSCTID"].ToString());
string IsAllowForDemo = dsDemoData.Tables[0].Rows[0]["IsAllowForDemo"].ToString();
if (bmssctid > (int)EnumFile.AssignValue.Zero)
{
if (IsAllowForDemo.ToString().Trim().ToLower() == "true")
{
Session["DEMOChapterTopic"] = ddlChapter.SelectedItem.ToString() + " >> " + ddlTopic.SelectedItem.ToString();
Session["DEMOBMSSCTID"] = bmssctid;
Session["DemoChapter"] = ddlChapter.SelectedItem.ToString();
Session["DemoTopic"] = ddlTopic.SelectedItem.ToString();
Session["DemoChapterID"] = ddlChapter.SelectedValue.ToString();
Session["DemoTopicID"] = ddlTopic.SelectedValue.ToString();
String Path1 = Server.MapPath("../EduResource/" + bmssctid);
if (Directory.Exists(Path1))
{
//Response.Redirect("../DemoPages/viewDemoContent.aspx?type=topic&BMSSCTID="+ bmssctid.ToString().Trim() +"");
Response.Redirect("../DemoPages/EducationResourceDemo.aspx");
}
else
{
WebMsg.Show("No Educational resource available.");
}
}
else
{
//WebMsg.Show("You have to register first for this content");
showme.Attributes["style"] = "visibility:visible;";
ModalPopupExtender1.Show();
}
}
else
{
showme.Attributes["style"] = "visibility:visible;";
ModalPopupExtender1.Show();
//WebMsg.Show("You have to register first for this content");
}
}
else
{
Response.Redirect("../DemoPages/Home.aspx");
}
}
