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