public List <dynamic> createRequest(int custID, int designID, int sizeID, string color, int webID, string prodCode, int quantity) { db.Configuration.ProxyCreationEnabled = false; List <dynamic> list = new List <dynamic>(); Quotation_Request request = new Quotation_Request(); request.Customer_ID = custID; request.Date = DateTime.Now; db.Quotation_Request.Add(request); db.SaveChanges(); list.Add(request); if (request != null) { Quotation_Request_Line quotation_Request_Line = new Quotation_Request_Line(); quotation_Request_Line.Request_ID = request.Request_ID; quotation_Request_Line.Design_ID = designID; quotation_Request_Line.Product_Size_ID = sizeID; quotation_Request_Line.Colour = color; quotation_Request_Line.Web_Link_ID = webID; quotation_Request_Line.Product_Code = prodCode; quotation_Request_Line.Quantity = quantity; db.Quotation_Request_Line.Add(quotation_Request_Line); db.SaveChanges(); list.Add(quotation_Request_Line); } return(list); }
public IHttpActionResult RemoveItem(int id, int bId) { try { Quotation_Request_Line delLine = db.Quotation_Request_Line.Where(s => (s.Design_ID == id) && (s.Request_Line_ID == bId)).FirstOrDefault(); db.Entry(delLine).State = System.Data.Entity.EntityState.Deleted; db.SaveChanges(); return(Ok()); } catch { return(BadRequest("Operation Failed")); } }
public HttpResponseMessage AddItemsToQuote([FromBody] Quotation_Request_Line ql) { try { /*Quotation_Request_Line checkBI = db.Basket_Line.Where(g => g.BasketID == bl.BasketID).FirstOrDefault(); * Basket_Line checkPI = db.Basket_Line.Where(g => g.ProductID == bl.ProductID).FirstOrDefault(); * if (checkPI != null && checkBI != null) * { * var badResponse = Request.CreateResponse(HttpStatusCode.BadRequest, "already in basket"); * return badResponse; * }*/ /*Basket upB = db.Baskets.Where(y => y.BasketID == bl.BasketID).FirstOrDefault(); * upB.BasketStatusID = 2; * db.Entry(upB).State = EntityState.Modified; * * db.SaveChanges();*/ Quotation_Request_Line reqLine = db.Quotation_Request_Line.SingleOrDefault(g => (g.Request_Line_ID == ql.Request_Line_ID) && (g.Design_ID == ql.Design_ID)); if (reqLine == null) { db.Quotation_Request_Line.Add(ql); db.SaveChanges(); var response = Request.CreateResponse(HttpStatusCode.OK, ql); response.Headers.Add("Access-Control-Allow-Origin", "http://localhost:4200"); response.Headers.Add("Access-Control-Allow-Headers", "Origin, Content-Type, X-Auth-Token"); return(response); } else { var badResponse = Request.CreateResponse(HttpStatusCode.BadRequest, "already in basket"); return(badResponse); } /*updateBasketStatus(bl); * * db.Basket_Line.Add(bl); * db.SaveChanges(); * * var response = Request.CreateResponse(HttpStatusCode.OK, bl); * response.Headers.Add("Access-Control-Allow-Origin", "http://localhost:4200"); * response.Headers.Add("Access-Control-Allow-Headers", "Origin, Content-Type, X-Auth-Token"); * return response;*/ } catch { var response = Request.CreateResponse(HttpStatusCode.BadRequest, "operation failed!"); return(response); } /* List<Product> prodList = new List<Product>(); * List<Basket> basket = new List<Basket>(); * Basket_Line newBL = new Basket_Line(); * newBL.BasketID = bl.BasketID; * newBL.ProductID = bl.ProductID; * newBL.Quantity = bl.Quantity; * newBL.Cost = bl.Cost; * * Basket_Line checkBI = db.Basket_Line.Where(g => g.BasketID == newBL.BasketID).FirstOrDefault(); * Basket_Line checkPI = db.Basket_Line.Where(g => g.ProductID == newBL.ProductID).FirstOrDefault(); * * if(checkPI!=null && checkBI!=null) * { * var response = Request.CreateResponse(HttpStatusCode.BadRequest, "already in basket"); * return response; * } */ /*Product upP = db.Products.Where(x => x.ProductID == newBL.ProductID).FirstOrDefault(); * upP.QuantityOnHand = (upP.QuantityOnHand - newBL.Quantity);*/ /* Basket upB = db.Baskets.Where(y => y.BasketID == newBL.BasketID).FirstOrDefault(); * upB.BasketStatusID = 2; * * try * { * //db.Entry(upP).State = EntityState.Modified; * db.Entry(upB).State = EntityState.Modified; * db.Basket_Line.Add(newBL); * db.SaveChanges(); * var response = Request.CreateResponse(HttpStatusCode.OK, newBL); * return response; * } * catch(Exception e) * { * var response = Request.CreateResponse(HttpStatusCode.BadRequest, "operation failed!"); * return response; * } */ }