public async Task <OperationResult <Entities.Task> > GetErrorAsync(LubyTasksHandler handler) { if (Id == 0) { return(new OperationResult <Entities.Task>(HttpStatusCode.BadRequest, $"Parameter {nameof(Id)} is required")); } if (!(await handler.LubyTasksContext.Tasks.AnyAsync(a => a.Id == Id))) { return(new OperationResult <Entities.Task>(HttpStatusCode.NotFound, $"Task with {nameof(Id)} {Id} was not found")); } if (string.IsNullOrWhiteSpace(Title)) { return(new OperationResult <Entities.Task>(HttpStatusCode.BadRequest, $"Parameter {nameof(Title)} is required")); } if (Title.Length > Convert.ToInt32(ELimitCaracteres.Sort)) { return(new OperationResult <Entities.Task>(HttpStatusCode.BadRequest, $"Parameter {nameof(Title)} must have a maximum of {Convert.ToInt32(ELimitCaracteres.Sort)} characters")); } if (!string.IsNullOrWhiteSpace(Description) && Description.Length > Convert.ToInt32(ELimitCaracteres.Long)) { return(new OperationResult <Entities.Task>(HttpStatusCode.BadRequest, $"Parameter {nameof(Description)} must have a maximum of {Convert.ToInt32(ELimitCaracteres.Long)} characters")); } return(await Task.FromResult <OperationResult <Entities.Task> >(null)); }
public async Task <OperationResult <User> > GetErrorAsync(LubyTasksHandler handler) { if (string.IsNullOrWhiteSpace(Name)) { return(new OperationResult <User>(HttpStatusCode.BadRequest, $"Parameter {nameof(Name) } is required")); } if (Name.Length > Convert.ToInt32(ELimitCaracteres.Sort)) { return(new OperationResult <User>(HttpStatusCode.BadRequest, $"Parameter {nameof(Name) } must have a maximum of {Convert.ToInt32(ELimitCaracteres.Sort)} caracteres")); } if (string.IsNullOrWhiteSpace(Login)) { return(new OperationResult <User>(HttpStatusCode.BadRequest, $"Parameter {nameof(Login) } is required")); } if (await handler.LubyTasksContext.Users.AnyAsync(u => u.Login == Login)) { return(new OperationResult <User>(HttpStatusCode.Conflict, $"{nameof(Login) } {Login} already exists")); } if (string.IsNullOrWhiteSpace(Password)) { return(new OperationResult <User>(HttpStatusCode.BadRequest, $"Parameter {nameof(Password) } is required")); } return(await Task.FromResult <OperationResult <User> >(null)); }
public async Task <OperationResult <User> > GetErrorAsync(LubyTasksHandler handler) { if (string.IsNullOrEmpty(handler.CurrentUser.Login)) { return(new OperationResult <User>(HttpStatusCode.Unauthorized, $"There's no opened session. Please, get the token and try again")); } if (!(await handler.LubyTasksContext.Users.AnyAsync(u => u.Password == Password.GetSHA512() && u.Login == handler.CurrentUser.Login))) { return(new OperationResult <User>(HttpStatusCode.BadRequest, $"User with wrong {nameof(Password)}")); } if (string.IsNullOrWhiteSpace(Name)) { return(new OperationResult <User>(HttpStatusCode.BadRequest, $"Parameter {nameof(Name) } is required")); } if (Name.Length > Convert.ToInt32(ELimitCaracteres.Sort)) { return(new OperationResult <User>(HttpStatusCode.BadRequest, $"Parameter {nameof(Name) } must be only {Convert.ToInt32(ELimitCaracteres.Sort)} caracteres")); } if (string.IsNullOrWhiteSpace(Login)) { return(new OperationResult <User>(HttpStatusCode.BadRequest, $"Parameter {nameof(Login)} is required")); } if (Login.Length > Convert.ToInt32(ELimitCaracteres.Login)) { return(new OperationResult <User>(HttpStatusCode.BadRequest, $"Parameter {nameof(Login) } must be only {Convert.ToInt32(ELimitCaracteres.Login)} caracteres")); } return(await Task.FromResult <OperationResult <User> >(null)); }
public async Task <OperationResult <User> > GetErrorAsync(LubyTasksHandler handler) { if (string.IsNullOrWhiteSpace(handler.CurrentUser.Login)) { return(new OperationResult <User>(HttpStatusCode.Unauthorized, $"There's no opened session. Please, get the token and try again")); } return(await Task.FromResult <OperationResult <User> >(null)); }
public async Task <OperationResult <User> > ExecuteOperationAsync(LubyTasksHandler handler) { var user = await handler.LubyTasksContext.Users.FirstOrDefaultAsync(u => u.Id == handler.CurrentUser.Id); user.SetData(Name, Login); var result = await handler.LubyTasksContext.SaveChangesAsync(); return(new OperationResult <User>(HttpStatusCode.OK, result)); }
public async Task <OperationResult <Entities.Task> > ExecuteOperationAsync(LubyTasksHandler handler) { var task = await handler.LubyTasksContext.Tasks .FirstOrDefaultAsync(a => a.Id == Id); task.Remove(); var result = await handler.LubyTasksContext.SaveChangesAsync(); return(new OperationResult <Entities.Task>(HttpStatusCode.OK, result)); }
public async Task<OperationResult<Entities.Task>> ExecuteOperationAsync(LubyTasksHandler handler) { var task = await handler.LubyTasksContext.Tasks .FirstOrDefaultAsync(t => t.Id == Id); task.Concluded = Concluded.Value; var result = await handler.LubyTasksContext.SaveChangesAsync(); return new OperationResult<Entities.Task>(HttpStatusCode.OK, result); }
public async Task <OperationResult <User> > ExecuteOperationAsync(LubyTasksHandler handler) { var user = await handler.LubyTasksContext.Users .Where(u => u.Id == handler.CurrentUser.Id) .Include(u => u.Tasks) .FirstOrDefaultAsync(); user.Remove(); var result = await handler.LubyTasksContext.SaveChangesAsync(); return(new OperationResult <User>(HttpStatusCode.OK, result)); }
public async Task<OperationResult<Entities.Task>> GetErrorAsync(LubyTasksHandler handler) { if (Id == 0) return new OperationResult<Entities.Task>(HttpStatusCode.BadRequest, $"Parameter {nameof(Id)} is required"); if (!Concluded.HasValue) return new OperationResult<Entities.Task>(HttpStatusCode.BadRequest, $"Parameter {nameof(Concluded)} is required"); if (!(await handler.LubyTasksContext.Tasks.AnyAsync(a => a.Id == Id))) return new OperationResult<Entities.Task>(HttpStatusCode.NotFound, $"Task with {nameof(Id)} {Id} was not found"); return await Task.FromResult<OperationResult<Entities.Task>>(null); }
public async Task <OperationResult <User> > ExecuteOperationAsync(LubyTasksHandler handler) { var sql = @" select u.id, u.name, u.login from users u where u.id=@CurrentUserId and u.removed=0 "; var conn = handler.LubyTasksContext.Database.GetDbConnection(); var result = await conn.QueryAsync <User>(sql, new { CurrentUserId = handler.CurrentUser.Id }); return(new OperationResult <User>(HttpStatusCode.OK, result)); }
public async Task <OperationResult <CredentialUser> > GetErrorAsync(LubyTasksHandler handler) { if (string.IsNullOrWhiteSpace(Login)) { return(new OperationResult <CredentialUser>(HttpStatusCode.BadRequest, $"Parameter {nameof(Login) } is null or empty")); } if (string.IsNullOrWhiteSpace(Password)) { return(new OperationResult <CredentialUser>(HttpStatusCode.BadRequest, $"Parameter {nameof(Password) } is null or empty")); } return(await System.Threading.Tasks.Task.FromResult <OperationResult <CredentialUser> >(null)); }
public async Task <OperationResult <Entities.Task> > ExecuteOperationAsync(LubyTasksHandler handler) { var task = new Entities.Task() { Title = Title, Description = Description, UserId = handler.CurrentUser.Id }; handler.LubyTasksContext.Tasks.Add(task); var result = await handler.LubyTasksContext.SaveChangesAsync(); return(new OperationResult <Entities.Task>(HttpStatusCode.Created, result)); }
public async Task <OperationResult <User> > ExecuteOperationAsync(LubyTasksHandler handler) { var user = new User { Name = Name, Login = Login, Password = Password.GetSHA512() }; handler.LubyTasksContext.Users.Add(user); var result = await handler.LubyTasksContext.SaveChangesAsync(); return(new OperationResult <User>(HttpStatusCode.Created, result)); }
public async Task <OperationResult <Entities.Task> > GetErrorAsync(LubyTasksHandler handler) { if (Id == 0) { return(new OperationResult <Entities.Task>(HttpStatusCode.BadRequest, $"Parameter {nameof(Id)} is required")); } var exists = await handler.LubyTasksContext.Tasks.AnyAsync(a => a.Id == Id); if (!exists) { return(new OperationResult <Entities.Task>(HttpStatusCode.NotFound, $"Task with {nameof(Id)} = {Id} was not found")); } return(await Task.FromResult <OperationResult <Entities.Task> >(null)); }
public async Task <OperationResult <CredentialUser> > ExecuteOperationAsync(LubyTasksHandler handler) { var sql = @" select u.id, u.login, u.password from users u where u.login=@Login and u.password=@Password and u.removed=0 "; var conn = handler.LubyTasksContext.Database.GetDbConnection(); var result = await conn.QueryAsync <CredentialUser>(sql, new { Login, Password = Password.GetSHA512() }); if (result.Count() == 0) { return(new OperationResult <CredentialUser>(HttpStatusCode.Unauthorized, result)); } return(new OperationResult <CredentialUser>(HttpStatusCode.Created, result)); }
public async Task <OperationResult <TaskVW> > ExecuteOperationAsync(LubyTasksHandler handler) { var sql = @" select a.id, a.title, a.description, a.concluded, a.create_date, u.id, u.name from tasks a inner join users u on (u.id=a.id_user) where a.removed=0 and u.id=@CurrentUserId "; var conn = handler.LubyTasksContext.Database.GetDbConnection(); var result = await conn.QueryAsync <TaskVW, User, TaskVW>(sql, (action, user) => { action.User = user; return(action); }, new { CurrentUserId = handler.CurrentUser.Id }, splitOn : "id" ); return(new OperationResult <TaskVW>(HttpStatusCode.OK, result)); }
public async Task <OperationResult <Entities.Task> > GetErrorAsync(LubyTasksHandler handler) { if (handler.CurrentUser.Id == 0) { return(new OperationResult <Entities.Task>(HttpStatusCode.Unauthorized, $"There's no opened session. Please, get the token and try again")); } if (string.IsNullOrWhiteSpace(Title)) { return(new OperationResult <Entities.Task>(HttpStatusCode.BadRequest, $"Parameter {nameof(Title)} is required")); } if (Title.Length > Convert.ToInt32(ELimitCaracteres.Sort)) { return(new OperationResult <Entities.Task>(HttpStatusCode.BadRequest, $"Parameter {nameof(Title)} must have a maximum of {Convert.ToInt32(ELimitCaracteres.Sort)} characters")); } if (!string.IsNullOrWhiteSpace(Description) && Description.Length > Convert.ToInt32(ELimitCaracteres.Long)) { return(new OperationResult <Entities.Task>(HttpStatusCode.BadRequest, $"Parameter {nameof(Description)} must have a maximum of {Convert.ToInt32(ELimitCaracteres.Long)} characters")); } return(await Task.FromResult <OperationResult <Entities.Task> >(null)); }
public async Task <OperationResult <TaskVW> > GetErrorAsync(LubyTasksHandler handler) { return(await Task.FromResult <OperationResult <TaskVW> >(null)); }
public AuthController(LubyTasksHandler handler) { _lubyTasksHandler = handler; }
public UsersController(LubyTasksHandler handler) { _lubyTasksHandler = handler; }