public bool Create(Account account, int[] competencey) { TeamUpContext db = new TeamUpContext(); List <Competence> listCompetences = new List <Competence>(); if (competencey != null) { foreach (var item in competencey) { listCompetences.Add(db.Competences.FirstOrDefault(c => c.CompetenceID == item)); } } account.Competences = listCompetences; if (GetOne(account.UserName) == null && GetOneEmail(account.Email) == null) { db.Accounts.Add(account); db.SaveChanges(); return(true); } else { return(false); } }
public Account GetOne(int id) { TeamUpContext db = new TeamUpContext(); Account account = new Account(); account = db.Accounts.FirstOrDefault(a => a.AccountID == id && a.isClose != true); return(account); }
public Account GetOne(string username) { TeamUpContext db = new TeamUpContext(); Account account = new Account(); account = db.Accounts.FirstOrDefault(a => a.UserName == username && a.isClose != true); return(account); }
public Account GetOneEmail(string email) { TeamUpContext db = new TeamUpContext(); Account account = new Account(); account = db.Accounts.FirstOrDefault(a => a.Email == email); return(account); }
public bool Create(TaskP task) { TeamUpContext dbTask = new TeamUpContext(); dbTask.Tasks.Add(task); dbTask.SaveChanges(); return(true); }
public void Save() { TeamUpContext db = new TeamUpContext(); Account account = new Account(); db.Accounts.Add(account); db.SaveChanges(); }
public void Update(TaskP task) { TeamUpContext dbTask = new TeamUpContext(); var taskDB = dbTask.Tasks.FirstOrDefault(x => x.TaskID == task.TaskID); taskDB.Name = task.Name; taskDB.DateClose = task.DateClose; taskDB.Description = task.Description; dbTask.SaveChanges(); }
public bool Delete(int Id) { TeamUpContext dbTask = new TeamUpContext(); var task = dbTask.Tasks.FirstOrDefault(x => x.TaskID == Id); if (task != null) { dbTask.Tasks.Remove(task); dbTask.SaveChanges(); return(true); } else { return(false); } }
public bool Delete(int id) { try { TeamUpContext db = new TeamUpContext(); var accountDelete = db.Accounts.First(x => x.AccountID == id); // db.Accounts.Remove(accountDelete); // db.Database.ExecuteSqlCommand("Delete from [CompetenceAccounts] where [UserName] = '" + accountDelete.UserName + "'"); accountDelete.isClose = true; db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool CloseOrOpen(int Id, bool CloseOrOpen) { TeamUpContext dbTask = new TeamUpContext(); TaskP task = new TaskP(); task = dbTask.Tasks.FirstOrDefault(x => x.TaskID == Id); if (task != null) { task.isClosed = CloseOrOpen; dbTask.SaveChanges(); return(true); } else { return(false); } }
public ProjetoRepository(TeamUpContext context) : base(context) { }
public List <Account> GetAll() { TeamUpContext db = new TeamUpContext(); return(db.Accounts.Where(x => x.isClose != true).ToList()); }
public CategoriaProjetoRepository(TeamUpContext context) : base(context) { }
public BaseController() { //Organizado dessa maneira para facilitar o eventual uso de dependency injection context = new TeamUpContext(); }
public VagaRepository(TeamUpContext context) : base(context) { }
public LoginService() { context = new TeamUpContext(); usuarioRepository = new UsuarioRepository(context); }
public bool Update(Account account) { try { TeamUpContext db = new TeamUpContext(); var dbAccount = db.Accounts.First(a => a.UserName == account.UserName); if (account.Avatar != null) { dbAccount.Avatar = account.Avatar; } if (account.DateOfBirth > new DateTime(1900, 01, 01)) { dbAccount.DateOfBirth = account.DateOfBirth; } if (account.UserName != null) { dbAccount.UserName = account.UserName; } if (account.Name != null) { dbAccount.Name = account.Name; } if (account.Surname != null) { dbAccount.Surname = account.Surname; } if (account.Email != null) { dbAccount.Email = account.Email; } if (account.Password != null) { dbAccount.Password = account.Password; } if (account.Competences != null) { db.Database.ExecuteSqlCommand("Delete from [CompetenceAccounts] where [UserName] = '" + account.UserName + "'"); List <Competence> listCompetences = new List <Competence>(); foreach (var item in account.Competences) { listCompetences.Add(db.Competences.FirstOrDefault(c => c.CompetenceID == item.CompetenceID)); } dbAccount.Competences = listCompetences; } db.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public BaseRepository(TeamUpContext context) { this.context = context; }
public UsuarioRepository(TeamUpContext context) : base(context) { }
public TaskP GetOne(int idSearch) { TeamUpContext dbTask = new TeamUpContext(); return(dbTask.Tasks.First(x => x.TaskID == idSearch)); }
public List <TaskP> GetAllFromProject(int projectID) { TeamUpContext dbTask = new TeamUpContext(); return(dbTask.Tasks.Where(x => x.ProjectID == projectID).ToList()); }
public List <TaskP> GetAll() { TeamUpContext dbTask = new TeamUpContext(); return(dbTask.Tasks.ToList()); }