public int addTrainFace(Face _obj) { var datetimenow = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd HH:mm:ss"); int iResult = -1; try { if (con != null) { sql = "INSERT INTO TrainedFace(CameraID,PeopleID,FaceCaptured,FaceTrainedPath,DateCaptured,Comment,isDeleted) values("; sql += "" + _obj.CameraID + ""; sql += "," + _obj.PeopleID + ""; sql += ",'" + _obj.FaceCaptured + "'"; sql += ",'" + _obj.FaceTrainedPath + "'"; sql += ",'" + datetimenow + "'"; sql += ",'" + _obj.Comment + "'"; sql += ",'" + _obj.isDeleted.ToString() + "')"; iResult = SqlDataHelper.ExecuteNonQuery(sql, con); if (iResult == 1) { sql = "SELECT MAX(ID) FROM TrainedFace"; iResult = SqlDataHelper.GetMaxID(sql, con); iResult = int.Parse(_obj.ID.ToString()); } Console.WriteLine(sql); } } catch { } return(iResult); }
public int getMaxID() { int iResult = -1; sql = "SELECT MAX(ID) FROM History"; iResult = SqlDataHelper.GetMaxID(sql, con); return(iResult); }
public int getMinuteDiff(string _daytime, string _datetimenow) { sql = "select DATEDIFF(MINUTE,'" + _daytime + "','" + _datetimenow + "')"; Console.WriteLine(sql); int minute = SqlDataHelper.GetMaxID(sql, con); return(minute); }
public int addPeople(People _obj) { int iResult = -1; try { if (con != null) { string sql = "INSERT INTO Peoples(PeopleID,FirstName,LastName,Position,Sex,Phone,Address,Comment,BirthDay,DateAdded,isDeleted) values("; sql += "'" + _obj.PeopleID + "'"; sql += ",N'" + _obj.FirstName + "'"; sql += ",N'" + _obj.LastName + "'"; sql += ",N'" + _obj.Position + "'"; sql += ",'" + _obj.Sex + "'"; sql += ",'" + _obj.Phone + "'"; sql += ",N'" + _obj.Address + "'"; sql += ",N'" + _obj.Comment + "'"; if (_obj.BirthDay >= DateTime.Now) { sql += ",'" + _obj.BirthDay + "'"; } else { sql += ",''"; } if (_obj.DateAdded >= DateTime.Now) { sql += ",'" + _obj.DateAdded + "'"; } else { sql += ",''"; } sql += ",'" + _obj.isDeleted.ToString() + "')"; Console.WriteLine("Sql add employee: " + sql); iResult = SqlDataHelper.ExecuteNonQuery(sql, con); if (iResult == 1) { sql = "SELECT MAX(ID) FROM Peoples"; iResult = SqlDataHelper.GetMaxID(sql, con); iResult = int.Parse(_obj.ID.ToString()); } Console.WriteLine(sql); } } catch { } return(iResult); }
public int addHistory(History _obj) { var datetimenow = Convert.ToDateTime(DateTime.Now.ToString()).ToString("yyyy-MM-dd HH:mm:ss"); int iResult = -1; try { if (con != null) { string sql = "INSERT INTO History(CameraID,PeopleID,FaceCaptured,DateCaptured,TimeIn,TimeOut,FrameCaptured,isDeleted) values("; sql += "" + _obj.CameraID + ""; sql += "," + _obj.PeopleID + ""; sql += ",N'" + _obj.FaceCaptured + "'"; sql += ",'" + datetimenow + "'"; if (_obj.TimeIn >= DateTime.Now) { sql += ",'" + _obj.TimeIn + "'"; } else { sql += ",''"; } if (_obj.TimeOut >= DateTime.Now) { sql += ",'" + _obj.TimeOut + "'"; } else { sql += ",''"; } sql += ",'" + _obj.FrameCaptured + "'"; sql += ",'" + _obj.isDeleted.ToString() + "')"; iResult = SqlDataHelper.ExecuteNonQuery(sql, con); if (iResult == 1) { sql = "SELECT MAX(ID) FROM History"; iResult = SqlDataHelper.GetMaxID(sql, con); iResult = int.Parse(_obj.ID.ToString()); } Console.WriteLine(sql); } } catch { } return(iResult); }
public int addCamera(Camera _obj) { int iResult = -1; try { if (con != null) { string sql = "INSERT INTO Cameras(CamName,CamAddress,Comment,DateAdded,DateModified,UserAdded,UserModded,isDeleted) values("; sql += "N'" + _obj.CamName + "'"; sql += ",'" + _obj.CamAddress + "'"; sql += ",N'" + _obj.Comment + "'"; if (_obj.DateAdded >= DateTime.Now) { sql += ",'" + _obj.DateAdded + "'"; } else { sql += ",''"; } if (_obj.DateModded >= DateTime.Now) { sql += ",'" + _obj.DateModded + "'"; } else { sql += ",''"; } sql += ",'" + _obj.UserAdded + "'"; sql += ",'" + _obj.UserModded + "'"; sql += ",'" + _obj.isDeleted.ToString() + "')"; Console.WriteLine("Sql add employee: " + sql); iResult = SqlDataHelper.ExecuteNonQuery(sql, con); if (iResult == 1) { sql = "SELECT MAX(ID) FROM Cameras"; iResult = SqlDataHelper.GetMaxID(sql, con); iResult = int.Parse(_obj.ID.ToString()); } Console.WriteLine(sql); } } catch { } return(iResult); }