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); }