protected void Page_Load(object sender, EventArgs e) { Label1.Text = "<h1>Check Your Particulars</h1>"; StudList tdList = new StudList(); StudListDAO tdDAO = new StudListDAO(); if (Session["username"] == null) { Response.Redirect("LoginStudent.aspx"); } else { if (!IsPostBack) { tdList = tdDAO.getRegbyStudAdmin(Session["username"].ToString()); Label14.Text = tdList.studentAdmin.ToString(); Label2.Text = tdList.studentName.ToString(); Label3.Text = tdList.gender.ToString(); Label4.Text = tdList.DOB.ToString("dd/MM/yyyy"); LblDiploma.Text = tdList.school.ToString(); Label5.Text = tdList.pemGroup.ToString(); tdCountry.Text = tdList.nationality.ToString(); tdMobileNo.Text = tdList.MobileNO.ToString(); tdDiet.Text = tdList.DietConstraint.ToString(); tdMedical.Text = tdList.MedicalHistory.ToString(); } } }
protected void Button1_Click(object sender, EventArgs e) { StudList tdList = new StudList(); StudListDAO tdDAO = new StudListDAO(); tdList = tdDAO.getRegbyStudAdmin(Session["username"].ToString()); string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; StringBuilder sqlStr = new StringBuilder(); int result = 0; SqlCommand sqlCmd = new SqlCommand(); sqlStr.AppendLine("UPDATE Student set Nationality = @paraNationality, MobileNO = @paraMobileNO, DietConstraint = @paraDietConstraint, MedicalHistory = @paraMedicalHistory "); sqlStr.AppendLine("WHERE Email = @paraEmail"); SqlConnection myConn = new SqlConnection(DBConnect); sqlCmd = new SqlCommand(sqlStr.ToString(), myConn); sqlCmd.Parameters.AddWithValue("@paraNationality", DdlCountry.SelectedValue.ToString()); sqlCmd.Parameters.AddWithValue("@paraMobileNO", tbMobileNo.Text); sqlCmd.Parameters.AddWithValue("@paraDietConstraint", tbDiet.Text); sqlCmd.Parameters.AddWithValue("@paraMedicalHistory", tbMedical.Text); sqlCmd.Parameters.AddWithValue("@paraEmail", Session["username"].ToString()); myConn.Open(); result = sqlCmd.ExecuteNonQuery(); myConn.Close(); lblResult.Text = "Particulars Updated"; if (Session["page"] != null) { Response.Redirect(Session["page"].ToString()); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null) { //Session["new"] = "Statistics"; Response.Redirect("LoginStudent.aspx"); } if (!IsPostBack) { GetStudentChartInfo(); } StudList studList = new StudList(); StudListDAO studDAO = new StudListDAO(); studList = studDAO.getRegbyStudAdmin(Session["Username"].ToString()); string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; using (SqlConnection myConn = new SqlConnection(DBConnect)) { myConn.Open(); SqlCommand cmd = new SqlCommand("SELECT count(StudentAdmin) FROM Feedback WHERE StudentAdmin = @paraStudAdmin", myConn); cmd.Parameters.AddWithValue("@paraStudAdmin", studList.studentAdmin.ToString()); int UserExist = (int)cmd.ExecuteScalar(); if (UserExist < 1) { Label1.Text = "<h3>You currently have a feedback form that is uncompleted! Complete it <a href='Feedback.aspx'>here</a></h3>"; } else { Label1.Visible = false; } myConn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["studInfo"] != null) { StudList tdList = new StudList(); StudListDAO tdDAO = new StudListDAO(); ProgCode.Text = "<h1>" + Session["Code"].ToString() + "</h1>"; tdList = tdDAO.getTDbyStudAdmin(Session["studInfo"].ToString()); LblAdmin.Text = tdList.studentAdmin.ToString(); LblStudname.Text = tdList.studentName.ToString(); LblGender.Text = tdList.gender.ToString(); LblSchool.Text = tdList.school.ToString(); LblPEMGroup.Text = tdList.pemGroup.ToString(); LblNationality.Text = tdList.nationality.ToString(); Label3.Text = tdList.passportNo.ToString(); Label4.Text = tdList.passportE.ToString("dd/MM/yyyy"); Label5.Text = tdList.DietConstraint.ToString(); Label6.Text = tdList.MedicalHistory.ToString(); Label7.Text = tdList.FASscheme.ToString(); Remarks.Text = tdList.Remarks.ToString(); } else { Response.Redirect("ListofStud.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Page.IsPostBack == false) { if (Session["SSTripID"] != null) { string tripID = Session["SSTripID"].ToString(); trip tripOjb = new trip(); tripDAO tripDAO = new tripDAO(); //tripOjb = tripDAO.getTripById(1); tripOjb = tripDAO.getTrip(tripID); imgTripDetails.ImageUrl = tripOjb.Image; lblCn.Text = tripOjb.Country; lblDesc.Text = tripOjb.Description; lblSD.Text = tripOjb.StartDate.ToShortDateString(); lblED.Text = tripOjb.EndDate.ToShortDateString(); lblPrc.Text = tripOjb.ETripPrice.ToString(); } else { Response.Redirect("TripStudentView.aspx"); } string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; StudList studList = new StudList(); DataSet ds = new DataSet(); DataTable tripData = new DataTable(); StudListDAO StudDao = new StudListDAO(); studList = StudDao.getRegbyStudAdmin(Session["Username"].ToString()); StringBuilder sqlStr = new StringBuilder(); sqlStr.AppendLine("SELECT * FROM RegisteredStudent"); sqlStr.AppendLine("INNER JOIN Trip"); sqlStr.AppendLine("ON RegisteredStudent.TripID = Trip.TripID"); sqlStr.AppendLine("where RegisteredStudent.TripID = @paraTripID AND RegisteredStudent.StudentAdmin = @paraStudentAdmin"); SqlConnection myConn = new SqlConnection(DBConnect); SqlDataAdapter da = new SqlDataAdapter(sqlStr.ToString(), myConn); da.SelectCommand.Parameters.AddWithValue("@paraTripID", Request.QueryString["id"].ToString()); da.SelectCommand.Parameters.AddWithValue("@paraStudentAdmin", studList.studentAdmin); da.Fill(ds, "studList"); int rec_cnt = ds.Tables["studList"].Rows.Count; if (rec_cnt > 0) { btnRegister.CssClass = "btn btn-primary disabled float-right"; btnRegister.Enabled = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null) { Response.Redirect("LoginStudent.aspx"); } else { StudList tdList = new StudList(); StudListDAO tdDAO = new StudListDAO(); tdList = tdDAO.getRegbyStudAdmin(Session["username"].ToString()); tbAdminNo.Text = tdList.studentAdmin.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null) { Response.Redirect("LoginStudent.aspx"); } else { StudList tdList = new StudList(); StudListDAO tdDAO = new StudListDAO(); tdList = tdDAO.getRegbyStudAdmin(Session["username"].ToString()); tdName.Text = tdList.studentName.ToString(); Label1.Text = tdList.studentAdmin.ToString(); Label2.Text = tdList.pemGroup.ToString(); Label3.Text = tdList.nationality.ToString(); Label4.Text = tdList.MobileNO.ToString(); Label5.Text = tdList.DietConstraint.ToString(); Label6.Text = tdList.MedicalHistory.ToString(); string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; SqlConnection myConn = new SqlConnection(DBConnect); SqlDataAdapter da; DataSet ds = new DataSet(); //Create Adapter StringBuilder sqlCommand = new StringBuilder(); sqlCommand.AppendLine("Select * from ProfilePic where StudentAdmin = @paraStudentAdmin "); da = new SqlDataAdapter(sqlCommand.ToString(), myConn); da.SelectCommand.Parameters.AddWithValue("paraStudentAdmin", tdList.studentAdmin.ToString()); // fill dataset da.Fill(ds, "stud_table"); int rec_cnt = ds.Tables["stud_table"].Rows.Count; if (rec_cnt > 0) { DataRow row = ds.Tables["stud_table"].Rows[0]; tdList.studentImage = row["Image"].ToString(); idProfile.ImageUrl = tdList.studentImage; } else { idProfile.ImageUrl = "~/ProfilePic/download1.jpg"; } } }
protected void Page_Load(object sender, EventArgs e) { string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; if (Session["username"] == null) { Response.Redirect("LoginStudent.aspx"); } if (!IsPostBack) { StudentStatusDAO tdDAO = new StudentStatusDAO(); List <StudentStatus> tdList = new List <StudentStatus>(); DataSet ds = new DataSet(); DataTable tdData = new DataTable(); StringBuilder sqlStr = new StringBuilder(); sqlStr.AppendLine("select * from Student"); sqlStr.AppendLine("Where Email = @paraEmail;"); SqlConnection myConn = new SqlConnection(DBConnect); SqlDataAdapter da = new SqlDataAdapter(sqlStr.ToString(), myConn); da.SelectCommand.Parameters.AddWithValue("paraEmail", Session["username"].ToString()); da.Fill(ds, "TableTD"); int rec_cnt = ds.Tables["TableTD"].Rows.Count; StudList myTD = new StudList(); string studentid = ""; if (rec_cnt > 0) { DataRow row = ds.Tables["TableTD"].Rows[0]; studentid = row["StudentAdmin"].ToString(); } else { myTD = null; } tdList = tdDAO.getStudentStatus(studentid, DateTime.Now); GVStatus.DataSource = tdList; GVStatus.DataBind(); GVStatus.Columns[0].ItemStyle.HorizontalAlign = HorizontalAlign.Center; GVStatus.Columns[0].ItemStyle.VerticalAlign = VerticalAlign.Middle; } }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null) { Session["new"] = "Feedback"; Response.Redirect("LoginStudent.aspx"); } StudList studList = new StudList(); StudListDAO studDAO = new StudListDAO(); StudentReg studReg = new StudentReg(); StudRegDAO regDAO = new StudRegDAO(); studList = studDAO.getRegbyStudAdmin(Session["Username"].ToString()); Lblno.Text = studList.studentAdmin.ToString(); studReg = regDAO.getTripID(Lblno.Text); Lblcode.Text = studReg.TripID.ToString(); }
protected void Button1_Click(object sender, EventArgs e) { StudList tdList = new StudList(); StudListDAO tdDAO = new StudListDAO(); tdList = tdDAO.getRegbyStudAdmin(Session["username"].ToString()); if (Encryption.MD5Hash(tbPassword.Text) != tdList.studentPassword.ToString()) { errorMsg.Text = "Your current password is incorrect"; } else if (TextBox1.Text != TextBox2.Text) { errorMsg.Text = "You new password is different than the confirm password"; } else if (TextBox1.Text == "") { errorMsg.Text = "Password field is empty!"; } else { string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; StringBuilder sqlStr = new StringBuilder(); int result = 0; SqlCommand sqlCmd = new SqlCommand(); sqlStr.AppendLine("UPDATE Student set StudentPassword = @paraPassword "); sqlStr.AppendLine("WHERE Email = @paraEmail"); SqlConnection myConn = new SqlConnection(DBConnect); sqlCmd = new SqlCommand(sqlStr.ToString(), myConn); sqlCmd.Parameters.AddWithValue("@paraPassword", Encryption.MD5Hash(TextBox1.Text)); sqlCmd.Parameters.AddWithValue("@paraEmail", Session["username"].ToString()); myConn.Open(); result = sqlCmd.ExecuteNonQuery(); myConn.Close(); errorMsg.Text = "Password change"; Response.AddHeader("Refresh", "5;URL=Account.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null) { Session["new"] = "Survey"; Response.Redirect("LoginStudent.aspx"); } StudList studList = new StudList(); StudListDAO studDAO = new StudListDAO(); SurveyQ tdList = new SurveyQ(); SurveyQDAO tdDAO = new SurveyQDAO(); studList = studDAO.getRegbyStudAdmin(Session["Username"].ToString()); LblNo.Text = studList.studentAdmin.ToString(); tdList = tdDAO.getSurveyQuestions(); if (tdList == null) { tbQ1.Visible = false; tbQ2.Visible = false; tbQ3.Visible = false; tbQ4.Visible = false; LblQ2.Visible = false; LblQ3.Visible = false; LblQ4.Visible = false; submitBtn.Visible = false; resetBtn.Visible = false; LblQ1.Text = "<h1>No survey has been loaded for the moment. Please check back again later!</h1>"; } else { LblQ1.Text = tdList.q1.ToString(); LblQ2.Text = tdList.q2.ToString(); LblQ3.Text = tdList.q3.ToString(); LblQ4.Text = tdList.q4.ToString(); } }
protected void btnCrop_Click(object sender, EventArgs e) { string fileName = Path.GetFileName(imgUpload.ImageUrl); string filePath = Path.Combine(Server.MapPath("~/ProfilePic"), fileName); string cropFileName = ""; string cropFilePath = ""; if (File.Exists(filePath)) { System.Drawing.Image orgImg = System.Drawing.Image.FromFile(filePath); Rectangle CropArea = new Rectangle( Convert.ToInt32(X.Value), Convert.ToInt32(Y.Value), Convert.ToInt32(W.Value), Convert.ToInt32(H.Value)); try { Bitmap bitMap = new Bitmap(CropArea.Width, CropArea.Height); using (Graphics g = Graphics.FromImage(bitMap)) { g.DrawImage(orgImg, new Rectangle(0, 0, bitMap.Width, bitMap.Height), CropArea, GraphicsUnit.Pixel); } cropFileName = "crop_" + fileName; cropFilePath = Path.Combine(Server.MapPath("~/ProfilePic"), cropFileName); bitMap.Save(cropFilePath); //if (System.IO.File.Exists(delFilePath)) //{ // System.IO.File.Delete(delFilePath); //} StudList tdList = new StudList(); StudListDAO tdDAO = new StudListDAO(); tdList = tdDAO.getRegbyStudAdmin(Session["username"].ToString()); SqlConnection myConn = new SqlConnection(DBConnect); StringBuilder sqlCommand = new StringBuilder(); SqlDataAdapter da; DataSet ds = new DataSet(); sqlCommand.AppendLine("Select * from ProfilePic where StudentAdmin = @paraStudAdmin"); da = new SqlDataAdapter(sqlCommand.ToString(), myConn); da.SelectCommand.Parameters.AddWithValue("@paraStudAdmin", tdList.studentAdmin.ToString()); da.Fill(ds, "stud_table"); int rec_cnt = ds.Tables["stud_table"].Rows.Count; if (rec_cnt > 0) { StringBuilder sqlImg = new StringBuilder(); int resultImg = 0; SqlCommand sqlCmdImg = new SqlCommand(); sqlImg.AppendLine("UPDATE ProfilePic set Image = @paraImage "); sqlImg.AppendLine("WHERE StudentAdmin = @paraStudentAdmin"); sqlCmdImg = new SqlCommand(sqlImg.ToString(), myConn); string Imagepath = "crop_" + fileName.ToString(); string Image = "~/ProfilePic/" + Imagepath; sqlCmdImg.Parameters.AddWithValue("@paraImage", Image); sqlCmdImg.Parameters.AddWithValue("@paraStudentAdmin", tdList.studentAdmin.ToString()); myConn.Open(); resultImg = sqlCmdImg.ExecuteNonQuery(); myConn.Close(); Response.Redirect("Account.aspx"); } else { StringBuilder sqlStr = new StringBuilder(); int result = 0; SqlCommand sqlCmd = new SqlCommand(); sqlStr.AppendLine("INSERT INTO ProfilePic (StudentAdmin, Image)"); sqlStr.AppendLine("VALUES (@paraStudAdmin,@paraImage)"); sqlCmd = new SqlCommand(sqlStr.ToString(), myConn); string Imagepath = "crop_" + fileName.ToString(); string Image = "~/ProfilePic/" + Imagepath; sqlCmd.Parameters.AddWithValue("@paraStudAdmin", tdList.studentAdmin.ToString()); sqlCmd.Parameters.AddWithValue("@paraImage", Image); myConn.Open(); result = sqlCmd.ExecuteNonQuery(); myConn.Close(); Response.Redirect("Account.aspx"); } } catch (Exception ex) { throw; } } }
protected void GVStatus_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "Cancel Trip") { int rowIndex = Convert.ToInt32(e.CommandArgument); GridViewRow row = GVStatus.Rows[rowIndex]; string country = row.Cells[1].Text; string btn = row.Cells[3].Text; string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; SqlConnection myConn = new SqlConnection(DBConnect); StudentStatusDAO tdDAO = new StudentStatusDAO(); DataSet ds1 = new DataSet(); StringBuilder sqlStr1 = new StringBuilder(); sqlStr1.AppendLine("select * from Student"); sqlStr1.AppendLine("Where Email = @paraEmail;"); SqlDataAdapter da1 = new SqlDataAdapter(sqlStr1.ToString(), myConn); da1.SelectCommand.Parameters.AddWithValue("paraEmail", Session["username"].ToString()); da1.Fill(ds1, "TableTD"); int rec_cnt1 = ds1.Tables["TableTD"].Rows.Count; StudList myTD1 = new StudList(); string studentid = ""; if (rec_cnt1 > 0) { DataRow row2 = ds1.Tables["TableTD"].Rows[0]; studentid = row2["StudentAdmin"].ToString(); } else { myTD1 = null; } StudentStatusDAO tdDAO1 = new StudentStatusDAO(); StudentStatus tdList = new StudentStatus(); List <StudentStatus> tdList1 = new List <StudentStatus>(); tdList = tdDAO1.getStudentdate(studentid, DateTime.Now); DateTime date = tdList.StartDate; double days = (Convert.ToDateTime(date) - Convert.ToDateTime(DateTime.Now)).TotalDays; StringBuilder sqlStr = new StringBuilder(); int result = 0; SqlCommand sqlCmd = new SqlCommand(); sqlStr.AppendLine("UPDATE RegisteredStudent set TripStatus = @paraStatus "); sqlStr.AppendLine("WHERE StudentAdmin = @paraStudentAdmin And TripID = @paraTripID"); sqlCmd = new SqlCommand(sqlStr.ToString(), myConn); sqlCmd.Parameters.AddWithValue("@paraStatus", "Cancel"); sqlCmd.Parameters.AddWithValue("@paraStudentAdmin", studentid.ToString()); sqlCmd.Parameters.AddWithValue("@paraTripID", country.ToString()); myConn.Open(); result = sqlCmd.ExecuteNonQuery(); myConn.Close(); tdList1 = tdDAO1.getStudentStatus(studentid, DateTime.Now); GVStatus.DataSource = tdList1; GVStatus.DataBind(); } }
protected void Button1_Click(object sender, EventArgs e) { //Session["Code"] = "Korea2018"; StudentStatusDAO tdDAO1 = new StudentStatusDAO(); StudentStatus tdList = new StudentStatus(); tdList = tdDAO1.getdate(Request.QueryString["id"].ToString()); DateTime date = tdList.StartDate; double days = (Convert.ToDateTime(tbDate.Text.ToString()) - Convert.ToDateTime(date)).TotalDays; string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString; SqlConnection myConn = new SqlConnection(DBConnect); StudentStatusDAO tdDAO = new StudentStatusDAO(); DataSet ds1 = new DataSet(); StringBuilder sqlStr1 = new StringBuilder(); sqlStr1.AppendLine("select * from Student"); sqlStr1.AppendLine("Where Email = @paraEmail;"); SqlDataAdapter da1 = new SqlDataAdapter(sqlStr1.ToString(), myConn); da1.SelectCommand.Parameters.AddWithValue("paraEmail", Session["username"].ToString()); da1.Fill(ds1, "TableTD"); int rec_cnt1 = ds1.Tables["TableTD"].Rows.Count; StudList myTD1 = new StudList(); string studentid = ""; if (rec_cnt1 > 0) { DataRow row2 = ds1.Tables["TableTD"].Rows[0]; studentid = row2["StudentAdmin"].ToString(); } else { myTD1 = null; } string TripID = Request.QueryString["id"].ToString(); string passportNO = tbPassportNo.Text.ToString(); DateTime PassportExpiry = Convert.ToDateTime(tbDate.Text.ToString()); string FASscheme = DdlFAS.SelectedValue.ToString(); string WaitingList = DdlWait.SelectedValue.ToString(); double PSEABalance = Convert.ToDouble(TextBox1.Text.ToString()); //lblResult.Text = PassportExpiry.ToString(); StudRegDAO regStudent = new StudRegDAO(); StudReg tdlist = new StudReg(); if (days < 182.5) { //lblwarning.Text = "Please renew your passport"; string message = "Successfuly Registered! we will redirect you to home page soon. Please don't forget to renew your passport."; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("<script type = 'text/javascript'>"); sb.Append("window.onload=function(){"); sb.Append("alert('"); sb.Append(message); sb.Append("')};"); sb.Append("</script>"); ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", sb.ToString()); regStudent.InsertStudReg(studentid, TripID, passportNO, PassportExpiry, FASscheme, WaitingList, PSEABalance); Response.AddHeader("REFRESH", "1;URL=TripStudentView.aspx"); } else { string message = "Successfuly Registered! We will redirect you to home page soon."; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("<script type = 'text/javascript'>"); sb.Append("window.onload=function(){"); sb.Append("alert('"); sb.Append(message); sb.Append("')};"); sb.Append("</script>"); ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", sb.ToString()); regStudent.InsertStudReg(studentid, TripID, passportNO, PassportExpiry, FASscheme, WaitingList, PSEABalance); Response.AddHeader("REFRESH", "1;URL=TripStudentView.aspx"); } //lblResult.Text = "Successfuly Registered \n we will redirect you to home page soon"; //Response.AddHeader("REFRESH", "5;URL=TripStudentView.aspx"); }