public static List <AppClient> GetAll(int currentPage, int pageSize, out int totalCount)
{
WealthTrackerIdentityDB db = new WealthTrackerIdentityDB();
db.Database.Connection.Open();
DbCommand cmd = db.Database.Connection.CreateCommand();
cmd.CommandText = "proc_AppClient_getAllPaged";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("currentPage", currentPage));
cmd.Parameters.Add(new SqlParameter("pageSize", pageSize));
var totalCountParam = new SqlParameter("totalCount", 0)
{
Direction = ParameterDirection.Output
};
cmd.Parameters.Add(totalCountParam);
List <AppClient> clients;
using (var reader = cmd.ExecuteReader())
{
clients = reader.MapToList <AppClient>();
}
//Access output variable after reader is closed
totalCount = (totalCountParam.Value == null) ? 0 : Convert.ToInt32(totalCountParam.Value);
return(clients);
}
public AuthRepository()
{
_ctx = new WealthTrackerIdentityDB();
_userManager = new UserManager <AppUser>(new UserStoreService());
_userManager.PasswordHasher = new MyPasswordHasher();
_userManager.UserValidator = new UserValidator <AppUser>(_userManager)
{
AllowOnlyAlphanumericUserNames = false
};
}
public static AppUser GetById(int id)
{
WealthTrackerIdentityDB db = new WealthTrackerIdentityDB();
db.Database.Connection.Open();
DbCommand cmd = db.Database.Connection.CreateCommand();
cmd.CommandText = "proc_Users_getById";
cmd.Parameters.Add(new SqlParameter("userId", id));
cmd.CommandType = System.Data.CommandType.StoredProcedure;
AppUser user;
using (var reader = cmd.ExecuteReader())
{
user = reader.MapToList <AppUser>()[0];
}
return(user);
}
public static decimal GetByUserIdAndYear(int clientID, int year)
{
WealthTrackerIdentityDB db = new WealthTrackerIdentityDB();
db.Database.Connection.Open();
DbCommand cmd = db.Database.Connection.CreateCommand();
cmd.CommandText = "proc_ProjectedData_GetByUserIdAndYear";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("userId", clientID));
cmd.Parameters.Add(new SqlParameter("year", year));
object result = cmd.ExecuteScalar();
if (result == null)
{
return(0);
}
else
{
return(decimal.Parse(result.ToString()));
}
}
