public List <Role> ListRoles() { AccountEntities db = new AccountEntities(); var lstRole = db.Roles.ToList(); return(lstRole); }
public bool CheckAccount(AccountEntity account) { AccountEntities db = new AccountEntities(); //int count = db.Accounts.Where(u => u.AccountName == txtUserName && u.AccountPassword == txtPassword).Count(); string query = "Select count(*) as count from [User] where UserName = @username and Password = @password"; int count = db.Database.SqlQuery <int>(query, new SqlParameter("username", account.AccountName), new SqlParameter("password", account.AccountPass)).FirstOrDefault(); if (count == 0) { return(false); } else { return(true); } }
public bool AddAccount(AccountEntity account) { AccountEntities db = new AccountEntities(); string query = "EXEC InsertIntoAccount @Name = @accountname, @Password = @accountpass"; try { db.Database.ExecuteSqlCommand(query, new SqlParameter("accountname", account.AccountName), new SqlParameter("accountpass", account.AccountPass)); int user_id = db.Users.Where(u => u.UserName == account.AccountName && u.Password == account.AccountPass).Select(u => u.ID).FirstOrDefault(); string query2 = "Insert into [RoleUser] values (@role_id, @user_id)"; db.Database.ExecuteSqlCommand(query2, new SqlParameter("role_id", account.Role_ID), new SqlParameter("user_id", user_id)); } catch (Exception e) { return(false); } return(true); }