public static void ListCategory()
{
var obj = new ProjectsEntities();
var expected = 0;
var actual = obj.WorkOut_Categorys.Count();
Assert.AreEqual(expected, actual);
}
public void Context()
{
using (var context = new ProjectsEntities())
{
var worker = new Worker()
{
FirstName = "alex",
LastName = "rob",
Email = "alex@rob",
MiddleName = "middle"
};
worker = context.WorkersBase.Add(worker);
Assert.IsNotNull(worker);
var worker1 = new Worker()
{
FirstName = "alex1",
LastName = "rob1",
Email = "alex@rob1",
MiddleName = "middle1"
};
worker1 = context.WorkersBase.Add(worker1);
Assert.IsNotNull(worker1);
context.SaveChanges();
Assert.IsNotNull(context.WorkersBase.Find(worker.Id));
Assert.IsNotNull(context.WorkersBase.Find(worker1.Id));
var project = new Project()
{
Comment = "Comment",
ConstractorCompany = "Cons",
CustomerCompany = "cust",
Employee = worker,
Leader = worker1,
Start = DateTime.Now,
End = DateTime.Now,
Workers = new List <Worker>
{
worker,
worker1
}
};
project = context.ProjectsBase.Add(project);
Assert.IsNotNull(project);
context.SaveChanges();
Assert.IsNotNull(context.ProjectsBase.Find(project.Id));
}
}
private void Drop()
{
using (var context = new ProjectsEntities())
{
context.Database.ExecuteSqlCommand("truncate table ProjectsWorkersBase");
context.ProjectsBase.RemoveRange(context.ProjectsBase);
context.WorkersBase.RemoveRange(context.WorkersBase);
context.SaveChanges();
}
}
protected TResult WOperation <TResult>(Func <ProjectsEntities, TResult> action)
{
var result = default(TResult);
using (var context = new ProjectsEntities())
{
try
{
result = action(context);
context.SaveChanges();
}
catch (Exception exception)
{
ManagerFactory.Logger.Error(Tag, exception);
}
}
return(result);
}
public void StartTest()
{
using (var context = new ProjectsEntities())
{
context.Database.ExecuteSqlCommand("truncate table ProjectsWorkersBase");
context.ProjectsBase.RemoveRange(context.ProjectsBase);
context.WorkersBase.RemoveRange(context.WorkersBase);
context.SaveChanges();
context.WorkersBase.Add(Worker1);
context.WorkersBase.Add(Worker2);
context.SaveChanges();
context.ProjectsBase.Add(Project1);
context.ProjectsBase.Add(Project2);
context.SaveChanges();
}
Start();
}
private TDataType WOperationGet <TDataType>(Func <IEnumerable <Project>, TDataType> action)
{
var result = default(TDataType);
using (var context = new ProjectsEntities())
{
var projects = context.ProjectsBase
.Include(p => p.Employee)
.Include(p => p.Leader)
.Include(p => p.Workers);
try
{
result = action(projects);
}
catch (Exception exception)
{
ManagerFactory.Logger.Error(Tag, exception);
}
}
return(result);
}
