public List <ParkingYard.Activities> GetActivities(int ParkID)
{
List <ParkingYard.Activities> ActivitiesList = new List <ParkingYard.Activities>();
ParkingYard.Activities activity;
using (var con = new SqlConnection(GC.ConnectionString))
{
con.Open();
Query = "select * from dbo.CarParkActivityHistory where Park_id='" + ParkID + "'";
using (var com = new SqlCommand(Query, con))
{
Reader = com.ExecuteReader();
while (Reader.Read())
{
activity = new ParkingYard.Activities();
activity.License = Reader["license"].ToString();
activity.Owner = Reader["Name"].ToString();
activity.IN = Convert.ToDateTime(Reader["Entered"].ToString());
activity.OUT = Convert.ToDateTime(Reader["Exited"].ToString());
ActivitiesList.Add(activity);
}
com.Dispose();
}
con.Close();
}
return(ActivitiesList);
}
public async Task <List <ParkingYard.Activities> > GetActivities(int ParkID)
{
HttpClient httpClient = new HttpClient();
List <ParkingYard.Activities> HistoryList = new List <ParkingYard.Activities>();
HttpResponseMessage response = await httpClient.GetAsync("http://localhost/dcss/api/parking/GetActivities/" + ParkID);
string responsemsg = await response.Content.ReadAsStringAsync();
JArray ActivityArray = JArray.Parse(responsemsg);
foreach (JObject Activity in ActivityArray)
{
ParkingYard.Activities activity = new ParkingYard.Activities();
activity.License = Activity["License"].ToString();
activity.Owner = Activity["Owner"].ToString();
activity.IN = Convert.ToDateTime(Activity["IN"].ToString());
activity.OUT = Convert.ToDateTime(Activity["OUT"].ToString());
HistoryList.Add(activity);
}
return(HistoryList);
}
