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