public void DownloadMessages() { try { db = new VehicleDBEntities(Connection.GetConnectionString()); var ps = db.ProjectSettings.FirstOrDefault(); if (ps == null) ps = new ProjectSetting() { StopSmsLogService = false, SmsLogUpdateDate = DateTime.Now.AddYears(-1), SmsLogRefreshTime = 1, }; if (!ps.StopSmsLogService) { var d = ps.SmsLogUpdateDate.Value; var twilio = new TwilioRestClient(ConfigHelper.AppSetting("Twilio_AccountSid"), ConfigHelper.AppSetting("Twilio_AuthToken")); var NowDate = DateTime.Now; string resource = string.Format("Accounts/{0}/SMS/Messages.json?DateSent>={1}", ConfigHelper.AppSetting("Twilio_AccountSid"), d.ToString("yyyy-MM-dd HH:mm:ss")); RestSharp.RestRequest rs = new RestSharp.RestRequest(); rs.Resource = resource; var smsResult = twilio.Execute<SmsMessageResult>(rs); var smsList = new List<Message>(); if (smsResult != null) AutoMapper.Mapper.Map(smsResult.SMSMessages, smsList); if (smsList.Count > 0) { foreach (var item in smsList) { if (!db.Messages.Any(p => p.Sid == item.Sid)) db.Messages.AddObject(item); } db.SaveChanges(); } ps.SmsLogUpdateDate = NowDate; if (ps.ID == 0) db.ProjectSettings.AddObject(ps); db.SaveChanges(); WriteLog(smsList.Count + " Sms read"); } int interval = ps.SmsLogRefreshTime * 60 * 1000; if (timer1.Interval != interval) { timer1.Stop(); timer1.Interval = interval; timer1.Start(); } } catch (Exception ex) { WriteLog(ex.ToString()); } }
public HttpResponseMessage create(VehicleDetail vehicledetail) { try { var response = new HttpResponseMessage(); ve.VehicleDetails.Add(vehicledetail); ve.SaveChanges(); response.StatusCode = HttpStatusCode.OK; return(Request.CreateResponse(HttpStatusCode.OK, vehicledetail)); } catch { return(new HttpResponseMessage(HttpStatusCode.BadGateway)); } }
public HttpResponseMessage Delete(int id) { try { using (VehicleDBEntities entities = new VehicleDBEntities()) { var entity = entities.VehiclesReports.FirstOrDefault(e => e.reportId == id); var report = entities.Reports.FirstOrDefault(e => e.id == id); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, " not found to delete")); } else { entities.VehiclesReports.Remove(entity); entities.Reports.Remove(report); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
//Add a new vehicle: public bool AddVehicle(VehicleModel vehicle) { try { var vehiclenew = new Vehicle { Make = vehicle.Make, Model = vehicle.Model, Year = vehicle.Year }; db.Vehicles.Add(vehiclenew); db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public Vehicle PostVehicle([FromBody] Vehicle vehicle) { vehicle.id = generateId(); using (VehicleDBEntities entities = new VehicleDBEntities()) { entities.Vehicles.Add(vehicle); entities.SaveChanges(); return(vehicle); } }
public Report PutReport([FromBody] Report report) { using (VehicleDBEntities entities = new VehicleDBEntities()) { var entity = entities.Reports.FirstOrDefault(e => e.id == report.id); entity.reportText = report.reportText; entities.SaveChanges(); return(report); } }
public void Put(string id, [FromBody] Vehicle vehicle) { using (VehicleDBEntities entities = new VehicleDBEntities()) { var entity = entities.Vehicles.FirstOrDefault(e => e.id == id); entity.unitName = vehicle.unitName; entity.carInfo = vehicle.carInfo; entity.active = vehicle.active; entity.registrationNumber = vehicle.registrationNumber; entity.numberOfTours = vehicle.numberOfTours; entities.SaveChanges(); } }
[HttpPost] //create public Report PostReport(string vehId, [FromBody] Report report) { using (VehicleDBEntities entities = new VehicleDBEntities()) { Random random = new Random(); report.id = random.Next(10000000, 999999999); entities.Reports.Add(report); var vehrep = new VehiclesReport() { id = random.Next(10000, 99999), reportId = report.id, vehicleId = vehId }; entities.VehiclesReports.Add(vehrep); entities.SaveChanges(); return(report); } }
public HttpResponseMessage Delete(string id) { try { using (VehicleDBEntities entities = new VehicleDBEntities()) { var entity = entities.Vehicles.FirstOrDefault(e => e.id == id); var vehrep = entities.VehiclesReports.Where(d => d.vehicleId == id); var reports = vehrep.Select(d => d.Report).ToList(); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Vehicle with Id = " + id + " not found to delete")); } else { foreach (VehiclesReport vp in vehrep) { entities.VehiclesReports.Remove(vp); } foreach (Report report in reports) { entities.Reports.Remove(report); } entities.Vehicles.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }