/// <summary>
/// Generic Delete method for the entities
/// </summary>
/// <param name="entityToDelete"></param>
public virtual void Delete(TEntity entityToDelete)
{
if (Context.Entry(entityToDelete).State == EntityState.Detached)
{
DbSet.Attach(entityToDelete);
}
DbSet.Remove(entityToDelete);
}
public IHttpActionResult PutProjectTable(int id, ProjectTable projectTable)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != projectTable.ProjectId)
{
return(BadRequest());
}
db.Entry(projectTable).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ProjectTableExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public int DeleteUserDetails(UserModel userModel)
{
int returnVal = 0;
using (ProjectManagerEntities userEntity = new ProjectManagerEntities())
{
User objUser = userEntity.Users.Where(x => x.User_ID == userModel.User_ID).FirstOrDefault();
if (objUser != null)
{
objUser.First_Name = userModel.First_Name;
objUser.Last_Name = userModel.Last_Name;
objUser.Employee_ID = userModel.Employee_ID;
//objUser.Project_ID = userModel.ProjectId;
objUser.IsActive = false;
userEntity.Entry(objUser).State = EntityState.Modified;
try
{
userEntity.SaveChanges();
returnVal = 1;
}
catch (Exception ex)
{
return(returnVal);
}
}
}
return(returnVal);
}
public IHttpActionResult PutUser(int id, User user)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
if (id != user.EmployeeID)
{
return(BadRequest());
}
db.Entry(user).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!UserExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public int UpdateTaskRepository(TaskModel taskModel)
{
int returnVal = 0;
using (ProjectManagerEntities taskManagerEntity = new ProjectManagerEntities())
{
Task objtask = taskManagerEntity.Tasks.Where(x => x.Task_ID == taskModel.Task_ID).FirstOrDefault();
if (objtask != null)
{
objtask.Task1 = taskModel.Task;
objtask.Parent_ID = taskModel.Parent_ID;
objtask.Start_Date = taskModel.Start_Date;
objtask.End_Date = taskModel.End_Date;
objtask.IsActive = taskModel.IsActive;
objtask.Priority = taskModel.Priority;
objtask.Project_ID = taskModel.Project_ID;
objtask.User_ID = taskModel.User_ID;
taskManagerEntity.Entry(objtask).State = EntityState.Modified;
try
{
taskManagerEntity.SaveChanges();
returnVal = 1;
}
catch (Exception ex)
{
return(returnVal);
}
}
}
return(returnVal);
}
/// <summary>
/// Task update method for the entities
/// </summary>
/// <param name="entityToUpdate"></param>
public virtual int Put(int id, Task entityToUpdate)
{
Context.Entry(entityToUpdate).State = EntityState.Modified;
return(Context.SaveChanges());
//DbSet.Attach(entityToUpdate);
//Context.Entry(entityToUpdate).State = EntityState.Modified;
}
/// <summary>
/// Method to suspend project
/// </summary>
/// <param name="projectModel"></param>
/// <returns></returns>
public bool SuspendProject(ProjectModel projectModel)
{
using (ProjectManagerEntities entity = new ProjectManagerEntities())
{
if (projectModel != null && projectModel.ProjectId != 0)
{
Project suspendProject = new Project();
suspendProject.Project1 = projectModel.Project;
suspendProject.Project_ID = projectModel.ProjectId;
if (projectModel.StartDateString != null)
{
suspendProject.Start_Date = Convert.ToDateTime(projectModel.StartDateString);
}
if (projectModel.EndDateString != null)
{
suspendProject.End_Date = Convert.ToDateTime(projectModel.EndDateString);
}
suspendProject.Priority = projectModel.Priority;
suspendProject.Status = false;
entity.Entry(suspendProject).State = System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
}
return(true);
}
}
public IHttpActionResult Puttbl_parent_task(int id, tbl_parent_task tbl_parent_task)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_parent_task.parent_id)
{
return(BadRequest());
}
db.Entry(tbl_parent_task).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tbl_parent_taskExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
/// <summary>
/// User update method for the entities
/// </summary>
/// <param name="entityToUpdate"></param>
public virtual int Put(int id, User entityToUpdate)
{
Context.Entry(entityToUpdate).State = EntityState.Modified;
return(Context.SaveChanges());
//DbSet.Attach(entityToUpdate);
//ProjectManagerDB.Entry(entityToUpdate).State = EntityState.Modified;
}
/// <summary>
/// Method to create new project or update an existing project
/// </summary>
/// <param name="projectModel"></param>
/// <returns></returns>
public string AddOrUpdateProject(ProjectModel projectModel)
{
string result = string.Empty;
using (ProjectManagerEntities entity = new ProjectManagerEntities())
{
if (projectModel != null)
{
Project addProject = new Project();
addProject.Project_ID = projectModel.ProjectId;
addProject.Project1 = projectModel.Project;
if (projectModel.StartDateString != null && !string.IsNullOrEmpty(projectModel.StartDateString))
{
addProject.Start_Date = Convert.ToDateTime(projectModel.StartDateString);
}
if (projectModel.EndDateString != null && !string.IsNullOrEmpty(projectModel.EndDateString))
{
addProject.End_Date = Convert.ToDateTime(projectModel.EndDateString);
}
addProject.Priority = projectModel.Priority;
addProject.Manager_ID = projectModel.ManagerId;
addProject.Status = true;
result = addProject.Project_ID == 0 ? "ADD" : "UPDATE";
entity.Entry(addProject).State = addProject.Project_ID == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
}
}
return(result);
}
/// <summary>
/// Method to end task
/// </summary>
/// <param name="taskModel"></param>
/// <returns></returns>
public bool End(TaskModel taskModel)
{
using (ProjectManagerEntities entity = new ProjectManagerEntities())
{
if (taskModel != null && taskModel.TaskId != 0)
{
Task endTask = new Task();
endTask.Task_ID = taskModel.TaskId;
endTask.Task1 = taskModel.Task;
if (taskModel.StartDateString != null)
{
endTask.Start_Date = Convert.ToDateTime(taskModel.StartDateString);
}
if (taskModel.EndDateString != null)
{
endTask.End_Date = Convert.ToDateTime(taskModel.EndDateString);
}
endTask.Priority = taskModel.Priority;
endTask.Parent_ID = taskModel.ParentId;
endTask.Project_ID = taskModel.ProjectId;
endTask.Status = false;
entity.Entry(endTask).State = System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
}
return(true);
}
}
public int UpdateProjectDetails(ProjectModel prjModel)
{
int returnVal = 0;
using (ProjectManagerEntities projEntity = new ProjectManagerEntities())
{
Project objProject = projEntity.Projects.Where(x => x.Project_ID == prjModel.Project_ID).FirstOrDefault();
if (objProject != null)
{
objProject.Project1 = prjModel.Project;
objProject.Start_Date = prjModel.Start_Date;
objProject.End_Date = prjModel.End_Date;
objProject.Priority = prjModel.Priority;
objProject.Manager_ID = prjModel.Manager_ID;
objProject.Status = prjModel.Status;
projEntity.Entry(objProject).State = EntityState.Modified;
try
{
projEntity.SaveChanges();
returnVal = 1;
}
catch (Exception ex)
{
return(returnVal);
}
}
}
return(returnVal);
}
public void DeleteUser(CommonLibrary.Users user)
{
DataAccessLayer.User usr = new DataAccessLayer.User
{
UserID = user.UserID
};
_projectManager.Entry(usr).State = EntityState.Deleted;
_projectManager.SaveChanges();
}
/// <summary>
/// Method to create a new task or update an existing task
/// </summary>
/// <param name="taskModel"></param>
/// <returns></returns>
public string ManageTask(TaskModel taskModel)
{
string result = string.Empty;
using (ProjectManagerEntities entity = new ProjectManagerEntities())
{
if (taskModel != null)
{
Task addTask = new Task();
addTask.Task1 = taskModel.Task;
if (taskModel.StartDateString != null && !string.IsNullOrEmpty(taskModel.StartDateString))
{
addTask.Start_Date = Convert.ToDateTime(taskModel.StartDateString);
}
if (taskModel.EndDateString != null && !string.IsNullOrEmpty(taskModel.EndDateString))
{
addTask.End_Date = Convert.ToDateTime(taskModel.EndDateString);
}
addTask.Priority = taskModel.Priority;
addTask.Parent_ID = taskModel.ParentId;
addTask.Task_ID = taskModel.TaskId;
addTask.Project_ID = taskModel.ProjectId;
addTask.Status = true;
result = addTask.Task_ID == 0 ? "ADD" : "UPDATE";
entity.Entry(addTask).State = addTask.Task_ID == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
if (result == "ADD")
{
int taskId = GetTaskId();
if (taskModel.UserId != 0)
{
User userTask = GetUserById(taskModel.UserId);
userTask.Project_ID = taskModel.ProjectId;
userTask.Task_ID = taskId;
userTask.User_ID = taskModel.UserId;
entity.Entry(userTask).State = System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
}
}
}
}
return(result);
}
public void DeleteUser(CommonEntities.Users user)
{
Users ur = new Users
{
UserID = user.UserID
};
_projectManager.Entry(ur).State = EntityState.Deleted;
_projectManager.SaveChanges();
}
public void SuspendProject(int ProjectID)
{
DataAccessLayer.Project proj = new DataAccessLayer.Project
{
ProjectID = ProjectID
};
var user = _projectManager.Users.Where(x => x.ProjectID == ProjectID).FirstOrDefault();
if (user != null)
{
user.ProjectID = null;
}
_projectManager.Entry(proj).State = EntityState.Deleted;
_projectManager.SaveChanges();
}
public bool DeleteUser(UsersModel user)
{
//using (ProjectManagerEntities dbContext = new ProjectManagerEntities())
//{
try
{
var userData = new Users_Table { User_ID = user.User_ID };
dbContext.Entry(userData).State = EntityState.Deleted;
dbContext.SaveChanges();
}
catch (Exception e)
{
return false;
}
return true;
}
public void SuspendProject(int projectID)
{
Projects proj = new Projects
{
ProjectID = projectID
};
var user = _projectManager.Users1.Where(x => x.ProjectID == projectID).FirstOrDefault();
if (user != null)
{
user.ProjectID = null;
}
_projectManager.Entry(proj).State = EntityState.Deleted;
_projectManager.SaveChanges();
}
/// <summary>
/// Method to create a new task or update an existing task
/// </summary>
/// <param name="taskModel"></param>
/// <returns></returns>
public string AddParent(TaskModel taskModel)
{
string result = string.Empty;
using (ProjectManagerEntities entity = new ProjectManagerEntities())
{
if (taskModel != null)
{
ParentTask parentTask = new ParentTask();
parentTask.Parent_Task = taskModel.Task;
entity.Entry(parentTask).State = System.Data.Entity.EntityState.Added;
entity.SaveChanges();
result = "ADD";
}
}
return(result);
}
/// <summary>
/// Method to delete user
/// </summary>
/// <param name="userModel"></param>
/// <returns></returns>
public bool DeleteUser(UserModel userModel)
{
using (ProjectManagerEntities entity = new ProjectManagerEntities())
{
if (userModel != null && userModel.UserId != 0)
{
User deleteUser = new User();
deleteUser.User_ID = userModel.UserId;
deleteUser.First_Name = userModel.FirstName;
deleteUser.Last_Name = userModel.LastName;
deleteUser.Employee_ID = userModel.EmployeeId;
deleteUser.IsActive = false;
entity.Entry(deleteUser).State = System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
}
return(true);
}
}
public bool DeleteProject(ProjectModel project)
{
try
{
var userData = dbContext.Users_Table.Where(c => c.User_ID == project.User_ID).First();
userData.Project_ID = null;
dbContext.SaveChanges();
var projectData = new Project_Table {
Project_ID = project.Project_ID
};
dbContext.Entry(projectData).State = EntityState.Deleted;
dbContext.SaveChanges();
}
catch (Exception e)
{
return(false);
}
return(true);
}
/// <summary>
/// Method to create or update a user
/// </summary>
/// <param name="userModel"></param>
/// <returns></returns>
public string AddOrUpdateUser(UserModel userModel)
{
string result = string.Empty;
using (ProjectManagerEntities entity = new ProjectManagerEntities())
{
if (userModel != null)
{
User addUser = new User();
addUser.First_Name = userModel.FirstName;
addUser.Last_Name = userModel.LastName;
addUser.Employee_ID = userModel.EmployeeId;
addUser.IsActive = true;
addUser.User_ID = userModel.UserId;
result = addUser.User_ID == 0 ? "ADD" : "UPDATE";
entity.Entry(addUser).State = addUser.User_ID == 0 ? System.Data.Entity.EntityState.Added : System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
}
}
return(result);
}
public void DeleteUser(int iUserID)
{
try
{
using (ProjectManagerEntities context = new ProjectManagerEntities())
{
User user = GetUsersByID(iUserID);
if (user != null)
{
User usrDelete = new User {
User_ID = iUserID
};
context.Entry(usrDelete).State = EntityState.Deleted;
context.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex.InnerException;
}
}
public void SuspendProject(int projectID)
{
Project proj = new Project
{
Project_ID = projectID
};
//var friends = db.Friends.Where(f => idList.Contains(f.ID)).ToList();
//friends.ForEach(a => a.msgSentBy = '1234');
//db.SaveChanges();
var user = _projectManager.Users.Where(x => x.Project_ID == projectID).ToList();
if (user.Count > 0)
{
user.ForEach(a => a.Project_ID = null);
}
var task = _projectManager.Tasks.Where(x => x.Project_ID == projectID).ToList();
if (task.Count > 0)
{
task.ForEach(a => a.Project_ID = null);
}
_projectManager.Entry(proj).State = EntityState.Deleted;
_projectManager.SaveChanges();
}