public List <BaseUser> GetUsers()
{
List <BaseUser> users = new List <BaseUser>();
var connectionString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
using (var connection = new SqlConnection(connectionString))
{
var command = new SqlCommand
{
Connection = connection,
CommandType = CommandType.StoredProcedure,
CommandText = "usp_GetUsers"
};
connection.Open();
var reader = command.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
Int64 roleInt = reader.GetInt64(4);
UserTypeDataAccess ut = new UserTypeDataAccess();
MenuVoicesDataAccess mt = new MenuVoicesDataAccess();
Role role = ut.GetRoleById(roleInt);
List <MenuBarVoices> menu = mt.GetMenuVoicesByMenuId(reader.GetInt64(6));
role.Menu = menu;
Store store = new Store();
store.Id = reader.GetInt64(9);
store.Name = reader.GetString(10);
Department department = new Department();
department.Id = reader.GetInt64(11);
department.Name = reader.GetString(12);
ClientUser user = new ClientUser();
user.Id = reader.GetInt64(0);
user.Firstname = reader.GetString(1);
user.Surname = reader.GetString(2);
user.Email = reader.GetString(3);
user.Username = reader.GetString(8);
user.IsActive = reader.GetBoolean(7);
user.Role = role;
user.Store = store;
user.Department = department;
users.Add(user);
}
}
return(users);
}
public BaseUser GetUser(string username, string password)
{
BaseUser user = null;
var connectionString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
using (var connection = new SqlConnection(connectionString))
{
var command = new SqlCommand
{
Connection = connection,
CommandType = CommandType.StoredProcedure,
CommandText = "usp_GetUser"
};
var parameterUsername = new SqlParameter("@username", SqlDbType.VarChar)
{
Value = username
};
var parameterPassword = new SqlParameter("@password", SqlDbType.VarChar)
{
Value = password
};
command.Parameters.Add(parameterUsername);
command.Parameters.Add(parameterPassword);
connection.Open();
var reader = command.ExecuteReader(CommandBehavior.CloseConnection);
if (reader.Read())
{
Int64 roleInt = reader.GetInt64(4);
UserTypeDataAccess ut = new UserTypeDataAccess();
MenuVoicesDataAccess mt = new MenuVoicesDataAccess();
Role role = ut.GetRoleById(roleInt);
Store store = new Store();
store.Id = reader.GetInt64(7);
store.Name = reader.GetString(8);
Department department = new Department();
department.Id = reader.GetInt64(9);
department.Name = reader.GetString(10);
List <MenuBarVoices> menu = mt.GetMenuVoicesByMenuId(reader.GetInt64(6));
role.Menu = menu;
user = UserFactory.getUser(role);
user.Id = reader.GetInt64(0);
user.Firstname = reader.GetString(1);
user.Surname = reader.GetString(2);
user.Email = reader.GetString(3);
user.Username = username;
user.Password = password;
user.Role = role;
user.Store = store;
user.Department = department;
user.IsPasswordRecovered = reader.GetBoolean(11);
}
}
return(user);
}
