// POST: api/PartStatus
        public string Post(HttpRequestMessage value)
        {
            try
            {
                Model.Part_Status ps = new Model.Part_Status();

                string  message           = HttpContext.Current.Server.UrlDecode(value.Content.ReadAsStringAsync().Result).Substring(5);
                JObject partStatusDetails = JObject.Parse(message);

                int key = db.Part_Status.Count() == 0 ? 1 : (from t in db.Part_Status
                                                             orderby t.Part_Status_ID descending
                                                             select t.Part_Status_ID).First() + 1;

                ps.Part_Status_ID = key;
                ps.Name           = (string)partStatusDetails["Name"];
                ps.Description    = (string)partStatusDetails["Description"];

                string errorString = "false|";
                bool   error       = false;

                if ((from t in db.Part_Status
                     where t.Name == ps.Name
                     select t).Count() != 0)
                {
                    error        = true;
                    errorString += "The Part Status entered already exists on the system. ";
                }

                if (error)
                {
                    return(errorString);
                }

                db.Part_Status.Add(ps);
                db.SaveChanges();
                return("true|Part Status #" + key + " successfully added.");
            }
            catch (Exception e)
            {
                ExceptionLog.LogException(e, "PartStatusController POST");
                return("false|An error has occured adding the Part Status to the system.");
            }
        }
        // PUT: api/PartStatus/5
        public string Put(int id, HttpRequestMessage value)
        {
            try
            {
                string  message           = HttpContext.Current.Server.UrlDecode(value.Content.ReadAsStringAsync().Result).Substring(5);
                JObject partStatusDetails = JObject.Parse(message);

                Model.Part_Status ps = new Model.Part_Status();
                ps = (from p in db.Part_Status
                      where p.Part_Status_ID == id
                      select p).First();

                ps.Name        = (string)partStatusDetails["Name"];
                ps.Description = (string)partStatusDetails["Description"];

                string errorString = "false|";
                bool   error       = false;

                if ((from t in db.Part_Status
                     where t.Name == ps.Name && t.Part_Status_ID != id
                     select t).Count() != 0)
                {
                    error        = true;
                    errorString += "The Part Status entered already exists on the system. ";
                }

                if (error)
                {
                    return(errorString);
                }

                db.SaveChanges();
                return("true|Part Status successfully updated.");
            }
            catch (Exception e)
            {
                ExceptionLog.LogException(e, "PartStatus PUT");
                return("false|An error has occured adding the Part Status to the system.");
            }
        }