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