public ActionResult DeleteConfirmed(int id) { if (Session["UserType"].ToString() == "Admin") { CustomerConsumingMoney customerConsumingMoney = db.CustomerConsumingMoneys.Find(id); db.CustomerConsumingMoneys.Remove(customerConsumingMoney); db.SaveChanges(); return(RedirectToAction("Index")); } else { return(RedirectToAction("../Home/LogIn")); } }
public ActionResult Edit(CustomerConsumingMoney customerConsumingMoney) { if (Session["UserType"].ToString() == "Admin") { if (ModelState.IsValid) { db.Entry(customerConsumingMoney).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.Month = new SelectList(db.MonthTbls, "MonthId", "Name", customerConsumingMoney.Month); ViewBag.CustomerId = new SelectList(db.Customers, "CustomerId", "Name", customerConsumingMoney.CustomerId); return(View(customerConsumingMoney)); } else { return(RedirectToAction("../Home/LogIn")); } }
// GET: CustomerConsumingMoneys/Details/5 public ActionResult Details(int?id) { if (Session["UserType"].ToString() == "Customer" || Session["UserType"].ToString() == "Admin") { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CustomerConsumingMoney customerConsumingMoney = db.CustomerConsumingMoneys.Find(id); if (customerConsumingMoney == null) { return(HttpNotFound()); } return(View(customerConsumingMoney)); } else { return(RedirectToAction("../Home/LogIn")); } }
// GET: CustomerConsumingMoneys/Edit/5 public ActionResult Edit(int?id) { if (Session["UserType"].ToString() == "Admin") { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CustomerConsumingMoney customerConsumingMoney = db.CustomerConsumingMoneys.Find(id); if (customerConsumingMoney == null) { return(HttpNotFound()); } ViewBag.Month = new SelectList(db.MonthTbls, "MonthId", "Name", customerConsumingMoney.Month); ViewBag.CustomerId = new SelectList(db.Customers, "CustomerId", "Name", customerConsumingMoney.CustomerId); return(View(customerConsumingMoney)); } else { return(RedirectToAction("../Home/LogIn")); } }
public ActionResult Create(CustomerPaidMoney customerPaidMoney) { if (Session["UserType"].ToString() == "Customer") { if (ModelState.IsValid) { ViewBag.Month = new SelectList(db.MonthTbls, "MonthId", "Name", customerPaidMoney.Month); ViewBag.CustomerId = new SelectList(db.Customers, "CustomerId", "Name", customerPaidMoney.CustomerId); CustomerConsumingMoney CCM = new CustomerConsumingMoney(); var customerMoneyInfoList = db.CustomerMonthlyPaids.Where(x => x.Month == customerPaidMoney.Month && x.CustomerId == customerPaidMoney.CustomerId).FirstOrDefault(); if (customerMoneyInfoList.ConsumeMoney > 0) { var cashBack = 0.0; var consumeMoney = 0.0; var serviceCharge = 0.0; var totalNeedToPaid = 0.0; var totalPaid = 0.0; consumeMoney = (double)customerMoneyInfoList.ConsumeMoney; cashBack = (double)customerMoneyInfoList.CashBack; serviceCharge = (double)customerMoneyInfoList.ServiceCharge; totalNeedToPaid = (consumeMoney + ((consumeMoney * serviceCharge) / 100)) - cashBack; var paidInfo = db.CustomerPaidMoneys.Where(x => x.Month == customerPaidMoney.Month && x.CustomerId == customerPaidMoney.CustomerId).ToList(); totalPaid = paidInfo.Select(x => x.PaidMoney).Sum(); var TotalwithcurrentPaid = customerPaidMoney.PaidMoney + totalPaid; if (customerMoneyInfoList.PaidStatus == "Paid") { ViewBag.error = "Dear Sir, you already Paid the bills"; return(View()); } else { if (TotalwithcurrentPaid > totalNeedToPaid) { ViewBag.error = "Dear Sir, you already Paid +" + TotalwithcurrentPaid + " taka. Now your available bill is " + (totalNeedToPaid - TotalwithcurrentPaid) + " taka."; return(View()); } else { db.CustomerPaidMoneys.Add(customerPaidMoney); db.SaveChanges(); //monthly paid table customerMoneyInfoList.PaidMoney = TotalwithcurrentPaid; if (TotalwithcurrentPaid == totalNeedToPaid) { customerMoneyInfoList.PaidStatus = "Paid"; } else { customerMoneyInfoList.PaidStatus = "Running"; } db.Entry(customerMoneyInfoList).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } } else { ViewBag.error = "Dear Sir, You have no bills"; return(View()); } } return(View(customerPaidMoney)); } else { return(RedirectToAction("../Home/LogIn")); } }
public ActionResult Create(CustomerConsumingMoney customerConsumingMoney) { if (Session["UserType"].ToString() == "Customer") { ViewBag.Month = new SelectList(db.MonthTbls, "MonthId", "Name", customerConsumingMoney.Month); ViewBag.CustomerId = new SelectList(db.Customers, "CustomerId", "Name", customerConsumingMoney.CustomerId); if (ModelState.IsValid) { var monthlyPaid = db.CustomerMonthlyPaids.Where(x => x.CustomerId == customerConsumingMoney.CustomerId && x.Month == customerConsumingMoney.Month).SingleOrDefault(); var TotalConsumeMoney = 0.0; var list = db.CustomerAssignMoneys.Where(x => x.ApplyingMonth == customerConsumingMoney.Month && x.CustomerId == customerConsumingMoney.CustomerId && x.ApplyingStatus == "Approved").ToList(); var ApplyMoney = 0; ApplyMoney = list.Select(x => x.Amount).Sum(); // Apply money if (ApplyMoney > 0) { var list2 = db.CustomerConsumingMoneys.Where(x => x.Month == customerConsumingMoney.Month && x.CustomerId == customerConsumingMoney.CustomerId).ToList(); var ConsumeMoney = list2.Select(x => x.ConsumeMoney).Sum(); //Used money TotalConsumeMoney = ConsumeMoney + customerConsumingMoney.ConsumeMoney; if (TotalConsumeMoney > ApplyMoney) { ViewBag.error = "Sorry,Out of Range.Your balance is " + ApplyMoney + " taka and you already used " + ConsumeMoney + " taka."; return(View()); } if (customerConsumingMoney.ConsumeMoney > ApplyMoney) { ViewBag.error = "Sorry,Out of Range.Your Current balance is " + ApplyMoney + " taka"; return(View()); } else { //TODO //var CashBack = customerConsumingMoney.CashBackMoney; //var witdraw = customerConsumingMoney.ConsumeMoney; //var cal = witdraw - ((witdraw* CashBack)/100); //customerConsumingMoney.TotalConsumeMoney = (double)cal; db.CustomerConsumingMoneys.Add(customerConsumingMoney); db.SaveChanges(); //Update Reward if (customerConsumingMoney.ConsumeMoney >= 100) { var reward = db.Rewards.Where(x => x.CustomerId == customerConsumingMoney.CustomerId).FirstOrDefault(); var Rw = db.Rewards.Where(x => x.RewardsId == reward.RewardsId).FirstOrDefault(); var beforRewardPoint = 0; var totalReward = 0.0; var beforeTotalAmount = 0.0; beforRewardPoint = reward.RewardsPoint; beforeTotalAmount = (double)reward.TotalAmount; totalReward = (customerConsumingMoney.ConsumeMoney / 50); Rw.RewardsPoint = (int)totalReward + beforRewardPoint; Rw.TotalAmount = customerConsumingMoney.ConsumeMoney + beforeTotalAmount; Rw.RewardDate = reward.RewardDate; db.Entry(Rw).State = EntityState.Modified; db.SaveChanges(); } //End //Customer Monthly paid var WitdrawMoney = 0.0; var TotalWitdrawMoney = 0.0; var CashBackMoney = 0.0; var cardType = Convert.ToInt32(Session["CardType"].ToString()); var monthlyData = db.CustomerMonthlyPaids.Where(x => x.Month == customerConsumingMoney.Month && x.CustomerId == customerConsumingMoney.CustomerId).ToList(); WitdrawMoney = (double)monthlyData.Select(x => x.ConsumeMoney).FirstOrDefault(); //Load from Monthly paid table then TotalWitdrawMoney = WitdrawMoney + customerConsumingMoney.ConsumeMoney; monthlyPaid.MonthlyPaidId = monthlyData.Select(x => x.MonthlyPaidId).FirstOrDefault(); monthlyPaid.CustomerId = customerConsumingMoney.CustomerId; var cardId = monthlyData.Select(x => x.CardNo).FirstOrDefault(); monthlyPaid.CardNo = cardId; monthlyPaid.Month = monthlyData.Select(x => x.Month).FirstOrDefault(); monthlyPaid.ApplyingMoney = monthlyData.Select(x => x.ApplyingMoney).FirstOrDefault(); monthlyPaid.ConsumeMoney = TotalWitdrawMoney; monthlyPaid.PaidMoney = monthlyData.Select(x => x.PaidMoney).FirstOrDefault(); var servicecarge = db.CardTypes.Where(x => x.CardId == cardType).Select(y => y.ServiceCharge).FirstOrDefault(); monthlyPaid.ServiceCharge = servicecarge; monthlyPaid.Fine = monthlyData.Select(x => x.Fine).FirstOrDefault(); //Rewards cash back if (monthlyData.Select(x => x.CashBack).FirstOrDefault() > 0) { CashBackMoney = (double)monthlyData.Select(x => x.CashBack).FirstOrDefault(); } monthlyPaid.CashBack = CashBackMoney; monthlyPaid.TotalBill = TotalWitdrawMoney; if (monthlyData.Select(x => x.PaidMoney).FirstOrDefault() == monthlyPaid.TotalBill) { var TotalBill = ((TotalWitdrawMoney) + ((TotalWitdrawMoney * servicecarge) / 100)) - CashBackMoney; monthlyPaid.TotalBill = TotalBill; monthlyPaid.PaidStatus = "Paid Successfully"; } else { monthlyPaid.PaidStatus = "Running"; } db.Entry(monthlyPaid).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } } else { ViewBag.error = "Sorry Sir, your balance is 0 taka. So you are not able to consume money."; return(View()); } } return(View(customerConsumingMoney)); } else { return(RedirectToAction("../Home/LogIn")); } }