public ActionResult Create(LoanViewModel lvm)
{
GLobalClient cc = new GLobalClient();
if (lvm != null)
{
lo.ContactAddress = lvm.LoanModel.ContactAddress;
/*gte.Loans.Add(lo);
* gte.SaveChanges();
* int id = lo.ID;*/
cc.Create(lvm.LoanModel);
lvm.LoanModel.ID = ln.ID;
lvm.LoanModel.ID = 1;
lvm.LoanBankModel.Loan_Fk = lvm.LoanModel.ID;
lvm.LoanEmployeeModel.Loan_Fk = lvm.LoanModel.ID;
lvm.LoanSocialModel.Loan_Fk = lvm.LoanModel.ID;
cc.CreateBank(lvm.LoanBankModel);
cc.CreateLoanEmployee(lvm.LoanEmployeeModel);
cc.CreateSocail(lvm.LoanSocialModel);
using (GlobalTransactEntitiesData g = new GlobalTransactEntitiesData())
{
List <DataAccess.Loan> Loan = g.Loans.ToList();
}
TempData["Message"] = "Loan Application Succesful";
// return RedirectToAction("Apply");
}
else
{
TempData["Message"] = "loan Application Failed";
}
return(View("Apply", lvm));
}
public static string getReferralCodeWithMyOwnReferralcode(string myOwnRefferalcode, out int userfk)
{
userfk = 0;
string referralCode = "";
try
{
if (myOwnRefferalcode.Length == 0)
{
return(referralCode);
}
GlobalTransactEntitiesData db = new GlobalTransactEntitiesData();
var qry = db.Users
.Where(x => x.MyReferalCode == myOwnRefferalcode).ToList();
if (qry == null || qry.Count == 0)
{
return(referralCode);
}
referralCode = qry.FirstOrDefault().Referal;
userfk = qry.FirstOrDefault().id;
}
catch (Exception ex)
{
// WebLog.Log(ex.Message + "##", ex.StackTrace);
}
return(referralCode);
}
public static int getRefferalLevel(string referralCode)
{
int refLevel = 0;
try
{
if (referralCode.Length < 3)
{
return(refLevel);
}
GlobalTransactEntitiesData db = new GlobalTransactEntitiesData();
// PowerNowEntities pwr = new PowerNowEntities();
DataAccess.User user = new DataAccess.User();
var trx = db.Users.Where(x => x.Referal == referralCode).ToList();
if (trx == null || trx.Count == 0)
{
return(refLevel);
}
refLevel = 1;
User usrObj = new DataAccess.User();
usrObj = trx.FirstOrDefault();
trx = db.Users.Where(x => x.Referal == usrObj.MyReferalCode).ToList();
if (trx == null || trx.Count == 0)
{
return(refLevel);
}
refLevel = 2;
}
catch (Exception ex)
{
// WebLog.Log(ex.Message + "####", ex.StackTrace);
}
return(refLevel);
}
public static string getMyReferralcode(int userID, out int referraluserid)
{
string referralCode = "";
referraluserid = 0;
try
{
if (userID == 0)
{
return(referralCode);
}
// PowerNowEntities pwr = new PowerNowEntities();
GlobalTransactEntitiesData db = new GlobalTransactEntitiesData();
var qry = db.Users
.Where(x => x.id == userID).ToList();
if (qry == null || qry.Count == 0)
{
return(referralCode);
}
referralCode = qry.FirstOrDefault().Referal;
referraluserid = qry.FirstOrDefault().id;
}
catch (Exception ex)
{
// WebLog.Log(ex.Message + "##", ex.StackTrace);
}
return(referralCode);
}
public static int SaveWallet(TransactionLog tLog, string narration, int userID, double discountValue, double discountamount = 0)
{
int walletID = 0;
try
{
if (userID == 0)
{
return(walletID);
}
GlobalTransactEntitiesData pwr = new GlobalTransactEntitiesData();
var qry = pwr.CustomerWallets
.Where(x => x.RefNumber == tLog.ReferenceNumber && x.User_FK == userID).ToList();
if (qry == null || qry.Count == 0)
{
double walletPoint = Convert.ToDouble(tLog.Amount) * 0.01 * discountValue;
CustomerWallet cwObj = new CustomerWallet
{
Credit = discountamount == 0 ? walletPoint : discountamount,
CustomerID = tLog.CustomerID,
Debit = 0,
IsVisible = 1,
Narration = narration,
RefNumber = tLog.ReferenceNumber,
TrnDate = tLog.TrnDate,
User_FK = userID,
ValueDate = Utility.GetCurrentDateTime().ToString("yyyy/MM/dd")
};
pwr.CustomerWallets.Add(cwObj);
pwr.SaveChanges();
walletID = cwObj.ID;
// return cwObj.ID;
}
}
catch (Exception ex)
{
// WebLog.Log(ex.Message + "##", ex.StackTrace);
}
return(walletID);
}
