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