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