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; }