public SPHAccount login(string name)
{
DbConnection.Instance().OpenConnection();
string sql = "select * from `account` where username = @name";
MySqlCommand msc = new MySqlCommand(sql, DbConnection.Instance().Connection);
msc.Parameters.AddWithValue("@name", name);
MySqlDataReader mdr = msc.ExecuteReader();
SPHAccount account = null;
if (mdr.Read())
{
account = new SPHAccount();
var accountNumber = mdr.GetString("accountNumber");
var name1 = mdr.GetString("username");
var password1 = mdr.GetString("password");
var fullname = mdr.GetString("fullname");
var balance = mdr.GetDecimal("balance");
var identity = mdr.GetString("identityCard");
var dob = mdr.GetString("dob");
var gender = mdr.GetInt32("gender");
var address = mdr.GetString("address");
var createAt = mdr.GetString("createAt");
var updateAt = mdr.GetString("updateAt");
var email = mdr.GetString("email");
var phoneNumber = mdr.GetString("phoneNumber");
var status = mdr.GetInt32("status");
}
DbConnection.Instance().CloseConnection();
return(account);
}
public Boolean save(SPHAccount account)
{
DbConnection.Instance().OpenConnection();
string sqlString =
"insert into `account`(username,password,fullname,accountNumber,balance,identityCard,dob,gender,address,createAt,updateAt,email,phoneNumber,status,salt)" +
" values (@name, @password, @fullname,@accountNumber,@balance,@identity,@dob,@gender,@address,@createAt,@updateAt,@email,@phoneNumber,@status,@salt)";
MySqlCommand mcd = new MySqlCommand(sqlString, DbConnection.Instance().Connection);
mcd.Parameters.AddWithValue("@name", account.Name);
mcd.Parameters.AddWithValue("@password", account.Password);
mcd.Parameters.AddWithValue("@fullname", account.Fullname);
mcd.Parameters.AddWithValue("@accountNumber", account.AccountNumber);
mcd.Parameters.AddWithValue("@balance", account.Balance);
mcd.Parameters.AddWithValue("@identity", account.Identity);
mcd.Parameters.AddWithValue("@dob", account.Dob);
mcd.Parameters.AddWithValue("@gender", account.Gender);
mcd.Parameters.AddWithValue("@address", account.Address);
mcd.Parameters.AddWithValue("@createAt", account.CreateAt);
mcd.Parameters.AddWithValue("@updateAt", account.UpdateAt);
mcd.Parameters.AddWithValue("@email", account.Email);
mcd.Parameters.AddWithValue("@phoneNumber", account.PhoneNumber);
mcd.Parameters.AddWithValue("@status", account.Status);
mcd.Parameters.AddWithValue("@salt", account.Salt);
mcd.ExecuteNonQuery();
DbConnection.Instance().CloseConnection();
return(true);
}
public void loginUser()
{
Console.WriteLine("Enter account infor.");
Console.WriteLine("Username: "******"Password: "******"ádas");
return;
}
//check password sau khi mã hóa
if (!account.CheckEncryptedPassword(password))
{
Console.WriteLine("Invalid account information.");
return;
}
Console.WriteLine("Login success!");
}
public bool Deposit(SPHAccount currentSphLoggedAccount, SPHTransation sphTransation)
{
DbConnection.Instance().OpenConnection();
var transaction = DbConnection.Instance().Connection.BeginTransaction();
try
{
var queryCheckBalance =
"select balance from `account` where accountNumber = @accountNumber and status = 1";
var command = new MySqlCommand(queryCheckBalance, DbConnection.Instance().Connection);
command.Parameters.AddWithValue("@accountNumber", Program.currentSphLoggedAccount.AccountNumber);
var reader = command.ExecuteReader();
decimal currentBalance = 0;
if (reader.Read())
{
currentBalance = reader.GetDecimal("balance");
}
if (sphTransation.Type == SPHTransation.TransactionType.WITHDRAW &&
currentBalance < sphTransation.Amount)
{
Console.WriteLine("Số dư tài khoản hiện");
}
if (sphTransation.Type == SPHTransation.TransactionType.WITHDRAW)
{
currentBalance -= sphTransation.Amount;
}
if (sphTransation.Type == SPHTransation.TransactionType.DEPOSIT)
{
currentBalance += sphTransation.Amount;
}
var updateCurrentBalance = 0;
var updateBalance =
"update `account` set balance =@balance where accountNumber =@accountNumber and status =1";
var updatecmd = new MySqlCommand(updateBalance, DbConnection.Instance().Connection);
updatecmd.Parameters.AddWithValue("@balance", currentBalance);
updatecmd.Parameters.AddWithValue("@accountNumber", Program.currentSphLoggedAccount.AccountNumber);
updateCurrentBalance = updatecmd.ExecuteNonQuery();
}
catch (Exception e)
{
transaction.Rollback();
throw;
}
finally
{
DbConnection.Instance().CloseConnection();
}
return(false);
}
public bool getInfoUser()
{
SPHAccount account = RegisterAccount();
Dictionary <string, string> errors = account.ValidateAccount();
if (errors.Count > 0)
{
foreach (var error in errors)
{
Console.WriteLine(error);
}
}
else
{
account.EncryptPassword();
model.save(account);
Console.WriteLine("create success");
return(true);
}
return(false);
}
public SPHAccount RegisterAccount()
{
Console.WriteLine("----------------REGISTER INFOMATION----------------");
Console.WriteLine("Nhap ten nguoi dung:");
var name = Console.ReadLine();
Console.WriteLine("Nhap password");
var password = Console.ReadLine();
Console.WriteLine("confirm password");
var cpassword = Console.ReadLine();
Console.WriteLine("Nhap ten day du cua ban:");
var fullname = Console.ReadLine();
Console.WriteLine("balance:");
var balance = utility.getDecimal();
Console.WriteLine("identity:");
var identity = Console.ReadLine();
Console.WriteLine("date of birth");
var dob = Console.ReadLine();
Console.WriteLine("gender");
var gender = utility.getNumber();
Console.WriteLine("address:");
var address = Console.ReadLine();
Console.WriteLine("creatAt:");
var createAt = Console.ReadLine();
Console.WriteLine("update At:");
var updateAt = Console.ReadLine();
Console.WriteLine("Email:");
var email = Console.ReadLine();
Console.WriteLine("phone:");
var phoneNumber = Console.ReadLine();
Console.WriteLine("status:");
var status = utility.getNumber();
var account = new SPHAccount
{
Name = name,
Password = password,
Cpasword = cpassword,
Fullname = fullname,
Balance = balance,
Identity = identity,
Dob = dob,
Gender = gender,
Address = address,
CreateAt = createAt,
UpdateAt = updateAt,
Email = email,
PhoneNumber = phoneNumber,
Status = status,
};
return(account);
}
