public IHttpActionResult PutProduct_Type(int id, Product_Type product_Type) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != product_Type.Product_Type_ID) { return(BadRequest()); } db.Entry(product_Type).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!Product_TypeExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
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 PutTemplate_Position(int id, Template_Position template_Position) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != template_Position.Template_Position_ID) { return(BadRequest()); } db.Entry(template_Position).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!Template_PositionExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PutCustomer_Order(int id, Customer_Order customer_Order) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != customer_Order.Customer_Order_ID) { return(BadRequest()); } db.Entry(customer_Order).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!Customer_OrderExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public bool SetNewPass(dynamic pss) { try { KIMODBEntities db11 = new KIMODBEntities(); string usr = pss.usrn; User user = db11.Users.Where(k => k.UserName == usr).FirstOrDefault(); if (user != null) { var hash = GenerateHash(pss.pssw.Value); // Do you have to use the word value string newP = hash; user.UserPassword = newP; user.UserPasswordChangeRequest = false; //user.UserPassword = pss.pssw; db11.Entry(user).State = EntityState.Modified; db11.SaveChanges(); return(true); } else { return(false); } } catch { return(false); } }
public void createQuote(int id, double price) { Quotation quote = db.Quotations.Where(x => x.Quotation_ID == id).FirstOrDefault(); Quotation_Line line = db.Quotation_Line.Where(x => x.Quotation_ID == quote.Quotation_ID).FirstOrDefault(); line.Price = Convert.ToDecimal(price); db.SaveChanges(); }
public IHttpActionResult PutQuotation_Request(Quotation_Request quotation_Request) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.Entry(quotation_Request).State = EntityState.Modified; try { db.SaveChanges(); } catch (Exception) { throw; } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult upload([FromBody] dynamic file) { db.Configuration.ProxyCreationEnabled = false; string upload = file.file; Product_Type product_Type = new Product_Type(); product_Type.ImageString = upload; db.Product_Type.Add(product_Type); db.SaveChanges(); return(Ok(product_Type)); }
private bool setOTP(string usrn, string OTP) { try { KIMODBEntities db10 = new KIMODBEntities(); User usr = db10.Users.Where(y => y.UserName == usrn).FirstOrDefault(); usr.ResetOTP = OTP; usr.UserPasswordChangeRequest = true; db10.Entry(usr).State = EntityState.Modified; db10.SaveChanges(); return(true); } catch { return(false); } }
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; * } */ }