protected void BtnChapterAdd_Click(object sender, EventArgs e)
{
obj_SYS_Chapter = new SYS_Chapter();
obj_BAL_SYS_Chapter = new SYS_Chapter_BLogic();
obj_SYS_Chapter.bmsid = Convert.ToInt64(ViewState["BMSID"]);
obj_SYS_Chapter.subjectid = Convert.ToInt16(ddlSubject.SelectedValue);
obj_SYS_Chapter.chapterindex = Convert.ToInt16(TxtChapterIndex.Text);
obj_SYS_Chapter.chapter = TxtChapterName.Text;
obj_SYS_Chapter.employeeid = Convert.ToInt64(Session["EmpolyeeID"]);
int Result = obj_BAL_SYS_Chapter.BAL_SYS_Chapter_Insert(obj_SYS_Chapter);
if (Result == ((int)EnumFile.Result.FileAdded))
{
WebMsg.Show("Chapter Added Successfully.");
}
else
{
WebMsg.Show("Chapter Details already exists.");
}
object s = new object();
EventArgs ea = new EventArgs();
ddlSubject_SelectedIndexChanged(s, ea);
}
protected void btnAppRejSubmit_Click(object sender, EventArgs e)
{
int CountChecked = Convert.ToInt32(EnumFile.AssignValue.Zero);
string tmp_SchoolBMSIDStr = string.Empty;
foreach (GridViewRow gr in gvSchoolRegistrationBMSdetail.Rows)
{
CheckBox chk = new CheckBox();
chk = (CheckBox)gr.FindControl("chkSelect");
if (chk.Checked == true)
{
int StatusID;
StatusID = Convert.ToInt32(gvSchoolRegistrationBMSdetail.DataKeys[gr.RowIndex]["StatusID"]);
if (StatusID == Convert.ToInt32(EnumFile.Status.Appiled) || StatusID == Convert.ToInt32(EnumFile.Status.Approve) || StatusID == Convert.ToInt32(EnumFile.Status.Reject))
{
if (CountChecked == Convert.ToInt32(EnumFile.AssignValue.Zero))
{
tmp_SchoolBMSIDStr = gvSchoolRegistrationBMSdetail.DataKeys[gr.RowIndex]["SchoolID"].ToString();
}
else
{
tmp_SchoolBMSIDStr = tmp_SchoolBMSIDStr + " , " + gvSchoolRegistrationBMSdetail.DataKeys[gr.RowIndex]["SchoolID"].ToString();
}
CountChecked = CountChecked + 1;
}
else
{
CountChecked = Convert.ToInt32(EnumFile.AssignValue.Zero);
break;
}
}
}
if (CountChecked > Convert.ToInt32(EnumFile.AssignValue.Zero))
{
try
{
obj_SchoolRegistrationBMS = new SchoolBMS();
obj_BAL_SchoolRegistrationBMS = new SchoolBMS_BLogic();
int tmpstatusid = Convert.ToInt32(EnumFile.AssignValue.Zero);
if (rbApprove.Checked == true)
{
tmpstatusid = Convert.ToInt32(EnumFile.Status.Approve);
}
if (rbReject.Checked == true)
{
tmpstatusid = Convert.ToInt32(EnumFile.Status.Reject);
}
obj_SchoolRegistrationBMS.schregbmsidStr = tmp_SchoolBMSIDStr;
obj_SchoolRegistrationBMS.StatusID = tmpstatusid;
obj_BAL_SchoolRegistrationBMS.BAL_SchoolBMS_UpdateStatus(obj_SchoolRegistrationBMS, "UpdateClassStatus");
bindgrvSchoolRegistrationBMSdetail(Convert.ToInt32(ViewState["SchRegID"].ToString()));
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
}
else
{
WebMsg.Show("Please select atleast one record.");
}
}
/// <summary>
/// Method wil be used to verify product license information.
/// </summary>
/// <param name="ProID">Product ID</param>
/// <param name="ProKey">Product Key</param>
/// <param name="ProCode">Product Code</param>
/// <returns>Retuen boolean</returns>
public static bool GetLicenseInfo(string ProID = null, string ProKey = null, string ProCode = null)
{
bool Flag = false;
string ProductID = string.Empty;
string strCode = string.Empty;
string key = string.Empty;
string OldCode = string.Empty;
Prepaid objPrepaid = new Prepaid();
DataSet dsProductInfo = new DataSet();
try
{
dsProductInfo = GetProductInfoFromXML();
if (dsProductInfo.Tables.Count > 0 & dsProductInfo != null)
{
if (dsProductInfo.Tables[0].Rows.Count > 0)
{
OldCode = dsProductInfo.Tables[0].Rows[0]["OldCode"].ToString();
}
}
if (ProID == null & ProKey == null & ProCode == null)
{
ProductID = GetProductID();
if (dsProductInfo.Tables.Count > 0 & dsProductInfo != null)
{
if (dsProductInfo.Tables[0].Rows.Count > 0)
{
strCode = dsProductInfo.Tables[0].Rows[0]["Code"].ToString();
key = dsProductInfo.Tables[0].Rows[0]["ProductKey"].ToString();
}
}
}
else
{
ProductID = ProID;
key = ProKey;
strCode = ProCode;
}
if (strCode == string.Empty & key == string.Empty)
{
Flag = false;
}
else
{
if (strCode == objPrepaid.GetSystemInfo(ProductID, OldCode))
{
enmErrorCode ErrorCode = new VarnindraClient.enmErrorCode();
ErrorCode = objPrepaid.CheckRegistration(strCode, key.Replace(" - ", ""), ProductID, DateTime.Now, "0", "0");
switch (ErrorCode.ToString())
{
case "Invalid_Product_ID":
Flag = false;
break;
case "InvalidKey":
Flag = false;
break;
case "Invalid_Count1":
Flag = false;
break;
case "Invalid_Count2":
Flag = false;
break;
case "Invalid_Start_Date":
Flag = false;
break;
case "No_Error":
Flag = true;
break;
}
}
else
{
Flag = false;
}
}
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
return(Flag);
}
protected void BindSubjectList()
{
try
{
if (Session["ShowPaymentPages"] != null)
{
//Session["DemoBMS"] = AppSessions.BMSID;
}
else
{
//GetStudentDetailBMS();
}
Student_DashBoard_BLogic obj_BAL_Student_Dashboard = new Student_DashBoard_BLogic();
StudentDash obj_Student_Dashboard = new StudentDash();
ArrayList Alist = new ArrayList();
//if (ViewState["ArrayList"] != null)
//{
// Alist = (ArrayList)ViewState["ArrayList"];
// string PackageFDID = string.Empty;
// for (int i = 0; i < Alist.Count; i++)
// {
// if (PackageFDID != string.Empty)
// {
// PackageFDID = PackageFDID + "," + Alist[i].ToString();
// }
// else
// {
// PackageFDID = PackageFDID + Alist[i].ToString();
// }
// }
// obj_Student_Dashboard.BMSID = AppSessions.BMSID;
// obj_Student_Dashboard.PackageFDID = PackageFDID;
// obj_Student_Dashboard.Mode = "Selected";
// DataSet ds = new DataSet();
// //ds = obj_BAL_Student_Dashboard.BAL_Student_Subject_Select(obj_Student_Dashboard);
// ds = obj_BAL_Student_Dashboard.BAL_Student_Purchased_Package("", Convert.ToInt32(AppSessions.BMSID), Convert.ToInt32(AppSessions.StudentID));
// DataTable dt = new DataTable();
// dt.Columns.Add("SubjectID", typeof(Int32));
// dt.Columns.Add("Subject", typeof(string));
// if (ds.Tables[0].Rows.Count > 0 && ds != null)
// {
// for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
// {
// if (ds.Tables[0].Rows[i]["PackageType"].ToString().ToLower() == "combo")
// {
// string[] subjects = ds.Tables[0].Rows[i]["subject"].ToString().Split(',');
// string[] subjectsid = ds.Tables[0].Rows[i]["subjectid"].ToString().Split(',');
// for (int subcnt = 0; subcnt < subjects.Length; subcnt++)
// {
// DataRow dr = dt.NewRow();
// dr["SubjectID"] = subjectsid[subcnt].ToString().Trim();
// dr["Subject"] = subjects[subcnt].ToString().Trim();
// dt.Rows.Add(dr);
// }
// }
// else
// {
// DataRow dr = dt.NewRow();
// dr["SubjectID"] = ds.Tables[0].Rows[i]["Subjectid"].ToString().Trim();
// dr["Subject"] = ds.Tables[0].Rows[i]["Subject"].ToString().Trim();
// dt.Rows.Add(dr);
// }
// }
// DataTable dt1 = dt.DefaultView.ToTable(true, "SubjectID", "Subject");
// DataView dv = dt1.DefaultView;
// dv.Sort = "Subject";
// dt = dv.ToTable();
// // dt = dt.DefaultView.ToTable(true);
// rbSubjectList.DataSource = dt;
// rbSubjectList.DataValueField = "SubjectID";
// rbSubjectList.DataTextField = "Subject";
// rbSubjectList.DataBind();
// rbSubjectList.SelectedIndex = 0;
// }
//}
//if (Session["DemoBMS"] != null)
if (Session["BMSID"] != null)
{
obj_Student_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Student_Dashboard.Mode = "All";
DataSet ds = new DataSet();
ds = obj_BAL_Student_Dashboard.BAL_Student_Subject_Select(obj_Student_Dashboard);
if (ds.Tables[0].Rows.Count > 0 && ds != null)
{
rbSubjectList.DataSource = ds.Tables[0];
rbSubjectList.DataValueField = "SubjectID";
rbSubjectList.DataTextField = "Subject";
rbSubjectList.DataBind();
rbSubjectList.SelectedIndex = 0;
Session["SubjectID"] = rbSubjectList.SelectedValue;
}
}
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
}
protected void BindSubjectList()
{
try
{
//if (Session["ShowPaymentPages"] != null)
//{
ViewState["StudentBMS"] = AppSessions.BMSID;
//}
//else
//{
// GetStudentDetailBMS();
//}
obj_BAL_Student_Dashboard = new Student_DashBoard_BLogic();
obj_Student_Dashboard = new StudentDash();
ArrayList Alist = new ArrayList();
if (ViewState["ArrayList"] != null)
{
Alist = (ArrayList)ViewState["ArrayList"];
string PackageFDID = string.Empty;
for (int i = 0; i < Alist.Count; i++)
{
if (PackageFDID != string.Empty)
{
PackageFDID = PackageFDID + "," + Alist[i].ToString();
}
else
{
PackageFDID = PackageFDID + Alist[i].ToString();
}
}
obj_Student_Dashboard.BMSID = AppSessions.BMSID;
obj_Student_Dashboard.PackageFDID = PackageFDID;
obj_Student_Dashboard.Mode = "Selected";
DataSet ds = new DataSet();
ds = obj_BAL_Student_Dashboard.BAL_Student_Subject_Select(obj_Student_Dashboard);
if (ds.Tables[0].Rows.Count > 0 && ds != null)
{
ddlsubject.DataSource = ds.Tables[0];
ddlsubject.DataValueField = "SubjectID";
ddlsubject.DataTextField = "Subject";
ddlsubject.DataBind();
ddlsubject.SelectedIndex = 0;
}
ddlsubject.Items.Insert(0, "Select");
}
if (ViewState["StudentBMS"] != null)
{
obj_Student_Dashboard.BMSID = Convert.ToInt64(ViewState["StudentBMS"]);
obj_Student_Dashboard.Mode = "All";
DataSet ds = new DataSet();
ds = obj_BAL_Student_Dashboard.BAL_Student_Subject_Select(obj_Student_Dashboard);
if (ds.Tables[0].Rows.Count > 0 && ds != null)
{
ddlsubject.DataSource = ds.Tables[0];
ddlsubject.DataValueField = "SubjectID";
ddlsubject.DataTextField = "Subject";
ddlsubject.DataBind();
}
ddlsubject.Items.Insert(0, "Select");
ddlsubject.SelectedIndex = 0;
}
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
}
/// <summary>
/// This method fills grid report using given datatable
/// </summary>
/// <param name="dtSearch"></param>
public void Search(DataTable dtSearch)
{
try
{
searchstatus = 1;
Getallinitialdata();
GetAllSettings();
Session["dtsearch"] = dtSearch;
gridreport.DataSource = null;
gridreport.DataSource = dtSearch;
gridreport.DataBind();
SetTotal();
ALLSetting(dtSearch);
//if (sortingcolumn != null && sortingcolumn != "")
//{
// DataView dv = new DataView(dtSearch);
// string SortDir = string.Empty;
// if (dir == SortDirection.Ascending)
// {
// dir = SortDirection.Descending;
// SortDir = "Desc";
// }
// else
// {
// dir = SortDirection.Ascending;
// SortDir = "Asc";
// }
// dv.Sort = sortingcolumn + " " + SortDir;
// gridreport.DataSource = dv;
// gridreport.DataBind();
//}
//for (int j = 0; j < gridreport.Rows.Count; j++)
//{
// for (int i = 0; i < gridreport.Rows[0].Cells.Count; i++)
// {
// //string HeaderText = c.HeaderText.ToLower();
// string HeaderText = (((System.Web.UI.WebControls.DataControlFieldCell)(gridreport.Rows[j].Cells[i])).ContainingField).HeaderText.ToLower();
// try
// {
// switch (dtSearch.Columns[HeaderText].DataType.ToString().ToLower())
// {
// case "system.string":
// break;
// case "system.decimal":
// gridreport.Rows[j].Cells[i].HorizontalAlign = HorizontalAlign.Right;
// break;
// case "system.int16":
// gridreport.Rows[j].Cells[i].HorizontalAlign = HorizontalAlign.Right;
// break;
// case "system.int32":
// gridreport.Rows[j].Cells[i].HorizontalAlign = HorizontalAlign.Right;
// break;
// case "system.int64":
// gridreport.Rows[j].Cells[i].HorizontalAlign = HorizontalAlign.Right;
// break;
// case "system.byte":
// case "system.boolean":
// break;
// case "system.datetime":
// break;
// case "System.Diagnostics.Debugger":
// break;
// //default:
// // System.Diagnostics.Debugger.Break();
// // break;
// }
// if (ColumnWidth != null)
// {
// foreach (string s in ColumnWidth)
// {
// string[] words = s.Split('=');
// if (HeaderText.ToLower() == words[0].ToString().ToLower())
// {
// gridreport.Rows[j].Cells[i].Width = Convert.ToInt32(words[1]);
// break;
// }
// }
// }
// if (alignment != null)
// {
// foreach (string s in alignment)
// {
// string[] words = s.Split('=');
// if (HeaderText.ToLower() == words[0].ToString().ToLower())
// {
// string stralignment = words[1];
// if (stralignment.Trim().ToLower() == "right")
// {
// gridreport.Rows[j].Cells[i].HorizontalAlign = HorizontalAlign.Right;
// }
// else if (stralignment.Trim().ToLower() == "left")
// {
// gridreport.Rows[j].Cells[i].HorizontalAlign = HorizontalAlign.Left;
// }
// else if (stralignment.Trim().ToLower() == "center")
// {
// gridreport.Rows[j].Cells[i].HorizontalAlign = HorizontalAlign.Center;
// }
// else if (stralignment.Trim().ToLower() == "justify")
// {
// gridreport.Rows[j].Cells[i].HorizontalAlign = HorizontalAlign.Justify;
// }
// }
// }
// }
// if (HiddenFields != null)
// {
// foreach (string s in HiddenFields)
// {
// if (HeaderText.ToLower() == s.ToLower())
// {
// gridreport.Rows[j].Cells[i].Visible = false;
// (((System.Web.UI.WebControls.DataControlFieldCell)(gridreport.Rows[j].Cells[i])).ContainingField).Visible = false;
// break;
// }
// }
// }
// }
// catch (Exception ex)
// {
// }
// }
//}
}
catch (Exception ex)
{
WebMsg.Show(ex.Message.ToString());
}
}
//protected void OnTextChanged(object sender, EventArgs e)
//{
// //ClientScript.RegisterClientScriptBlock(GetType(), "alert", "alert('" + (sender as TextBox).Text + "');", true);
// TextBox tb = sender as TextBox;
// if (Convert.ToInt32(tb.Text) > Convert.ToInt32(ViewState["TotalMarks"]))
// {
// WebMsg.Show("Right marks must be lessthen Total marks.");
// tb.Text = "";
// tb.Focus();
// }
//}
#endregion
#endregion
#region User Define Function
public void fill_ALL_Covered_Chaptes_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_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, ddlExam };
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 System.Web.UI.WebControls.ListItem("-- Select --"));
DropDownList[] disddl = { ddlChapter, ddlTopic, ddlExam };
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 System.Web.UI.WebControls.ListItem("-- Select --"));
ddlTopic.SelectedIndex = Convert.ToInt32(EnumFile.AssignValue.Zero);
}
else if (dsSelect.Tables[0].Rows.Count == 0)
{
ddlChapter.DataSource = dsSelect.Tables[0];
ddlChapter.DataTextField = "Chapter";
ddlChapter.DataValueField = "ChapterID";
ddlChapter.DataBind();
ddlChapter.Items.Insert(0, new System.Web.UI.WebControls.ListItem("-- Select --"));
}
else
{
DropDownList[] disddl = { ddlChapter, ddlTopic, ddlExam };
DisableDropDwon(disddl);
}
}
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();
}
public void Displayselecteddata(Hashtable hashtable, object objsender)
{
if (ReportControl1.Visible == true)
{
ReportControl1.Visible = false;
ReportControl2.Visible = true;
FirstRpt.Visible = true;
secondRpt.Visible = true;
btnback.Visible = true;
slblSchoolValue.Text = ddlSchool.SelectedItem.Text;
slblTeacherValue.Text = hashtable["Teacher"].ToString();
//slblDurationValue.Text = hashtable["\r\nTotal Activity Duration"].ToString();
slblDurationValue.Text = hashtable["Total Activity Duration"].ToString();
slblDateValue.Text = hashtable["ActivityDate"].ToString();
obj_TracklogRPT = new TrackLogRPT_BLogic();
DataSet dsResult = obj_TracklogRPT.BAL_Select_TeacherWiseBMSSCTWiseBYEmpIDTrackLog(Convert.ToInt32(hashtable["EmployeeID"].ToString()), Convert.ToDateTime(hashtable["ActivityDate"].ToString()));
if (dsResult.Tables.Count > 0)
{
CommanCallUserControl(dsResult.Tables[0], "../ReportXMLFiles/TeacherTrackRPTEmpWise.xml", 2);
}
else
{
WebMsg.Show("No data found.");
}
}
else if (ReportControl2.Visible == true)
{
ReportControl2.Visible = false;
div1.Visible = true;
secondRpt.Visible = false;
thirdRpt.Visible = true;
tlblSchoolValue.Text = slblSchoolValue.Text;
tlblTeacherValue.Text = slblTeacherValue.Text;
tlblDurationValue.Text = hashtable["Total Activity Duration"].ToString();
tlblDateValue.Text = slblDateValue.Text;
string BMSString = hashtable["BMS_SCT"].ToString();
string[] lines = Regex.Split(BMSString, ">>");
tlblboardValue.Text = lines[0];
tlblmediumValue.Text = lines[1];
tlblStandardValue.Text = lines[2];
tlblSubjectValue.Text = lines[3];
tlblChapterValue.Text = lines[4];
tlblTopicValue.Text = lines[5];
obj_TracklogRPT = new TrackLogRPT_BLogic();
DataSet dsResult = obj_TracklogRPT.BAL_Select_TeacherWiseBMSSCTWiseBYEmpIDBMSSCTIDTrackLog(Convert.ToInt32(hashtable["BMSSCTID"].ToString()), Convert.ToInt32(hashtable["DivisionID"].ToString()), Convert.ToInt32(hashtable["EmployeeID"].ToString()), Convert.ToDateTime(hashtable["ActivityDate"].ToString()));
if (dsResult.Tables.Count > 0)
{
CommanCallUserControl(dsResult.Tables[0], "../ReportXMLFiles/TeacherTrackRPTEmpWiseBMSSCT.xml", 3);
}
else
{
WebMsg.Show("No data found.");
}
}
}
private void CommanCallUserControl(DataTable dt, string reporttype, int control)
{
GetConnectionStringSTRING obj = new GetConnectionStringSTRING();
connectionstring = obj.BAL_EpathshalaString();
try
{
if (control == 1)
{
ReportControl1.ConnectionString = connectionstring;
//reporttype = Server.MapPath("Files/MonthlySummary.xml");
ReportControl1.XMLReportFile = Server.MapPath(reporttype);
ReportControl1.Search(dt);
}
else if (control == 2)
{
ReportControl2.ConnectionString = connectionstring;
//reporttype = Server.MapPath("Files/MonthlySummary.xml");
ReportControl2.XMLReportFile = Server.MapPath(reporttype);
ReportControl2.Search(dt);
}
else if (control == 3)
{
//ReportControl3.ConnectionString = connectionstring;
////reporttype = Server.MapPath("../ReportXMLFiles/TeacherTrackRPTEmpWiseBMSSCT.xml");
//ReportControl3.XMLReportFile = Server.MapPath(reporttype);
//ReportControl3.Search(dt);
StringBuilder ReportString = new StringBuilder();
//Header
//XML to Dataset
DataSet xmllanguage = new DataSet();
xmllanguage.ReadXml(Server.MapPath("../ReportXMLFiles/TeacherTrackRPTEmpWiseBMSSCT.xml"));
//End XML to Dataset
//HiddenFields list get
List <string> HiddenFields;
HiddenFields = GetHiddenFields();
//End HiddenFields list get
DataTable dtTableHeder = dt.DefaultView.ToTable(true, "SessionID");
for (int i = 0; i < dtTableHeder.Rows.Count; i++)
{
CreadeRowColumMainTable(ReportString);
//ReportString.Append(xmllanguage.Tables[Session["LANG"].ToString().ToLower()].Rows[0]["Session"].ToString()+" : "+dtTableHeder.Rows[i]["SessionID"].ToString());
ReportString.Append(xmllanguage.Tables[Session["Varnindra"].ToString().ToLower()].Rows[0]["Session"].ToString() + " : " + dtTableHeder.Rows[i]["SessionID"].ToString());
CloseTDTR(ReportString);
OpenTDTR(ReportString);
DataView dv1 = dt.DefaultView;
dv1.RowFilter = " SessionID = '" + dtTableHeder.Rows[i]["SessionID"].ToString() + "'";
DataTable dtNew = dv1.ToTable();
ReportString.Append("<table class=\"GridViewCss\" cellspacing=\"2\" cellpadding=\"2\" border=\"1\" style=\"border-width:1px;border-style:None;width:100%;\" rules=\"all\">");
ReportString.Append("<tr class=\"GridViewHeadercss\">");
for (int j = 0; j < dtNew.Columns.Count; j++)
{
if (HiddenFields != null)
{
foreach (string s in HiddenFields)
{
if (dtNew.Columns[j].ToString().ToLower() != s.ToLower())
{
string Columen = dtNew.Columns[j].ToString().Trim().Replace(" ", "");
string str = xmllanguage.Tables[Session["Varnindra"].ToString().ToLower()].Rows[0][Columen].ToString();
ReportString.Append("<th scope=\"col\">" + str + "</th>");
break;
}
else
{
break;
}
}
}
}
ReportString.Append("</tr>");
for (int ij = 0; ij < dtNew.Rows.Count; ij++)
{
ReportString.Append("<tr class=\"GridViewItem\">");
for (int ro = 0; ro < dtNew.Columns.Count; ro++)
{
if (HiddenFields != null)
{
foreach (string s in HiddenFields)
{
if (dtNew.Columns[ro].ToString().ToLower() != s.ToLower())
{
ReportString.Append("<td>" + dtNew.Rows[ij][ro].ToString() + "</td>"); break;
}
else
{
break;
}
}
}
}
ReportString.Append("</tr>");
}
ReportString.Append("</table>");
CloseRowColumnMainTable(ReportString);
}
div1.InnerHtml = ReportString.ToString();
}
}
catch (Exception ex)
{
WebMsg.Show("" + ex.Message.ToString());
}
}
protected void btnGo_Click(object sender, EventArgs e)
{
try
{
StoreCookie();
int status = CheckLogin();
//if (ddlUserType.SelectedValue == "0")
if (status == 2)
{
WebMsg.Show("invalid username or password");
return;
}
else if (status == 0)
{
// 0 Indicates Student
StudentDash = new StudentDash();
BLogic_Student = new Student_DashBoard_BLogic();
DataSet dtLogin = new DataSet();
DataTable LoginInfo = new DataTable();
DataTable UserInfo = new DataTable();
obj_SYS_Role = new SYS_Role();
obj_BAL_SYS_Role = new SYS_Role_BLogic();
obj_SYS_Role.Username = txtUserName.Text;
obj_SYS_Role.Password = txtUserPassword.Text;
//obj_SYS_Role.roleid = Convert.ToInt16(DdlRole.SelectedValue);
dtLogin = obj_BAL_SYS_Role.BAL_SYS_Student_Login(obj_SYS_Role);
LoginInfo = dtLogin.Tables[0];
if (LoginInfo.Rows.Count > 0 && LoginInfo != null)
{
AppSessions.AppUserType = "Student";
AppSessions.StudentID = Convert.ToInt32(LoginInfo.Rows[0]["StudentID"].ToString());
AppSessions.UserName = LoginInfo.Rows[0]["FirstName"].ToString();
AppSessions.BMSID = Convert.ToInt32(LoginInfo.Rows[0]["BMSID"].ToString());
AppSessions.BMS = LoginInfo.Rows[0]["BMS"].ToString();
AppSessions.BoardID = Convert.ToInt32(LoginInfo.Rows[0]["BoardID"].ToString());
AppSessions.Board = LoginInfo.Rows[0]["Board"].ToString();
AppSessions.MediumID = Convert.ToInt32(LoginInfo.Rows[0]["MediumID"].ToString());
AppSessions.Medium = LoginInfo.Rows[0]["Medium"].ToString();
AppSessions.StandardID = Convert.ToInt32(LoginInfo.Rows[0]["StandardID"].ToString());
AppSessions.Standard = LoginInfo.Rows[0]["Standard"].ToString();
AppSessions.DivisionID = Convert.ToInt32(LoginInfo.Rows[0]["DivisionID"].ToString());
//AppSessions.Division = LoginInfo.Rows[0]["Division"].ToString();
AppSessions.SchoolID = Convert.ToInt32(LoginInfo.Rows[0]["SchoolID"].ToString());
//AppSessions.SchoolName = LoginInfo.Rows[0]["SchoolName"].ToString();
AppSessions.Role = LoginInfo.Rows[0]["Role"].ToString();
AppSessions.RoleID = Convert.ToInt32(LoginInfo.Rows[0]["RoleID"].ToString());
yourLoginMethodStudent(LoginInfo);
bool AllowPayment = false;
DataSet dsPaymentInfo = new DataSet();
dsPaymentInfo = BLogic_Student.BAL_Select_PaymentPagesInfo("Payment");
if (dsPaymentInfo != null & dsPaymentInfo.Tables.Count > 0)
{
if (dsPaymentInfo.Tables[0].Rows.Count > 0)
{
string a = dsPaymentInfo.Tables[0].Rows[0]["value"].ToString();
if (a == "0")
{
AllowPayment = false;
}
else
{
AllowPayment = true;
}
}
}
DataSet ds = new DataSet();
StudentDash.StudentID = AppSessions.StudentID;
// ds = BLogic_Student.BAL_Validate_Student(StudentDash);
ds = BLogic_Student.BAL_Validate_Student_Package(StudentDash);
if (AllowPayment == true)
{
if (ds != null && dtLogin.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
Session["CheckValidity"] = "Yes";
ProceedToRedirect();
}
else
{
Response.Redirect("~/DashBoard/SelectPackage.aspx");
}
}
else
{
Response.Redirect("~/DashBoard/SelectPackage.aspx");
}
}
else
{
Session["CheckValidity"] = "Yes";
Session["ShowPaymentPages"] = "No";
ProceedToRedirect();
}
}
}
else if (status == 1)
{
// 1 Indicates Teacher
DataSet dtLogin = new DataSet();
DataTable LoginInfo = new DataTable();
DataTable UserInfo = new DataTable();
obj_SYS_Role = new SYS_Role();
obj_BAL_SYS_Role = new SYS_Role_BLogic();
obj_SYS_Role.Username = txtUserName.Text;
obj_SYS_Role.Password = txtUserPassword.Text;
//obj_SYS_Role.roleid = Convert.ToInt16(DdlRole.SelectedValue);
dtLogin = obj_BAL_SYS_Role.BAL_SYS_Active_Login(obj_SYS_Role);
LoginInfo = dtLogin.Tables[0];
if (LoginInfo.Rows.Count > 0 && LoginInfo != null && LoginInfo.Rows[0]["Status"].ToString().Equals("1"))
{
if (dtLogin.Tables[1].Rows[0]["RoleID"].ToString() != "3")
{
bool AllowMultipleSession = false;
UserInfo = dtLogin.Tables[1];
if (UserInfo.Rows.Count > 0 && UserInfo != null)
{
AppSessions.AppUserType = "School";
AppSessions.EmpolyeeID = int.Parse(UserInfo.Rows[0]["EmployeeID"].ToString());
AppSessions.RoleID = int.Parse(UserInfo.Rows[0]["RoleID"].ToString());
AppSessions.SchoolID = int.Parse(UserInfo.Rows[0]["SchoolID"].ToString());
AppSessions.UserName = UserInfo.Rows[0]["FirstName"].ToString();
AppSessions.SchoolName = UserInfo.Rows[0]["Name"].ToString();
AppSessions.Role = UserInfo.Rows[0]["Role"].ToString();
AllowMultipleSession = Convert.ToBoolean(UserInfo.Rows[0]["AllowMultipleSession"].ToString());
TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmpolyeeID), Convert.ToInt16(AppSessions.DivisionID), "LoginPage", "btnLogin", "Click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.LoginSuccess), "LoginId: " + txtUserName.Text, 0);
}
if (AllowMultipleSession == false)
{
Hashtable sessions = (Hashtable)Application["WEB_SESSIONS_OBJECT"];
if (sessions == null)
{
sessions = new Hashtable();
}
////////getting the pointer to the Session of the current logged in user
HttpSessionState existingUserSession = (HttpSessionState)sessions[Session["EmpolyeeID"].ToString()];
if (existingUserSession != null)
{
////existingUserSession[Session["EmpolyeeID"].ToString()] = null;
//logout current logged in user
lblError1.Visible = true;
}
else
{
yourLoginMethod(UserInfo);
ProceedToRedirectPage(UserInfo);
}
}
else
{
yourLoginMethod(UserInfo);
ProceedToRedirectPage(UserInfo);
}
}
else
{
// For Teacher Redirection
bool AllowMultipleSession = false;
UserInfo = dtLogin.Tables[1];
if (UserInfo.Rows.Count > 0 && UserInfo != null)
{
Session["UserInfoTable"] = UserInfo;
ViewState["AppUserType"] = "School";
ViewState["EmpolyeeID"] = int.Parse(UserInfo.Rows[0]["EmployeeID"].ToString());
ViewState["RoleID"] = int.Parse(UserInfo.Rows[0]["RoleID"].ToString());
ViewState["SchoolID"] = int.Parse(UserInfo.Rows[0]["SchoolID"].ToString());
ViewState["UserName"] = UserInfo.Rows[0]["FirstName"].ToString();
ViewState["SchoolName"] = UserInfo.Rows[0]["Name"].ToString();
ViewState["Role"] = UserInfo.Rows[0]["Role"].ToString();
AllowMultipleSession = Convert.ToBoolean(UserInfo.Rows[0]["AllowMultipleSession"].ToString());
TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmpolyeeID), Convert.ToInt16(AppSessions.DivisionID), "LoginPage", "btnLogin", "Click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.LoginSuccess), "LoginId: " + txtUserName.Text, 0);
}
if (AllowMultipleSession == false)
{
Hashtable sessions = (Hashtable)Application["WEB_SESSIONS_OBJECT"];
if (sessions == null)
{
sessions = new Hashtable();
}
////////getting the pointer to the Session of the current logged in user
// HttpSessionState existingUserSession = (HttpSessionState)sessions[Session["EmpolyeeID"].ToString()];
HttpSessionState existingUserSession = (HttpSessionState)sessions[ViewState["EmpolyeeID"].ToString()];
if (existingUserSession != null)
{
////existingUserSession[Session["EmpolyeeID"].ToString()] = null;
//logout current logged in user
lblError1.Visible = true;
}
else
{
yourLoginMethod(UserInfo);
ProceedToRedirectPage(UserInfo);
}
}
else
{
yourLoginMethod(UserInfo);
ProceedToRedirectPage(UserInfo);
}
}
}
else
{
TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmpolyeeID), Convert.ToInt16(AppSessions.DivisionID), "LoginPage", "btnLogin", "Click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.LoginFailed), "LoginId: " + txtUserName.Text + " , Password: "******"Authentication Failed,unable to login");
}
}
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
}
protected void btnsearcksubmit_Click(object sender, EventArgs e)
{
//Response.Redirect("SearchResult.aspx?key=" + txtkeyword.Text + "");
WebMsg.Show("You have to register first to use this facility ");
}
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");
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int count = (int)EnumFile.AssignValue.Zero;
string divisionidstr = string.Empty;
foreach (ListItem chk in clstDivision.Items)
{
if (chk.Selected == true)
{
if (count == ((int)EnumFile.AssignValue.Zero))
{
divisionidstr = chk.Value;
}
else
{
divisionidstr = divisionidstr + " , " + chk.Value;
}
count = count + 1;
}
}
if (count == ((int)EnumFile.AssignValue.Zero))
{
WebMsg.Show("Please select atleast one Division");
}
else
{
try
{
DataSet dsselectErrors = new DataSet();
this.PAnnouncement.bmsid = Convert.ToInt32(ddlBoardMediumStandard.SelectedValue.ToString());
if (divisionidstr == string.Empty)
{
divisionidstr = ((int)EnumFile.AssignValue.Zero).ToString();
}
this.PAnnouncement.divisionstr = divisionidstr;
string IFormat = "dd-MMM-yyyy";
DateTime StartDate = Convert.ToDateTime(DateTime.Parse(txtStartDate.Text).ToString(IFormat));
DateTime EndDate = Convert.ToDateTime(DateTime.Parse(txtEndDate.Text).ToString(IFormat));
if (StartDate > EndDate)
{
WebMsg.Show("End Date Larger than StartDate");
}
else
{
this.PAnnouncement.divisionid = Convert.ToInt32(clstDivision.SelectedValue);
this.PAnnouncement.startdate = StartDate;
this.PAnnouncement.enddate = EndDate;
//this.PAnnouncement.announcement = edtAnnouncement.Content.ToString();
//// PAnnouncement.announcement = edtAnnouncement.Content.Substring(0, edtAnnouncement.Content.Length - 6);
this.PAnnouncement.announcement = txtSearchAnnouncement.Text;
this.PAnnouncement.createdby = Convert.ToInt32(this.Session["EmpolyeeID"]);
this.PAnnouncement.modifiedby = Convert.ToInt32(this.Session["EmpolyeeID"]);
this.PAnnouncement.announcementid = Convert.ToInt32(this.ViewState["AnnouncementID"].ToString());
dsselectErrors = this.BAL_Announcement.BAL_Announcement_Update(this.PAnnouncement, "Update");
if (dsselectErrors.Tables.Count > ((int)EnumFile.AssignValue.Zero))
{
if (dsselectErrors.Tables[0].Rows.Count > ((int)EnumFile.AssignValue.Zero))
{
if (Convert.ToInt32(dsselectErrors.Tables[0].Rows[0][0].ToString()) == ((int)EnumFile.AssignValue.Zero))
{
WebMsg.Show("Following Combination already exist.");
}
}
else
{
this.RefreshControls();
WebMsg.Show("Record Updated.");
}
}
}
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
int count = Convert.ToInt32(EnumFile.AssignValue.Zero);
string divisionidstr = string.Empty;
foreach (ListItem chk in clstDivision.Items)
{
if (chk.Selected == true)
{
if (count == Convert.ToInt32(EnumFile.AssignValue.Zero))
{
divisionidstr = chk.Value;
}
else
{
divisionidstr = divisionidstr + " , " + chk.Value;
}
count = count + 1;
}
}
////divisionidstr = "' " + divisionidstr + " '";
if (count == Convert.ToInt32(EnumFile.AssignValue.Zero))
{
WebMsg.Show("Please select atleast one Division");
}
else
{
try
{
DataSet dsselectErrors = new DataSet();
this.PAnnouncement.bmsid = Convert.ToInt32(ddlBoardMediumStandard.SelectedValue.ToString());
if (divisionidstr == string.Empty)
{
divisionidstr = ((int)EnumFile.AssignValue.Zero).ToString();
}
this.PAnnouncement.divisionstr = divisionidstr;
string IFormat = "dd-MMM-yyyy";
DateTime StartDate = Convert.ToDateTime(DateTime.Parse(txtStartDate.Text).ToString(IFormat));
DateTime EndDate = Convert.ToDateTime(DateTime.Parse(txtEndDate.Text).ToString(IFormat));
if (StartDate > EndDate)
{
WebMsg.Show("End Date Larger than StartDate");
}
else
{
this.PAnnouncement.divisionid = Convert.ToInt32(clstDivision.SelectedValue);
this.PAnnouncement.startdate = StartDate;
this.PAnnouncement.enddate = EndDate;
//Label lbl = new Label();
//lbl.Text = Server.HtmlDecode(edtAnnouncement.Content.ToString());
//this.PAnnouncement.announcement = lbl.Text;
//Literal ltrl = new Literal();
//ltrl.Text = HttpUtility.HtmlDecode(edtAnnouncement.Content.ToString());
//Literal ltr1 = new Literal();
//ltr1.Text = HttpUtility.HtmlEncode(edtAnnouncement.Content.ToString());
//this.PAnnouncement.announcement = ltrl.Text;
////PAnnouncement.announcement = edtAnnouncement.Content.ToString();
////PAnnouncement.announcement = edtAnnouncement.Content.Substring(0, edtAnnouncement.Content.Length - 6);
this.PAnnouncement.announcement = txtSearchAnnouncement.Text;
this.PAnnouncement.createdby = Convert.ToInt32(this.Session["EmpolyeeID"]);
this.PAnnouncement.modifiedby = Convert.ToInt32(this.Session["EmpolyeeID"]);
dsselectErrors = this.BAL_Announcement.BAL_Announcement_Insert(this.PAnnouncement, "Insert");
if (dsselectErrors.Tables.Count > ((int)EnumFile.AssignValue.Zero))
{
if (dsselectErrors.Tables[0].Rows.Count > ((int)EnumFile.AssignValue.Zero))
{
if (Convert.ToInt32(dsselectErrors.Tables[0].Rows[0][0].ToString()) != ((int)EnumFile.AssignValue.Zero))
{
WebMsg.Show("Record already exist.");
}
}
else
{
////BindGridAnnouncement();
this.RefreshControls();
WebMsg.Show("Record inserted.");
}
}
}
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
}
}
protected string DefaultEmailBody(string ISFreeTrial = null)
{
StringBuilder oBuilder = new StringBuilder();
try
{
oBuilder.Append("<!DOCTYPE html><html><head>");
oBuilder.Append("<style type=text/css> th {color: #685858;} table tr:nth-child(odd) { background-color: #DBDBDB; border-bottom: 1px SOLID GRAY; } p { text-align:justify; line-height:1.4em; } </style> ");
oBuilder.Append("</head><body>");
//oBuilder.Append("<div style='font-family: Calibri,Cambria,verdana; color: #4C3636;'>");
oBuilder.Append("<div style='font-family:Trebuchet MS,Georgia,Verdana,Tahoma;color:#4C3636;'>");
oBuilder.Append("<table width=72% style='margin: 10px; border: 5px SOLID SILVER; border-radius: 5px;' border=0>");
oBuilder.Append("<tr><td><div style='background-color: #2f378e; height: 30px; font-size: 21px; font-weight: bold;padding: 10px;'><span style='color: white; display: block;'>EPATHSHALA</span></div></td></tr>");
oBuilder.Append("<tr><td style='font-size: 16px;'>");
oBuilder.Append("<div id=dvcontent style='font-size: 14px; padding: 20px; background-color: #F4F4F4;'>");
oBuilder.Append("Dear " + txtFirstName.Text + ", <p> Thank you for registering with ePathshala. We welcome you to the world of experiential learning to make your learning process efficient and effective.</p> ");
//oBuilder.Append("Dear " + txtFirstName.Text + "<br /><br />Thank you for registering with E-Pathshala. We welcome you to the world of experiential learning so as to make learning interesting for you.<br /><br />We have different packages for " + ddlBMS.SelectedItem.Text + " as below:<br /><br /><center> ");
//oBuilder.Append("<table border=0 cellpadding=5 cellspacing=0 width=80% style='border: 1px SOLID #9B9B9B;'>");
//oBuilder.Append("<tr style='background-color: #CECECE;'><th>BMS</th><th>Subject</th><th>Price</th></tr>");
//// Dynamice for available packages
//oBuilder.Append("<tr><td>Gujarat Board>> Gujarati Medium >> Standar-08</td><td>English</td><td style='text-align: right;'>200</td></tr>");
//oBuilder.Append("<tr><td style='width: 60%;'>Gujarat Board>> Gujarati Medium >> Standar-08</td><td style='width: 30%;'>English</td><td style='width: 10%; text-align: right;'>200</td></tr>");
//oBuilder.Append("</table></center><br />");
if (ISFreeTrial != null && ISFreeTrial.ToString().ToLower() == "yes")
{
DataTable dtTrialPackage = (DataTable)Session["dsTrailPAckage"];
string strBMS = ddlBMS.SelectedItem.Text.Replace(">>", ">");
string[] BMS = strBMS.Split('>');
string Board = ddlBoard.SelectedItem.ToString();
string Medium = ddlMedium.SelectedItem.ToString();;
string Standard = ddlStandard.SelectedItem.ToString();
//oBuilder.Append(" <p> We are pleased to provide you access to ePathshala package for " + dtTrialPackage.Rows[0]["NoOfMonth"].ToString() + " days for " + Board + " Board " + Medium + " Medium " + Standard + ". ");
oBuilder.Append(" <p> We are pleased to provide you access to ePathshala package for " + dtTrialPackage.Rows[0]["NoOfMonth"].ToString() + " day(s) as an introductory promotional offer for selected standard.");
oBuilder.Append("<br />Discover how E-Pathshala helps you like a teacher/friend. </p>");
oBuilder.Append("<div><center>");
oBuilder.Append("<table border=0 cellpadding=5 cellspacing=0 style='border-collapse: collapse; border: 1px SOLID #9B9B9B; width=80%'>");
oBuilder.Append("<tr style='background-color: #CECECE;'><th>Package Name</th><th>Subject</th><th>Start From</th><th>Valid Till</th> </tr>");
for (int i = 0; i < dtTrialPackage.Rows.Count; i++)
{
oBuilder.Append("<tr><td>" + dtTrialPackage.Rows[i]["PackageName"].ToString() + "</td><td>" + dtTrialPackage.Rows[i]["Subject"].ToString() + "</td><td style='text-align: center;'>" + DateTime.Now.ToString("dd MMM, yyyy") + "</td><td style='text-align: center;'>" + DateTime.Now.AddDays(Convert.ToInt32(dtTrialPackage.Rows[0]["NoOfMonth"].ToString())).ToString("dd MMM, yyyy") + "</td></tr>");
}
oBuilder.Append("</table> </center></div><br />");
}
//oBuilder.Append("<div><p> We wish you happy learning and also wish to strengthen your knowledge, increase your confidence and achieve better performance.<br />We look forward to a wonderful learning experience with us and relationship with us. </p> <b>Your Login details are as below: </b></div><br/>");
oBuilder.Append("<div><p>We look forward to a wonderful learning experience and relationship with us. </p> <b>Your Login details are as below: </b></div><br/>");
oBuilder.Append("<div><table border=0 cellpadding=5 cellspacing=3 style='border-collapse: collapse;border: 1px SOLID #9B9B9B; margin-left: 90px; width=40%'>");
oBuilder.Append("<tr><td>Visit:</td><td>http://epathshala.co.in/</td></tr>");
oBuilder.Append("<tr><td class=style2>Login ID:</td><td class=style1><b>" + txtEmail.Text + "</b></td></tr>");
oBuilder.Append("<tr><td class=style2>Password:</td><td class=style1><b>" + ViewState["strpassword"].ToString() + "</b></td></tr>");
oBuilder.Append("<tr><td class=style2 colspan=2>Please do reach us on [email protected] for your queries or suggestion.</td></tr>");
oBuilder.Append("</table></div><br />");
oBuilder.Append("<div>Thank You,<br />ePathshala - Support Team.</div></div>");
oBuilder.Append("</td></tr>");
oBuilder.Append("<tr><td><div style='background-color: #E4722B; height: 24px; font-size: 18px; font-weight: bold;padding: 5px;'>");
oBuilder.Append("<div><table border=0 cellpadding=0 cellspacing=0 style='background:none;color:Black;'>");
oBuilder.Append("<tr style='background:none;color:Black;'><td><span style='color: white; display: block;'>FOLLOW US!</span></td>");
oBuilder.Append("<td> </td>");
oBuilder.Append("<td> <a href=https://www.facebook.com/myepathshala><img src=https://cdn3.iconfinder.com/data/icons/peelicons-vol-1/50/Facebook-48.png height=36 /></a></td>");
oBuilder.Append("<td> <a href=https://twitter.com/EpathshalaEpath><img src=https://cdn3.iconfinder.com/data/icons/peelicons-vol-1/50/Twitter-48.png height=36 /></a></td>");
oBuilder.Append("</tr></table></div></div></td></tr>");
//oBuilder.Append("<span style='color: white; display: block;'>FOLLOW US!</span> <a href=https://www.facebook.com/myepathshala> <img alt=Epathshala width=26px height=23px src=App_Themes/Images/FBIcon.png /> <a> <a href=https://twitter.com/EpathshalaEpath> <img alt=Epathshala width=26px height=23px src=App_Themes/Images/twitter.png /> <a> </div> </td> </tr>");
oBuilder.Append("<tr> <td style='padding: 20px;'> Please do not reply this message. Queries? Contact. Customer Support. <br /> Arraycom India Ltd. 13, GIDC, Gandhinagar, 382025. </td></tr>");
oBuilder.Append(" </table></div>");
//oBuilder.Append("<p>Thank you for registration in Epathshala <br /><br />");
//oBuilder.Append("Best Regards,<br />Admin.</p>");
//oBuilder.Append("</div></div>");
//oBuilder.Append("</body></html>");
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
return(oBuilder.ToString());
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
int t1 = 0;
//if (TxtBxCap.Text.Trim() != "")
//{
//Captcha1.ValidateCaptcha(TxtBxCap.Text.Trim());
try
{
if (verifyLoginID())
{
//if (!CheckPasswordComplexcity())
//{
// WebMsg.Show("Invalid password format, please enter minimum 6 alphanumeric character with @ # $ %. Sign.");
// return;
//}
/*if (txtPassword.Text.Length < 6)
* {
* WebMsg.Show("Minimum 6 character required in password");
* return;
* }*/
Student = new Student();
BAL_Student = new Student_BLogic();
Student.schoolid = GetDefaultSchoolID();
Student.divisionid = 1;
Student.bmsid = (int)ViewState["BMSID"];
//ViewState["BMSID"] = int.Parse(ddlBMS.SelectedValue);
Student.loginid = txtEmail.Text;
//Student.password = txtPassword.Text;
Student.password = ViewState["strpassword"].ToString();
Student.firstname = txtFirstName.Text;
Student.lastname = txtLastName.Text;
Student.schoolname = txtSchoolname.Text;
//Student.contactno = Convert.ToInt64(txtContactNo.Text);
Student.mobilenostring = txtContactNo.Text;
Student.emailid = txtEmail.Text;
//DateTime fromdatetime;
//string d = txtBirthdate.Text;
//d = d.Replace("-", "/");
//DateTime dt;
//try
//{
// dt = DateTime.ParseExact(d, "d/M/yyyy", CultureInfo.InvariantCulture);
//}
//catch (Exception)
//{
// dt = DateTime.ParseExact(d, "M/d/yyyy", CultureInfo.InvariantCulture); ;
//}
//= DateTime.ParseExact(d, "d/M/yyyy", CultureInfo.InvariantCulture);
// for both "1/1/2000" or "25/1/2000" formats
//string newString = dt.ToString("dd/MMM/yyyy");
//Student.dateofbirth = dt;
//if (DateTime.TryParse(txtBirthdate.Text, out fromdatetime))
//{
// Student.dateofbirth = fromdatetime;
//}
//if (RlstGender.SelectedValue == "1")
//{
// Student.gender = 'M';
//}
//else if (RlstGender.SelectedValue == "2")
//{
// Student.gender = 'F';
//}
Student.PaymentType = 'I';
//if (Captcha1.UserValidated)
//{
t1 = BAL_Student.BAL_Student_Insert_Online(Student, "OnlineReg");
InsertIntoStudentPackageDetails(t1);
//}
//else
//{
// WebMsg.Show("Please enter the correct Captcha code");
//}
if (t1 > 0)
{
//ScriptManager.RegisterStartupScript(this.Page, GetType(), "Message", "You are successfully registered", false);
//string MailContent = DefaultEmailBody();
//string strResponce = SendMail(txtEmail.Text, "New Registration Details:", MailContent);
//WebMsg.Show("Your registration was successfull. We have sent your Login details on your registered Email Address.");
// ShowMessage("Your registration was successfull. We have sent your Login details on your registered Email Address.");
RedirectToDashboard();
//AppSessions.StudentID = t1;
//AppSessions.BMSID = (int)ViewState["BMSID"];
//Response.Redirect("~/Dashboard/StudentDashboard.aspx", false);
//WebMsg.Show(strResponce);
//ClearRegisterControls();
//Response.Redirect("Login.aspx");
}
ClearRegisterControls();
}
else
{
WebMsg.Show("LoginID already exist..");
}
}
catch (FormatException fe)
{
//WebMsg.Show("Invalid birthdate");
//txtBirthdate.Focus();
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
finally
{ }
//}
//else
//{
// WebMsg.Show("Please enter code");
//}
}
public static List <object> GetPerformanceChartdata(int subjectid)
{
StringBuilder sb = new StringBuilder();
List <object> iData = new List <object>();
List <string> labels = new List <string>();
List <string> lst_dataItem_1 = new List <string>();
try
{
//int subjectid = Convert.ToInt16(AppSessions.SubjectID);
//int subjectid = 1;
int studentid = Convert.ToInt32(AppSessions.StudentID);
int bmsid = Convert.ToInt32(AppSessions.BMSID);
DataTable dtexam = new DataTable();
dtexam.Columns.Add("Chapter", typeof(string));
dtexam.Columns.Add("ObtainedPercentage", typeof(string));
DataSet dsResult = new DataSet();
ReportsForResult Report_Bal = new ReportsForResult();
string data;
// dsResult = Report_Bal.BAL_SYS_ResultRPTByStudentSubDetails(studentid, subjectid,bmsid);
dsResult = Report_Bal.BAL_SYS_Student_Performance_Chart(studentid, subjectid, bmsid);
//sb.Append("[");
if (dsResult.Tables[0].Rows.Count > 0 && dsResult != null)
{
for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++)
{
//int count = dsResult.Tables[0].Rows.Count;
//DataRow dr = dtexam.NewRow();
//dr["Chapter"] = dsResult.Tables[0].Rows[0]["Chapter"].ToString();
//dr["ObtainedPercentage"] = dsResult.Tables[0].Rows[0]["ObtainedPercentage"].ToString(); ;
//dtexam.Rows.Add(dr);
//sb.Append("{");
//System.Threading.Thread.Sleep(50);
//string color = String.Format("#{0:X6}", new Random().Next(0x1000000));
//sb.Append(string.Format("text :'{0}', value:{1}, color: '{2}'", dsResult.Tables[0].Rows[0]["Chapter"].ToString(), dsResult.Tables[0].Rows[0]["ObtainedPercentage"].ToString(), color));
//sb.Append("},");
labels.Add(dsResult.Tables[0].Rows[i]["Chapter"].ToString());
// lst_dataItem_1.Add(Convert.ToInt32(dsResult.Tables[0].Rows[i]["ObtainedPercentage"]));
if (dsResult.Tables[0].Rows[i]["ObtainedPercentage"].ToString().Length > 0)
{
lst_dataItem_1.Add(dsResult.Tables[0].Rows[i]["ObtainedPercentage"].ToString());
}
else
{
lst_dataItem_1.Add(null);
}
}
iData.Add(labels);
iData.Add(lst_dataItem_1);
}
else
{
DataRow dr = dtexam.NewRow();
dr["chapter"] = "";
dr["ObtainedPercentage"] = "";
dtexam.Rows.Add(dr);
}
//sb = sb.Remove(sb.Length - 1, 1);
//sb.Append("]");
}
catch (Exception ex)
{
WebMsg.Show("" + ex.Message.ToString());
}
//return sb.ToString();
return(iData);
}
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 gvAnalysis_RowDataBound(object sender, GridViewRowEventArgs e)
{
try
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Literal ltQuestion = (Literal)e.Row.FindControl("ltQuestion");
Literal lblSolution = (Literal)e.Row.FindControl("lblSolution");
Literal Option1 = (Literal)e.Row.FindControl("Option1");
Literal Option2 = (Literal)e.Row.FindControl("Option2");
Literal Option3 = (Literal)e.Row.FindControl("Option3");
Literal Option4 = (Literal)e.Row.FindControl("Option4");
ltQuestion.Text = HttpUtility.HtmlDecode(DataBinder.Eval(e.Row.DataItem, "Question").ToString());
lblSolution.Text = HttpUtility.HtmlDecode(DataBinder.Eval(e.Row.DataItem, "Solution").ToString());
Option1.Text = "<div style=\"";
if (DataBinder.Eval(e.Row.DataItem, "Option1ID").ToString() == DataBinder.Eval(e.Row.DataItem, "AnswerID").ToString())
{
Option1.Text = Option1.Text + "color:Red;";
}
if (DataBinder.Eval(e.Row.DataItem, "Option1ID").ToString() == DataBinder.Eval(e.Row.DataItem, "GivenAnswerID").ToString())
{
Option1.Text = Option1.Text + "background-color:#ABBCAB;";
}
Option1.Text = Option1.Text + "min-width:20px\">A. " + HttpUtility.HtmlDecode(DataBinder.Eval(e.Row.DataItem, "Option1").ToString()) + "</div>";
Option2.Text = "<div style=\"";
if (DataBinder.Eval(e.Row.DataItem, "Option2ID").ToString() == DataBinder.Eval(e.Row.DataItem, "AnswerID").ToString())
{
Option2.Text = Option2.Text + "color:Red;";
}
if (DataBinder.Eval(e.Row.DataItem, "Option2ID").ToString() == DataBinder.Eval(e.Row.DataItem, "GivenAnswerID").ToString())
{
Option2.Text = Option2.Text + "background-color:#ABBCAB;";
}
Option2.Text = Option2.Text + "min-width:20px\">B. " + HttpUtility.HtmlDecode(DataBinder.Eval(e.Row.DataItem, "Option2").ToString()) + "</div>";
Option3.Text = "<div style=\"";
if (DataBinder.Eval(e.Row.DataItem, "Option3ID").ToString() == DataBinder.Eval(e.Row.DataItem, "AnswerID").ToString())
{
Option3.Text = Option3.Text + "color:Red;";
}
if (DataBinder.Eval(e.Row.DataItem, "Option3ID").ToString() == DataBinder.Eval(e.Row.DataItem, "GivenAnswerID").ToString())
{
Option3.Text = Option3.Text + "background-color:#ABBCAB;";
}
Option3.Text = Option3.Text + "min-width:20px\">C. " + HttpUtility.HtmlDecode(DataBinder.Eval(e.Row.DataItem, "Option3").ToString()) + "</div>";
Option4.Text = "<div style=\"";
if (DataBinder.Eval(e.Row.DataItem, "Option4ID").ToString() == DataBinder.Eval(e.Row.DataItem, "AnswerID").ToString())
{
Option4.Text = Option4.Text + "color:Red;";
}
if (DataBinder.Eval(e.Row.DataItem, "Option4ID").ToString() == DataBinder.Eval(e.Row.DataItem, "GivenAnswerID").ToString())
{
Option4.Text = Option4.Text + "background-color:#ABBCAB;";
}
Option4.Text = Option4.Text + "min-width:20px\">D. " + HttpUtility.HtmlDecode(DataBinder.Eval(e.Row.DataItem, "Option4").ToString()) + "</div>";
}
}
catch (Exception ex)
{
WebMsg.Show(ex.Message.ToString());
}
finally
{
}
}
/// <summary>
/// Get all the clause and header footer visibility setting from XML file and fill the grid report
/// </summary>
public string GetAllSettings()
{
try
{
string allowfooter = GetXMLElementByTagName("allowfooter").ToLower();
if (allowfooter.Trim().ToLower() == "true")
{
lblFooter.Visible = true;
}
else
{
lblFooter.Visible = false;
}
string allowheader = GetXMLElementByTagName("allowheader").ToLower();
if (allowheader.Trim().ToLower() == "true")
{
lblTitle.Visible = true;
}
else
{
lblTitle.Visible = false;
}
string ispaging = GetXMLElementByTagName("AllowPaging").ToLower();
if (ispaging.Trim().Length > 2 && ispaging.Trim().ToLower() == "true")
{
gridreport.AllowPaging = true;
gridreport.PageSize = int.Parse(GetXMLElementByTagName("pagesize"));
}
else
{
gridreport.AllowPaging = false;
}
string strGroupBy = GetXMLElementByTagName("GroupBy");
if (strGroupBy.Trim().Length > 1)
{
strGroupBy = " Group By " + strGroupBy;
}
string strOrderBy = GetXMLElementByTagName("OrderBy");
if (strOrderBy.Trim().Length > 3)
{
strOrderBy = " Order By " + strOrderBy;
}
string strWhere = GetXMLElementByTagName("Where");
try
{
if (strWhere.Trim().Length > 3)
{
strWhere = " where " + GetXMLElementByTagName("Where");
}
}
catch (Exception ex)
{
}
return(strSQL + strWhere + strGroupBy + strOrderBy);
}
catch (Exception ex)
{
WebMsg.Show("error in get all settings" + ex.Message.ToString());
return(null);
}
}
protected void submit_Click(object sender, EventArgs e)
{
try
{
int subjectcount = 0;
package = new Package_BLogic();
Package Newpackage = new Package();
string subjectid = " ";
string subjectname = " ";
foreach (ListItem chk in clstSubject.Items)
{
if (chk.Selected == true)
{
subjectid += chk.Value.ToString() + ",";
subjectname += chk.Text.ToString() + ",";
subjectcount = subjectcount + 1;
}
}
subjectid = subjectid.Remove(subjectid.Length - 1);
subjectname = subjectname.Remove(subjectname.Length - 1);
Newpackage.PackageName = txtPackageName.Text;
Newpackage.PackageDescription = txtdescription.Text;
Newpackage.BMSID = Convert.ToInt32(ddlBoardMediumStandard.SelectedValue);
Newpackage.SubjectID = subjectid;
Newpackage.Subject = subjectname;
//Newpackage.ID = Convert.ToInt32(Session["New_Package_ID"].ToString());
Newpackage.NoOfMonth = Convert.ToInt32(txtmonth.Text);
Newpackage.Price = Convert.ToDecimal(txtprice.Text);
if (rbyes.Checked)
{
Newpackage.IsActive = true;
}
else
{
Newpackage.IsActive = false;
}
DateTime expirydatetime;
if (DateTime.TryParse(txtdate.Text, out expirydatetime))
{
Newpackage.EndDate = expirydatetime;
}
if (subjectcount > 1)
{
Newpackage.PackageType = "Combo";
}
else
{
Newpackage.PackageType = "Single";
}
New_Package_ID = package.InsertPackageFeesDetail(Newpackage);
WebMsg.Show("New Package insterted Sucessfully");
BindGrid();
ClearFields();
}
catch (Exception ex)
{
WebMsg.Show("New Package not insterted Sucessfully");
}
finally
{
}
}
/// <summary>
/// Get the total of required column value
/// </summary>
//double finaltotal = 0;
public void SetTotal()
{
try
{
XmlDocument doc = new XmlDocument();
doc.Load(XMLReportFile);
string TotalColumn = string.Empty;
XmlNodeList list = doc.GetElementsByTagName("Total");
int rowcnt = 0;
foreach (XmlElement item in list)
{
TotalColumn = item.InnerText;
}
if (TotalColumn.Length == 0)
{
lblFooter.Text = ""; return;
}
double total = 0;
string columnname = "";
foreach (GridViewRow dr in gridreport.Rows)
{
//int rowcnt = gridreport.Rows
for (int j = 0; j < dr.Cells.Count; j++)
{
columnname = ((System.Web.UI.WebControls.DataControlFieldCell)(dr.Cells[j])).ContainingField.HeaderText.ToLower();
if (columnname == TotalColumn.ToLower())
{
total += Double.Parse(dr.Cells[j].Text.ToString());
ViewState["granttotal"] = total;
//rowcnt = rowcnt+1;
}
}
}
//foreach (GridViewRow dr in ((System.Data.DataTable)(gridreport.DataSource)).Rows)
//{
for (int i = 0; i < ((System.Data.DataTable)(gridreport.DataSource)).Rows.Count; i++)
{
for (int j = 0; j < ((System.Data.DataTable)(gridreport.DataSource)).Rows[0].ItemArray.Length; j++)
{
columnname = ((System.Data.DataTable)(gridreport.DataSource)).Columns[j].ToString().ToLower();
if (columnname == TotalColumn.ToLower())
{
finaltotal += Double.Parse(((System.Data.DataTable)(gridreport.DataSource)).Rows[i].ItemArray[j].ToString());
ViewState["granttotal"] = total;
rowcnt = rowcnt + 1;
break;
}
}
}
//int rowcnt = gridreport.Rows
//}
double avg = finaltotal / rowcnt;
string footer = "Total " + TotalColumn.ToLower() + ": " + total.ToString() + "<br/>" + " Average " + TotalColumn.ToLower() + ": " + avg.ToString() + "<br/>" + "Grand Total " + TotalColumn.ToLower() + ": " + finaltotal.ToString();
lblFooter.Text = footer;
//lblFooter.Text = "Total " + TotalColumn.ToLower() + ": " + total.ToString();
////finaltotal += ViewState["grandtotal"]
//lblaverage.Text = "Average " + avg.ToString();
//lbltotal.Text = " Total " + finaltotal.ToString();
}
catch (Exception ex)
{
WebMsg.Show("Error in set total" + ex.Message.ToString());
}
}
private void BindNextQuestion(DataTable dt)
{
if (dt.Rows.Count > 0)
{
ltQuestionCount1.Text = Convert.ToString(Convert.ToInt32(ViewState["CurQuestion"]) + 1);
ltQuestionCount3.Text = Convert.ToString(dt.Rows.Count.ToString());
lblQues.Text = "Question " + (Convert.ToInt32(ViewState["CurQuestion"]) + 1) + ": ";
ltQuestion.Text = HttpUtility.HtmlDecode(dt.Rows[Convert.ToInt32(ViewState["CurQuestion"])]["Question"].ToString());
rdb.Items.Clear();
ListItem ltm;
bool isRandomOption = false;
string RndoKey = "0";
RndoKey = getConfigValue("JumbleOption");
if (RndoKey == "0")
{
RndoKey = "false";
}
else
{
RndoKey = "true";
}
isRandomOption = Convert.ToBoolean(RndoKey);
if (isRandomOption)
{
Random randNum = new Random();
int randomRow = 0;
List <int> numbers = new List <int>();
int num = 0;
num = randNum.Next(1, 5);
while (numbers.Count < 4)
{
if (numbers.Contains(num))
{
num = randNum.Next(1, 5);
}
else
{
randomRow = num;
numbers.Add(num);
ltm = new ListItem(dt.Rows[Convert.ToInt32(ViewState["CurQuestion"])]["Option" + num].ToString(), dt.Rows[Convert.ToInt32(ViewState["CurQuestion"])]["Option" + num + "ID"].ToString());
rdb.Items.Add(ltm);
}
}
}
else
{
ltm = new ListItem(dt.Rows[Convert.ToInt32(ViewState["CurQuestion"])]["Option1"].ToString(), dt.Rows[Convert.ToInt32(ViewState["CurQuestion"])]["Option1ID"].ToString());
rdb.Items.Add(ltm);
ltm = new ListItem(dt.Rows[Convert.ToInt32(ViewState["CurQuestion"])]["Option2"].ToString(), dt.Rows[Convert.ToInt32(ViewState["CurQuestion"])]["Option2ID"].ToString());
rdb.Items.Add(ltm);
ltm = new ListItem(dt.Rows[Convert.ToInt32(ViewState["CurQuestion"])]["Option3"].ToString(), dt.Rows[Convert.ToInt32(ViewState["CurQuestion"])]["Option3ID"].ToString());
rdb.Items.Add(ltm);
ltm = new ListItem(dt.Rows[Convert.ToInt32(ViewState["CurQuestion"])]["Option4"].ToString(), dt.Rows[Convert.ToInt32(ViewState["CurQuestion"])]["Option4ID"].ToString());
rdb.Items.Add(ltm);
}
}
else
{
Examtbl.Visible = false;
WebMsg.Show("Question not available");
}
}
public void FillChapters_Topic()
{
obj_BAL_Student_Dashboard = new Student_DashBoard_BLogic();
obj_Student_Dashboard = new StudentDash();
obj_Student_Dashboard.BMSID = Convert.ToInt64(Session["BMSID"]);
obj_Student_Dashboard.SubjectID = Convert.ToInt16(Session["SubjectID"]);
obj_Student_Dashboard.StudentID = Convert.ToInt64(Session["StudentID"]);
//
DataSet dsSettings = new DataSet();
dsSettings = obj_BAL_Student_Dashboard.BAL_Select_CoveredUncoverChapterTopic_Settings();
IsAllow_Enable_Settings(dsSettings);
DataSet dsSelect = new DataSet();
dsSelect = obj_BAL_Student_Dashboard.BAL_Select_Chapters_Topics(obj_Student_Dashboard);
if (dsSelect.Tables.Count == ((int)EnumFile.AssignValue.One))
{
if (dsSelect.Tables[0].Rows[0]["NoRecord"].ToString().Equals("0"))
{
WebMsg.Show("No Chatper availbale.");
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);
if (dsSelect.Tables[2].Rows.Count > ((int)EnumFile.AssignValue.Zero))
{
if (dsSelect.Tables[2].Rows[0]["ChapterID"].ToString().Equals(""))
{
ddlChapter.SelectedIndex = ((int)EnumFile.AssignValue.Zero);
}
else
{
ddlChapter.SelectedValue = dsSelect.Tables[2].Rows[0]["ChapterID"].ToString();
}
}
//DropDownList[] disddl1 = { ddlTopic };
//DisableDropDwon(disddl1);
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);
if (dsSelect.Tables[3].Rows.Count > ((int)EnumFile.AssignValue.Zero))
{
if (dsSelect.Tables[3].Rows[0]["TopicID"].ToString().Equals(""))
{
ddlTopic.SelectedIndex = ((int)EnumFile.AssignValue.Zero);
}
else
{
ViewState["TopicID"] = dsSelect.Tables[3].Rows[0]["TopicID"].ToString();
ddlTopic.SelectedValue = dsSelect.Tables[3].Rows[0]["TopicID"].ToString();
}
}
}
else
{
DropDownList[] disddl = { ddlChapter, ddlTopic };
DisableDropDwon(disddl);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["BMSSCTID"].ToString() != "")
{
//int Level = 0;
//int NoOfQuestion = 0;
//if (Request.QueryString["Level"].ToString() != "")
//{
// Level = Convert.ToInt32(Request.QueryString["Level"].ToString());
//}
//if (Level == 0)
//{
// NoOfQuestion = Convert.ToInt32(getConfigValue("MaxQuestionForAll"));
//}
//else
//{
// NoOfQuestion = Convert.ToInt32(getConfigValue("MaxQuestionForLevelWise"));
//}
DataTable dt = new DataTable();
QuestionMaster objQuestionMaster = new QuestionMaster();
DataSet ds = new DataSet();
DataTable dtExaAuto = null;
Hashtable Question = (Hashtable)Application["Exam_TeacherSheResult"];
if (Question == null)
{
Question = new Hashtable();
}
else
{
dtExaAuto = (DataTable)Question[Session["TrackLogID"].ToString()];
}
// ds = objQuestionMaster.SELECTAll_QuestionByBMSSCTID(RndmQuestion, Level, NoOfQuestion, Convert.ToInt32(Request.QueryString["BMSSCTID"].ToString()), Request.QueryString["TestType"]);
// ds = objQuestionMaster.SELECTAll_QuestionByBMSSCTID(RndmQuestion, Level, NoOfQuestion, Convert.ToInt32(Request.QueryString["BMSSCTID"].ToString()), "MCQ");
if (dtExaAuto != null)
{
if (dtExaAuto.Rows.Count > 0)
{
// dt = ds.Tables[0];
// dt.Columns.Add("GivenAnswerID", typeof(Int64));
// dt.Columns.Add("GivenAnswer", typeof(String));
// dt.Columns.Add("ResultTF", typeof(String));
//Create RandomQuestion
//' Now, add a random number for the RandNum value for each row
//Dim rndNum as New Random()
//For i = 0 to myDataTable.Rows.Count - 1
// myDataTable.Rows(i)("RandNum") = rndNum.Next(10000)
//Next i
string RndoKey = "0";
RndoKey = getConfigValue("JumbleQuestion");
int RndmQuestion = Convert.ToInt32(RndoKey);
DataTable dtExaAutoRandom;
if (RndmQuestion == 1)
{
Random randNum = new Random();
int randomRow = 0;
List <int> numbers = new List <int>();
int num = 0;
int rowToEnter = 0;
num = randNum.Next(1, dtExaAuto.Rows.Count + 1);
while (numbers.Count < dtExaAuto.Rows.Count)
{
if (numbers.Contains(num))
{
num = randNum.Next(1, dtExaAuto.Rows.Count + 1);
}
else
{
randomRow = num;
numbers.Add(num);
dtExaAuto.Rows[rowToEnter]["RandNum"] = num;
dtExaAuto.AcceptChanges();
rowToEnter = rowToEnter + 1;
}
}
DataView dv = new DataView(dtExaAuto);
dv.Sort = "RandNum ASC";
dtExaAutoRandom = dv.ToTable();
}
else
{
DataView dv = new DataView(dtExaAuto);
dtExaAutoRandom = dv.ToTable();
}
ViewState["QuestionAnsDT"] = dtExaAutoRandom;
ViewState["CurQuestion"] = 0;
BindNextQuestion(dtExaAutoRandom);
}
else
{
BtnButton.Visible = false;
WebMsg.Show("No Question found!");
}
}
else
{
Session["ExamStarted"] = "";
Session["TrackLogID"] = "";
Response.Redirect("../Dashboard/StudentDashboard.aspx");
}
}
}
}
/// <summary>
/// Method will be used to create grid condition based on the selected criteria.
/// </summary>
/// <returns>Return GridCondition</returns>
protected string CreateGridCondition()
{
string Condition = string.Empty;
string AndCondtion = " And";
string ESchool = "dbo.Employee.SchoolID";
string ERole = "dbo.Employee.RoleID";
string EStandard = "dbo.SYS_Standard.StandardID";
string EDivision = "dbo.SYS_Division.DivisionID";
string SSchool = "Stud.SchoolID";
string SRole = "Stud.RoleID";
string SDivision = "Stud.DivisionID";
string SysBmsStandard = "SYS_BMS.StandardID";
try
{
if (DdlRole.SelectedValue == Convert.ToString((int)EnumFile.Role.Teacher) || DdlRole.SelectedValue == Convert.ToString((int)EnumFile.Role.S_Admin))
{
// Role ID 3 Indicates Teacher.
if (LtSchoolID.Text != string.Empty)
{
Condition = string.Format("{0}={1}", ESchool, int.Parse(LtSchoolID.Text));
}
if (DdlRole.SelectedValue != Convert.ToString((int)EnumFile.AssignValue.Zero))
{
Condition = Condition + string.Format("{0} {1}={2}", AndCondtion, ERole, DdlRole.SelectedValue);
}
if (DdlStandard.SelectedValue != Convert.ToString((int)EnumFile.AssignValue.Zero))
{
Condition = Condition + string.Format("{0} {1}={2}", AndCondtion, EStandard, DdlStandard.SelectedValue);
}
if (DdlDivision.SelectedValue != Convert.ToString((int)EnumFile.AssignValue.Zero))
{
Condition = Condition + string.Format("{0} {1}={2}", AndCondtion, EDivision, DdlDivision.SelectedValue);
}
}
else if (DdlRole.SelectedValue == Convert.ToString((int)EnumFile.Role.Student))
{
// Role Id 4 indicates student.
if (LtSchoolID.Text != string.Empty)
{
Condition = string.Format("{0}={1}", SSchool, int.Parse(LtSchoolID.Text));
}
if (DdlRole.SelectedValue != Convert.ToString((int)EnumFile.AssignValue.Zero))
{
Condition = Condition + string.Format("{0} {1}={2}", AndCondtion, SRole, DdlRole.SelectedValue);
}
if (int.Parse(ViewState["UserRoleID"].ToString()) != Convert.ToInt32(EnumFile.Role.Teacher))
{
if (DdlStandard.SelectedValue != Convert.ToString((int)EnumFile.AssignValue.Zero))
{
////string B = "Stud.BMSID in (Select BMSID from SYS_BMS where SYS_BMS.BoardID=" + BoardID + " and SYS_BMS.MediumID=" + MediumID + " and SYS_BMS.StandardID=" + DdlStandard.SelectedValue + ")";
////Condition = Condition + string.Format("{0} {1}", AndCondtion, B);
Condition = Condition + string.Format("{0} {1}={2}", AndCondtion, SysBmsStandard, DdlStandard.SelectedValue);
}
if (DdlDivision.SelectedValue != Convert.ToString((int)EnumFile.AssignValue.Zero))
{
Condition = Condition + string.Format("{0} {1}={2}", AndCondtion, SDivision, DdlDivision.SelectedValue);
}
}
else if (int.Parse(ViewState["UserRoleID"].ToString()) == Convert.ToInt32(EnumFile.Role.Teacher))
{
if (DdlStandard.SelectedValue != Convert.ToString((int)EnumFile.AssignValue.Zero))
{
string B = "Stud.BMSID in (Select DISTINCT BMSID from EmployeeStandardDetail ESD where ESD.EmployeeID=" + int.Parse(this.ViewState["EmployeeID"].ToString()) + " and Sbms.BMSID=ESD.BMSID and Std.StandardID=" + DdlStandard.SelectedValue + ")";
Condition = Condition + string.Format("{0} {1}", AndCondtion, B);
}
if (DdlDivision.SelectedValue != Convert.ToString((int)EnumFile.AssignValue.Zero))
{
string B = "Stud.DivisionID in (Select DISTINCT DivisionID from EmployeeStandardDetail where EmployeeStandardDetail.EmployeeID=" + int.Parse(this.ViewState["EmployeeID"].ToString()) + "and Div.DivisionID=" + DdlDivision.SelectedValue + ")";
Condition = Condition + string.Format("{0} {1}", AndCondtion, B);
}
}
}
}
catch (Exception ex)
{
WebMsg.Show(ex.Message);
}
return(Condition);
}
protected void btnDisplay_Click(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.ToString().Equals("View"))
{
myframe.Attributes["style"] = "";
mp1.Show();
LblDisplay.Text = Session["DEMOChapterTopic"].ToString();
Session["DashboardTopic"] = LblDisplay.Text;
LinkButton lb = (LinkButton)e.CommandSource;
GridViewRow gvr = (GridViewRow)lb.NamingContainer;
string src = string.Empty;
objeAes = new SimplerAES();
try
{
string value = gvrecords.DataKeys[gvr.RowIndex].Values["ResourcePath"].ToString();
string[] lines = Regex.Split(value, "/");
string Actvty = lines[lines.Length - 2].ToString();
// bool IsNotAssessment = true;
ViewState["FileName"] = lines[lines.Length - 1].ToString();
// TrackLog_Utils obj = new TrackLog_Utils();
// DataSet dsCheckLog = new DataSet();
// bool AllowToAssessment = false;
//if (!IsNotAssessment)
//{
// if (AppSessions.StudentID == 0)
// {
// dsCheckLog = obj.SELECTExamTrackLogOtherEmployee(AppSessions.BMSID, AppSessions.SchoolID, AppSessions.DivisionID, AppSessions.EmpolyeeID);
// if (dsCheckLog.Tables.Count > 0)
// {
// if (dsCheckLog.Tables[0].Rows.Count > 0)
// {
// if (dsCheckLog.Tables[0].Rows[0]["Activity"].ToString() == "Assessment" || dsCheckLog.Tables[0].Rows[0]["Activity"].ToString() == "Pretest")
// {
// AllowToAssessment = false;
// mp1.Hide();
// WebMsg.Show("Assessment for the class is alredy running");
// }
// else
// {
// AllowToAssessment = true;
// }
// }
// else
// {
// AllowToAssessment = true;
// }
// }
// }
// else { AllowToAssessment = true; }
//}
//if (AllowToAssessment || IsNotAssessment)
//{
//TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmpolyeeID), Convert.ToInt16(AppSessions.DivisionID), "EducationResourcepage", "lnkDisplay", "Click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, Actvty, "View the " + lines[lines.Length - 1].ToString() + " File.", Convert.ToInt32(Session["BMSSCTID"]));
Session["src"] = gvrecords.DataKeys[gvr.RowIndex].Values["ResourcePath"].ToString();
Session["ext"] = gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString();
if (gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString().Equals(".pdf"))
{
//Session["ContentPath"] = gvrecords.DataKeys[gvr.RowIndex].Values["ResourcePath"].ToString();
//Session["ContentType"] = "application/pdf";
//HttpContext.Current.Session["ContentType"] = "application/pdf";
src = "../PDFViewer/web/viewer.html?lank=" + gvrecords.DataKeys[gvr.RowIndex].Values["ResourcePath"].ToString();
myframe.Attributes["src"] = src;
Session["myframesrc"] = src;
//src = "OpenFlv.aspx?FullPath=" + gvrecords.DataKeys[gvr.RowIndex].Values["ResourcePath"].ToString() + "&ext=" + gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString();
//myframe.Attributes["src"] = src;
}
else if (gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString().Equals(".flv"))
{
src = "OpenFLVDemo.aspx?FullPath=" + gvrecords.DataKeys[gvr.RowIndex].Values["ResourcePath"].ToString() + "&ext=" + gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString();
myframe.Attributes["src"] = src;
Session["myframesrc"] = src;
}
else if (gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString().Equals(".swf"))
{
src = "OpenFLVDemo.aspx?FullPath=" + gvrecords.DataKeys[gvr.RowIndex].Values["ResourcePath"].ToString() + "&ext=" + gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString();
myframe.Attributes["src"] = src;
Session["myframesrc"] = src;
}
else if (gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString().Equals(".avi"))
{
src = "OpenFLVDemo.aspx?FullPath=" + gvrecords.DataKeys[gvr.RowIndex].Values["ResourcePath"].ToString() + "&ext=" + gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString();
myframe.Attributes["src"] = src;
Session["myframesrc"] = src;
}
else if (gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString().Equals(".mp4"))
{
src = "OpenFLVDemo.aspx?FullPath=" + gvrecords.DataKeys[gvr.RowIndex].Values["ResourcePath"].ToString() + "&ext=" + gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString();
myframe.Attributes["src"] = src;
Session["myframesrc"] = src;
//string filename = "test.mp4";
//getExtension(filename);
}
else if (gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString().Equals(".html") || gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString().Equals(".htm"))
{
src = gvrecords.DataKeys[gvr.RowIndex].Values["ResourcePath"].ToString();
myframe.Attributes["src"] = src;
Session["myframesrc"] = src;
}
//else if (gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString().Equals(".Test") || gvrecords.DataKeys[gvr.RowIndex].Values["Ext"].ToString().Equals(".Test"))
//{
// DataSet dsCheckLogToTrackLog = new DataSet();
// dsCheckLogToTrackLog = obj.SELECTExamTrackLogOtherEmployee(AppSessions.BMSID, AppSessions.SchoolID, AppSessions.DivisionID, AppSessions.EmpolyeeID);
// if (dsCheckLogToTrackLog.Tables.Count > 0)
// {
// if (dsCheckLogToTrackLog.Tables[0].Rows.Count > 0)
// {
// if (dsCheckLogToTrackLog.Tables[0].Rows[0]["Activity"].ToString() == "Posttest" || dsCheckLogToTrackLog.Tables[0].Rows[0]["Activity"].ToString() == "Pretest")
// {
// Hashtable Question = (Hashtable)Application["Exam_TeacherSheResult"];
// if (Question == null)
// {
// Question = new Hashtable();
// }
// else
// {
// if (Session["TrackLogID"] != null)
// {
// try
// {
// Question.Remove(Session["TrackLogID"].ToString());
// Application.Lock();
// Application["Exam_TeacherSheResult"] = Question;
// Application.UnLock();
// }
// catch (Exception ex)
// { }
// }
// }
// Session["TrackLogID"] = dsCheckLogToTrackLog.Tables[0].Rows[0]["TrackLogID"].ToString();
// }
// }
// }
// src = gvrecords.DataKeys[gvr.RowIndex].Values["ResourcePath"].ToString() + "&BMSSCTID=" + Convert.ToInt32(Session["BMSSCTID"]) + "";
// myframe.Attributes["src"] = src;
// if (AppSessions.StudentID == 0)
// { myframe.Style.Add("height", "550px"); }
// else
// {
// myframe.Style.Add("height", "450px");
// }
//}
//}
//else
//{
// //WebMsg.Show("Selected class exam alredy running");
// }
}
catch (FileNotFoundException ex)
{
WebMsg.Show("No File Exists" + ex.StackTrace);
}
catch (Exception ex)
{
WebMsg.Show("No File Exists");
}
}
}
protected void ibtnEdit_Click(object sender, ImageClickEventArgs e)
{
imgUpdate.Visible = false;
FormView1.Visible = true;
DataSet dsSelect = new DataSet();
string SearchCondition = string.Empty;
string IFormat = "dd-MMM-yyyy";
int CoundChecked = (int)EnumFile.AssignValue.Zero;
int GRrowIndex = (int)EnumFile.AssignValue.Zero;
foreach (GridViewRow gr in gvEmployeeDetails.Rows)
{
CheckBox chk = new CheckBox();
chk = (CheckBox)gr.FindControl("chkSelect");
if (chk.Checked == true)
{
CoundChecked = CoundChecked + 1;
GRrowIndex = gr.RowIndex;
}
}
if (CoundChecked == (int)EnumFile.AssignValue.Zero || CoundChecked > (int)EnumFile.AssignValue.One)
{
WebMsg.Show("Please select one record to Update.");
}
else
{
this.InvisiblePanels();
pnlEdit.CssClass = "Visible";
int employeeid = Convert.ToInt32(gvEmployeeDetails.DataKeys[GRrowIndex]["EmployeeID"].ToString());
this.ViewState["EmployeeID"] = employeeid;
SearchCondition = "and Employee.EmployeeID= " + Convert.ToString(employeeid);
dsSelect = dsSelect = this.BAL_Employee.BAL_EmployeeDetailsBySchoolID(Convert.ToInt32(this.Session["SchoolID"]), SearchCondition);
FormView1.DataSource = dsSelect;
FormView1.DataBind();
txtUpdateFirstName.Text = dsSelect.Tables[0].Rows[0]["FirstName"].ToString();
txtUpdateMiddleName.Text = dsSelect.Tables[0].Rows[0]["MiddleName"].ToString();
txtUpdateLastName.Text = dsSelect.Tables[0].Rows[0]["LastName"].ToString();
txtUpdateDOB.Text = Convert.ToDateTime(dsSelect.Tables[0].Rows[0]["DateOfBirth"].ToString()).ToString(IFormat);
rlstUpdateGender.SelectedValue = dsSelect.Tables[0].Rows[0]["Gender"].ToString();
txtUpdateBloodGroup.Text = dsSelect.Tables[0].Rows[0]["BloodGroup"].ToString();
txtUpdatePermanentAddress.Text = dsSelect.Tables[0].Rows[0]["Address"].ToString();
txtUpdateContactNo.Text = dsSelect.Tables[0].Rows[0]["ContactNo"].ToString();
txtUpdateEmail.Text = dsSelect.Tables[0].Rows[0]["EmailID"].ToString();
txtUpdateQualification.Text = dsSelect.Tables[0].Rows[0]["Qualification"].ToString();
txtUpdateDesignation.Text = dsSelect.Tables[0].Rows[0]["Designation"].ToString();
if (dsSelect.Tables[0].Rows[0]["Image"].ToString() != string.Empty)
{
byte[] ImageBytes = (byte[])dsSelect.Tables[0].Rows[0]["Image"];
ViewState["ImageBytes"] = ImageBytes;
if (ImageBytes.Length == 0)
{
FormView1.Visible = false;
imgUpdate.Visible = true;
imgUpdate.ImageUrl = "~/SchoolAdmin/EmployeePhoto/NoPhoto.jpg";
}
}
else
{
FormView1.Visible = false;
imgUpdate.Visible = true;
imgUpdate.ImageUrl = "~/SchoolAdmin/EmployeePhoto/NoPhoto.jpg";
}
////fupUpdateFileUploadPhoto.FileContent.Read(buffer, 0, buffer.Length);
ddlUpdateSecurityQues.SelectedIndex = Convert.ToInt32(dsSelect.Tables[0].Rows[0]["SecurityQuestion"].ToString());
txtUpdateSecAns.Text = dsSelect.Tables[0].Rows[0]["SecurityAnswer"].ToString();
}
}
//public void ShowMessage(string message)
//{
// this.lblMessage.Text = message;
// ModalMessageExtender.Show();
//}
protected void RedirectToDashboard()
{
try
{
// 0 Indicates Student
StudentDash = new StudentDash();
BLogic_Student = new Student_DashBoard_BLogic();
DataSet dtLogin = new DataSet();
DataTable LoginInfo = new DataTable();
DataTable UserInfo = new DataTable();
obj_SYS_Role = new SYS_Role();
obj_BAL_SYS_Role = new SYS_Role_BLogic();
obj_SYS_Role.Username = txtEmail.Text;
obj_SYS_Role.Password = ViewState["strpassword"].ToString();
//obj_SYS_Role.roleid = Convert.ToInt16(DdlRole.SelectedValue);
//if (uctxtEmail.Text != "" && uctxtpass.Text != "")
//{
dtLogin = obj_BAL_SYS_Role.BAL_SYS_Student_Login(obj_SYS_Role);
LoginInfo = dtLogin.Tables[0];
//}
if (LoginInfo.Rows.Count > 0 && LoginInfo != null)
{
AppSessions.AppUserType = "Student";
AppSessions.StudentID = Convert.ToInt32(LoginInfo.Rows[0]["StudentID"].ToString());
AppSessions.UserName = LoginInfo.Rows[0]["FirstName"].ToString();
AppSessions.BMSID = Convert.ToInt32(LoginInfo.Rows[0]["BMSID"].ToString());
AppSessions.BMS = LoginInfo.Rows[0]["BMS"].ToString();
AppSessions.BoardID = Convert.ToInt32(LoginInfo.Rows[0]["BoardID"].ToString());
AppSessions.Board = LoginInfo.Rows[0]["Board"].ToString();
AppSessions.MediumID = Convert.ToInt32(LoginInfo.Rows[0]["MediumID"].ToString());
AppSessions.Medium = LoginInfo.Rows[0]["Medium"].ToString();
AppSessions.StandardID = Convert.ToInt32(LoginInfo.Rows[0]["StandardID"].ToString());
AppSessions.Standard = LoginInfo.Rows[0]["Standard"].ToString();
AppSessions.DivisionID = Convert.ToInt32(LoginInfo.Rows[0]["DivisionID"].ToString());
//AppSessions.Division = LoginInfo.Rows[0]["Division"].ToString();
AppSessions.SchoolID = Convert.ToInt32(LoginInfo.Rows[0]["SchoolID"].ToString());
//AppSessions.SchoolName = LoginInfo.Rows[0]["SchoolName"].ToString();
AppSessions.Role = LoginInfo.Rows[0]["Role"].ToString();
AppSessions.RoleID = Convert.ToInt32(LoginInfo.Rows[0]["RoleID"].ToString());
AppSessions.IsFreePackage = IsFreePackage();
//AppSessions.EmailID = Convert.ToString(LoginInfo.Rows[0]["EmailID"]);
//yourLoginMethodStudent(LoginInfo);
bool AllowMultipleSession = false;
AllowMultipleSession = Convert.ToBoolean(LoginInfo.Rows[0]["AllowMultipleSession"].ToString());
//Hashtable sessions1 = (Hashtable)Application["WEB_SESSIONS_OBJECT"];
//HttpSessionState existingUserSession1 = (HttpSessionState)sessions1[Session["StudentID"].ToString()];
//if (existingUserSession1 != null)
//{
// Response.Redirect("../Dashboard/StudentDashboard.aspx");
//}
if (AllowMultipleSession == false)
{
Hashtable sessions = (Hashtable)Application["WEB_SESSIONS_OBJECT"];
if (sessions == null)
{
sessions = new Hashtable();
}
HttpSessionState existingUserSession = (HttpSessionState)sessions[Session["StudentID"].ToString()];
if (existingUserSession != null)
{
////existingUserSession[Session["EmpolyeeID"].ToString()] = null;
//logout current logged in user
WebMsg.Show("you are already logged in.");
return;
}
}
////////getting the pointer to the Session of the current logged in user
yourLoginMethodStudent(LoginInfo);
//ProceedToRedirectPage(LoginInfo);
bool AllowPayment = false;
DataSet dsPaymentInfo = new DataSet();
dsPaymentInfo = BLogic_Student.BAL_Select_PaymentPagesInfo("Payment");
if (dsPaymentInfo != null & dsPaymentInfo.Tables.Count > 0)
{
if (dsPaymentInfo.Tables[0].Rows.Count > 0)
{
string a = dsPaymentInfo.Tables[0].Rows[0]["value"].ToString();
if (a == "0")
{
AllowPayment = false;
}
else
{
AllowPayment = true;
}
}
}
DataSet ds = new DataSet();
StudentDash.StudentID = AppSessions.StudentID;
//ds = BLogic_Student.BAL_Validate_Student(StudentDash);
ds = BLogic_Student.BAL_Validate_Student_Package(StudentDash);
TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmployeeOrStudentID), Convert.ToInt16(AppSessions.DivisionID), "Login", "btnLogin", "Click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.LoginSuccess), "LoginId: " + txtEmail.Text, 0);
if (AllowPayment == true)
{
//Session["ShowPaymentPages"] = "yes";
if (ds != null && dtLogin.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
Session["CheckValidity"] = "Yes";
ProceedToRedirect();
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('We have sent your Login details on your registered Email Address, kindly check your Email to get your Password. ');window.open('../DashBoard/StudentDashboard.aspx','_self');", true);
//Response.Redirect("~/DashBoard/StudentDashboard.aspx", false);
//ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('Congratulation! You got free trial for 30 days. \\n We have sent your Login details on your registered Email Address. ');window.open('../DashBoard/StudentDashboard.aspx','_self');", true);
TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmployeeOrStudentID), Convert.ToInt16(AppSessions.DivisionID), "Login", "btnLogin", "Click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.PackageSelection), "LoginId: " + txtEmail.Text, 0);
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Alert", "alert('We have sent your Login details on your registered Email Address, kindly check your Email to get your Password. ');window.open('../DashBoard/StudentDashboard.aspx','_self');", true);
//Response.Redirect("~/DashBoard/StudentDashboard.aspx", false);
TrackLog_Utils.Log(Convert.ToInt32(AppSessions.SchoolID), Convert.ToInt32(AppSessions.EmployeeOrStudentID), Convert.ToInt16(AppSessions.DivisionID), "Login", "btnLogin", "Click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.PackageSelection), "LoginId: " + txtEmail.Text, 0);
}
}
else
{
Session["CheckValidity"] = "Yes";
Session["ShowPaymentPages"] = "No";
ProceedToRedirect();
}
}
}
catch (Exception)
{
}
}
