public ActionResult Create(Provider provider) { if (ModelState.IsValid) { db.Providers.Add(provider); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(provider)); }
public ActionResult Edit(WalletTransaction wallettransaction) { if (ModelState.IsValid) { db.Entry(wallettransaction).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "CustomerName", wallettransaction.CustomerID); return(View(wallettransaction)); }
public ActionResult Create(Commission commission) { if (ModelState.IsValid) { db.Commissions.Add(commission); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ProviderID = new SelectList(db.Providers, "ProviderID", "ProviderName", commission.ProviderID); return(View(commission)); }
public ActionResult Create(Recharge recharge) { if (ModelState.IsValid) { db.Recharges.Add(recharge); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "CustomerName", recharge.CustomerID); return(View(recharge)); }
public ActionResult Create(CashTransaction cashtransaction) { if (ModelState.IsValid) { var lastCashBalance = db.CashTransactions.Where(m => m.CustomerID == cashtransaction.CustomerID).OrderByDescending(m => m.CashTransactionID).FirstOrDefault().CashBalance; cashtransaction.CashBalance = (Convert.ToDecimal(cashtransaction.CashTransactionAmount) + Convert.ToDecimal(lastCashBalance)).ToString(); cashtransaction.CreatedDate = DateTime.Now.ToString(); db.CashTransactions.Add(cashtransaction); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "CustomerName", cashtransaction.CustomerID); return(View(cashtransaction)); }
public ActionResult Create(WalletTransaction wallettransaction) { if (ModelState.IsValid) { using (var dbUse = new RechargeEntities()) { var lastWalletBalance = dbUse.WalletTransactions.Where(m => m.CustomerID == wallettransaction.CustomerID).OrderByDescending(m => m.WalletTransactionID).FirstOrDefault().WalletBalance; wallettransaction.IsCredit = true; wallettransaction.CreatedDate = DateTime.Now.ToString(); wallettransaction.WalletTransactionReferenceDescription = "CashTransaction"; wallettransaction.WalletTransactionReferenceID = "0"; wallettransaction.WalletTransactionDescription = "Move cash to wallet"; wallettransaction.WalletBalance = (Convert.ToDecimal(wallettransaction.WalletTransactionAmount) + Convert.ToDecimal(lastWalletBalance)).ToString(); dbUse.WalletTransactions.Add(wallettransaction); var lastCashBalance = dbUse.CashTransactions.Where(m => m.CustomerID == wallettransaction.CustomerID).OrderByDescending(m => m.CashTransactionID).FirstOrDefault().CashBalance; CashTransaction cashtransaction = new CashTransaction(); cashtransaction.IsCredit = false; cashtransaction.CustomerID = wallettransaction.CustomerID; cashtransaction.CreatedDate = wallettransaction.CreatedDate; cashtransaction.CreatedBy = wallettransaction.CreatedBy; cashtransaction.CashTransactionReferenceID = wallettransaction.WalletTransactionID.ToString(); cashtransaction.CashTransactionReferenceDescription = "WalletTransaction"; cashtransaction.CashTransactionDescription = "Debit amount from cash transaction"; cashtransaction.CashTransactionAmount = wallettransaction.WalletTransactionAmount; cashtransaction.CashBalance = (Convert.ToDecimal(lastCashBalance) - Convert.ToDecimal(wallettransaction.WalletTransactionAmount)).ToString(); dbUse.CashTransactions.Add(cashtransaction); var updatedTransaction = dbUse.WalletTransactions.Find(wallettransaction.WalletTransactionID); updatedTransaction.WalletTransactionReferenceID = cashtransaction.CashTransactionID.ToString(); dbUse.SaveChanges(); } return(RedirectToAction("Index")); } ViewBag.CustomerID = new SelectList(db.Customers, "CustomerID", "CustomerName", wallettransaction.CustomerID); return(View(wallettransaction)); }
public ActionResult Create(Customer customer) { if (ModelState.IsValid) { // 1. Customer table entry customer.CreatedDate = DateTime.Now.ToString(); customer.LastModifiedDate = DateTime.Now.ToString(); db.Customers.Add(customer); var CustomerID = customer.CustomerID; // 2. Commission table entry var ProvidersList = db.Providers.ToList(); for (int i = 0; i < ProvidersList.Count; i++) { Commission objCommission = new Commission(); objCommission.CommissionPercentage = "1"; objCommission.CreatedBy = customer.CreatedBy; objCommission.CreatedDate = customer.CreatedDate; objCommission.CustomerID = CustomerID; objCommission.LastModifiedBy = customer.LastModifiedBy; objCommission.LastModifiedDate = customer.LastModifiedDate; objCommission.ProviderID = ProvidersList[i].ProviderID; db.Commissions.Add(objCommission); } // 3. CommissionTranaction table entry CommissionTransaction objCommissionTransaction = new CommissionTransaction(); objCommissionTransaction.CreatedBy = customer.CreatedBy; objCommissionTransaction.CreatedDate = customer.CreatedDate; objCommissionTransaction.CustomerID = CustomerID; objCommissionTransaction.CommissionBalance = "0"; objCommissionTransaction.CommissionTransactionAmount = "0"; objCommissionTransaction.CommissionTransactionDate = customer.CreatedDate; objCommissionTransaction.CommissionTransactionDescription = "Primary Entry"; objCommissionTransaction.CommissionTransactionReferenceDescription = "From customer creation entry"; objCommissionTransaction.CommissionTransactionReferenceID = CustomerID.ToString(); objCommissionTransaction.CreatedBy = customer.CreatedBy; objCommissionTransaction.CreatedDate = customer.CreatedDate; objCommissionTransaction.IsCredit = true; db.CommissionTransactions.Add(objCommissionTransaction); // 4. WalletTransaction table entry WalletTransaction objWalletTransaction = new WalletTransaction(); objWalletTransaction.CreatedBy = customer.CreatedBy; objWalletTransaction.CreatedDate = customer.CreatedDate; objWalletTransaction.CustomerID = CustomerID; objWalletTransaction.IsCredit = true; objWalletTransaction.WalletBalance = "0"; objWalletTransaction.WalletTransactionAmount = "0"; objWalletTransaction.WalletTransactionDate = customer.CreatedDate; objWalletTransaction.WalletTransactionDescription = "Primary Entry"; objWalletTransaction.WalletTransactionReferenceDescription = "From customer creation entry"; objWalletTransaction.WalletTransactionReferenceID = CustomerID.ToString(); db.WalletTransactions.Add(objWalletTransaction); // 5. CashTransaction table entry CashTransaction objCashTransaction = new CashTransaction(); objCashTransaction.CashBalance = "0"; objCashTransaction.CashTransactionAmount = "0"; objCashTransaction.CashTransactionDate = customer.CreatedDate; objCashTransaction.CashTransactionDescription = "Primary Entry"; objCashTransaction.CashTransactionReferenceDescription = "For customer creation entry"; objCashTransaction.CashTransactionReferenceID = CustomerID.ToString(); objCashTransaction.CreatedBy = customer.CreatedBy; objCashTransaction.CreatedDate = customer.CreatedDate; objCashTransaction.CustomerID = CustomerID; objCashTransaction.IsCredit = true; db.CashTransactions.Add(objCashTransaction); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(customer)); }
public ActionResult MoveProfitToBalanceFunction(TransferProfitToWallet objTransferProfitToWallet) { int CustomerID = Convert.ToInt32(objTransferProfitToWallet.CustomerID); RechargeEntities objRechargeEntities = new RechargeEntities(); try { // 3. Commission Tranction var LastCommissionBalanceAmount = objRechargeEntities.CommissionTransactions.OrderByDescending(n => n.CommissionTransactionID).Where(m => m.CustomerID == CustomerID).FirstOrDefault().CommissionBalance; CommissionTransaction objCommissionTransaction = new CommissionTransaction(); objCommissionTransaction.CustomerID = CustomerID; objCommissionTransaction.IsCredit = false; objCommissionTransaction.CommissionTransactionDate = objTransferProfitToWallet.DateAndTime; objCommissionTransaction.CommissionTransactionReferenceDescription = "CommissionTransaction"; objCommissionTransaction.CommissionTransactionID = 0; objCommissionTransaction.CommissionTransactionAmount = LastCommissionBalanceAmount; objCommissionTransaction.CommissionTransactionDescription = "Commission move to wallet"; objCommissionTransaction.CommissionBalance = "0"; objCommissionTransaction.CreatedDate = objTransferProfitToWallet.DateAndTime; objCommissionTransaction.CreatedBy = objTransferProfitToWallet.CreatedBy; objRechargeEntities.CommissionTransactions.Add(objCommissionTransaction); objRechargeEntities.SaveChanges(); var LastWalletBalanceAmount = objRechargeEntities.WalletTransactions.OrderByDescending(n => n.WalletTransactionID).Where(m => m.CustomerID == CustomerID).FirstOrDefault().WalletBalance; WalletTransaction objWalletTransaction = new WalletTransaction(); objWalletTransaction.CustomerID = CustomerID; objWalletTransaction.IsCredit = true; objWalletTransaction.WalletTransactionDate = objTransferProfitToWallet.DateAndTime; objWalletTransaction.WalletTransactionReferenceDescription = "CommissionTransaction"; objWalletTransaction.WalletTransactionReferenceID = objCommissionTransaction.CommissionTransactionID.ToString(); objWalletTransaction.WalletTransactionAmount = LastCommissionBalanceAmount; objWalletTransaction.WalletTransactionDescription = "Credit transaction move commision to wallet"; objWalletTransaction.WalletBalance = (Convert.ToDecimal(LastWalletBalanceAmount) + Convert.ToDecimal(LastCommissionBalanceAmount)).ToString(); objWalletTransaction.CreatedDate = objTransferProfitToWallet.DateAndTime; objWalletTransaction.CreatedBy = objTransferProfitToWallet.CreatedBy; objRechargeEntities.WalletTransactions.Add(objWalletTransaction); objRechargeEntities.SaveChanges(); LoginResponse objLoginResponse = new LoginResponse(); var WalletBalanceAmount = "0.00"; var ProfitBalanceAmount = "0.00"; WalletBalanceAmount = objRechargeEntities.WalletTransactions.OrderByDescending(n => n.WalletTransactionID).Where(m => m.CustomerID == CustomerID).FirstOrDefault().WalletBalance; WalletBalanceAmount = String.Format("{0:0.00}", Convert.ToDecimal(WalletBalanceAmount)); ProfitBalanceAmount = objRechargeEntities.CommissionTransactions.OrderByDescending(n => n.CommissionTransactionID).Where(m => m.CustomerID == CustomerID).FirstOrDefault().CommissionBalance; ProfitBalanceAmount = String.Format("{0:0.00}", Convert.ToDecimal(ProfitBalanceAmount)); objLoginResponse.CustomerID = CustomerID.ToString(); objLoginResponse.WalletBalance = WalletBalanceAmount; objLoginResponse.ProfitBalance = ProfitBalanceAmount; objLoginResponse.StatusDescription = "Commission moved to wallet"; return(Json(objLoginResponse, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(objTransferProfitToWallet, JsonRequestBehavior.AllowGet)); } }
public ActionResult RechargeFunction(DatasForRecharge objDatasForRecharge) { RechargeEntities objRechargeEntities = new RechargeEntities(); LoginResponse objLoginResponse = new LoginResponse(); int NetworkID = Convert.ToInt32(objDatasForRecharge.NetworkID); try { // 1. Recharge Table Entry Recharge newRecharge = new Recharge(); newRecharge.CustomerID = objDatasForRecharge.CustomerID; newRecharge.MobileNumber = objDatasForRecharge.MobileNumber; newRecharge.NetworkName = objDatasForRecharge.NetworkName; newRecharge.RechargeAmount = objDatasForRecharge.RechargeAmount; newRecharge.DateAndTime = objDatasForRecharge.DateAndTime; newRecharge.RechargeStatus = objDatasForRecharge.RechargeStatus; newRecharge.RechargeStatusDescription = objDatasForRecharge.RechargeStatusDescription; newRecharge.RechargeReferenceIDFromAPI = objDatasForRecharge.RechargeReferenceIDFromAPI; newRecharge.RechargeReferenceIDFromNetwork = objDatasForRecharge.RechargeReferenceIDFromNetwork; newRecharge.CreatedDate = objDatasForRecharge.CreatedDate; newRecharge.CreatedBy = objDatasForRecharge.CreatedBy; newRecharge.LastModifiedDate = objDatasForRecharge.LastModifiedDate; newRecharge.LastModifiedBy = objDatasForRecharge.LastModifiedBy; newRecharge.Profit = objDatasForRecharge.Profit; objRechargeEntities.Recharges.Add(newRecharge); objRechargeEntities.SaveChanges(); if (objDatasForRecharge.RechargeStatus.ToLower() != "failed") { // 2. Wallet Transaction var LastWalletBalanceAmount = objRechargeEntities.WalletTransactions.OrderByDescending(n => n.WalletTransactionID).Where(m => m.CustomerID == objDatasForRecharge.CustomerID).FirstOrDefault().WalletBalance; WalletTransaction objWalletTransaction = new WalletTransaction(); objWalletTransaction.CustomerID = objDatasForRecharge.CustomerID; objWalletTransaction.IsCredit = false; objWalletTransaction.WalletTransactionDate = objDatasForRecharge.DateAndTime; objWalletTransaction.WalletTransactionReferenceDescription = "Recharge"; objWalletTransaction.WalletTransactionReferenceID = newRecharge.RechargeID.ToString(); objWalletTransaction.WalletTransactionAmount = objDatasForRecharge.RechargeAmount; objWalletTransaction.WalletTransactionDescription = "Debit transaction for mobile recharge amount"; objWalletTransaction.WalletBalance = (Convert.ToDecimal(LastWalletBalanceAmount) - Convert.ToDecimal(objDatasForRecharge.RechargeAmount)).ToString(); objWalletTransaction.CreatedDate = objDatasForRecharge.DateAndTime; objWalletTransaction.CreatedBy = objDatasForRecharge.CreatedBy; objRechargeEntities.WalletTransactions.Add(objWalletTransaction); objRechargeEntities.SaveChanges(); // 3. Commission Tranction //var LastCommissionBalanceAmount = objRechargeEntities.CommissionTransactions.OrderByDescending(n => n.CommissionTransactionID).Where(m => m.CustomerID == objDatasForRecharge.CustomerID).FirstOrDefault().CommissionBalance; //var ThisRechargeCommisionPercentage = objRechargeEntities.Commissions.OrderByDescending(n => n.CommissionID).Where(m => m.CustomerID == objDatasForRecharge.CustomerID && m.ProviderID == NetworkID).FirstOrDefault().CommissionPercentage; //var ThisRechargeCommissionAmount = (Convert.ToDecimal(objDatasForRecharge.RechargeAmount) * Convert.ToDecimal(ThisRechargeCommisionPercentage)) / 100; //CommissionTransaction objCommissionTransaction = new CommissionTransaction(); //objCommissionTransaction.CustomerID = objDatasForRecharge.CustomerID; //objCommissionTransaction.IsCredit = true; //objCommissionTransaction.CommissionTransactionDate = objDatasForRecharge.DateAndTime; //objCommissionTransaction.CommissionTransactionReferenceDescription = "WalletTransaction"; //objCommissionTransaction.CommissionTransactionID = objWalletTransaction.WalletTransactionID; //objCommissionTransaction.CommissionTransactionAmount = ThisRechargeCommissionAmount.ToString(); //objCommissionTransaction.CommissionTransactionDescription = "Credit transaction for mobile recharge commission"; //objCommissionTransaction.CommissionBalance = (Convert.ToDecimal(LastCommissionBalanceAmount) + Convert.ToDecimal(ThisRechargeCommissionAmount)).ToString(); ; //objCommissionTransaction.CreatedDate = objDatasForRecharge.DateAndTime; //objCommissionTransaction.CreatedBy = objDatasForRecharge.CreatedBy; //objRechargeEntities.CommissionTransactions.Add(objCommissionTransaction); //objRechargeEntities.SaveChanges(); } var WalletBalanceAmount = "0.00"; var ProfitBalanceAmount = "0.00"; WalletBalanceAmount = objRechargeEntities.WalletTransactions.OrderByDescending(n => n.WalletTransactionID).Where(m => m.CustomerID == objDatasForRecharge.CustomerID).FirstOrDefault().WalletBalance; WalletBalanceAmount = String.Format("{0:0.00}", Convert.ToDecimal(WalletBalanceAmount)); //ProfitBalanceAmount = objRechargeEntities.CommissionTransactions.OrderByDescending(n => n.CommissionTransactionID).Where(m => m.CustomerID == objDatasForRecharge.CustomerID).FirstOrDefault().CommissionBalance; ProfitBalanceAmount = String.Format("{0:0.00}", Convert.ToDecimal(ProfitBalanceAmount)); objLoginResponse.CustomerID = objDatasForRecharge.CustomerID.ToString(); objLoginResponse.WalletBalance = WalletBalanceAmount; objLoginResponse.ProfitBalance = ProfitBalanceAmount; objLoginResponse.StatusDescription = objDatasForRecharge.RechargeStatusDescription; return(Json(objLoginResponse, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { var exceptionDetails = ex; objLoginResponse.CustomerID = "-99"; objLoginResponse.WalletBalance = ex.StackTrace; objLoginResponse.StatusDescription = ex.Message; //objLoginResponse.CustomerID = ex.InnerException bhjk; return(Json(objLoginResponse, JsonRequestBehavior.AllowGet)); } }