public ClaimsPrincipal CreateIdentity(Entity.Account account) { var claims = new List <Claim> { new Claim(ClaimTypes.Name, account.FullName, ClaimValueTypes.String), new Claim(ClaimTypes.NameIdentifier, account.Id.ToString(), ClaimValueTypes.String), new Claim(ClaimTypes.Email, account.Email, ClaimValueTypes.String), new Claim(ClaimTypes.Role, account.Role, ClaimValueTypes.String) }; return(new ClaimsPrincipal(new ClaimsIdentity(claims, "Cookies", "User", "Role"))); }
public void Setup() { Repository = new TransactionRepository(Context, new AccountRepository(Context), new CategoryRepository(Context), new SubCategoryRepository(Context), new TransactionTypeRepository(Context)); var user = new Entity.User() { FirstName = "test", LastName = "test", Email = "*****@*****.**", Phone = "123-123-1234" }; Context.Users.Add(user); Context.SaveChanges(); var account = new Entity.Account() { User = user.ID, Name = "test", Description = "test" }; Context.Accounts.Add(account); Context.SaveChanges(); var category = new Entity.Category() { User = user.ID, Name = "test", Description = "test" }; Context.Categories.Add(category); Context.SaveChanges(); var subCategory = new Entity.SubCategory() { User = user.ID, Category = category.ID, Name = "test", Description = "test" }; Context.SubCategories.Add(subCategory); Context.SaveChanges(); var type = new Entity.TransactionType() { Name = "test", Description = "test" }; Context.TransactionTypes.Add(type); Context.SaveChanges(); UserId = user.ID; AccountId = account.ID; CategoryId = category.ID; SubCategoryId = subCategory.ID; TransactionTypeId = type.ID; }
public Entity.Account GetByUsernamePassword(string username, string password) { string query = string.Format("SELECT UserTypeID FROM Account WHERE UserName='******' AND Password='******'", username, password); SqlDataReader reader = DataAccess.GetData(query); reader.Read(); Entity.Account account = null; if (reader.HasRows) { account = new Entity.Account(); account.UserTypeID = reader["UserTypeID"].ToString(); } else { MessageBox.Show("Wrong Username or Password!"); Application.Exit(); } return(account); }
public async Task <int> CreateAccount(int user, string name, string description) { var result = 0; var entity = new Entity.Account() { User = user, Name = name, Description = description }; Context.Accounts.Add(entity); if (await Context.SaveChangesAsync() > 0) { result = entity.ID; } return(result); }
public List <Entity.Account> GetAll() { string query = "SELECT AccountId, UserName, Password, FirstName, LastName, UserTypeID, Salary, JoinDate FROM Account"; SqlDataReader reader = DataAccess.GetData(query); Entity.Account account = null; List <Entity.Account> accountList = new List <Entity.Account>(); while (reader.Read()) { account = new Entity.Account(reader["AccountId"].ToString()); account.Username = reader["UserName"].ToString(); account.Password = reader["Password"].ToString(); account.FirstName = reader["FirstName"].ToString(); account.LastName = reader["LastName"].ToString();; account.UserTypeID = reader["UserTypeID"].ToString(); account.Salary = Convert.ToDouble(reader["UserTypeID"]); account.JoinDate = Convert.ToDateTime(reader["UserTypeID"]); accountList.Add(account); } return(accountList); }
public int Edit(Entity.Account account) { string query = string.Format("UPDATE Account SET UserName='******', Password='******', FirstName='" + account.FirstName + "', LastName='" + account.LastName + "', UserTypeID='" + account.UserTypeID + "', Salary='" + account.Salary + "', JoinDate='" + account.JoinDate + "' WHERE AccountId='{0}'", account.AccountID); return(DataAccess.ExecuteQuery(query)); }
public int Add(Entity.Account account) { string query = string.Format("INSERT INTO Account(AccountId, UserName, Password, FirstName, LastName, UserTypeID, Salary, JoinDate) VALUES('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', {6}, '{7}')", account.AccountID, account.Username, account.Password, account.FirstName, account.LastName, account.UserTypeID, account.Salary, account.JoinDate); return(DataAccess.ExecuteQuery(query)); }
public int Edit(Entity.Account account) { return(AccountService.accountDataAccess.Edit(account)); }
public int Add(Entity.Account account) { return(AccountService.accountDataAccess.Add(account)); }
// 确定事件 private void confirm_Click(object sender, RoutedEventArgs e) { //MessageBox.Show(time.Text); if (inout.Text == "" || acctype.Text == "" || time.Text == "" || money.Text == "" || content.Text == "") { MessageBox.Show("填写信息不完全,请完善!!!"); return; } int inoutValue; int acctypeValue; string timeValue; double moneyValue; string contentValue; // 可能存在输入数据的错误 try { inoutValue = Convert.ToInt32(inout.SelectedValue); acctypeValue = Convert.ToInt32(acctype.SelectedValue); timeValue = time.Text; moneyValue = Convert.ToDouble(money.Text); contentValue = Convert.ToString(content.Text); } catch (Exception ex) { MessageBox.Show("输入数据有错,请检查!!!"); return; } string[] tmp = timeValue.Split('-'); DateTime dat = new DateTime(Int32.Parse(tmp[0]), Int32.Parse(tmp[1]), Int32.Parse(tmp[2])); Entity.Account acc = new Entity.Account(helper.getUserId(currentUser), acctypeValue, inoutValue, moneyValue, contentValue, dat); if (helper.addAccountData(acc) == 1) { MessageBox.Show("插入成功!!!"); this.Close(); } else { MessageBox.Show("插入失败!!!"); } }