public void Fillddls() { obj_SYS_Role = new SYS_Role(); obj_BAL_SYS_Role = new SYS_Role_BLogic(); DataSet dsSelect = new DataSet(); dsSelect = obj_BAL_SYS_Role.BAL_Select_BMSList(); if (dsSelect.Tables.Count > ((int)EnumFile.AssignValue.Zero)) { ddlBoard.DataSource = dsSelect.Tables[0]; ddlBoard.DataTextField = "BMS"; ddlBoard.DataValueField = "BMSID"; ddlBoard.DataBind(); ddlBoard.Items.Insert(((int)EnumFile.AssignValue.Zero), new ListItem("-- Select --")); ddlSubject.DataSource = dsSelect.Tables[1]; ddlSubject.DataTextField = "Subject"; ddlSubject.DataValueField = "SubjectID"; ddlSubject.DataBind(); ddlSubject.Items.Insert(((int)EnumFile.AssignValue.Zero), new ListItem("-- Select --")); } }
protected string IsFreePackage() { try { string strresult = string.Empty; obj_BAL_SYS_Role = new SYS_Role_BLogic(); DataSet dtPackageDetails = new DataSet(); dtPackageDetails = obj_BAL_SYS_Role.BAL_SYS_Select_IsFreePackage(Convert.ToInt32(AppSessions.StudentID)); double packageprice = Convert.ToDouble(dtPackageDetails.Tables[0].Rows[0]["Price"].ToString()); if (packageprice > 0) { strresult = "paid"; } else { strresult = "free"; } return(strresult); } catch (Exception) { return(string.Empty); } }
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) { } }
//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) { } }
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 btnGo_Click(object sender, EventArgs e) { try { if (uctxtUserName.Text == string.Empty || uctxtUserPassword.Text == string.Empty) { WebMsg.Show("Please enter User ID and Password"); } else { StoreCookie(); int status = CheckLogin(); //if (ddlUserType.SelectedValue == "0") if (status == 2) { //WebMsg.Show("invalid username or password"); uctxtUserName.Text = string.Empty; uctxtUserPassword.Text = string.Empty; ucinvalididpassword.Text = "Invalid User ID or Password"; //Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('FiveDot File uploaded successfully'); ", true); //Response.Write("<script>alert('my message');</script> "); //ScriptManager.RegisterClientScriptBlock(ucbtnGo, this.GetType(), "Alert Message", "<script> alert('invalid username or password');</script>", true); 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 = uctxtUserName.Text; obj_SYS_Role.Password = uctxtUserPassword.Text; //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.LoginID = LoginInfo.Rows[0]["LoginID"].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 Session["StudentID"] = null; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "key", "<script>alert('You are already Logged In.')</script>", false); 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: " + uctxtUserName.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 { Response.Redirect("~/DashBoard/SelectPackage.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: " + uctxtUserName.Text, 0); } } else { Response.Redirect("~/DashBoard/SelectPackage.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: " + uctxtUserName.Text, 0); } } else { Session["CheckValidity"] = "Yes"; Session["ShowPaymentPages"] = "No"; ProceedToRedirect(); } } } //else if (ddlUserType.SelectedValue == "1") 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 = uctxtUserName.Text; obj_SYS_Role.Password = uctxtUserPassword.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: " + uctxtUserName.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 } 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(ViewState["SchoolID"]), Convert.ToInt32(ViewState["EmpolyeeID"]), Convert.ToInt16(AppSessions.DivisionID), "LoginMasterPage.master", "ucbtnGo", "Click", Convert.ToDateTime(System.DateTime.Now), HttpContext.Current.Session.SessionID, StringEnum.stringValueOf(EnumFile.Activity.LoginSuccess), ViewState["UserName"] + " (" + uctxtUserName.Text + ") From " + ViewState["SchoolName"] + " school Logged in.", 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) { WebMsg.Show("This user is already logged in"); } 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: " + uctxtUserName.Text + " , Password: "******"Authentication Failed,unable to login"); } } uctxtUserName.Text = string.Empty; uctxtUserPassword.Text = string.Empty; } } catch (Exception ex) { WebMsg.Show(ex.Message); } }
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); ViewState["BMSSCTID"] = bmssctid.ToString(); if (ddlDivision.SelectedIndex != 0) { ds_ActivityFeedback = obj_Activity_Feedback_Rating.GetActivityFeedback(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(bmssctid), Convert.ToInt32(ddlDivision.SelectedValue), 2); ds_QuestionAverage = obj_Activity_Feedback_Rating.GetQuestionRatingAverage(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(bmssctid), Convert.ToInt32(ddlDivision.SelectedValue)); } else { ds_ActivityFeedback = obj_Activity_Feedback_Rating.GetActivityFeedback(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(bmssctid), 0, 1); ds_QuestionAverage = obj_Activity_Feedback_Rating.GetQuestionRatingAverage(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(bmssctid), Convert.ToInt32(ddlDivision.SelectedValue)); } //DataSet teacher = new DataSet(); //teacher = obj_Activity_Feedback_Rating.GetActivityFeedbackTeacher(Convert.ToInt32(ddlSchool.SelectedValue), Convert.ToInt32(bmssctid),Convert.ToInt32(ddlDivision.SelectedValue)); //ds_ActivityFeedback.Merge(teacher); double[] totalavg; int[] star; star = new int[6]; DataTable dt_teacherRating = new DataTable(); dt_teacherRating = ds_QuestionAverage.Tables[0]; DataTable dt_studentRating = new DataTable(); dt_studentRating = ds_QuestionAverage.Tables[1]; //DataRow dr; //for (int i = 0; i < dt_studentRating.Rows.Count; i++) //{ // dr = dt_teacherRating.NewRow(); // dr["ActivityFeedbackID"] = dt_studentRating.Rows[i]["ActivityFeedbackID"].ToString(); // dr["SchoolID"] = dt_studentRating.Rows[i]["SchoolID"].ToString(); // dr["BMSSCTID"] = dt_studentRating.Rows[i]["BMSSCTID"].ToString(); // dr["ID"] = dt_studentRating.Rows[i]["ID"].ToString(); // dr["DivisionID"] = dt_studentRating.Rows[i]["DivisionID"].ToString(); // dr["Rating"] = dt_studentRating.Rows[i]["Rating"].ToString(); // dt_teacherRating.Rows.Add(dr); //} int total = 0; if (ds_ActivityFeedback.Tables[0].Rows.Count > 0) { for (int cnt = 0; cnt < ds_ActivityFeedback.Tables[0].Rows.Count; cnt++) { if (ds_ActivityFeedback.Tables[0].Rows[cnt]["Rating"].ToString() != "0") { //total += ds_ActivityFeedback.Tables[0].Rows.Count; total += 1; } } } if (ds_ActivityFeedback.Tables[1].Rows.Count > 0) { //total += ds_ActivityFeedback.Tables[1].Rows.Count; for (int cnt = 0; cnt < ds_ActivityFeedback.Tables[1].Rows.Count; cnt++) { if (ds_ActivityFeedback.Tables[1].Rows[cnt]["Rating"].ToString() != "0") { //total += ds_ActivityFeedback.Tables[0].Rows.Count; total += 1; } } } for (int q_avg = 0; q_avg < ds_ActivityFeedback.Tables[0].Rows.Count; q_avg++) { if (ds_ActivityFeedback.Tables[0].Rows[q_avg]["Rating"].ToString() == "1") { OneStar += 1.0; star[1] = Convert.ToInt32(Math.Round((OneStar * 100) / total)); lbl1star.Text = star[1].ToString() + "%"; } if (ds_ActivityFeedback.Tables[0].Rows[q_avg]["Rating"].ToString() == "2") { Twostar += 1.0; star[2] = Convert.ToInt32(Math.Round((Twostar * 100) / total)); lbl2star.Text = star[2].ToString() + "%"; } if (ds_ActivityFeedback.Tables[0].Rows[q_avg]["Rating"].ToString() == "3") { Threestar += 1.0; star[3] = Convert.ToInt32(Math.Round((Threestar * 100) / total)); lbl3star.Text = star[3].ToString() + "%"; } if (ds_ActivityFeedback.Tables[0].Rows[q_avg]["Rating"].ToString() == "4") { Fourstar += 1.0; star[4] = Convert.ToInt32(Math.Round((Fourstar * 100) / total));; lbl4star.Text = star[4].ToString() + "%"; } if (ds_ActivityFeedback.Tables[0].Rows[q_avg]["Rating"].ToString() == "5") { Fivestar += 1.0; star[5] = Convert.ToInt32(Math.Round((Fivestar * 100) / total)); lbl5star.Text = star[5].ToString() + "%"; } } for (int q_avg = 0; q_avg < ds_ActivityFeedback.Tables[1].Rows.Count; q_avg++) { if (ds_ActivityFeedback.Tables[1].Rows[q_avg]["Rating"].ToString() == "1") { OneStar += 1.0; star[1] = Convert.ToInt32((OneStar * 100) / total); lbl1star.Text = star[1].ToString() + "%"; } if (ds_ActivityFeedback.Tables[1].Rows[q_avg]["Rating"].ToString() == "2") { Twostar += 1.0; star[2] = Convert.ToInt32(Math.Round(Twostar * 100) / total); lbl2star.Text = star[2].ToString() + "%"; } if (ds_ActivityFeedback.Tables[1].Rows[q_avg]["Rating"].ToString() == "3") { Threestar += 1.0; star[3] = Convert.ToInt32((Threestar * 100) / total); lbl3star.Text = star[3].ToString() + "%"; } if (ds_ActivityFeedback.Tables[1].Rows[q_avg]["Rating"].ToString() == "4") { Fourstar += 1.0; star[4] = Convert.ToInt32((Fourstar * 100) / total); lbl4star.Text = star[4].ToString() + "%"; } if (ds_ActivityFeedback.Tables[1].Rows[q_avg]["Rating"].ToString() == "5") { Fivestar += 1.0; star[5] = Convert.ToInt32((Fivestar * 100) / total); lbl5star.Text = star[5].ToString() + "%"; } } #region commnet //for (int i = 0; i < dt_student.Rows.Count; i++) //{ // dt_teacher.ImportRow(dt_student.Rows[i]); //} //for (int q_avg = 0; q_avg < ds_QuestionAverage.Tables[0].Rows.Count; q_avg++) //{ // if (ds_QuestionAverage.Tables[0].Rows[q_avg]["Rating"].ToString() == "1") // { // OneStar += 1.0; // star[1] = Convert.ToInt32(Math.Round((OneStar * 100) / ds_QuestionAverage.Tables[0].Rows.Count)); // lbl1star.Text = star[1].ToString() + "%"; // } // if (ds_QuestionAverage.Tables[0].Rows[q_avg]["Rating"].ToString() == "2") // { // Twostar += 1.0; // star[2] = Convert.ToInt32(Convert.ToDouble(Math.Round((Twostar * 100) / ds_QuestionAverage.Tables[0].Rows.Count))); // lbl2star.Text = star[2].ToString() + "%"; // } // if (ds_QuestionAverage.Tables[0].Rows[q_avg]["Rating"].ToString() == "3") // { // Threestar += 1.0; // star[3] = Convert.ToInt32(Math.Round((Threestar * 100) / ds_QuestionAverage.Tables[0].Rows.Count)); // lbl3star.Text = star[3].ToString() + "%"; // } // if (ds_QuestionAverage.Tables[0].Rows[q_avg]["Rating"].ToString() == "4") // { // Fourstar += 1.0; // star[4] = Convert.ToInt32(Math.Round((Fourstar * 100) / ds_QuestionAverage.Tables[0].Rows.Count)); // lbl4star.Text = star[4].ToString() + "%"; // } // if (ds_QuestionAverage.Tables[0].Rows[q_avg]["Rating"].ToString() == "5") // { // Fivestar += 1.0; // star[5] = Convert.ToInt32(Math.Round((Fivestar * 100) / ds_QuestionAverage.Tables[0].Rows.Count)); // lbl5star.Text = star[5].ToString() + "%"; // } //} //for (int q_avg = 0; q_avg < ds_QuestionAverage.Tables[0].Rows.Count; q_avg++) //{ // if (ds_QuestionAverage.Tables[1].Rows[q_avg]["Rating"].ToString() == "1") // { // OneStar += 1.0; // star[1] = Convert.ToInt32(Math.Round((OneStar * 100) / ds_QuestionAverage.Tables[1].Rows.Count)); // lbl1star.Text = star[1].ToString() + "%"; // } // if (ds_QuestionAverage.Tables[1].Rows[q_avg]["Rating"].ToString() == "2") // { // Twostar += 1.0; // star[2] = Convert.ToInt32(Convert.ToDouble(Math.Round((Twostar * 100) / ds_QuestionAverage.Tables[1].Rows.Count))); // lbl2star.Text = star[2].ToString() + "%"; // } // if (ds_QuestionAverage.Tables[1].Rows[q_avg]["Rating"].ToString() == "3") // { // Threestar += 1.0; // star[3] = Convert.ToInt32(Math.Round((Threestar * 100) / ds_QuestionAverage.Tables[1].Rows.Count)); // lbl3star.Text = star[3].ToString() + "%"; // } // if (ds_QuestionAverage.Tables[1].Rows[q_avg]["Rating"].ToString() == "4") // { // Fourstar += 1.0; // star[4] = Convert.ToInt32(Math.Round((Fourstar * 100) / ds_QuestionAverage.Tables[1].Rows.Count)); // lbl4star.Text = star[4].ToString() + "%"; // } // if (ds_QuestionAverage.Tables[1].Rows[q_avg]["Rating"].ToString() == "5") // { // Fivestar += 1.0; // star[5] = Convert.ToInt32(Math.Round((Fivestar * 100) / ds_QuestionAverage.Tables[1].Rows.Count)); // lbl5star.Text = star[5].ToString() + "%"; // } //} //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]; #endregion int rowcount = ds_ActivityFeedback.Tables[0].Rows.Count + ds_ActivityFeedback.Tables[1].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[0].Rows.Count > 0) { QuestionCount = Convert.ToInt32(ds_ActivityFeedback.Tables[0].Rows[0]["count"].ToString()); for (int cnt = 0; cnt < ds_ActivityFeedback.Tables[0].Rows.Count; cnt++) { TotalRating1 = Convert.ToInt32(ds_ActivityFeedback.Tables[0].Rows[cnt]["Rating"].ToString()); if (TotalRating1 != 0) { totalavg[row_count] = (TotalRating1 / Convert.ToDouble(QuestionCount)); row_count = row_count + 1; } } } if (ds_ActivityFeedback.Tables[1].Rows.Count > 0) { //QuestionCount = Convert.ToInt32(ds_ActivityFeedback.Tables[1].Rows[1]["count"].ToString()); QuestionCount = Convert.ToInt32(ds_ActivityFeedback.Tables[1].Rows[0]["count"].ToString()); for (int cnt = 0; cnt < ds_ActivityFeedback.Tables[1].Rows.Count; cnt++) { TotalRating1 = Convert.ToInt32(ds_ActivityFeedback.Tables[1].Rows[cnt]["Rating"].ToString()); if (TotalRating1 != 0) { totalavg[row_count] += (TotalRating1 / Convert.ToDouble(QuestionCount)); row_count = row_count + 1; } } } //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]["QuestionCount"].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[3].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 Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Page.Title = "Manage User"; string IFormat = "dd-MMM-yyyy"; SYS_Role_BLogic obj_BAL_SYS_Role = new SYS_Role_BLogic(); DataSet dsSelect = new DataSet(); dsSelect = obj_BAL_SYS_Role.BAL_SYS_Role_SelectAll(); if (Session["RoleID"].ToString() == Convert.ToString((int)EnumFile.Role.E_Admin)) { //EAdmin foreach (DataRow dr in dsSelect.Tables[0].Rows) { if ((Convert.ToString(dr["RoleID"]) == "2") || Convert.ToString(dr["RoleID"]) == "3") { ListItem oList = new ListItem(Convert.ToString(dr["Role"]), Convert.ToString(dr["RoleID"])); ddlRole.Items.Add(oList); } } } else if (Session["RoleID"].ToString() == Convert.ToString((int)EnumFile.Role.S_Admin)) { //SAdmin foreach (DataRow dr in dsSelect.Tables[0].Rows) { if (Convert.ToString(dr["RoleID"]) == "3") { ListItem oList = new ListItem(Convert.ToString(dr["Role"]), Convert.ToString(dr["RoleID"])); ddlRole.Items.Add(oList); } } } //ddlRole.DataSource = dsSelect.Tables[0]; //ddlRole.DataTextField = "Role"; //ddlRole.DataValueField = "RoleID"; //ddlRole.DataBind(); ddlRole.Items.Insert(((int)EnumFile.AssignValue.Zero), new ListItem("-- Select --", "0")); if (Request.QueryString["Employeeid"] != "0" & Request.QueryString["Employeeid"] != null) { this.ViewState["Employeeid"] = Request.QueryString["Employeeid"]; ArrayList AlistEmailID = new ArrayList(); DataSet dsEmail = new DataSet(); BAL_Employee = new Employee_BLogic(); try { dsEmail = BAL_Employee.SelectEmployeeDetailByEmployeeID(Convert.ToInt64(this.ViewState["Employeeid"])); if (dsEmail != null & dsEmail.Tables.Count > 0) { if (dsEmail.Tables[0].Rows.Count > 0) { //EmployeeID, Code, RoleID, SchoolID, FirstName, MiddleName, LastName, Gender, DateOfBirth, BloodGroup, Address, EmailID, ContactNo, Qualification, // Designation, SecurityQuestion, SecurityAnswer, LoginID, Password, Image, LastLoginDate, AttemptCount, IsActive, CreatedOn, CreatedBy, ModifiedOn, // ModifiedBy, AllowMultipleSession ddlRole.SelectedValue = Convert.ToString(dsEmail.Tables[0].Rows[0]["RoleID"]); txtAddFirstName.Text = Convert.ToString(dsEmail.Tables[0].Rows[0]["FirstName"]); txtAddMiddleName.Text = Convert.ToString(dsEmail.Tables[0].Rows[0]["MiddleName"]); txtAddLastName.Text = Convert.ToString(dsEmail.Tables[0].Rows[0]["LastName"]); rlstAddGender.SelectedValue = Convert.ToString(dsEmail.Tables[0].Rows[0]["Gender"]); DateTime dt; if (DateTime.TryParse(Convert.ToString(dsEmail.Tables[0].Rows[0]["DateOfBirth"]), out dt)) { txtAddDOB.Text = dt.ToString(IFormat); } txtAddBloodGroup.Text = Convert.ToString(dsEmail.Tables[0].Rows[0]["BloodGroup"]); txtAddPermanentAddress.Text = Convert.ToString(dsEmail.Tables[0].Rows[0]["Address"]); txtAddEmail.Text = Convert.ToString(dsEmail.Tables[0].Rows[0]["EmailID"]); txtAddContactNumber.Text = Convert.ToString(dsEmail.Tables[0].Rows[0]["ContactNo"]); txtAddQualification.Text = Convert.ToString(dsEmail.Tables[0].Rows[0]["Qualification"]); txtAddDesignation.Text = Convert.ToString(dsEmail.Tables[0].Rows[0]["Designation"]); tLoginId.Text = Convert.ToString(dsEmail.Tables[0].Rows[0]["LoginID"]); hdnLoginid.Value = Convert.ToString(dsEmail.Tables[0].Rows[0]["LoginID"]); lblAddTitle.Text = "Update User: " + txtAddFirstName.Text; } } } catch (Exception ex) { WebMsg.Show(ex.Message); } } } }
public string GetStudentInformation(int studentID, string ValueField) { SYS_Role_BLogic obj_BAL_SYS_Role = new SYS_Role_BLogic(); DataSet dtLogin = new DataSet(); DataTable LoginInfo = new DataTable(); dtLogin = obj_BAL_SYS_Role.BAL_SYS_Student_Information(2); LoginInfo = dtLogin.Tables[0]; string returnValue = ""; if (LoginInfo.Rows.Count > 0 && LoginInfo != null) { if (ValueField == "StudentID") { returnValue = LoginInfo.Rows[0]["StudentID"].ToString(); } else if (ValueField == "StudentName") { returnValue = LoginInfo.Rows[0]["FirstName"].ToString(); } else if (ValueField == "BMSID") { returnValue = LoginInfo.Rows[0]["BMSID"].ToString(); } else if (ValueField == "BMS") { returnValue = LoginInfo.Rows[0]["BMS"].ToString(); } else if (ValueField == "BoardID") { returnValue = LoginInfo.Rows[0]["BoardID"].ToString(); } else if (ValueField == "Board") { returnValue = LoginInfo.Rows[0]["Board"].ToString(); } else if (ValueField == "MediumID") { returnValue = LoginInfo.Rows[0]["MediumID"].ToString(); } else if (ValueField == "Medium") { returnValue = LoginInfo.Rows[0]["Medium"].ToString(); } else if (ValueField == "StandardID") { returnValue = LoginInfo.Rows[0]["StandardID"].ToString(); } else if (ValueField == "Standard") { returnValue = LoginInfo.Rows[0]["Standard"].ToString(); } else if (ValueField == "DivisionID") { returnValue = LoginInfo.Rows[0]["DivisionID"].ToString(); } else if (ValueField == "SchoolID") { returnValue = LoginInfo.Rows[0]["SchoolID"].ToString(); } else if (ValueField == "Role") { returnValue = LoginInfo.Rows[0]["Role"].ToString(); } else if (ValueField == "RoleID") { returnValue = LoginInfo.Rows[0]["RoleID"].ToString(); } else { } } return(returnValue); }
protected void btnUpdate_Click(object sender, EventArgs e) { try { if (AppSessions.RoleID == 4)//student { DataSet dtLogin = new DataSet(); DataTable LoginInfo = new DataTable(); DataTable UserInfo = new DataTable(); SYS_Role obj_SYS_Role = new SYS_Role(); SYS_Role_BLogic obj_BAL_SYS_Role = new SYS_Role_BLogic(); obj_SYS_Role.Username = AppSessions.LoginID; // obj_SYS_Role.Password = TxtOldPassword.Text; if (!string.IsNullOrEmpty(TxtOldPassword.Text)) { dtLogin = obj_BAL_SYS_Role.BAL_SYS_Student_Login(obj_SYS_Role); LoginInfo = dtLogin.Tables[0]; if (LoginInfo.Rows.Count > 0 && LoginInfo != null) { oStudent.password = TxtNewPassword.Text; } else { WebMsg.Show("Please enter valid old password."); } } } else if (AppSessions.RoleID == 3 || AppSessions.RoleID == 2 || AppSessions.RoleID == 1) //3-teacher,2-sadmin,1-epath-admin { Employee_BLogic BEmployee = new Employee_BLogic(); Employee PEmployee = new Employee(); PEmployee.roleid = AppSessions.RoleID; PEmployee.userid = Convert.ToString(AppSessions.EmpolyeeID); PEmployee.Studentlist = ""; PEmployee.password = TxtNewPassword.Text; PEmployee.modifiedby = AppSessions.EmpolyeeID; BEmployee.BAL_Employee_Password_Update(PEmployee); } oStudent = new Student(); BAL_Student = new Student_BLogic(); string IFormat = "dd-MMM-yyyy"; oStudent.studentid = AppSessions.StudentID; oStudent.firstname = txtAddFirstName.Text; // oStudent.middlename = txtAddMiddleName.Text; oStudent.lastname = txtAddLastName.Text; if (rlstAddGender.SelectedIndex == (int)EnumFile.AssignValue.Zero) { oStudent.gender = 'M'; } else if (rlstAddGender.SelectedIndex == (int)EnumFile.AssignValue.One) { oStudent.gender = 'F'; } if (!string.IsNullOrEmpty(txtAddDOB.Text)) { oStudent.dateofbirth = Convert.ToDateTime(DateTime.Parse(txtAddDOB.Text).ToString(IFormat)); } //else //{ // oStudent.dateofbirth = null; //} //oStudent.bloodgroup = ""; //txtAddBloodGroup.Text; if (!string.IsNullOrEmpty(txtAddPermanentAddress.Text)) { oStudent.Address = txtAddPermanentAddress.Text; } if (!string.IsNullOrEmpty(txtAddEmail.Text)) { oStudent.emailid = txtAddEmail.Text; } if (!string.IsNullOrEmpty(txtAddContactNumber.Text)) { oStudent.contactno = Convert.ToInt64(txtAddContactNumber.Text); } if (!string.IsNullOrEmpty(txtAddMobileNumber.Text)) { oStudent.mobileno = Convert.ToInt64(txtAddMobileNumber.Text); } bool Status = this.BAL_Student.BAL_Student_UpdateProfile(oStudent); if (Status) { ResetControl(); ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alert('Update profile sucessfully');", true); } else { ScriptManager.RegisterStartupScript(this, GetType(), "alertMessage", "alert('Update profile Failed');", true); } } catch (Exception ex) { throw ex; } finally { } }