public void AddProject(tblProject item)
{
using (ProjectManagerDBEntities db1 = new ProjectManagerDBEntities())
{
try
{
item.Nooftasks = 0;
item.completed = 0;
item.PStatus = false;
db1.tblProjects.Add(item);
db1.SaveChanges();
}
catch { };
}
}
public void AddTask(tblTask item)
{
try
{
using (ProjectManagerDBEntities db1 = new ProjectManagerDBEntities())
{
var projectupdate = db1.tblProjects.Where(x => x.ProjectId == item.ProjectId).ToList();
projectupdate.ForEach(m => m.Nooftasks = m.Nooftasks + 1);
item.TStatus = false;
db1.tblTasks.Add(item);
db1.SaveChanges();
}
}
catch { };
}
public void UpdateUser(tblUser useritem)
{
try
{
using (ProjectManagerDBEntities db1 = new ProjectManagerDBEntities())
{
tblUser userupdate = db1.tblUsers.SingleOrDefault(x => x.UserId == useritem.UserId);
userupdate.FirstName = useritem.FirstName;
userupdate.LastName = useritem.LastName;
userupdate.EmployeeId = useritem.EmployeeId;
db1.SaveChanges();
}
}
catch { }
}
public void Setup()
{
_tasks = SetUpTasks();
_dbEntities = new Mock <ProjectManagerDBEntities>().Object;
_taskRepository = SetUpTaskRepository();
var unitOfWork = new Mock <IUnitOfWork>();
unitOfWork.SetupGet(s => s.TaskRepository).Returns(_taskRepository);
_unitOfWork = unitOfWork.Object;
_taskService = new TaskService();
_client = new HttpClient
{
BaseAddress = new Uri(ServiceBaseURL)
};
}
public void DeleteTask(int TaskId)
{
try
{
using (ProjectManagerDBEntities db1 = new ProjectManagerDBEntities())
{
tblTask ts = db1.tblTasks.Where(d => d.TaskId == TaskId).FirstOrDefault();
var projectupdate = db1.tblProjects.Where(x => x.ProjectId == ts.ProjectId).ToList();
projectupdate.ForEach(m => m.completed = m.completed - 1);
db1.tblTasks.Remove(ts);
db1.SaveChanges();
}
}
catch { };
}
public void Suspendtask(int id)
{
using (ProjectManagerDBEntities db = new ProjectManagerDBEntities())
{
tblProject tp = db.tblProjects.SingleOrDefault(x => x.ProjectId == id);
if (tp.PStatus == false)
{
tp.PStatus = true;
}
else
{
tp.PStatus = false;
}
db.SaveChanges();
}
}
public void DeleteUser(int Id)
{
try
{
using (ProjectManagerDBEntities db1 = new ProjectManagerDBEntities())
{
tblUser us = db1.tblUsers.Where(d => d.UserId == Id).First();
var projectupdate = db1.tblProjects.Where(x => x.ManagerId == Id).ToList();
projectupdate.ForEach(m => m.ManagerId = 0);
var taskupdate = db1.tblTasks.Where(x => x.UserId == Id).ToList();
taskupdate.ForEach(m => m.UserId = 0);
db1.tblUsers.Remove(us);
db1.SaveChanges();
}
}
catch { }
}
public void Updateproject(tblProject projectitem)
{
try
{
using (ProjectManagerDBEntities db1 = new ProjectManagerDBEntities())
{
tblProject projectupdate = db1.tblProjects.SingleOrDefault(x => x.ProjectId == projectitem.ProjectId);
projectupdate.ProjectName = projectitem.ProjectName;
projectupdate.PStartDate = projectitem.PStartDate;
projectupdate.PEndDate = projectitem.PEndDate;
projectupdate.PPriority = projectitem.PPriority;
projectupdate.ManagerId = projectitem.ManagerId;
db1.SaveChanges();
}
using (ProjectManagerDBEntities db2 = new ProjectManagerDBEntities())
{
var projectupdate = db2.tblProjects.Where(x => x.ProjectId == projectitem.ProjectId).ToList();
// projectupdate.ForEach(m=>m.Nooftasks=()
}
}
catch { }
}
/// <summary>
/// Public Constructor,initializes privately declared local variables.
/// </summary>
/// <param name="context"></param>
public GenericRepository(ProjectManagerDBEntities context)
{
this.Context = context;
this.DbSet = context.Set <TEntity>();
}
public UnitOfWork()
{
_context = new ProjectManagerDBEntities();
}
public ProjectManagerBL(ProjectManagerDBEntities projectManager)
{
pmdb = projectManager;
}
public ProjectManagerBL()
{
pmdb = new ProjectManagerDBEntities();
}
