public List <trip> getImmersionTripInfo() { List <trip> tripList = new List <trip>(); DataSet ds = new DataSet(); DataTable tripData = new DataTable(); StringBuilder sqlStr = new StringBuilder(); sqlStr.AppendLine("SELECT Trip.TripID, Trip.Country, Trip.StartDate, Trip.EndDate, Trip.ETripPrice, Trip.Duration, Trip.Description, Trip.MaxStudent, Trip.Image, Staff.StaffName FROM Trip"); sqlStr.AppendLine("INNER JOIN Staff"); sqlStr.AppendLine("ON Trip.StaffID = Staff.StaffID"); sqlStr.AppendLine("where GETDATE() <= Trip.EndDate AND TripType = 'Immersion Trip'"); SqlConnection myConn = new SqlConnection(DBConnect); SqlDataAdapter da = new SqlDataAdapter(sqlStr.ToString(), myConn); //da.SelectCommand.Parameters.AddWithValue("1", TripID); da.Fill(ds, "TableInfo"); int rec_cnt = ds.Tables["TableInfo"].Rows.Count; if (rec_cnt > 0) { foreach (DataRow row in ds.Tables["TableInfo"].Rows) { trip myTrip = new trip(); myTrip.TripID = Convert.ToString(row["TripID"]); myTrip.Country = row["Country"].ToString(); myTrip.StartDate = Convert.ToDateTime(row["StartDate"]); myTrip.EndDate = Convert.ToDateTime(row["EndDate"]); myTrip.ETripPrice = Convert.ToDouble(row["ETripPrice"]); myTrip.Duration = Convert.ToInt16(row["Duration"]); myTrip.Description = row["Description"].ToString(); myTrip.MaxStudent = Convert.ToInt16(row["MaxStudent"]); myTrip.Image = row["Image"].ToString(); myTrip.StaffName = row["StaffName"].ToString(); tripList.Add(myTrip); } } else { tripList = null; } return(tripList); }
public List <trip> getListTrip(string TripID) { SqlDataAdapter da; DataSet ds = new DataSet(); List <trip> tripList = new List <trip>(); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.AppendLine("Select * from Trip"); sqlCommand.AppendLine("where TripID = @paraTripID"); trip obj = new trip(); SqlConnection myConn = new SqlConnection(DBConnect); da = new SqlDataAdapter(sqlCommand.ToString(), myConn); da.SelectCommand.Parameters.AddWithValue("@paraTripID", TripID); da.Fill(ds, "tripTable"); int rec_cnt = ds.Tables["tripTable"].Rows.Count; if (rec_cnt > 0) { foreach (DataRow row in ds.Tables["TableInfo"].Rows) { trip myTrip = new trip(); myTrip.TripID = Convert.ToString(row["TripID"]); myTrip.Country = row["Country"].ToString(); myTrip.StartDate = Convert.ToDateTime(row["StartDate"]); myTrip.EndDate = Convert.ToDateTime(row["EndDate"]); myTrip.ETripPrice = Convert.ToDouble(row["ETripPrice"]); myTrip.Duration = Convert.ToInt16(row["Duration"]); myTrip.Description = row["Description"].ToString(); myTrip.MaxStudent = Convert.ToInt16(row["MaxStudent"]); myTrip.Image = row["Image"].ToString(); myTrip.StaffName = row["StaffName"].ToString(); tripList.Add(myTrip); } } else { tripList = null; } return(tripList); }
public trip getTrip(string TripID) { SqlDataAdapter da; DataSet ds = new DataSet(); StringBuilder sqlCommand = new StringBuilder(); sqlCommand.AppendLine("Select * from Trip"); sqlCommand.AppendLine("where TripID = @paraTripID"); trip obj = new trip(); SqlConnection myConn = new SqlConnection(DBConnect); da = new SqlDataAdapter(sqlCommand.ToString(), myConn); da.SelectCommand.Parameters.AddWithValue("@paraTripID", TripID); da.Fill(ds, "tripTable"); int rec_cnt = ds.Tables["tripTable"].Rows.Count; if (rec_cnt > 0) { DataRow row = ds.Tables["tripTable"].Rows[0]; obj.Country = row["Country"].ToString(); obj.Description = row["Description"].ToString(); obj.StartDate = Convert.ToDateTime(row["StartDate"]); obj.EndDate = Convert.ToDateTime(row["EndDate"]); obj.ETripPrice = Convert.ToInt16(row["ETripPrice"]); obj.Image = row["Image"].ToString(); } else { obj = null; } return(obj); }