// GET api/Myshelf public IList <myshelf> Getmyshelves() { //var myshelves = db.myshelves.Include(m => m.customer.customerid).Include(m => m.invoiceheader.invoiceheaderid).Include(m => m.product.productid); //return myshelves.AsEnumerable(); ProductController productController = new ProductController(); var x = (from m in db.myshelves select new { myshelfid = m.myshelfid, purchasedate = m.purchasedate, enddate = m.enddate, purchasetype = m.purchasetype, rating = m.rating, customer_customerid = m.customer_customerid, invoiceheader_invoiceheaderid = m.invoiceheader_invoiceheaderid, product_productid = m.product_productid, }); //var x = db.myshelves.ToList<myshelf>(); IList <myshelf> l = new List <myshelf>(); foreach (var a in x) { myshelf m = new myshelf(); m.myshelfid = a.myshelfid; m.myshelfid = a.myshelfid; m.purchasedate = a.purchasedate; m.enddate = a.enddate; m.purchasetype = a.purchasetype; m.rating = a.rating; m.customer_customerid = a.customer_customerid; m.invoiceheader_invoiceheaderid = a.invoiceheader_invoiceheaderid; m.product_productid = a.product_productid; l.Add(m); } return(l); }
// PUT api/Myshelf/5 public HttpResponseMessage Putmyshelf(short id, myshelf myshelf) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } if (id != myshelf.myshelfid) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } db.Entry(myshelf).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex)); } return(Request.CreateResponse(HttpStatusCode.OK)); }
// DELETE api/Myshelf/5 public HttpResponseMessage Deletemyshelf(short id) { myshelf myshelf = db.myshelves.Find(id); if (myshelf == null) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } db.myshelves.Remove(myshelf); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex)); } return(Request.CreateResponse(HttpStatusCode.OK, myshelf)); }
// POST api/Invoiceheader public invoiceheader Postinvoiceheader(invoiceheader invoiceheader, myshelf myshelf, product product, string purchasetype, short days) { if (ModelState.IsValid) { db.invoiceheaders.Add(invoiceheader); db.SaveChanges(); InvoicedetailController InvoicedetailController = new Controllers.InvoicedetailController(); invoicedetail invoicedetail = new invoicedetail(); invoicedetail.invoiceheader_invoiceheaderid = invoiceheader.invoiceheaderid; invoicedetail.product_productid = myshelf.product_productid; if (purchasetype.Contains("rent")) { invoicedetail.amount = product.rentcost * days; invoiceheader.totalamount = product.rentcost * days; } else { invoicedetail.amount = Convert.ToInt32(product.price); } InvoicedetailController.Postinvoicedetail(invoicedetail, purchasetype); db.SaveChanges(); // HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, invoiceheader); // response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = invoiceheader.invoiceheaderid })); return(invoiceheader); } else { return(invoiceheader); //return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState); } }
// GET api/Myshelf/5 public List <myshelf> Getmyshelf(short cid, string purchasetype) { //List<myshelf> list = db.myshelves.ToList(); var x = (from m in db.myshelves select new { myshelfid = m.myshelfid, purchasedate = m.purchasedate, enddate = m.enddate, purchasetype = m.purchasetype, rating = m.rating, customer_customerid = m.customer_customerid, invoiceheader_invoiceheaderid = m.invoiceheader_invoiceheaderid, product_productid = m.product_productid }); //var x = db.myshelves.ToList<myshelf>(); IList <myshelf> list = new List <myshelf>(); foreach (var a in x) { myshelf m = new myshelf(); m.myshelfid = a.myshelfid; m.myshelfid = a.myshelfid; m.purchasedate = a.purchasedate; m.enddate = a.enddate; m.purchasetype = a.purchasetype; m.rating = a.rating; m.customer_customerid = a.customer_customerid; m.invoiceheader_invoiceheaderid = a.invoiceheader_invoiceheaderid; m.product_productid = a.product_productid; list.Add(m); } List <myshelf> myshelf = (from l in list where l.customer_customerid == cid select l).ToList <myshelf>(); if (myshelf == null) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound)); } if (purchasetype.Contains("purchase")) { List <myshelf> purchase = (from l in myshelf where l.purchasetype == "purchase" select l).ToList <myshelf>(); return(purchase); } else if (purchasetype.Contains("rent")) { List <myshelf> rent = (from l in myshelf where l.purchasetype == "rent" select l).ToList <myshelf>(); return(rent); } else if (purchasetype.Contains("lent")) { List <myshelf> lent = (from l in myshelf where l.purchasetype == "lent" select l).ToList <myshelf>(); return(lent); } else { List <myshelf> cart = (from l in myshelf where l.purchasetype == "cart" select l).ToList <myshelf>(); return(cart); } }