public static UserListResponse GetUserList(TodoListDBContext db, long userId)
{
UserListResponse response = new UserListResponse();
var list = from ul in db.UserList
join l in db.List
on ul.ListId equals l.Id
join lt in db.ListType
on l.Type equals lt.Id
where ul.UserId == userId &&
ul.Status == (byte)StatusType.Active &&
l.Status == (byte)StatusType.Active
select new List()
{
TypeName = lt.Name,
CreatedDate = l.CreatedDate,
Description = l.Description,
EndsAt = l.EndsAt,
Id = l.Id,
ModifierBy = l.ModifierBy,
OwnerBy = l.OwnerBy,
Priority = l.Priority,
StartsAt = l.StartsAt,
Status = l.Status,
Title = l.Title,
Type = l.Type,
UpdatedDate = l.UpdatedDate
};
response.List = list.ToList();
response.UserId = userId;
return(response);
}
public static bool CheckBasicAuth(TodoListDBContext db, StringValues authorizationToken, ref User user_ref)
{
if (!String.IsNullOrEmpty(authorizationToken.ToString()))
{
string[] decodedCredentials = Encoding.ASCII.GetString(Convert.FromBase64String(authorizationToken.ToString().Replace("Basic ", ""))).Split(new[] { ':' });
var encodePassword = EncodePassword(decodedCredentials[1]);
var user = db.User.FirstOrDefault(u => u.UserName == decodedCredentials[0] && u.Password == encodePassword && u.Status == (byte)StatusType.Active);
if (user == null)
{
return(false);
}
else
{
user_ref = user;
return(true);
}
}
return(false);
}
public TodoService(TodoListDBContext context)
{
_context = context;
}
public SubTaskRepository(TodoListDBContext context) : base(context)
{
}
public UserController(TodoListDBContext _db)
{
db = _db;
}
public Repository(TodoListDBContext context)
{
this.context = context;
entities = context.Set <T>();
}
public ListTypeController(TodoListDBContext _db)
{
db = _db;
}
public MsSqlController(TodoListDBContext dbContext)
{
_dbContext = dbContext;
}
