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