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