public IHttpActionResult PutEMIcard(int id, EMIcard eMIcard) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != eMIcard.EMIcard_id) { return(BadRequest()); } db.Entry(eMIcard).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!EMIcardExists(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 GetEMIcard(int id) { EMIcard eMIcard = db.EMIcards.Find(id); if (eMIcard == null) { return(NotFound()); } return(Ok(eMIcard)); }
public IHttpActionResult DeleteEMIcard(int id) { EMIcard eMIcard = db.EMIcards.Find(id); if (eMIcard == null) { return(NotFound()); } db.EMIcards.Remove(eMIcard); db.SaveChanges(); return(Ok(eMIcard)); }
// [Route("api/EMIinsert")] public IHttpActionResult PostEMIinsertion(Customer tempcustomer) { EMIcard temp = db.EMIcards.Where(x => x.customer_id == tempcustomer.customer_id).FirstOrDefault(); if (temp != null) { return(Ok(0)); } else { System.DateTime date = DateTime.Now; EMIcard emicard = new EMIcard(); var tempCustomerDetails = db.Customers.ToList(); CustomerCard a = new CustomerCard(); a = (from ab in tempCustomerDetails join ct in db.CardTypeMasters on ab.cardtype_id equals ct.EMIcardtype_id select new CustomerCard { customer_id = ab.customer_id, total_limit = ct.total_limit, EMIcard_validity = ct.EMIcard_validity } ).Where(x => x.customer_id == tempcustomer.customer_id).SingleOrDefault(); emicard.customer_id = a.customer_id; emicard.EMIcard_expiry = date.AddYears(a.EMIcard_validity); emicard.used_credit = 0; emicard.remaining_credit = a.total_limit; //int num = random.Next(1000); //Math.Floor((Math.random() * 100) + 1); Random random = new Random(); emicard.EMIcard_number = random.Next(1000000000, int.MaxValue); db.EMIcards.Add(emicard); db.SaveChanges(); } return(Ok(1)); }
public IHttpActionResult GetPayNowStatusByOrderId(int OrderId) { List <Transaction> transactions = new List <Transaction>(); transactions = db.Transactions.Where(x => x.order_id == OrderId).ToList(); if (transactions == null) { return(Ok(false)); } else { Transaction trans = transactions.Where(x => x.Transaction_status == false).FirstOrDefault(); trans.Transaction_status = true; trans.Payment_date = DateTime.Now; db.Entry(trans).State = EntityState.Modified; db.SaveChanges(); order tempOrder = db.orders.Where(x => x.order_id == OrderId).FirstOrDefault(); EMIcard emicard = db.EMIcards.Where(x => x.customer_id == tempOrder.customer_id).FirstOrDefault(); emicard.used_credit = emicard.used_credit - trans.Transaction_amount; emicard.remaining_credit = emicard.remaining_credit + trans.Transaction_amount; db.Entry(emicard).State = EntityState.Modified; db.SaveChanges(); int TransCount = transactions.Where(x => x.Transaction_status == false).ToList().Count; if (TransCount == 0) { tempOrder.order_status = true; db.Entry(tempOrder).State = EntityState.Modified; db.SaveChanges(); } return(Ok(true)); } //List<Transaction> transactions = new List<Transaction>(); //transactions = db.Transactions.Where(x => x.order_id == OrderId).ToList(); //if (transactions == null) //{ // return Ok(false); //} //else //{ // Transaction trans = transactions.Where(x => x.Transaction_status == false).FirstOrDefault(); // if (trans == null) // { // order tempOrder = db.orders.Where(x => x.order_id == OrderId).FirstOrDefault(); // tempOrder.order_status = true; // db.Entry(tempOrder).State = EntityState.Modified; // db.SaveChanges(); // } // else // { // trans.Transaction_status = true; // trans.Payment_date = DateTime.Now; // db.Entry(trans).State = EntityState.Modified; // db.SaveChanges(); // } // return Ok(true); //} }