public TEntity GetById(int id)
{
var entity = Db.Set <TEntity>().Find(id);
Db.Entry <TEntity>(entity).Reload();
return(entity);
//return Db.Set<TEntity>().Find(id);
}
/// <summary>
/// Method to create new task or update an existing task
/// </summary>
/// <param name="taskModel"></param>
/// <returns></returns>
public string InsertTask(TaskModel taskModel)
{
string result = string.Empty;
using (TaskManagerEntities entity = new TaskManagerEntities())
{
if (taskModel != null)
{
Task addTask = new Task();
addTask.Task1 = taskModel.Task;
if (taskModel.StartDateString != null)
{
addTask.Start_Date = Convert.ToDateTime(taskModel.StartDateString);
}
if (taskModel.EndDateString != null)
{
addTask.End_Date = Convert.ToDateTime(taskModel.EndDateString);
}
addTask.Priority = taskModel.Priority;
addTask.Parent_Id = taskModel.ParentId;
addTask.Task_Id = taskModel.TaskId;
addTask.IsActive = 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();
}
}
return(result);
}
/// <summary>
/// Method to end task
/// </summary>
/// <param name="taskModel"></param>
/// <returns></returns>
public bool UpdateTask(TaskModel taskModel)
{
using (TaskManagerEntities entity = new TaskManagerEntities())
{
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.IsActive = false;
entity.Entry(endTask).State = System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
}
return(true);
}
}
public string SaveProject(Project projectModel)
{
if (projectModel != null)
{
Project Project = GetProject(projectModel.ProjectID);
using (TaskManagerEntities db = new TaskManagerEntities())
{
if (Project == null)
{
projectModel.Status = true;
db.Projects.Add(projectModel);
}
else
{
Project.ProjectName = projectModel.ProjectName;
Project.Priority = projectModel.Priority;
Project.EndDate = projectModel.EndDate;
Project.StartDate = projectModel.StartDate;
Project.Status = projectModel.Status;
db.Entry(Project).State = EntityState.Modified;
}
db.SaveChanges();
}
}
return(projectModel.ProjectID.ToString());
}
public int UpdateTask(int taskid, Task taskdetails)
{
try
{
if (taskdetails != null)
{
if (taskdetails.Task_ID != 0)
{
Task t = TME.Tasks.Where(x => x.Task_ID == taskid).FirstOrDefault();
if (t != null)
{
t.Task1 = taskdetails.Task1;
t.Parent_ID = taskdetails.Parent_ID;
t.Priority = taskdetails.Priority;
t.Start_Date = taskdetails.Start_Date;
t.End_Date = taskdetails.End_Date;
TME.Tasks.Add(t);
TME.Entry(t).State = System.Data.Entity.EntityState.Modified;
return(TME.SaveChanges());
}
}
return(TME.SaveChanges());
}
}
catch (Exception e)
{
throw e;
}
return(0);
}
public void InsertarentTask(Parent_Task task)
{
using (taskManagerEntities = new TaskManagerEntities())
{
if (task.Parent_Task_Id == 0)
{
taskManagerEntities.Parent_Task.Add(task);
taskManagerEntities.Entry(task).State = System.Data.Entity.EntityState.Added;
}
else
{
taskManagerEntities.Parent_Task.Add(task);
taskManagerEntities.Entry(task).State = System.Data.Entity.EntityState.Modified;
}
taskManagerEntities.SaveChanges();
}
}
public void SaveProject(Project project)
{
using (taskManagerEntities = new TaskManagerEntities())
{
project.Is_Active = true;
if (project.Project_Id == 0)
{
taskManagerEntities.Projects.Add(project);
taskManagerEntities.Entry(project).State = System.Data.Entity.EntityState.Added;
}
else
{
taskManagerEntities.Projects.Add(project);
taskManagerEntities.Entry(project).State = System.Data.Entity.EntityState.Modified;
}
taskManagerEntities.SaveChanges();
}
}
public void SaveUser(User user)
{
using (taskManagerEntities = new TaskManagerEntities())
{
user.Is_Active = true;
if (user.User_Id == 0)
{
taskManagerEntities.Users.Add(user);
taskManagerEntities.Entry(user).State = System.Data.Entity.EntityState.Added;
}
else
{
taskManagerEntities.Users.Add(user);
taskManagerEntities.Entry(user).State = System.Data.Entity.EntityState.Modified;
}
taskManagerEntities.SaveChanges();
}
}
public void Delete(int ProjectId)
{
TaskManagerEntities taskmanagerEntities = new TaskManagerEntities();
var DeletedProjects = taskmanagerEntities.Projects.Where(x => x.Project_Id == ProjectId).FirstOrDefault();
taskmanagerEntities.Entry <Project>(DeletedProjects).State = System.Data.Entity.EntityState.Deleted;
taskmanagerEntities.SaveChanges();
}
public void Delete(int UserId)
{
TaskManagerEntities taskmanagerEntities = new TaskManagerEntities();
var DeletedUsers = taskmanagerEntities.Users.Where(x => x.User_Id == UserId).FirstOrDefault();
taskmanagerEntities.Entry <User>(DeletedUsers).State = System.Data.Entity.EntityState.Deleted;
taskmanagerEntities.SaveChanges();
}
public int InsertTask(Task task)
{
using (taskManagerEntities = new TaskManagerEntities())
{
if (task.Task_Id == 0)
{
task.Is_Active = true;
taskManagerEntities.Tasks.Add(task);
taskManagerEntities.Entry(task).State = System.Data.Entity.EntityState.Added;
}
else
{
taskManagerEntities.Tasks.Add(task);
taskManagerEntities.Entry(task).State = System.Data.Entity.EntityState.Modified;
}
taskManagerEntities.SaveChanges();
}
return(task.Task_Id);
}
public void DeleteProject(Project project)
{
using (taskManagerEntities = new TaskManagerEntities())
{
project.Is_Active = false;
taskManagerEntities.Projects.Add(project);
taskManagerEntities.Entry(project).State = System.Data.Entity.EntityState.Modified;
taskManagerEntities.SaveChanges();
}
}
public void DeleteUser(User user)
{
using (taskManagerEntities = new TaskManagerEntities())
{
user.Is_Active = false;
taskManagerEntities.Users.Add(user);
taskManagerEntities.Entry(user).State = System.Data.Entity.EntityState.Modified;
taskManagerEntities.SaveChanges();
}
}
public void DeleteTask(Task task)
{
using (taskManagerEntities = new TaskManagerEntities())
{
task.Is_Active = false;
taskManagerEntities.Tasks.Add(task);
taskManagerEntities.Entry(task).State = System.Data.Entity.EntityState.Modified;
//taskManagerEntities.Entry(task).State = System.Data.Entity.EntityState.Deleted;
taskManagerEntities.SaveChanges();
}
}
public string SaveUser(User userModel)
{
if (userModel != null)
{
User user = GetUser(userModel.Employee_ID);
using (TaskManagerEntities db = new TaskManagerEntities())
{
if (user == null)
{
db.Users.Add(userModel);
}
else
{
user.FirstName = userModel.FirstName;
user.LastName = userModel.LastName;
user.IsActive = userModel.IsActive;
db.Entry(user).State = System.Data.Entity.EntityState.Modified;
}
db.SaveChanges();
}
}
return(userModel.User_ID.ToString());
}
public void UpdateTask(int id, ITask task)
{
_taskContext.Entry(task).State = EntityState.Modified;
_taskContext.SaveChanges();
}
