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 }));
}
}
}
