private void FillDataGrid()
{
dataGridView1.Rows.Clear();
List <Elements> CarData = new List <Elements>();
CarData = SO.GetCarData();
foreach (var elment in CarData)
{
TagElments TimeOfCar = SO.GetCarTime(elment.CarID);
dataGridView1.Rows.Add(elment.CarOwner, elment.CarNumber, TimeOfCar.TimeIn, TimeOfCar.TimeOut, elment.CarID);
}
}
public TagElments GetCarTime(string CarNumber)
{
TagElments LastTime = new TagElments();
String TagNum = GetTagNumber(CarNumber);
string Query = @"select * from CarMovement where TagNumber=";
Query += "'" + TagNum + "'";
SqlConnection con = new SqlConnection(ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand(Query, con);
SqlDataReader rdr = cmd.ExecuteReader();
List <String> myTagData = new List <String>();
while (rdr.Read())
{
String temp;
temp = rdr["TimeStatus"].ToString();
myTagData.Add(temp);
}
if (myTagData.Count > 0)
{
if (myTagData.Count == 1)
{
LastTime.TimeIn = myTagData[0];
LastTime.TimeOut = "";
}
else
{
LastTime.TimeIn = myTagData[0];
LastTime.TimeOut = myTagData[myTagData.Count - 1];
}
}
con.Close();
return(LastTime);
}