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