private void AddEmployeeOnProject(int employeeId, int projectId)
{
_context.ProjectEmployees.Add(new ProjectEmployee {
ProjectId = projectId, EmployeeId = employeeId
});
_context.SaveChanges();
}
public bool DeleteProductData(ProductDTO deleteCustomer)
{
context.Products.Remove(mapper.Map <Product>(deleteCustomer));
if (context.SaveChanges() == 1)
{
return(true);
}
return(false);
}
public bool DeleteStoreData(StoreDTO deletestore)
{
context.Stores.Remove(mapper.Map <Store>(deletestore));
if (context.SaveChanges() == 1)
{
return(true);
}
return(false);
}
public ActionResult Create([Bind(Include = "CardID,ProjectID,Status,Title,Description")] Card card)
{
if (ModelState.IsValid)
{
db.Cards.Add(card);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(card));
}
public ActionResult Create([Bind(Include = "productId,productName,price,stock")] Product product)
{
if (ModelState.IsValid)
{
db.products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(product));
}
// Delete customer record based on incoming id.
public bool DeleteCustomerData(CustomerDTO deleteCustomer)
{
Customer DeleteCustomer = context.Customers.FirstOrDefault(x => x.Id == deleteCustomer.Id);
context.Customers.Remove(DeleteCustomer);
if (context.SaveChanges() == 1)
{
return(true);
}
return(false);
}
public ActionResult Create(Supplier supplier)
{
if (ModelState.IsValid)
{
db.suppliers.Add(supplier);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(supplier));
}
public ActionResult Create([Bind(Include = "ProjectID,Title,Description,Phase")] Project project)
{
if (ModelState.IsValid)
{
db.Projects.Add(project);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(project));
}
public T Add(T entity)
{
var entityCreated = _context.BaseEntitys.Add(entity);
_context.SaveChanges();
if (entityCreated != null)
{
return((T)entityCreated.Entity);
}
return(null);
}
public void Task_GetUserById_Return_OkResult()
{
User testUser2 = new User
{
Id = 2,
Email = "*****@*****.**",
FirstName = "Harsh",
LastName = "Verma",
Password = "******"
};
_context.Users.Add(testUser2);
_context.SaveChanges();
var controller = new UserController(_service);
var userId = 2;
var data = controller.GetUserById(userId);
Assert.IsType <OkObjectResult>(data);
}
public ProjectController(PMContext <Project> context, IBaseRepository <Project> repository) : base(repository)
{
_context = context;
if (!_context.Table.Any())
{
_context.Table.Add(new Project
{
ID = 001,
Name = "ABC",
CreatedOn = DateTime.Now,
Detail = "Abc Project"
});
_context.SaveChanges();
}
}
public UserController(PMContext <User> userContext, IBaseRepository <User> repository) : base(repository)
{
_userContext = userContext;
if (!_userContext.Table.Any())
{
_userContext.Table.Add(new User
{
ID = 001,
FirstName = "Manila",
LastName = "Jain",
Email = "*****@*****.**",
Password = "******"
});
}
_userContext.SaveChanges();
}
public TaskController(PMContext <Task> taskContext, IBaseRepository <Task> repository) : base(repository)
{
_taskContext = taskContext;
if (!_taskContext.Table.Any())
{
_taskContext.Table.Add(new Task
{
ID = 001,
AssignedToUserID = 001,
CreatedOn = DateTime.Now,
ProjectID = 001,
Status = Entities.Enums.TaskStatus.New,
Detail = "Test Task"
});
}
_taskContext.SaveChanges();
}
public void Task_GetProjectById_Return_OkResult()
{
Project testproject1 = new Project
{
Id = 4,
Name = "ProjectManagement",
Detail = "this is a project management project",
CreatedOn = DateTime.Parse(V)
};
_context.Projects.Add(testproject1);
_context.SaveChanges();
var controller = new ProjectController(_service);
var ProjectId = 4;
var data = controller.Get(ProjectId);
Assert.IsType <OkObjectResult>(data);
}
public void Task_GetTaskById_Return_OkResult()
{
Task testTask1 = new Task
{
Id = 3,
ProjectID = 1,
Detail = "this is a task 1 for management project1",
CreatedOn = DateTime.Parse(V),
Status = ProjectManagement.Entities.Enums.TaskStatus.New,
AssignedToUserID = 1
};
_context.Tasks.Add(testTask1);
_context.SaveChanges();
var controller = new TaskController(_service);
var TaskId = 3;
var data = controller.Get(TaskId);
Assert.IsType <OkObjectResult>(data);
}
public int Add(T entity)
{
_context.Add(entity);
return(_context.SaveChanges());
}
public void TestCleanup()
{
_context.Properties.RemoveRange(_context.Properties);
_context.Categories.RemoveRange(_context.Categories);
_context.SaveChanges();
}
public void SaveChange()
{
_context.SaveChanges();
}
private static void AddTestData(PMContext context)
{
User testUser1 = new User
{
Id = 1,
Email = "*****@*****.**",
FirstName = "Sunny",
LastName = "Kumar",
Password = "******"
};
User testUser2 = new User
{
Id = 2,
Email = "*****@*****.**",
FirstName = "Harsh",
LastName = "Verma",
Password = "******"
};
Task testTask1 = new Task
{
Id = 3,
ProjectID = 1,
Detail = "this is a task 1 for management project1",
CreatedOn = DateTime.Parse(V),
Status = Entities.Enums.TaskStatus.New,
AssignedToUserID = 1
};
Project testproject1 = new Project
{
Id = 4,
Name = "ProjectManagement",
Detail = "this is a project management project",
CreatedOn = DateTime.Parse(V)
};
Project testproject2 = new Project
{
Id = 5,
Name = "ProjectManagement2",
Detail = "this is a project management project2",
CreatedOn = DateTime.Parse(V)
};
Task testTask2 = new Task
{
Id = 6,
ProjectID = 4,
Detail = "this is a task 2 for management project1",
CreatedOn = DateTime.Parse(V),
Status = Entities.Enums.TaskStatus.InProgress,
AssignedToUserID = 2
};
Task testTask3 = new Task
{
Id = 7,
ProjectID = 5,
Detail = "this is a task 1 for management project2",
CreatedOn = DateTime.Parse(V),
Status = Entities.Enums.TaskStatus.Completed,
AssignedToUserID = 1
};
context.Users.Add(testUser1);
context.Users.Add(testUser2);
context.SaveChanges();
context.Tasks.Add(testTask1);
context.Tasks.Add(testTask2);
context.Tasks.Add(testTask3);
context.SaveChanges();
context.Projects.Add(testproject1);
context.Projects.Add(testproject2);
context.SaveChanges();
}
