public StudentStatus getdate(string TripID)
{
StudentStatus myTD = new StudentStatus();
DataSet ds = new DataSet();
DataTable tdData = new DataTable();
StringBuilder sqlStr = new StringBuilder();
sqlStr.AppendLine("select StartDate from Trip");
sqlStr.AppendLine("where TripID = @paraTripID;");
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)
{
DataRow row = ds.Tables["TableTD"].Rows[0];
myTD.StartDate = Convert.ToDateTime(row["StartDate"]);
}
else
{
myTD = null;
}
return(myTD);
}
public List <StudentStatus> getStudentStatus(string studentadmin, DateTime CurrentDate)
{
List <StudentStatus> tdList = new List <StudentStatus>();
DataSet ds = new DataSet();
DataTable tdData = new DataTable();
StringBuilder sqlStr = new StringBuilder();
sqlStr.AppendLine("select Trip.TripID, Image,StartDate, TripStatus, StudentAdmin, Country from Trip");
sqlStr.AppendLine("inner join RegisteredStudent");
sqlStr.AppendLine("On RegisteredStudent.TripID = Trip.TripID");
sqlStr.AppendLine("where RegisteredStudent.StudentAdmin = @paraStudentAdmin AND StartDate > @paraCurrentDate;");
SqlConnection myConn = new SqlConnection(DBConnect);
SqlDataAdapter da = new SqlDataAdapter(sqlStr.ToString(), myConn);
da.SelectCommand.Parameters.AddWithValue("paraStudentAdmin", studentadmin);
da.SelectCommand.Parameters.AddWithValue("paraCurrentDate", CurrentDate);
da.Fill(ds, "TableTD");
int rec_cnt = ds.Tables["TableTD"].Rows.Count;
if (rec_cnt > 0)
{
foreach (DataRow row in ds.Tables["TableTD"].Rows)
{
StudentStatus myTD = new StudentStatus();
myTD.Image = row["Image"].ToString();
myTD.StartDate = Convert.ToDateTime(row["StartDate"]);
myTD.TripStatus = row["TripStatus"].ToString();
myTD.StudentAdmin = row["StudentAdmin"].ToString();
myTD.Country = row["TripID"].ToString();
tdList.Add(myTD);
}
}
else
{
tdList = null;
}
return(tdList);
}