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