public List <History> getTopHistorys()
{
List <History> listResult = new List <History>();
try
{
sql = "Select a.CameraID, a.DateCaptured,a.FrameCaptured,b.PeopleID,b.FirstName,b.LastName,b.Position from History a left join Peoples b on a.PeopleID = b.ID";
dt = SqlDataHelper.GetDataToStringSQL(sql, con);
if (dt.Rows.Count > 0)
{
foreach (DataRow Row in dt.Rows)
{
History obj = new History();
obj.PeopleID = int.Parse(Row["PeopleID"].ToString());
obj.CameraID = int.Parse(Row["CameraID"].ToString());
obj.DateCaptured = DateTime.Parse(Row["DateCaptured"].ToString());
obj.FirstName = Row["FirstName"].ToString();
obj.LastName = Row["LastName"].ToString();
obj.Position = Row["Position"].ToString();
obj.FrameCaptured = Row["FrameCaptured"].ToString();
// obj.isDeleted = bool.Parse(Row["isDeleted"].ToString());
listResult.Add(obj);
Console.WriteLine(obj.PeopleID);
}
}
}
catch { }
return(listResult);
}
public List <Camera> getAllCamera()
{
List <Camera> listResult = new List <Camera>();
try
{
sql = "Select * from Cameras;";
dt = SqlDataHelper.GetDataToStringSQL(sql, con);
if (dt.Rows.Count > 0)
{
foreach (DataRow Row in dt.Rows)
{
Camera obj = new Camera();
obj.ID = int.Parse(Row["ID"].ToString());
obj.CamName = Row["CamName"].ToString();
obj.Comment = Row["Comment"].ToString();
obj.UserAdded = int.Parse(Row["UserAdded"].ToString());
obj.UserModded = int.Parse(Row["UserModded"].ToString());
obj.DateAdded = DateTime.Parse(Row["DateAdded"].ToString());
obj.DateModded = DateTime.Parse(Row["DateModified"].ToString());
obj.CamAddress = Row["CamAddress"].ToString();
obj.isDeleted = bool.Parse(Row["isDeleted"].ToString());
listResult.Add(obj);
Console.WriteLine(obj.CamName);
}
}
}
catch { }
return(listResult);
}
public List <People> getAllPeoples()
{
List <People> listResult = new List <People>();
try
{
sql = "Select * from Peoples;";
dt = SqlDataHelper.GetDataToStringSQL(sql, con);
if (dt.Rows.Count > 0)
{
foreach (DataRow Row in dt.Rows)
{
People obj = new People();
obj.ID = int.Parse(Row["ID"].ToString());
obj.PeopleID = Row["PeopleID"].ToString();
obj.FirstName = Row["FirstName"].ToString();
obj.LastName = Row["LastName"].ToString();
obj.Position = Row["Position"].ToString();
obj.Sex = bool.Parse(Row["Sex"].ToString());
obj.Phone = Row["Phone"].ToString();
obj.Address = Row["Address"].ToString();
obj.Comment = Row["Comment"].ToString();
obj.BirthDay = DateTime.Parse(Row["BirthDay"].ToString());
obj.DateAdded = DateTime.Parse(Row["DateAdded"].ToString());
obj.isDeleted = bool.Parse(Row["isDeleted"].ToString());
listResult.Add(obj);
}
}
}
catch { }
return(listResult);
}
public People getPeopleByID(int _id)
{
People obj = new People();
//sql = "Select * from Peoples a left join TrainedFace b on a.PeopleID = b.PeopleID where b.ID=" + _id;
sql = "Select a.ID,a.FirstName,a.LastName,a.Position,a.Phone,a.Address,a.BirthDay,a.PeopleID,a.Sex from Peoples a left join TrainedFace b on a.ID = b.PeopleID where b.ID =" + _id;
dt = SqlDataHelper.GetDataToStringSQL(sql, con);
if (dt.Rows.Count == 1)
{
obj.ID = int.Parse(dt.Rows[0]["ID"].ToString());
obj.PeopleID = dt.Rows[0]["PeopleID"].ToString();
obj.FirstName = dt.Rows[0]["FirstName"].ToString();
obj.LastName = dt.Rows[0]["LastName"].ToString();
if (dt.Rows[0]["Sex"].ToString() == "1")
{
obj.Sex = true;
}
else
{
obj.Sex = false;
}
obj.Phone = dt.Rows[0]["Phone"].ToString();
obj.Position = dt.Rows[0]["Position"].ToString();
obj.Address = dt.Rows[0]["Address"].ToString();
obj.BirthDay = DateTime.Parse(dt.Rows[0]["BirthDay"].ToString());
}
return(obj);
}
public List <Face> getAllUnKnowFace()
{
List <Face> listResult = new List <Face>();
try
{
sql = "Select * from TrainedFace where PeopleID='';";
dt = SqlDataHelper.GetDataToStringSQL(sql, con);
if (dt.Rows.Count > 0)
{
foreach (DataRow Row in dt.Rows)
{
Face obj = new Face();
obj.ID = int.Parse(Row["ID"].ToString());
obj.PeopleID = int.Parse(Row["PeopleID"].ToString());
obj.CameraID = int.Parse(Row["CameraID"].ToString());
//obj.FaceCaptured = int.Parse(Row["FaceCaptured"].ToString());
obj.DateCaptured = DateTime.Parse(Row["DateCaptured"].ToString());
obj.Comment = Row["Comment"].ToString();
obj.FaceTrainedPath = Row["FaceTrainedPath"].ToString();
obj.isDeleted = bool.Parse(Row["isDeleted"].ToString());
listResult.Add(obj);
}
}
}
catch { }
return(listResult);
}
public History getLatestHistorybyPeopleID(int _id)
{
History obj = new History();
//sql = "Select top(1) * from CapturedHistory where PeopleID="+ _id +" order by _dectionID desc;";
sql = "Select top(1) * from History where PeopleID=" + _id + " order by ID desc";
dt = SqlDataHelper.GetDataToStringSQL(sql, con);
if (dt.Rows.Count == 1)
{
obj.ID = int.Parse(dt.Rows[0]["ID"].ToString());
obj.PeopleID = int.Parse(dt.Rows[0]["PeopleID"].ToString());
// obj.FirstName = dt.Rows[0]["FirstName"].ToString();
//obj.LastName = dt.Rows[0]["LastName"].ToString();
obj.DateCaptured = DateTime.Parse(dt.Rows[0]["DateCaptured"].ToString());
Console.WriteLine(obj.DateCaptured.ToString() + "ID: " + _id);
}
return(obj);
}