public IHttpActionResult PutproductsMaster(int id, productsMaster productsMaster) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != productsMaster.product_id) { return(BadRequest()); } db.Entry(productsMaster).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!productsMasterExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult PostOrders(orderattributes orderattributes) { productsMaster product = db.productsMasters.Where(x => x.product_id == orderattributes.product_id).FirstOrDefault(); order order = new order(); EMItypeMaster EMItype = db.EMItypeMasters.Where(x => x.EMItype_id == orderattributes.EMItype_id).FirstOrDefault(); EMIcard emicard = db.EMIcards.Where(x => x.customer_id == orderattributes.customer_id).FirstOrDefault(); if (emicard == null) { return(Ok(-1)); } if (emicard.remaining_credit < product.product_price) { return(Ok(0)); } else { order.product_id = orderattributes.product_id; order.customer_id = orderattributes.customer_id; order.EMItype_id = orderattributes.EMItype_id; order.EMI_amount = product.product_price / EMItype.EMI_tenure; order.order_date = DateTime.Now; order.order_status = false; db.orders.Add(order); db.SaveChanges(); emicard.remaining_credit = emicard.remaining_credit - product.product_price; emicard.used_credit = emicard.used_credit + product.product_price; db.Entry(emicard).State = EntityState.Modified; db.SaveChanges(); return(Ok(1)); } }
public IHttpActionResult GetRecentTransactions(int?customer_id) { List <order> orderslist = new List <order>(); //orderslist = db.orders.Where(x => x.customer_id == customer_id).ToList(); List <RecentTrans> transactions = new List <RecentTrans>(); transactions = (from trans in db.Transactions join orders in db.orders on trans.order_id equals orders.order_id orderby trans.Payment_date descending select new RecentTrans { customer_id = orders.customer_id, Transaction_status = trans.Transaction_status, product_id = orders.product_id, Payment_date = trans.Payment_date, Amount_paid = trans.Transaction_amount }).Where(x => x.customer_id == customer_id && x.Transaction_status == true).ToList(); RecentTransactionsResponse response = new RecentTransactionsResponse(); if (transactions.Count != 0) { RecentTrans recent = transactions[0]; productsMaster product = db.productsMasters.Where(x => x.product_id == recent.product_id).FirstOrDefault(); response.recent = recent; response.product = product; } return(Ok(response)); }
public IHttpActionResult GetproductsMaster(int id) { productsMaster productsMaster = db.productsMasters.Find(id); if (productsMaster == null) { return(NotFound()); } return(Ok(productsMaster)); }
public IHttpActionResult PostproductsMaster(productsMaster productsMaster) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.productsMasters.Add(productsMaster); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = productsMaster.product_id }, productsMaster)); }
public IHttpActionResult DeleteproductsMaster(int id) { productsMaster productsMaster = db.productsMasters.Find(id); if (productsMaster == null) { return(NotFound()); } db.productsMasters.Remove(productsMaster); db.SaveChanges(); return(Ok(productsMaster)); }
public List <DashBoardProduct> GetProductBasedOnCustomerId(int customer_id) { List <DashBoardProduct> products = new List <DashBoardProduct>(); List <order> orders = db.orders.Where(x => x.customer_id == customer_id).ToList(); for (int i = 0; i < orders.Count; i++) { int orderId = orders[i].order_id; if (orders[i].order_status == false) { DashBoardProduct dashBoardProduct = new DashBoardProduct(); List <Transaction> transactions = db.Transactions.Where(x => x.order_id == orderId).ToList(); for (int j = 0; j < transactions.Count; j++) { var startDate = DateTime.Now; var EndDate = transactions[j].Transction_date; int DateDifference = Convert.ToInt32((EndDate - startDate).TotalDays); if (DateDifference < 30) { if (transactions[j].Transaction_status == false) { dashBoardProduct.PaymentStatus = false; break; } else { dashBoardProduct.PaymentStatus = true; dashBoardProduct.PaidAmount = dashBoardProduct.PaidAmount + transactions[j].Transaction_amount; } } else { dashBoardProduct.PaymentStatus = true; } } int productId = Convert.ToInt32(orders[i].product_id); productsMaster product = db.productsMasters.Where(x => x.product_id == productId).FirstOrDefault(); dashBoardProduct.OrderId = orders[i].order_id; dashBoardProduct.BalanceAmount = product.product_price - dashBoardProduct.PaidAmount; dashBoardProduct.Details = product.product_details; dashBoardProduct.Cost = product.product_price; dashBoardProduct.Name = product.product_name; dashBoardProduct.Image = product.product_image; products.Add(dashBoardProduct); } else { continue; } } //products = (from order in orders // join pd in db.productsMasters on order.product_id equals pd.product_id // select new DashBoardProduct // { // Details=pd.product_details, // Cost=pd.product_price, // PaymentStatus= // } // ).ToList(); return(products); }