public void EditUser(int ID, UserData User)
{
using (var ct = new ProjectManagerContext())
{
var Upduser = ct.UserData.Where(a => a.UserID == ID).FirstOrDefault();
Upduser.FirstName = User.FirstName;
Upduser.LastName = User.LastName;
Upduser.EmployeeID = User.EmployeeID;
ct.SaveChanges();
}
}
public void EditProject(int ID, ProjectData Project)
{
using (var ct = new ProjectManagerContext())
{
var UpdProject = ct.ProjectData.Where(a => a.ProjectID == ID).FirstOrDefault();
UpdProject.Project = Project.Project;
UpdProject.ProjectStartDate = Project.ProjectStartDate;
UpdProject.ProjectEndDate = Project.ProjectEndDate;
UpdProject.ProjectPriority = Project.ProjectPriority;
UpdProject.ProjectManager = Project.ProjectManager;
ct.SaveChanges();
}
}
public void DeleteUser(int ID)
{
using (var ct = new ProjectManagerContext())
{
List <UserData> DelUser = new List <UserData>();
DelUser = (from r in ct.UserData select r).ToList <UserData>();
if (DelUser != null && DelUser.Count != 0)
{
ct.UserData.Remove(DelUser[0]);
ct.SaveChanges();
}
}
}
public void DeleteProject(int ID)
{
using (var ct = new ProjectManagerContext())
{
List <ProjectData> DelProject = new List <ProjectData>();
DelProject = (from r in ct.ProjectData select r).ToList <ProjectData>();
if (DelProject != null && DelProject.Count != 0)
{
ct.ProjectData.Remove(DelProject[0]);
ct.SaveChanges();
}
}
}
public void DeleteTask(int ID)
{
using (var ct = new ProjectManagerContext())
{
//List<TaskData> DelTask = new List<TaskData>();
//var DelTask = (from r in ct.TaskData select r).ToList<TaskData>();
var DelTask = ct.TaskData.Where(a => a.TaskID == ID).FirstOrDefault();
//if (DelTask != null && DelTask.Count != 0)
//{
DelTask.Status = "Completed";
ct.SaveChanges();
//}
}
}
public void UpdateTask(int ID, TaskData Task)
{
int ParentID = 0;
using (var ct = new ProjectManagerContext())
{
var UpdTask = ct.TaskData.Where(a => a.TaskID == ID).FirstOrDefault();
UpdTask.Task = Task.Task;
UpdTask.ParentID = ParentID;
UpdTask.ParentTask = Task.ParentTask;
UpdTask.Priority = Task.Priority;
UpdTask.StartDate = Task.StartDate;
UpdTask.EndDate = Task.EndDate;
ct.SaveChanges();
}
}
