//Delete Existing project Method
public void DeleteProject(int id)
{
ProjectManagerContext dbCtxt = new ProjectManagerContext();
var deleteProject = dbCtxt.Projects.Where(m => m.ProjectId == id).FirstOrDefault();
if (deleteProject != null)
{
dbCtxt.Projects.Remove(deleteProject);
dbCtxt.SaveChanges();
}
}
// Update User
public void UpdateUser(User editUser)
{
ProjectManagerContext dbCtxt = new ProjectManagerContext();
var existingUser = dbCtxt.Users.Where(m => m.UserId == editUser.UserId).FirstOrDefault();
existingUser.FirstName = editUser.FirstName;
existingUser.LastName = editUser.LastName;
existingUser.EmployeeId = editUser.EmployeeId;
dbCtxt.SaveChanges();
}
public void WriteToDatabase(string description, int projectID)
{
var activityMonitor = new ActivityMonitor();
activityMonitor.Timestamp = DateTime.Now;
activityMonitor.ProjectID = projectID;
activityMonitor.Description = description;
dbContext.Activities.Add(activityMonitor);
dbContext.SaveChanges();
}
//Delete User
public void DeleteUser(int id)
{
ProjectManagerContext dbCtxt = new ProjectManagerContext();
var deleteUser = dbCtxt.Users.Where(m => m.UserId == id).FirstOrDefault();
if (deleteUser != null)
{
dbCtxt.Users.Remove(deleteUser);
dbCtxt.SaveChanges();
}
}
// end Task
public void EndTask(int id)
{
ProjectManagerContext dbCtxt = new ProjectManagerContext();
var endTask = dbCtxt.Tasks.Where(m => m.TaskId == id).FirstOrDefault();
if (endTask != null)
{
endTask.Status = false;
dbCtxt.SaveChanges();
}
}
/// <summary>
/// This is the method to end the existing task based on user interaction
/// </summary>
/// <param name="taskID">Task id which needs to be ended</param>
public void EndTask(int taskID)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
var itemToEnd = db.Task.SingleOrDefault(task => task.Task_ID.Equals(taskID));
if (itemToEnd != null)
{
itemToEnd.Status = true;
db.SaveChanges();
}
}
}
/// <summary>
/// Method to delete the task based on the user interaction
/// </summary>
/// <param name="taskID">Task Id which needs to be deleted</param>
public void DeleteUser(int userID)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
var itemToDelete = db.User.SingleOrDefault(task => task.User_ID.Equals(userID));
if (itemToDelete != null)
{
db.User.Remove(itemToDelete);
db.SaveChanges();
}
}
}
/// <summary>
/// Method to delete the task based on the user interaction
/// </summary>
/// <param name="taskID">Task Id which needs to be deleted</param>
public void DeleteTask(int taskID)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
var itemToDelete = db.Task.SingleOrDefault(task => task.Task_ID.Equals(taskID));
if (itemToDelete != null)
{
db.Task.Remove(itemToDelete);
db.SaveChanges();
}
}
}
public void DeleteProject(int Id)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
var Prj = db.Projects.First(i => i.ProjectId == Id);
if (Prj != null)
{
db.Entry(Prj).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
}
public void DeleteUser(int Id)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
var Usr = db.Users.First(i => i.UserId == Id);
if (Usr != null)
{
db.Entry(Usr).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
}
// delete Task
public void DeleteTask(int id)
{
ProjectManagerContext dbCtxt = new ProjectManagerContext();
var deleteTask = dbCtxt.Tasks.Where(m => m.TaskId == id).FirstOrDefault();
if (deleteTask != null)
{
dbCtxt.Tasks.Remove(deleteTask);
dbCtxt.SaveChanges();
}
}
public ActionResult Create([Bind(Include = "ID,Username,Email,UserRole")] User user)
{
if (ModelState.IsValid)
{
User dbUser = dbContext.Users.ToList()
.Where(u => u.Email == user.Email || u.Username == user.Username)
.FirstOrDefault();
if (dbUser != null)
{
return(FailedAction("User with specified details already exists!", user));
}
if (!user.UserRole.HasValue)
{
return(FailedAction("Please specify a role for the new user!", user));
}
dbContext.Users.Add(user);
dbContext.SaveChanges();
var description = ApplicationState.Instance.CurrentUser.FirstName + " " + ApplicationState.Instance.CurrentUser.LastName + " added new user with username "
+ user.Username + " and role " + user.UserRole.ToString();
new ActivityMonitorUpdater(dbContext).WriteToDatabase(description, -1);
return(RedirectToAction("Index"));
}
return(View(user));
}
public void AddTask(Task item)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
db.Tasks.Add(item);
db.SaveChanges();
//if (item.ParentTask != null && !string.IsNullOrEmpty(item.ParentTask))
//{
// ProjectBL obj = new ProjectBL();
// obj.UpdateProject(item.ProjectId);
//}
}
}
public void DeleteTask(int Id)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
var Tsk = db.Tasks.First(i => i.TaskId == Id);
//var Tsk = GetById(item.TaskId);
if (Tsk != null)
{
db.Entry(Tsk).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
}
}
}
// Update Task
public void UpdateTask(Task editTask)
{
ProjectManagerContext dbCtxt = new ProjectManagerContext();
var existingTask = dbCtxt.Tasks.Where(m => m.TaskId == editTask.TaskId).FirstOrDefault();
existingTask.ParentId = editTask.ParentId;
existingTask.TaskName = editTask.TaskName;
existingTask.TaskStartDate = editTask.TaskStartDate;
existingTask.TaskEndDate = editTask.TaskEndDate;
existingTask.Priority = editTask.Priority;
existingTask.User_ID = editTask.User_ID;
dbCtxt.SaveChanges();
}
public void Can_Add_Projects_And_Orders()
{
using (var db = new ProjectManagerContext())
{
var proj1 = new PROJECT {
NAME = "TEST PROJ 1"
};
var proj2 = new PROJECT {
NAME = "TEST PROJ 2"
};
var proj3 = new PROJECT {
NAME = "TEST PROJ 3"
};
db.PROJECTs.Add(proj1);
db.PROJECTs.Add(proj2);
db.PROJECTs.Add(proj3);
db.SaveChanges();
var order1 = new ORDER {
NAME = "ORDER 1"
};
var order2 = new ORDER {
NAME = "ORDER 2"
};
db.ORDERs.Add(order1);
db.ORDERs.Add(order2);
db.SaveChanges();
proj1.ORDERS.Add(order1);
proj1.ORDERS.Add(order2);
proj2.ORDERS.Add(order2);
db.SaveChanges();
}
}
// Update Existing Project
public void UpdateProject(Project editProject)
{
ProjectManagerContext dbCtxt = new ProjectManagerContext();
var existingProject = dbCtxt.Projects.Where(m => m.ProjectId == editProject.ProjectId).FirstOrDefault();
existingProject.ProjectId = editProject.ProjectId;
existingProject.ProjectName = editProject.ProjectName;
existingProject.ProjectStartDate = editProject.ProjectStartDate;
existingProject.ProjectEndDate = editProject.ProjectEndDate;
existingProject.Priority = editProject.Priority;
existingProject.User_ID = editProject.User_ID;
dbCtxt.SaveChanges();
}
/// <summary>
/// Method to update the task into the database
/// </summary>
/// <param name="item">Task which needs to be updated</param>
public void UpdateUser(User item)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
var itemToUpdate = db.User.SingleOrDefault(data => data.User_ID.Equals(item.User_ID));
if (itemToUpdate != null)
{
itemToUpdate.User_ID = item.User_ID;
itemToUpdate.FirstName = item.FirstName;
itemToUpdate.LastName = item.LastName;
itemToUpdate.Employee_ID = item.Employee_ID;
db.SaveChanges();
}
}
}
public ActionResult ValidateLogin([Bind(Include = "Username,Password")] User user)
{
if (ModelState.IsValid)
{
User dbUser = dbContext.Users.ToList()
.Where(u => u.Username.Equals(user.Username) && u.Password.Equals(user.Password))
.FirstOrDefault();
if (dbUser == null)
{
TempData[Constants.NOTICE] = "Invalid username or password! Please try again!";
return(RedirectToAction("Login"));
}
dbUser.LastLogin = DateTime.UtcNow;
ApplicationState.Instance.CurrentUser = dbUser;
dbContext.Entry(dbUser).State = System.Data.Entity.EntityState.Modified;
dbContext.SaveChanges();
return(RedirectToAction("Activity"));
}
return(RedirectToAction("Login"));
}
public void UpdateProject(int ProjID)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
var Proj = db.Projects.First(i => i.ProjectId == ProjID);
//var Tsk = GetById(item.TaskId);
if (Proj != null)
{
//Proj.TotalTasks += 1;
db.Entry(Proj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
//db.Entry(Tsk).CurrentValues.SetValues(item);
//db.Tasks.AddOrUpdate(item);
}
}
public void Can_Remove_Projects_And_Orders_Relation()
{
using (var db = new ProjectManagerContext())
{
var proj1 = db.PROJECTs.Single(p => p.NAME == "TEST PROJ 1");
Debug.WriteLine($"Num of proj1 orders = [{proj1.ORDERS.Count}]");
foreach (var order in proj1.ORDERS.ToList())
{
Debug.WriteLine($"Removed proj order = [{proj1.NAME}] [{order.NAME}]");
proj1.ORDERS.Remove(order);
}
db.SaveChanges();
}
}
/// <summary>
/// Method to update the task into the database
/// </summary>
/// <param name="item">Task which needs to be updated</param>
public void UpdateTask(Task item)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
var itemToUpdate = db.Task.SingleOrDefault(task => task.Task_ID.Equals(item.Task_ID));
if (itemToUpdate != null)
{
itemToUpdate.Task_Name = item.Task_Name;
itemToUpdate.Parent_ID = item.Parent_ID;
itemToUpdate.Priority = item.Priority;
itemToUpdate.Start_Date = item.Start_Date;
itemToUpdate.End_Date = item.End_Date;
db.SaveChanges();
}
}
}
/// <summary>
/// Method to update the task into the database
/// </summary>
/// <param name="item">Task which needs to be updated</param>
public void UpdateProject(Project item)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
var itemToUpdate = db.Project.SingleOrDefault(data => data.Project_ID.Equals(item.Project_ID));
if (itemToUpdate != null)
{
itemToUpdate.Project_ID = item.Project_ID;
itemToUpdate.Project_Name = item.Project_Name;
itemToUpdate.Start_Date = item.Start_Date;
itemToUpdate.End_Date = item.End_Date;
itemToUpdate.Priority = item.Priority;
db.SaveChanges();
}
}
}
public void UpdateNormal()
{
var options = new DbContextOptionsBuilder <ProjectManagerContext>()
.UseInMemoryDatabase(databaseName: "save")
.Options;
using (var context = new ProjectManagerContext(options, null))
{
context.Projects.Add(new Project
{
Name = "teste1",
InitialDate = DateTime.Now,
FinalDate = DateTime.Now.AddMonths(1),
PercentComplete = 0,
Late = false,
Removed = false
});
context.Activities.Add(new Activity
{
Name = "teste1",
InitialDate = DateTime.Now,
FinalDate = DateTime.Now.AddDays(1),
ProjectId = 1,
Finished = false
});
context.SaveChanges();
}
using (var context = new ProjectManagerContext(options, null))
{
var repoA = new ActivityRepository(context);
var service = new ActivityService(repoA);
var activity = service.Get(1).Result;
activity.Name = "testeUpdate";
service.Update(activity).Wait();
var newActivity = service.Get(1).Result;
Assert.Equal("testeUpdate", newActivity.Name);
}
}
public static void EnsureSeedDataForContext(this ProjectManagerContext context)
{
if (context.Projects.Any())
{
return; // database already seeded
}
var projects = new List <Project>()
{
new Project()
{
Id = 1,
Name = "Project 1",
Description = "The first project",
UserStories = new List <UserStory>()
{
new UserStory()
{
Id = 1,
Name = "Add Login Screen",
Description = "A login screen needs to be added to the homepage",
WorkRemaining = "3 hours",
Completed = false
}
}
},
new Project()
{
Id = 2,
Name = "Project 2",
Description = "The second project",
},
new Project()
{
Id = 3,
Name = "Project Alpha",
Description = "The finished project",
}
};
context.Projects.AddRange(projects);
if (context.SaveChanges() > 0)
{
Console.WriteLine("Data seeded to ProjectManagerContext");
}
}
public void UpdateWithoutField()
{
var options = new DbContextOptionsBuilder <ProjectManagerContext>()
.UseInMemoryDatabase(databaseName: "save")
.Options;
using (var context = new ProjectManagerContext(options, null))
{
context.Projects.Add(new Project
{
Name = "teste1",
InitialDate = DateTime.Now,
FinalDate = DateTime.Now.AddMonths(1),
PercentComplete = 0,
Late = false,
Removed = false
});
context.Activities.Add(new Activity
{
Name = "teste1",
InitialDate = DateTime.Now,
FinalDate = DateTime.Now.AddDays(1),
ProjectId = 1,
Finished = false
});
context.SaveChanges();
}
using (var context = new ProjectManagerContext(options, null))
{
var repoA = new ActivityRepository(context);
var service = new ActivityService(repoA);
var activity = service.Get(1).Result;
activity.ProjectId = 0;
Assert.ThrowsAsync <AggregateException>(
() => service.Update(activity)
);
}
}
public void UpdateUser(User item)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
var User = db.Users.First(i => i.UserId == item.UserId);
//var Tsk = GetById(item.TaskId);
if (User != null)
{
User.FirstName = item.FirstName;
User.LastName = item.LastName;
User.EmployeeID = item.EmployeeID;
db.Entry(User).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
//db.Entry(Tsk).CurrentValues.SetValues(item);
//db.Tasks.AddOrUpdate(item);
}
}
public void UpdateProject(Project item)
{
using (ProjectManagerContext db = new ProjectManagerContext())
{
var Proj = db.Projects.First(i => i.ProjectId == item.ProjectId);
//var Tsk = GetById(item.TaskId);
if (Proj != null)
{
Proj.ProjectName = item.ProjectName;
Proj.Priority = item.Priority;
Proj.SDate = item.SDate;
Proj.EDate = item.EDate;
db.Entry(Proj).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
//db.Entry(Tsk).CurrentValues.SetValues(item);
//db.Tasks.AddOrUpdate(item);
}
}
public IHttpActionResult UserProjects(UsersProjectsDTO dto)
{
var userId = User.Identity.GetUserId();
if (_context.UsersProjects.Any(u => u.UserId == userId && u.ProjectId == dto.ProjectId))
{
return(BadRequest("Project Already Exists."));
}
var userprojects = new UsersProjects
{
ProjectId = dto.ProjectId,
UserId = userId
};
_context.UsersProjects.Add(userprojects);
_context.SaveChanges();
return(Ok());
}
public JsonResult Delete(int[] data)
{
int taskId = Convert.ToInt32(data[0]);
db.Tasks.Remove(db.Tasks.Find(taskId));
try
{
db.SaveChanges();
}
catch (DbUpdateException ex)
{
//TODO
}
//TODO
return(Json(""));
}
