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