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