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