public HttpResponseMessage UpdateRTLSDataDelete(Domins.ViewModels.FilterLocationData model)
{
var _rtlsDataAccordingtoSite = db.RtlsConfiguration.Where(m => m.SiteId == model.SiteId).FirstOrDefault();
_rtlsDataAccordingtoSite.TimeFrame = model.TimeFrame;
db.SaveChanges();
// ConnectionString
connection = new MySqlConnection(ConnectionString);
if (model.TimeFrame != 0 && model.TimeFrame != 1)
{
query = "DROP EVENT IF EXISTS ClearRTLSData; CREATE EVENT ClearRTLSData ON SCHEDULE EVERY " + " " + model.TimeFrame + " " + " HOUR COMMENT 'Clear RTLS Data as per Admin Configuration' DO CALL ArchiveRTLSData(" + "'" + _rtlsDataAccordingtoSite.EngageSiteName + "'" + ")";
}
else
{
query = "DROP EVENT IF EXISTS ClearRTLSData";
}
//open connection
connection.Open();
//create command and assign the query and connection from the constructor
MySqlCommand cmd = new MySqlCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
//close connection
connection.Close();
return(new HttpResponseMessage()
{
});
}
public HttpResponseMessage FilterLocationData(Domins.ViewModels.FilterLocationData model)
{
int FixedLength = Convert.ToInt32(model.RecordToDisply);
int SkipStart = (Convert.ToInt32(model.CurrentPage) * FixedLength);
int pages = (SkipStart + FixedLength) / FixedLength;
int TotalRecords = 0;
IEnumerable <RtlsNotificationData> lstLocationData = null;
try
{
//var objRtlsConfiguration = db.RtlsConfiguration.FirstOrDefault(m => m.SiteId == model.SiteId);
//var row = db.LocationData.Where(m => m.sn == objRtlsConfiguration.EngageSiteName);
lstLocationData = db.RtlsNotificationData;
TotalRecords = lstLocationData.Count();
if (model.MacAddress != null && model.AreaName != null)
{
lstLocationData = db.RtlsNotificationData.OrderByDescending(m => m.NotifyDateTime).Where(m => m.MacAddress == model.MacAddress).Take(FixedLength).ToList();
}
else if (model.MacAddress != null)
{
lstLocationData = db.RtlsNotificationData.OrderByDescending(m => m.NotifyDateTime).Where(m => m.MacAddress == model.MacAddress).Take(FixedLength).ToList();
}
else if (model.AreaName != null)
{
lstLocationData = db.RtlsNotificationData.OrderByDescending(m => m.NotifyDateTime).Take(FixedLength).ToList();
}
}
catch (Exception ex)
{
log.Error(ex.Message);
log.Error(ex.InnerException.Message);
}
return(new HttpResponseMessage()
{
Content = new StringContent(JsonConvert.SerializeObject(new
{
CurrentPage = pages,
TotalRecords = TotalRecords,
RecordToDisply = FixedLength,
lstLocationData
}), Encoding.UTF8, "application/json")
});
}
