protected void SubmitBtn_Click(object sender, EventArgs e)
{
string uname = (string)Session["Logged"];
string pass = (string)Session["lPwd"];
int aid = (int)Session["accId"];
AccountsBLL user = new AccountsBLL();
AccountsDAL a = user.retrieveUser(uname, pass);
BuyerBLL buyer = new BuyerBLL();
BuyerDAL b = buyer.retrieveFinPlan(aid);
string mainName = b.MainApplicantName;
decimal mainSalary = b.MainApplicantSalary;
string coName = b.CoApplicantName;
decimal coSalary = b.CoApplicantSalary;
decimal totSavings = b.totalSavings;
decimal upfrontPayment = b.upfrontPaymentBudget;
int loanServicePeriod = b.loanServicingPeriod;
string useCpf = b.userCpfToService;
decimal ab1 = decimal.Parse(theTotalSavings.Text);
decimal ac1 = decimal.Parse(theUpfrontPaymentBudget.Text.Trim());
decimal asd = ab1 + ac1;
decimal asdf = asd - (asd * 0.8m) + (asd * 0.0275m);
Label1.Text = "Recommended Bufget: S$ " + asdf;
}
//Membership and Roles management related functionality
public static bool Validate(string userName, string password)
{
bool status = false;
status = AccountsDAL.Validate(userName, password);
return(status);
}
public string retrieveAccType(string accType)
{
AccountsDAL p = new AccountsDAL();
AccountsDAL p2 = p.retrieveAccType(accType);
return(p.accType);
}
protected void Page_Load(object sender, EventArgs e)
{
string username = (string)Session["Logged"];
string pass = (string)Session["lPwd"];
int aid = (int)Session["accId"];
AccountsBLL user = new AccountsBLL();
AccountsDAL p = user.retrieveUser(username, pass);
string name = p.fullName;
theName.Text = name;
//Page lastPage = (Page)Context.Handler;
//string asd = ((TextBox)lastPage.FindControl("loginTextbox")).Text;
//SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MYDBConnection"].ConnectionString);
//conn.Open();
//SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM Accounts WHERE userName ='******'", conn);
//DataTable dt = new DataTable();
//sda.Fill(dt);
//name = dt.Rows[0][3].ToString();
//theName.Text = name;
}
public void CreateABL(Accounts newAccount)
{
// Call the DAL to create a new record.
AccountsDAL accountDAL = new AccountsDAL();
accountDAL.CreateADAL(newAccount);
}
public AccountsDAL retrieveUser(string username, string password)
{
AccountsDAL p = new AccountsDAL();
AccountsDAL p2 = p.retrieveUser(username, password);
return(p2);
}
public static Accounts CloseAccount(int userID, int accID)
{
AccountsDAL dal = new AccountsDAL();
var account = dal.CloseAccount(userID, accID);
return(null);
}
public static Accounts AddTransaction(int userID, int accID, string transaction)
{
AccountsDAL dal = new AccountsDAL();
var account = dal.AddTransaction(userID, accID, transaction);
return(account);
}
public static Accounts UpdateBalance(int userID, int accID, double balance)
{
AccountsDAL dal = new AccountsDAL();
var account = dal.UpdateBalance(userID, accID, balance);
return(account);
}
public static List <Accounts> GetAll(int userID)
{
AccountsDAL dal = new AccountsDAL();
var account = dal.GetAll(userID);
return(account);
}
public static Accounts Get(int userID, int accID)
{
AccountsDAL dal = new AccountsDAL();
var account = dal.Get(userID, accID);
return(account);
}
protected void Page_Load(object sender, EventArgs e)
{
string uname = (string)Session["Logged"];
string pass = (string)Session["lPwd"];
int aid = (int)Session["accId"];
AccountsBLL user = new AccountsBLL();
AccountsDAL a = user.retrieveUser(uname, pass);
string fullname = a.fullName;
string mobile = a.mobile;
string email = a.email;
string address = a.address;
BuyerBLL buyer = new BuyerBLL();
BuyerDAL b = buyer.retrieveFinPlan(aid);
string mainName = b.MainApplicantName;
decimal mainSalary = b.MainApplicantSalary;
string coName = b.CoApplicantName;
decimal coSalary = b.CoApplicantSalary;
decimal totSavings = b.totalSavings;
decimal upfrontPayment = b.upfrontPaymentBudget;
int loanServicePeriod = b.loanServicingPeriod;
string useCpf = b.userCpfToService;
UserName.Text = fullname;
Mobile.Text = mobile;
Email.Text = email;
Address.Text = address;
theMainApplicantName.Text = mainName;
theMainApplicantSalary.Text = mainSalary.ToString();
theCoApplicantName.Text = coName;
theCoApplicantSalary.Text = coSalary.ToString();
theTotalSavings.Text = totSavings.ToString();
theUpfrontPaymentBudget.Text = upfrontPayment.ToString();
theLoanServicePeriod.Text = loanServicePeriod.ToString();
//Page lastPage = (Page)Context.Handler;
//string asd = ((TextBox)lastPage.FindControl("loginTextbox")).Text;
//SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MYDBConnection"].ConnectionString);
//conn.Open();
//SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM Accounts WHERE userName ='******'", conn);
//DataTable dt = new DataTable();
//sda.Fill(dt);
//name1 = dt.Rows[0][3].ToString();
//theName.Text = name1;
}
public IActionResult Get(string phonenumber, string token)
{
if (!UserAuthDAL.VerifyToken(phonenumber, token))
{
return(Unauthorized());
}
var transactions = AccountsDAL.GetAccounts(phonenumber);
return(Ok(transactions));
}
public bool retrieveUserByLogin(string username, string password)
{
bool result = false;
AccountsDAL p = new AccountsDAL();
AccountsDAL p2 = p.retrieveUser(username, password);
if (p2 != null)
{
result = true;
}
return(result);
}
public bool createUser(int accId, string uName, string pwd, string fullNm, string mobileNo, string emailAdd, string add, string accountType)
{
bool result = false;
// string passwordHash = generatePasswordHash(password, salt);
AccountsDAL user = new AccountsDAL();
if (user.createUser(accId, uName, pwd, fullNm, mobileNo, emailAdd, add, accountType) == 1)
{
result = true;
}
else
{
result = false;
}
return(result);
}
/// <summary>
/// Method to Update Payments
/// </summary>
/// <param name="arglist">List of Accounts Entity is the Input.ChequeNo,ChequeDate,Updateby and UpdatedTime are Input Properties</param>
/// <returns>Returns Boolean.</returns>
public bool UpdatePayments(List <AccountsEn> arglist)
{
AccountsDAL lods = new AccountsDAL();
bool lbRes = false;
string sqlCmd;
try
{
int j = 0;
for (j = 0; j < arglist.Count; j++)
{
sqlCmd = "UPDATE SAS_Accounts SET ChequeNo = @ChequeNo,ChequeDate = @ChequeDate, UpdatedBy = @UpdatedBy, UpdatedTime = @UpdatedTime WHERE TransCode = '" + arglist[j].TransactionCode + "'";
if (!FormHelp.IsBlank(sqlCmd))
{
DbCommand cmd = _DatabaseFactory.GetDbCommand(Helper.GetDataBaseType, sqlCmd, DataBaseConnectionString);
_DatabaseFactory.AddInParameter(ref cmd, "@ChequeNo", DbType.String, arglist[j].ChequeNo);
_DatabaseFactory.AddInParameter(ref cmd, "@ChequeDate", DbType.DateTime, arglist[j].ChequeDate);
_DatabaseFactory.AddInParameter(ref cmd, "@UpdatedBy", DbType.String, arglist[j].UpdatedBy);
_DatabaseFactory.AddInParameter(ref cmd, "@UpdatedTime", DbType.DateTime, arglist[j].UpdatedTime);
_DbParameterCollection = cmd.Parameters;
int liRowAffected = _DatabaseFactory.ExecuteNonQuery(Helper.GetDataBaseType, cmd,
DataBaseConnectionString, sqlCmd, _DbParameterCollection);
if (liRowAffected > -1)
{
lbRes = true;
}
else
{
throw new Exception("Update Failed! No Row has been updated...");
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lbRes);
}
public IActionResult Post([FromBody] Account account)
{
AccountsDAL.AddAccount(account);
return(Ok());
}
protected void SignInBtn_Click(object sender, EventArgs e)
{
string username = loginTextbox.Text.Trim();
string password = passwordTextBox.Text.Trim();
AccountsBLL user = new AccountsBLL();
AccountsDAL p = user.retrieveUser(username, password);
string accType = p.accType;
int accId = p.AccountID;
if (user.retrieveUserByLogin(username, password) == true)
{
Session["Logged"] = username;
Session["lPwd"] = password;
Session["accId"] = accId;
if (accType.Equals("Buyer"))
{
Response.Redirect("index.aspx");
}
else if (accType.Equals("Reseller"))
{
Response.Redirect("reseller.aspx");
}
else if (accType.Equals("Banker"))
{
Response.Redirect("bankerIndex.aspx");
}
}
else
{
Response.Write("<script>alert('Please enter valid Username and Password')</script>");
}
//SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["MYDBConnection"].ConnectionString);
//conn.Open();
//SqlDataAdapter sda = new SqlDataAdapter("SELECT * FROM Accounts WHERE userName ='******' AND password = '******'" , conn);
//SqlDataAdapter sdaa = new SqlDataAdapter("SELECT * FROM Accounts WHERE accType ='Buyer'", conn);
//DataTable dt = new System.Data.DataTable();
//sda.Fill(dt);
//if(dt.Rows.Count == 1 )
//{
// utype = dt.Rows[0][7].ToString();
// if (utype == "Buyer")
// {
// Server.Transfer("index.aspx");
// }
// else if (utype == "Reseller")
// {
// Server.Transfer("reseller.aspx");
// }
// else if (utype == "Banker")
// {
// Server.Transfer("bankerIndex.aspx");
// }
//}
//else
//{
// Response.Write("<script>alert('Please enter valid Username and Password')</script>");
//}
//conn.Close();
}
