public HttpResponseMessage GetSupplierById([FromUri] string id) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { HttpResponseMessage response = new HttpResponseMessage(); supplier supplierObj = dbContext.suppliers.Find(id); if (supplierObj == null) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Supplier cannot be found" }); } else { response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, data = supplierObj }); } return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message }));; } } }
public IEnumerable <supplier> Get() { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { return(dbContext.suppliers.ToList()); } }
public HttpResponseMessage DeleteSupplier([FromUri] string id) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { HttpResponseMessage response = new HttpResponseMessage(); supplier supplierObj = dbContext.suppliers.Find(id); if (supplierObj == null) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Supplier cannot be found" }); } else { dbContext.suppliers.Remove(supplierObj); dbContext.SaveChanges(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Supplier deleted successfully" }); } return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message }));; } } }
public HttpResponseMessage PostPurchReqItem([FromBody] purchaseRequestItem item) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { var result = dbContext.purchaseRequestItems.Add(item); dbContext.SaveChanges(); purchaseRequest reqObj = dbContext.purchaseRequests.FirstOrDefault(i => i.requestId == item.requestId); double totalAmount = Convert.ToDouble((from p in dbContext.purchaseRequestItems where p.requestId == item.requestId group p by p.requestId into g select g.Sum(c => c.subTotal).Value).FirstOrDefault()); reqObj.totalAmount = totalAmount; dbContext.Entry(reqObj).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); HttpResponseMessage response = new HttpResponseMessage(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Item Added to Cart Succesfully" }); return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage PostSupplier([FromBody] inventory item) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { HttpResponseMessage response = new HttpResponseMessage(); if (item.currentStock > item.maxStock) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Stock Exceeds and Item cannot be Saved" }); } else { var result = dbContext.inventories.Add(item); dbContext.SaveChanges(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Item Added into Inventory Succesfully" }); } return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage DeletePaymentById([FromUri] string id, [FromBody] payment payment) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { HttpResponseMessage response = new HttpResponseMessage(); payment paymentObj = dbContext.payments.Find(id); if (paymentObj == null) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Payment cannot be found" }); } else { paymentObj.status = "BLOCK"; dbContext.Entry(paymentObj).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Payments edited successfully" }); } return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message }));; } } }
public HttpResponseMessage EditSupplierById([FromUri] string id, [FromBody] siteManager siteManager) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { HttpResponseMessage response = new HttpResponseMessage(); siteManager sManager = dbContext.siteManagers.Find(id); if (sManager == null) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Site Manager cannot be found" }); } else { sManager.smanagerNo = siteManager.smanagerNo; sManager.sname = siteManager.sname; sManager.snic = siteManager.snic; sManager.scontactNo = siteManager.scontactNo; sManager.site = siteManager.site; sManager.approvedValue = siteManager.approvedValue; dbContext.Entry(sManager).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Site Manager edited successfully" }); } return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message }));; } } }
public HttpResponseMessage DeleteSupplier([FromUri] string supItemId, [FromUri] string supplierId) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { HttpResponseMessage response = new HttpResponseMessage(); supplier_items itemObj = dbContext.supplier_items.FirstOrDefault(i => i.supItemId == supItemId && i.supplierId == supplierId); if (itemObj == null) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Item cannot be found" }); } else { dbContext.supplier_items.Remove(itemObj); dbContext.SaveChanges(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Item deleted successfully" }); } return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message }));; } } }
public HttpResponseMessage GetCartByPurchReqId([FromUri] string requestId) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { HttpResponseMessage response = new HttpResponseMessage(); var itemObj = dbContext.Database.SqlQuery <purchaseRequestItem>("select * from purchaseRequestItems where requestId = @id", new SqlParameter("id", requestId)).ToList(); if (itemObj == null) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Items cannot be found" }); } else { response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, data = itemObj }); } return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage AprrovePurchReq([FromUri] string requestId, [FromBody] purchaseRequest reqObj) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { HttpResponseMessage response = new HttpResponseMessage(); purchaseRequest requestObj = dbContext.purchaseRequests.Find(requestId); if (requestObj == null) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Purchase Request cannot be found" }); } else { requestObj.requestStatus = "OPEN"; dbContext.Entry(requestObj).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Purchase Request Approved successfully" }); } return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage EditPurchaseById([FromUri] string id, [FromBody] order order) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { HttpResponseMessage response = new HttpResponseMessage(); order orderObj = dbContext.orders.Find(id); if (orderObj == null) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Order cannot be found" }); } else { orderObj.id = order.id; orderObj.reqId = order.reqId; orderObj.createBy = order.createBy; orderObj.date = order.date; orderObj.status = order.status; dbContext.Entry(orderObj).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Order edited successfully" }); } return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message }));; } } }
public HttpResponseMessage GetSupplierItemByKeys([FromUri] string supItemId, [FromUri] string supplierId) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { HttpResponseMessage response = new HttpResponseMessage(); supplier_items itemObj = dbContext.supplier_items.FirstOrDefault(i => i.supItemId == supItemId && i.supplierId == supplierId); //var itemObj = dbContext.supplier_items.SqlQuery("select * from supplier_items").ToList(); if (itemObj == null) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Item cannot be found" }); } else { response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, data = itemObj }); } return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message }));; } } }
public HttpResponseMessage EditSupplierById([FromUri] string id, [FromBody] supplier supplier) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { HttpResponseMessage response = new HttpResponseMessage(); supplier supplierObj = dbContext.suppliers.Find(id); if (supplierObj == null) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Supplier cannot be found" }); } else { supplierObj.supplierId = supplier.supplierId; supplierObj.name = supplier.name; supplierObj.address = supplier.address; supplierObj.contactNo = supplier.contactNo; supplierObj.email = supplier.email; dbContext.Entry(supplierObj).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Supplier edited successfully" }); } return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message }));; } } }
public HttpResponseMessage DeletePaymentById() { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { var payments = dbContext.payments.SqlQuery(@"select * from payments where status = 'BLOCK'").ToList(); return(Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, data = payments })); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage GetOpenPurchReq() { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { var reqObj = dbContext.purchaseRequests.SqlQuery("select * from purchaseRequests where requestStatus = 'OPEN'").ToList(); return(Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, data = reqObj })); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage GetPurchReqByReqId([FromUri] string requestId) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { purchaseRequest reqObj = dbContext.purchaseRequests.FirstOrDefault(i => i.requestId == requestId); return(Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, data = reqObj })); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage Get([FromUri] string id) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { var suppliers_items = dbContext.Database.SqlQuery <supplier_items>("select * from supplier_items where supplierId = @id", new SqlParameter("id", id)).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, data = suppliers_items })); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage Get() { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { var suppliers = dbContext.suppliers.SqlQuery(@"select * from suppliers").ToList(); return(Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, data = suppliers })); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage PostPurchaseRequest([FromBody] purchaseRequest req) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { var result = dbContext.purchaseRequests.Add(req); dbContext.SaveChanges(); HttpResponseMessage response = new HttpResponseMessage(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Purchase Request Added Succesfully" }); return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message }));; } } }
public HttpResponseMessage searchPayById([FromUri] string paymentId) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { //var payments = dbContext.Database.SqlQuery<payment>(@"select * from payments where paymentId=@id", new SqlParameter("id", paymentId)).ToList(); var payments = (from p in dbContext.payments where p.paymentId == paymentId select p).ToList(); return(Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, data = payments })); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage PostSupplier([FromBody] supplier supplier) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { var suppliers = dbContext.suppliers.Add(supplier); dbContext.SaveChanges(); HttpResponseMessage response = new HttpResponseMessage(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Supplier Added Succesfully" }); return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message }));; } } }
public HttpResponseMessage GetApprovedValue([FromUri] string siteManagerId) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { //var totalAmount = dbContext.purchaseRequestItems.SqlQuery("select sum(p.subTotal) from purchaseRequestItems p where p.requestId = @id", new SqlParameter("id", requestId)); double approvedValue = Convert.ToDouble((from p in dbContext.siteManagers where p.smanagerNo == siteManagerId select(p.approvedValue).Value).FirstOrDefault()); return(Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, data = approvedValue })); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage PostOrder(order order) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { var purchaseOrders = dbContext.orders.Add(order); dbContext.SaveChanges(); purchaseRequest reqObj = dbContext.purchaseRequests.Find(order.reqId); reqObj.requestStatus = "CLOSE"; dbContext.SaveChanges(); HttpResponseMessage response = new HttpResponseMessage(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Order Added Succesfully" }); return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message }));; } } }
public HttpResponseMessage GetSumOfSubTotal([FromUri] string requestId) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { //var totalAmount = dbContext.purchaseRequestItems.SqlQuery("select sum(p.subTotal) from purchaseRequestItems p where p.requestId = @id", new SqlParameter("id", requestId)); double totalAmount = Convert.ToDouble((from p in dbContext.purchaseRequestItems where p.requestId == requestId group p by p.requestId into g select g.Sum(c => c.subTotal).Value).FirstOrDefault()); return(Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, data = totalAmount })); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage UserLogin([FromUri] string username, [FromUri] string password) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { user user = dbContext.users.FirstOrDefault(i => i.user_name == username && i.pass_word == password); if (user == null) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Invalid Username or Password" })); } else { return(Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "User Logged in Successfully", data = user })); } } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage PlaceOrder([FromUri] string requestId, [FromBody] purchaseRequest reqObj) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { HttpResponseMessage response = new HttpResponseMessage(); purchaseRequest requestObj = dbContext.purchaseRequests.Find(requestId); if (requestObj == null) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Purchase Request cannot be found" }); } else { double approvedValue = Convert.ToDouble((from p in dbContext.siteManagers where p.smanagerNo == reqObj.createdBy select(p.approvedValue).Value).FirstOrDefault()); if (reqObj.totalAmount > approvedValue) { requestObj.requestStatus = "NEED APPROVAL"; } else { requestObj.requestStatus = reqObj.requestStatus; } dbContext.Entry(requestObj).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Purchase Request edited successfully" }); } return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }
public HttpResponseMessage DeleteCartItem([FromUri] string requestItemId, [FromUri] string requestId, [FromUri] string supplierId) { using (ProcurementDBEntities1 dbContext = new ProcurementDBEntities1()) { try { HttpResponseMessage response = new HttpResponseMessage(); purchaseRequestItem itemObj = dbContext.purchaseRequestItems.FirstOrDefault(i => i.requestItemId == requestItemId && i.requestId == requestId && i.supplierId == supplierId); if (itemObj == null) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = "Item cannot be found" }); } else { dbContext.purchaseRequestItems.Remove(itemObj); dbContext.SaveChanges(); purchaseRequest reqObj = dbContext.purchaseRequests.FirstOrDefault(i => i.requestId == requestId); double totalAmount = Convert.ToDouble((from p in dbContext.purchaseRequestItems where p.requestId == requestId group p by p.requestId into g select g.Sum(c => c.subTotal).Value).FirstOrDefault()); reqObj.totalAmount = totalAmount; dbContext.Entry(reqObj).State = System.Data.Entity.EntityState.Modified; dbContext.SaveChanges(); response = Request.CreateResponse(HttpStatusCode.OK, new { statusCode = HttpStatusCode.OK, message = "Item deleted successfully" }); } return(response); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.NotFound, new { statusCode = HttpStatusCode.NotFound, message = e.Message })); } } }