// POST api/MaintainPurchaseQuotation
        public HttpResponseMessage PostMaintainPurchaseQuotation(MaintainPurchaseQuotation maintainpurchasequotation)
        {
            if (ModelState.IsValid)
            {
                string CustomCode = "PQ-" + DateTime.Now.ToString("yyyyMMdd");

                int? MaxCode = Convert.ToInt32((db.MaintainPurchaseQuotations.Where(r => r.MaintainPurchaseQuotationCode.StartsWith(CustomCode)).Select(r => r.MaintainPurchaseQuotationCode.Substring(CustomCode.Length, 4)).ToList()).Max());
                string QRCode = CustomCode + ((MaxCode + 1).ToString()).PadLeft(4, '0');
                maintainpurchasequotation.MaintainPurchaseQuotationCode = QRCode;
                db.MaintainPurchaseQuotations.Add(maintainpurchasequotation);
                db.SaveChanges();

                HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, maintainpurchasequotation);
                response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = maintainpurchasequotation.MaintainPurchaseQuotationID }));
                return response;
            }
            else
            {
                return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
            }
        }
        // PUT api/MaintainPurchaseQuotation/5
        public HttpResponseMessage PutMaintainPurchaseQuotation(long id, MaintainPurchaseQuotation maintainpurchasequotation)
        {
            if (!ModelState.IsValid)
            {
                return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
            }

            if (id != maintainpurchasequotation.MaintainPurchaseQuotationID)
            {
                return Request.CreateResponse(HttpStatusCode.BadRequest);
            }
            maintainpurchasequotation.Collaborator = null;
            maintainpurchasequotation.ProcesStatus = null;
            maintainpurchasequotation.ProjectSetup = null;
            db.Entry(maintainpurchasequotation).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException ex)
            {
                return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
            }

            return Request.CreateResponse(HttpStatusCode.OK);
        }