public void AddMonitorPerson(MonitorPersonInfo info)
{
string endDate = string.Empty;
if (info.EndDate.HasValue)
{
endDate = "'" + info.EndDate.ToString() + "'";
}
else
{
endDate = "null";
}
string sql = "insert into Rent_Person_Monitor values ('" + Guid.NewGuid().ToString() + "','" + info.Name + "','" + info.IDCard
+ "','" + info.Phone + "','" + info.CreatedOn.ToString() + "','" + info.StartDate.ToString() + "'," + endDate + ",'" + info.CreatedBy + "','" + info.PersonType + "','" + info.Status + "')";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
public void UpdateMonitorPerson(MonitorPersonInfo info)
{
string endDate = string.Empty;
if (info.EndDate.HasValue)
{
endDate = "'" + info.EndDate.ToString() + "'";
}
else
{
endDate = "null";
}
string sql = "update Rent_Person_Monitor set Name='" + info.Name + "',IDCard='" + info.IDCard
+ "',Phone='" + info.Phone + "',StartDate='" + info.StartDate.ToString() + "',EndDate=" + endDate + ",PersonType='" + info.PersonType + "',Status='" + info.Status + "' where ID='" + info.ID + "'";
MySQLHelper.ExecuteNonQuery(MySQLHelper.SqlConnString, MySQLHelper.CreateCommand(sql));
}
