public static IColaboratorService Create()
{
IUnityOfWork unityOfWork = new UnityOfWork();
IColaboratorRepository colaboratorRepository = new ColaboratorRepository(unityOfWork as UnityOfWork);
return new ColaboratorService(colaboratorRepository);
}
public void Repository_Can_InsertAsync()
{
using (var context = new InMemoryContext())
using (IRepository <TabelaTesteWithGuidKey, Guid> repository = new TabelaTesteWithGuidKeyRepository(context, GetUserContextService()))
{
var uow = new UnityOfWork(context, Substitute.For <ILogProvider>());
var result = repository.AddOrUpdateAsync(new TabelaTesteWithGuidKey()
{
Propriedade = Guid.NewGuid().ToString()
}).Result;
var alteracoes = uow.SaveAndCommitAsync().Result;
Assert.IsTrue(alteracoes == 1);
var chave = repository.FindAsync(p => p.Propriedade == result.Propriedade).Result.FirstOrDefault();
Assert.NotNull(chave);
Assert.IsTrue(chave.Id != Guid.Empty);
var registro = repository.GetByIdAsync(chave.Id).Result;
Assert.NotNull(registro);
registro.Propriedade = "Alterada";
var saveResult = uow.SaveAndCommitAsync().Result;
registro = repository.GetByIdAsync(chave.Id).Result;
Assert.NotNull(registro);
Assert.AreEqual(registro.Propriedade, "Alterada");
}
}
internal static List <ListViewItem> GetTeamsItemList(UnityOfWork unit, string client_Id)
{
var projects = unit.Project.GetAll().Where(p => p.Client.Contains(unit.Client.GetAll().FirstOrDefault(C => C.Id == client_Id)));
List <Team> ListOfTeams = new List <Team>();
List <ListViewItem> TeamsItemList = new List <ListViewItem>();
foreach (var project in projects)
{
foreach (var Team in project.Team)
{
ListViewItem item = new ListViewItem(Team.Team_ID.ToString());
if (Team.Senior.Count > 0)
{
item.SubItems.Add(Team.Senior.FirstOrDefault().Id);
}
else
{
item.SubItems.Add("Not Assigned");
}
item.SubItems.Add(project.Project_ID);
TeamsItemList.Add(item);
}
}
return(TeamsItemList);
}
public DeveloperProjectsView(Developer myDeveloper)
{
InitializeComponent();
MyDeveloper = myDeveloper;
Unit = new UnityOfWork(new ProjectTracerEntities());
LoadProjects();
}
public ActionResult Login(FormCollection fc)
{
string username = fc["username"];
string password = fc["password"];
string encrptPwd = Md5(password);
bool RememberMe = fc["RememberMe"] == null ? false : true;
string returnUrl = Convert.ToString(TempData["ReturnUrl"]);
UnityOfWork unity = new UnityOfWork();
SysUser user = unity.SysUserRepository.Get(t => t.UserName == username && t.PassWord == password).FirstOrDefault();
unity.Dispose();
if (user != null)
{
FormsAuthentication.SetAuthCookie(user.UserName, RememberMe);
if (returnUrl != null)
{
return(Redirect(returnUrl));
}
else
{
return(Redirect("~/"));
}
}
return(View());
}
internal static List <ListViewItem> FindDeveloperById(UnityOfWork unit, string id)
{
var developers = unit.Developer.GetAll();
List <ListViewItem> developersItemList = new List <ListViewItem>();
var SearcheDeveloper = new Developer()
{
Id = id
};
foreach (var developer in developers)
{
int Distance = LevenshteinDistance.Compute(SearcheDeveloper.Id, developer.Id);
int moresimilar = 30;
if (Distance <= 4)
{
ListViewItem item = new ListViewItem(developer.Id);
developersItemList.Add(item);
}
}
return(developersItemList);
}
public InvoiceService()
{
var ctx = new Context();
invoiceRepository = new InvoiceRepository(ctx);
unityOfWork = new UnityOfWork(ctx);
}
public static List <ListViewItem> GetProjectsItemList(UnityOfWork unit)
{
List <Project> ListOfProjects = unit.Project.GetAll().ToList();
List <ListViewItem> ProjectsItemList = new List <ListViewItem>();
foreach (var project in ListOfProjects)
{
ListViewItem item = new ListViewItem(project.Project_ID.ToString());
item.SubItems.Add(project.Description.ToString());
item.SubItems.Add(project.DeadLine.ToString());
item.SubItems.Add(project.Result.ToString());
if (project.Client.Count > 0)
{
item.SubItems.Add(project.Client.FirstOrDefault().Id);
}
ProjectsItemList.Add(item);
}
return(ProjectsItemList);
}
public ClientProjectsView(Client myClient)
{
MyClient = myClient;
Unit = new UnityOfWork(new ProjectTracerEntities());
InitializeComponent();
LoadProjects();
}
internal static void FinishTask(UnityOfWork unit, Task selectedTask)
{
var task = unit.Task.GetAll().FirstOrDefault(T => T.Task_Id == selectedTask.Task_Id);
task.Done = true;
unit.Complete();
}
public void Repository_Can_Insert()
{
using (var context = new InMemoryContext())
using (IRepository <TabelaTesteWithLongKey, long> repository = new TabelaTesteWithLongKeyRepository(context, GetUserContextService()))
{
var uow = new UnityOfWork(context, Substitute.For <ILogProvider>());
repository.AddOrUpdate(new TabelaTesteWithLongKey()
{
Propriedade = Guid.NewGuid().ToString()
});
var alteracoes = uow.SaveAndCommit();
Assert.IsTrue(alteracoes == 1);
var chave = repository.GetAll().FirstOrDefault();
Assert.NotNull(chave);
Assert.IsTrue(chave.Id > 0);
var registro = repository.GetById(chave.Id);
Assert.NotNull(registro);
registro.Propriedade = "Alterada";
uow.SaveAndCommit();
registro = repository.GetById(chave.Id);
Assert.NotNull(registro);
Assert.AreEqual(registro.Propriedade, "Alterada");
}
}
public static IColaboratorService Create()
{
IUnityOfWork unityOfWork = new UnityOfWork();
IColaboratorRepository colaboratorRepository = new ColaboratorRepository(unityOfWork as UnityOfWork);
return(new ColaboratorService(colaboratorRepository));
}
public void Repository_Can_Update_Attached()
{
using (var context = new InMemoryContext())
using (IRepository <TabelaTesteWithGuidKey, Guid> repository = new TabelaTesteWithGuidKeyRepository(context, GetUserContextService()))
{
var uow = new UnityOfWork(context, Substitute.For <ILogProvider>());
repository.AddOrUpdate(new TabelaTesteWithGuidKey()
{
Propriedade = Guid.NewGuid().ToString()
});
var alteracoes = uow.SaveAndCommit();
Assert.IsTrue(alteracoes == 1);
var registro = repository.GetAll().FirstOrDefault();
Assert.NotNull(registro);
Assert.IsTrue(registro.Id != Guid.Empty);
registro.Propriedade = "Alterada_123";
repository.AddOrUpdate(registro);
uow.SaveAndCommit();
Assert.IsTrue(alteracoes == 1);
Assert.AreEqual(registro.Propriedade, "Alterada_123");
}
}
public static Form ChooseStartPage(IUser user)
{
UnityOfWork unit = new UnityOfWork(new ProjectTracerEntities());
var StartPage = new Form();
switch (user.GetType().Name)
{
case "Client":
StartPage = new ClientProjectsView(unit.Client.GetAll().FirstOrDefault(c => c.Id == user.Id));
break;
case "Developer":
StartPage = new DeveloperProjectsView(unit.Developer.GetAll().FirstOrDefault(d => d.Id == user.Id));
break;
case "Senior":
StartPage = new SeniorProjectsView(unit.Senior.GetAll().FirstOrDefault(s => s.Id == user.Id));
break;
case "Administrator":
StartPage = new ProjectsView();
break;
default:
break;
}
return(StartPage);
}
public static bool AddProject(string id, string descripton, string deadline)
{
var ParsedDeadLine = new DateTime();
try
{
ParsedDeadLine = DateTime.Parse(deadline);
}
catch (Exception)
{
return(false);
}
var unit = new UnityOfWork(new ProjectTracerEntities());
unit.Project.Add(new Project()
{
Project_ID = id,
Description = descripton,
DeadLine = ParsedDeadLine,
Result = "notregistered",
});
try
{
unit.Complete();
unit.Dispose();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public SeniorProjectsView(Senior mySenior)
{
InitializeComponent();
MySenior = mySenior;
Unit = new UnityOfWork(new ProjectTracerEntities());
LoadProjects();
}
public ClientDevelopersView(Client myClient)
{
Unit = new UnityOfWork(new ProjectTracerEntities());
MyClient = myClient;
InitializeComponent();
LoadTeams();
}
static void ExecutandoComErro()
{
var contexto = new ContextTeste();
var uow = new UnityOfWork(contexto);
var repo = new ProdutoGrupoRepository(contexto);
var service = new ProdutoGrupoService(repo, uow);
var id = Guid.NewGuid();
service.Inserir(new ProdutoGrupoCommand(id, "TESTE"));
service.Atualizar(new ProdutoGrupoCommand(id, "TESTE DE ALTERACAO"));
service.Atualizar(new ProdutoGrupoCommand(id, "TESTE DE ALTERACAO 2"));
var grupo = service.ObterGrupoPorId(id);
if (grupo != null)
{
Console.WriteLine("NOME ATUAL DO GRUPO: " + grupo.NomeGrupo);
}
Console.Write("Aperte enter para continuar:");
Console.ReadLine();
}
internal static List <ListViewItem> GetProjectsByInput(UnityOfWork unit, string text, string client_Id)
{
var projects = unit.Project
.GetAll()
.Where(p => p.Client.Contains(
unit.Client.GetAll().FirstOrDefault(c => c.Id == client_Id))
);
List <ListViewItem> ProjectsItemList = new List <ListViewItem>();
var SearchedProject = new Project()
{
Project_ID = text
};
foreach (var project in projects)
{
int Distance = LevenshteinDistance.Compute(SearchedProject.Project_ID, project.Project_ID);
if (Distance <= 4)
{
ListViewItem item = new ListViewItem(project.Project_ID.ToString());
item.SubItems.Add(project.Description.ToString());
item.SubItems.Add(project.DeadLine.ToString());
item.SubItems.Add(project.Result.ToString());
if (project.Client.Count > 0)
{
item.SubItems.Add(project.Client.FirstOrDefault().Id);
}
ProjectsItemList.Add(item);
}
}
return(ProjectsItemList);
}
internal static List <ListViewItem> FindDevelopersByTeam(UnityOfWork unit, int teamId, string senior_Id)
{
var teams = unit.Team
.GetAll()
.Where(T => T.Senior
.Contains(unit.Senior.GetAll().FirstOrDefault(d => d.Id == senior_Id)));
List <Developer> developers = new List <Developer>();
foreach (var team in teams)
{
foreach (var dev in team.Developer)
{
if (!developers.Contains(dev))
{
developers.Add(dev);
}
}
}
List <ListViewItem> developersItemList = new List <ListViewItem>();
foreach (var developer in developers)
{
foreach (var team in developer.Team)
{
if (team.Team_ID == teamId)
{
ListViewItem item = new ListViewItem(developer.Id);
developersItemList.Add(item);
}
}
}
return(developersItemList);
}
internal static List <ListViewItem> GetDevelopersItemList(UnityOfWork unit, string senior_Id)
{
var teams = unit.Team
.GetAll()
.Where(T => T.Senior
.Contains(unit.Senior.GetAll().FirstOrDefault(d => d.Id == senior_Id)));
List <Developer> ListOfDevelopers = new List <Developer>();
List <ListViewItem> DevelopersItemList = new List <ListViewItem>();
foreach (var team in teams)
{
foreach (var dev in team.Developer)
{
if (!ListOfDevelopers.Contains(dev))
{
ListOfDevelopers.Add(dev);
ListViewItem item = new ListViewItem(dev.Id);
DevelopersItemList.Add(item);
}
}
}
return(DevelopersItemList);
}
public User Register(User user, string password)
{
user = CreatePasswordHash(user, password);
UnityOfWork.Users.Add(user);
UnityOfWork.SaveChanges();
return(user);
}
public void Repository_Can_Remove_ByIdAsync()
{
using (var context = new InMemoryContext())
using (IRepository <TabelaTesteWithGuidKey, Guid> repository = new TabelaTesteWithGuidKeyRepository(context, GetUserContextService()))
{
var uow = new UnityOfWork(context, Substitute.For <ILogProvider>());
var registro = new TabelaTesteWithGuidKey()
{
Propriedade = Guid.NewGuid().ToString()
};
var saveResult = repository.AddOrUpdateAsync(registro).Result;
var alteracoes = uow.SaveAndCommitAsync().Result;
Assert.IsTrue(alteracoes == 1);
var removeResult = repository.RemoveAsync(registro.Id).Result;
var saveRemoveResult = uow.SaveAndCommitAsync().Result;
Assert.IsTrue(alteracoes == 1);
registro = repository.FindAsync(p => p.Id == registro.Id).Result.FirstOrDefault();
Assert.Null(registro);
}
}
public static Task GetTaskById(UnityOfWork unit, string project_Id, int task_Id)
{
return(unit.Task
.GetAll()
.Where(searchedTasks => searchedTasks.Project_Id == project_Id)
.Where(searchedTask => searchedTask.Task_Id == task_Id)
.FirstOrDefault());
}
public DetalheDeVacaViewModel(Gado Vaca, INavigation navigation) : base(navigation)
{
_vacaSelecionada = Vaca;
var connection = new UnityOfWork();
_filhosDaVacaSelecionada = connection.GadoRepository.Find(e => e.IdVacaMae == _vacaSelecionada.IDGado).ToList();
}
internal static bool ReleaseTask(UnityOfWork unit, Task selectedTask, Developer myDeveloper)
{
var task = unit.Task.GetAll().FirstOrDefault(T => T.Task_Id == selectedTask.Task_Id);
task.DeveloperOnTask = null;
unit.Complete();
return(unit.Task.GetAll().FirstOrDefault(T => T.Task_Id == selectedTask.Task_Id).DeveloperOnTask == null);
}
public void RemoveAuthor(Author Author)
{
using (var unity = new UnityOfWork())
{
new AuthorBdRepository(unity).Remove(Author);
unity.Complete();
}
}
public IndividualRepository()
{
if (uow == null)
{
DataContext = new DmsDomainContext();
uow = new UnityOfWork(DataContext);
}
}
protected BaseBdRepository(UnityOfWork unityOfWork)
{
if (unityOfWork == null)
{
throw new ArgumentNullException("A unidade de trabalho não pode ser nula.");
}
_unityOfWork = unityOfWork;
}
public AssociateRepository()
{
if (uow == null)
{
amsContext = new ContextAMS();
uow = new UnityOfWork(amsContext);
}
}
public ControleDeParicaoViewModel(INavigation navigation) : base(navigation)
{
var connection = new UnityOfWork();
_numeroDeVacas = connection.GadoRepository.Find(e => e.Genero == Sexo.Fêmea).Count();
_totalDeVacasText = ("Total de vacas: " + _numeroDeVacas);
_listaDeVacas = connection.GadoRepository.Find(e => e.Genero == Sexo.Fêmea && e.Numeracao != null).ToList();
}
public void Initialize()
{
var initializer = new UnityOfWorkInitializer();
var unityOfWork = new UnityOfWork("TestDb");
initializer.InitializeDatabase(unityOfWork);
_repository = new ColaboratorRepository(unityOfWork);
}
