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));
}
}
public Vehicle Get(string id)
{
using (VehicleDBEntities entities = new VehicleDBEntities())
{
return(entities.Vehicles.FirstOrDefault(e => e.id == id));
}
}
public IEnumerable <Vehicle> Get()
{
using (VehicleDBEntities entities = new VehicleDBEntities())
{
return(entities.Vehicles.ToList().OrderBy(s => s.unitName));
}
}
public IEnumerable <Vehicle> GetSpecific(string searchText)
{
using (VehicleDBEntities entities = new VehicleDBEntities())
{
var result = entities.Vehicles.Where(d => d.unitName.Contains(searchText)).ToList();
return(result);
}
}
public IEnumerable <Report> Get(string id)
{
using (VehicleDBEntities entities = new VehicleDBEntities())
{
var vehRep = entities.VehiclesReports.Include(m => m.Report).Where(veh => veh.vehicleId == id).ToList();
var reports = vehRep.Select(d => d.Report).ToList();
return(reports);
}
}
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 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 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));
}
}
protected override void OnStart(string[] args)
{
db = new VehicleDBEntities(Connection.GetConnectionString());
timer1.Interval = 1000;
timer1.Elapsed += new ElapsedEventHandler(timer1_Elapsed);
timer1.Enabled = true;
timer1.Start();
WriteLog("Application started");
AutoMapperConfig.InitializeMappings();
}
