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