// DELETE api/WorkOrders/5
        public string Delete(int id)
        {
            try
            {
                var dbCtxt = new WorkOrdersAppEntities();

                dbCtxt.WorkOrders.Remove(dbCtxt.WorkOrders.Find(id));
                dbCtxt.SaveChanges();

                return "Success";
            }
            catch
            {
                return "Failed";
            }
        }
 // POST api/Devices
 public string Post([FromBody]ReferenceTableData refData)
 {
     //Add Devices to list from Admin Panel
     try
     {
         var dbCtxt = new WorkOrdersAppEntities();
         dbCtxt.refDevices.Add(new refDevice()
         {
             DeviceName = refData.Value,
             Enabled = true
         });
         dbCtxt.SaveChanges();
         return "Success";
     }
     catch
     {
         return "Failed";
     }
 }
        // DELETE api/Sites/5
        public string Delete(int id)
        {
            //Disable Sites from list on Admin Panel
            try
            {
                var dbCtxt = new WorkOrdersAppEntities();
                var record = dbCtxt.refSites.Find(id);

                if (record != null)
                {
                    record.Enabled = false;
                    dbCtxt.SaveChanges();
                    return "Success";
                }
                return "Failed";
            }
            catch
            {
                return "Failed";
            }
        }
        // DELETE api/ManageDevices/5
        public string Delete(int id)
        {
            //Delete record from Manage Devices list on Web UI
            try
            {
                var dbCtxt = new WorkOrdersAppEntities();
                var record = dbCtxt.ManageDevices.Find(id);

                if (record != null)
                {
                    dbCtxt.ManageDevices.Remove(record);
                    dbCtxt.SaveChanges();
                    return "Success";
                }
                return "Failed";
            }
            catch
            {
                return "Failed";
            }
        }
 // POST api/Jobs
 public string Post([FromBody]RefJobData refJobData)
 {
     //Add Job to list from Admin Panel
     try
     {
         var dbCtxt = new WorkOrdersAppEntities();
         dbCtxt.refJobs.Add(new refJob()
         {
             SiteID = refJobData.SiteID,
             JobNumber = refJobData.JobNumber,
             JobName = refJobData.Value,
             Enabled = true
         });
         dbCtxt.SaveChanges();
         return "Success";
     }
     catch
     {
         return "Failed";
     }
 }
        // POST api/Users
        public string Post([FromBody]RefUsersData refData)
        {
            //Adds a User on the Admin Panel
            try
            {
                var dbCtxt = new WorkOrdersAppEntities();
                var userFound = dbCtxt.refUsers.Find(refData.ID);

                if (userFound == null)
                {

                    dbCtxt.refUsers.Add(new refUser()
                    {
                        First_Name = refData.FirstName,
                        Last_Name = refData.LastName,
                        EmailAddress = refData.EmailAddress,
                        WebUser = refData.WebUser,
                        Admin = refData.Admin,
                        Enabled = refData.Enabled
                    });
                }else
                {
                    userFound.First_Name = refData.FirstName;
                    userFound.Last_Name = refData.LastName;
                    userFound.EmailAddress = refData.EmailAddress;
                    userFound.WebUser = refData.WebUser;
                    userFound.Admin = refData.Admin;
                    userFound.Enabled = refData.Enabled;
                }
                dbCtxt.SaveChanges();
                return "Success";
            }
            catch
            {
                return "Failed";
            }
        }
        // POST api/WorkOrders
        public string Post([FromBody]WorkOrderWeb wo)
        {
            try
            {
                var dbCtxt = new WorkOrdersAppEntities();
                var woFound = dbCtxt.WorkOrders.Find(wo.ID);

                if (woFound == null) //insert
                {
                    dbCtxt.WorkOrders.Add(new WorkOrder
                    {
                        JobID = wo.JobID,
                        SubmitUserID = wo.SubmittedUserID,
                        SubmittedDate = FormattingFunctions.ESTDateTime(),
                        RegHoursWorked = wo.RegWorkHours,
                        OvertimeHoursWorked = wo.OvertimeWorkHours,
                        Subject = wo.Subject,
                        Description = wo.Description,
                        LastUpdateBy = wo.LastUpdatedBy,
                        LastUpdateDate = FormattingFunctions.ESTDateTime()
                    });
                }
                else //update
                {
                    if (wo.JobID != 0)//Denotes incoming update from app or web page
                    {
                        woFound.JobID = wo.JobID;
                        woFound.SubmitUserID = wo.SubmittedUserID;
                        woFound.RegHoursWorked = wo.RegWorkHours;
                        woFound.OvertimeHoursWorked = wo.OvertimeWorkHours;
                        woFound.Subject = wo.Subject;
                        woFound.Description = wo.Description;
                    }
                    woFound.Reviewed = wo.Reviewed;
                    woFound.LastUpdateBy = wo.LastUpdatedBy;
                    woFound.LastUpdateDate = FormattingFunctions.ESTDateTime();
                }

                dbCtxt.SaveChanges();
                return "Success";
            }
            catch(Exception ex)
            {
                return "Failed: " + ex.Message + ": " + ex.InnerException;
            }
        }
        // POST api/ManageDevices
        public string Post([FromBody]ManageDevicesWeb md)
        {
            try
            {
                var dbCtxt = new WorkOrdersAppEntities();
                var mdFound = dbCtxt.ManageDevices.Find(md.ID);

                if (mdFound == null) //insert
                {
                    dbCtxt.ManageDevices.Add(new ManageDevice
                    {
                        UserID = md.UserID,
                        DeviceID = md.DeviceID,
                        DeviceGUID = md.GUID,
                        LastUpdateBy = md.LastUpdateBy,
                        LastUpdateDate = FormattingFunctions.ESTDateTime()
                    });
                }
                else //update
                {
                    mdFound.UserID = md.UserID;
                    mdFound.DeviceID = md.DeviceID;
                    mdFound.DeviceGUID = md.GUID;
                    mdFound.LastUpdateBy = md.LastUpdateBy;
                    mdFound.LastUpdateDate = FormattingFunctions.ESTDateTime();
                }

                dbCtxt.SaveChanges();
                return "Success";
            }
            catch
            {
                return "Failed";
            }
        }