public List <StudList> getTDbyTripID(string tripID)
{
List <StudList> tdList = new List <StudList>();
DataSet ds = new DataSet();
DataTable tdData = new DataTable();
StringBuilder sqlStr = new StringBuilder();
sqlStr.AppendLine("select* from RegisteredStudent");
sqlStr.AppendLine("INNER JOIN Student");
sqlStr.AppendLine("ON RegisteredStudent.StudentAdmin = Student.StudentAdmin");
sqlStr.AppendLine("where TripID = @paraCustId;");
SqlConnection myConn = new SqlConnection(DBConnect);
SqlDataAdapter da = new SqlDataAdapter(sqlStr.ToString(), myConn);
da.SelectCommand.Parameters.AddWithValue("paraCustId", tripID);
da.Fill(ds, "TableTD");
int rec_cnt = ds.Tables["TableTD"].Rows.Count;
if (rec_cnt > 0)
{
foreach (DataRow row in ds.Tables["TableTD"].Rows)
{
StudList myTD = new StudList();
myTD.studentAdmin = row["StudentAdmin"].ToString();
myTD.studentName = row["StudentName"].ToString();
myTD.gender = row["Gender"].ToString();
myTD.school = row["School"].ToString();
myTD.pemGroup = row["PEMGroup"].ToString();
myTD.nationality = row["Nationality"].ToString();
myTD.passportNo = row["PassportNO"].ToString();
myTD.passportE = Convert.ToDateTime(row["PassportExpiry"]);
myTD.DietConstraint = row["DietConstraint"].ToString();
myTD.MedicalHistory = row["MedicalHistory"].ToString();
myTD.FASscheme = row["FASscheme"].ToString();
myTD.Remarks = row["Remarks"].ToString();
myTD.TripStatus = row["TripStatus"].ToString();
tdList.Add(myTD);
}
}
else
{
tdList = null;
}
return(tdList);
}
public StudList getTDbyStudAdmin(string StudAdmin)
{
DataSet ds = new DataSet();
DataTable tdData = new DataTable();
StringBuilder sqlStr = new StringBuilder();
sqlStr.AppendLine("select RegisteredStudent.StudentAdmin, Student.StudentName,Student.Gender,Student.School,Student.PEMGroup,Student.Nationality,RegisteredStudent.PassportNO,RegisteredStudent.PassportExpiry,Student.DietConstraint,Student.MedicalHistory,RegisteredStudent.FASscheme,RegisteredStudent.Remarks from Student");
sqlStr.AppendLine("Inner Join RegisteredStudent");
sqlStr.AppendLine("on Student.StudentAdmin = RegisteredStudent.StudentAdmin");
sqlStr.AppendLine("AND RegisteredStudent.StudentAdmin = @paraCustId;");
SqlConnection myConn = new SqlConnection(DBConnect);
SqlDataAdapter da = new SqlDataAdapter(sqlStr.ToString(), myConn);
da.SelectCommand.Parameters.AddWithValue("paraCustId", StudAdmin);
da.Fill(ds, "TableTD");
int rec_cnt = ds.Tables["TableTD"].Rows.Count;
StudList myTD = new StudList();
if (rec_cnt > 0)
{
DataRow row = ds.Tables["TableTD"].Rows[0];
myTD.studentAdmin = row["StudentAdmin"].ToString();
myTD.studentName = row["StudentName"].ToString();
myTD.gender = row["Gender"].ToString();
myTD.school = row["School"].ToString();
myTD.pemGroup = row["PEMGroup"].ToString();
myTD.nationality = row["Nationality"].ToString();
myTD.passportNo = row["PassportNO"].ToString();
myTD.passportE = Convert.ToDateTime(row["PassportExpiry"]);
myTD.DietConstraint = row["DietConstraint"].ToString();
myTD.MedicalHistory = row["MedicalHistory"].ToString();
myTD.FASscheme = row["FASscheme"].ToString();
myTD.Remarks = row["Remarks"].ToString();
}
else
{
myTD = null;
}
return(myTD);
}
public StudList getRegbyStudAdmin(string Email)
{
DataSet ds = new DataSet();
DataTable tdData = new DataTable();
StringBuilder sqlStr = new StringBuilder();
sqlStr.AppendLine("select * from Student");
sqlStr.AppendLine("Where Email = @paraCustId;");
SqlConnection myConn = new SqlConnection(DBConnect);
SqlDataAdapter da = new SqlDataAdapter(sqlStr.ToString(), myConn);
da.SelectCommand.Parameters.AddWithValue("paraCustId", Email);
da.Fill(ds, "TableTD");
int rec_cnt = ds.Tables["TableTD"].Rows.Count;
StudList myTD = new StudList();
if (rec_cnt > 0)
{
DataRow row = ds.Tables["TableTD"].Rows[0];
myTD.studentAdmin = row["StudentAdmin"].ToString();
myTD.studentPassword = row["StudentPassword"].ToString();
myTD.studentName = row["StudentName"].ToString();
myTD.gender = row["Gender"].ToString();
myTD.school = row["School"].ToString();
myTD.DOB = Convert.ToDateTime(row["DOB"].ToString());
myTD.pemGroup = row["PEMGroup"].ToString();
myTD.nationality = row["Nationality"].ToString();
myTD.MobileNO = row["MobileNO"].ToString();
myTD.DietConstraint = row["DietConstraint"].ToString();
myTD.MedicalHistory = row["MedicalHistory"].ToString();
}
else
{
myTD = null;
}
return(myTD);
}
public List <StudList> listStud(string tripid)
{
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
List <StudList> tdList = new List <StudList>();
DataSet ds = new DataSet();
DataTable tdData = new DataTable();
StringBuilder sqlStr = new StringBuilder();
sqlStr.AppendLine("select Student.StudentName from Student");
sqlStr.AppendLine("Inner Join RegisteredStudent");
sqlStr.AppendLine("on Student.StudentAdmin = RegisteredStudent.StudentAdmin");
sqlStr.AppendLine("where TripID = @paraTripID AND TripStatus = 'Accepted';");
SqlConnection myConn = new SqlConnection(DBConnect);
SqlDataAdapter da = new SqlDataAdapter(sqlStr.ToString(), myConn);
da.SelectCommand.Parameters.AddWithValue("paraTripID", tripid);
da.Fill(ds, "TableTD");
int rec_cnt = ds.Tables["TableTD"].Rows.Count;
if (rec_cnt > 0)
{
foreach (DataRow row in ds.Tables["TableTD"].Rows)
{
StudList myTD = new StudList();
myTD.studentAdmin = row["StudentAdmin"].ToString();
tdList.Add(myTD);
}
}
else
{
tdList = null;
}
return(tdList);
}