/// <summary>
/// GetAllTask
/// </summary>
/// <returns></returns>
public List <TaskModel> GetAllTask()
{
TaskManagerEntities entity = new TaskManagerEntities();
var taskE = (from task in entity.Tasks.Include("ParentTask")
select new TaskModel()
{
TaskId = task.Task_Id,
Task = task.Task1,
ParentTask = task.ParentTask.Parent_Task,
Priority = task.Priority,
StartDate = task.Start_Date,
EndDate = task.End_Date,
ParentId = task.ParentTask.Parent_Id,
}).ToList();
if (taskE != null)
{
foreach (var item in taskE)
{
if (item.StartDate != null)
{
item.StartDateString = item.StartDate.ToString();
}
if (item.EndDate != null)
{
item.EndDateString = item.EndDate.ToString();
}
}
}
return(taskE);
}
/// <summary>
/// AddTask
/// </summary>
/// <param name="taskModel"></param>
/// <returns></returns>
public bool AddTask(TaskModel taskModel)
{
TaskManagerEntities entity = new TaskManagerEntities();
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;
if (!string.IsNullOrEmpty(taskModel.ParentTask))
{
ParentTask pTask = new ParentTask();
pTask.Parent_Task = taskModel.ParentTask;
addTask.ParentTask = pTask;
}
entity.Tasks.Add(addTask);
entity.SaveChanges();
return(true);
}
/// <summary>
/// GetTaskById
/// </summary>
/// <param name="taskId"></param>
/// <returns></returns>
public TaskModel GetTaskById(int taskId)
{
TaskManagerEntities entity = new TaskManagerEntities();
var taskE = (from task in entity.Tasks.Include("ParentTask")
where task.Task_Id == taskId
select new TaskModel()
{
TaskId = task.Task_Id,
Task = task.Task1,
ParentTask = task.ParentTask.Parent_Task,
Priority = task.Priority,
StartDate = task.Start_Date,
EndDate = task.End_Date,
ParentId = task.ParentTask.Parent_Id,
}).FirstOrDefault();
if (taskE != null)
{
if (taskE.StartDate != null)
{
taskE.StartDateString = taskE.StartDate.ToString();
}
if (taskE.EndDate != null)
{
taskE.EndDateString = taskE.EndDate.ToString();
}
}
return(taskE);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <UserModel> GetUserDetails()
{
List <UserModel> userModelList = null;
using (TaskManagerEntities db = new TaskManagerEntities())
{
var userList = db.GET_USER_DETAILS();
if (userList != null)
{
userModelList = new List <UserModel>();
foreach (var item in userList)
{
userModelList.Add(new UserModel()
{
User_ID = item.User_ID,
First_Name = item.First_Name,
Last_Name = item.Last_Name,
Employee_ID = item.Employee_ID
});
}
}
return(userModelList);
}
}
/// <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);
}
public List <TaskDetails> GetTaskDetails()
{
TaskManagerEntities taskmanagerEntities = new TaskManagerEntities();
//taskmanagerEntities.Configuration.ProxyCreationEnabled = false;
var TaskDetails = (from task in taskmanagerEntities.Tasks
join parenttask in taskmanagerEntities.Tasks on task.Parent_Id equals parenttask.Task_Id into tGroup
from parenttask in tGroup.DefaultIfEmpty()
join projects in taskmanagerEntities.Projects on task.Project_Id equals projects.Project_Id into pGroup
from projects in pGroup.DefaultIfEmpty()
join users in taskmanagerEntities.Users on task.User_Id equals users.User_Id into uGroup
from users in uGroup.DefaultIfEmpty()
select new TaskDetails {
TaskId = task.Task_Id,
Task = task.Name,
ParentTask = task.Parent_Id != 0 ? parenttask.Name : "",
Priority = task.Parent_Id != 0 ? parenttask.Priority : task.Priority,
StartDate = task.Parent_Id != 0 ? parenttask.Start_Date.ToString() : task.Start_Date.ToString(),
EndDate = task.Parent_Id != 0 ? parenttask.End_Date.ToString() : task.End_Date.ToString(),
EditFlag = task.Edit_Flag,
Project = projects.Name,
User = users.First_Name
}).ToList <TaskDetails>();
return(TaskDetails);
}
public List <TaskDetailsModel> GetTaskDetails(TaskSearchModel taskSearchModel)
{
using (taskManagerEntities = new TaskManagerEntities())
{
var result = (from t in taskManagerEntities.Tasks
join p in taskManagerEntities.Parent_Task
on t.Parent_Task_Id equals p.Parent_Task_Id
where ((taskSearchModel.Task == null || taskSearchModel.Task == "" ||
t.Task1.ToLower().Contains(taskSearchModel.Task.ToLower())) &&
(taskSearchModel.ParentTask == null || taskSearchModel.ParentTask == "" ||
p.Parent_Task1.ToLower().Contains(taskSearchModel.ParentTask.ToLower())) &&
(taskSearchModel.PriorityFrom == null || t.Priority >= taskSearchModel.PriorityFrom) &&
(taskSearchModel.PriorityTo == null || t.Priority <= taskSearchModel.PriorityTo) &&
(taskSearchModel.StartDate == null || t.Start_Date == taskSearchModel.StartDate) &&
(taskSearchModel.EndDate == null || t.End_Date == taskSearchModel.EndDate) &&
(taskSearchModel.ProjectId == 0 || t.Project_Id == taskSearchModel.ProjectId)
)
select new TaskDetailsModel()
{
TaskId = t.Task_Id,
ParentTaskId = t.Parent_Task_Id,
Task = t.Task1,
ParentTask = p.Parent_Task1,
Priority = t.Priority,
StartDate = t.Start_Date,
EndDate = t.End_Date,
IsActive = t.Is_Active,
Status = t.Status,
ProjectId = t.Project_Id
}).ToList();
return(result);
}
}
//Update Task by ID
public HttpResponseMessage Put(int id, [FromBody] Quote quote)
{
try
{
using (TaskManagerEntities entities = new TaskManagerEntities())
{
var entity = entities.Quotes.FirstOrDefault(q => q.QuoteID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Task with Id " + id.ToString() + " not found to update"));
}
else
{
entity.QuoteType = quote.QuoteType;
entity.Contact = quote.Contact;
entity.DueDate = quote.DueDate;
entity.Task = quote.Task;
entity.TaskType = quote.TaskType;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, entity));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
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());
}
//Delete Task by ID
public HttpResponseMessage Delete(int id)
{
try
{
using (TaskManagerEntities entities = new TaskManagerEntities())
{
var entity = entities.Quotes.FirstOrDefault(q => q.QuoteID == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound,
"Task with Id = " + id.ToString() + " not found to delete"));
}
else
{
entities.Quotes.Remove(entity);
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex));
}
}
public void AddTask(Task taskData)
{
using (var db = new TaskManagerEntities())
{
db.Tasks.Add(taskData);
}
}
/// <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 HttpResponseMessage Post(HttpRequestMessage request)///
{
var json = request.Content.ReadAsStringAsync().Result;
var requestData = Newtonsoft.Json.JsonConvert.DeserializeObject <User>(json);
using (TaskManagerEntities ent = new TaskManagerEntities())
{
var response = new HttpResponseMessage();
response.StatusCode = HttpStatusCode.BadRequest;
var user = ent.Users.FirstOrDefault(e => e.email == requestData.email);
if (user != null)
{
response.Content = new StringContent("Email already exists in the system");
return(response);
}
else
{
response.StatusCode = HttpStatusCode.OK;
response.Content = new ObjectContent <User>(requestData, new JsonMediaTypeFormatter());
ent.Users.Add(requestData);
ent.SaveChanges();
return(response);
}
}
}
public List <ProjectModel> GetProject()
{
using (TaskManagerEntities db = new TaskManagerEntities())
{
var projectList = (from project in db.Projects
join task in db.Tasks on project.ProjectID equals task.Project_ID into allPro
from temp in allPro.DefaultIfEmpty()
where project.Status == true
//orderby project.Project_ID descending
select new ProjectModel()
{
ProjectID = project.ProjectID,
ProjectName = project.ProjectName,
Priority = project.Priority,
StartDate = project.StartDate,
EndDate = project.EndDate,
Status = project.Status,
NoOfTasks = project.Tasks.Count(),
ManagerID = project.ManagerID.ToString(),
CompletedTasks = project.Tasks.Where(x => x.IsActive == false).Count()
}).Distinct().ToList();
return(projectList.OrderByDescending(x => x.ProjectID).ToList());
}
}
/// <summary>
/// Method to get all task
/// </summary>
/// <returns></returns>
public List <TaskModel> GetAllTask()
{
using (TaskManagerEntities entity = new TaskManagerEntities())
{
var taskList = (from task in entity.Tasks.Include("ParentTask") orderby task.Task_Id descending
select new TaskModel()
{
TaskId = task.Task_Id,
Task = task.Task1,
ParentTask = task.ParentTask.Parent_Task,
Priority = task.Priority,
StartDate = task.Start_Date,
EndDate = task.End_Date,
ParentId = task.ParentTask.Parent_Id,
IsActive = task.IsActive
}).ToList();
if (taskList != null)
{
foreach (var item in taskList)
{
if (item.StartDate != null)
{
item.StartDateString = item.StartDate.ToString();
}
if (item.EndDate != null)
{
item.EndDateString = item.EndDate.ToString();
}
}
}
return(taskList);
}
}
public IEnumerable <Quote> Get()
{
using (TaskManagerEntities entities = new TaskManagerEntities())
{
return(entities.Quotes.ToList());
}
}
// POST api/values
public HttpResponseMessage Post(HttpRequestMessage request)
{
//MainAccess main = new MainAccess();
//var json = request.Content.ReadAsStringAsync().Result;
//var requestData = Newtonsoft.Json.JsonConvert.DeserializeObject<User>(json);
//var response = new HttpResponseMessage();
//User user;
//try
//{
// user = main.authenticateUser(requestData.username, requestData.password);
//}
//catch (ArgumentOutOfRangeException e)
//{
// response.StatusCode = HttpStatusCode.BadRequest;
// if (e.ParamName == "username")
// {
// response.Content = new StringContent("שם משתמש או סיסמא שגויים");
// }
// else if (e.ParamName == "password")
// {
// response.Content = new StringContent("שם משתמש או סיסמא שגויים");
// }
// return response;
//}
//Company company = main.GetCompany(user.companyId);
//response.Content = new ObjectContent<AuthenticateResponse>(new AuthenticateResponse(user, company), new JsonMediaTypeFormatter());
//return response;
//return new HttpResponseMessage(HttpStatusCode.NotFound);
var json = request.Content.ReadAsStringAsync().Result;
var requestData = Newtonsoft.Json.JsonConvert.DeserializeObject <User>(json);
using (TaskManagerEntities ent = new TaskManagerEntities())
{
var response = new HttpResponseMessage();
response.StatusCode = HttpStatusCode.BadRequest;
//response.Content = new ObjectContent<User>(ent.Users.FirstOrDefault(e => e.email == requestData.email), new JsonMediaTypeFormatter());
var user = ent.Users.FirstOrDefault(e => e.email == requestData.email);
if (user == null)
{
response.Content = new StringContent("No such email here...");
return(response);
}
else if (user.password != requestData.password)
{
response.Content = new StringContent("Wrong Password!!!");
return(response);
}
else
{
response.StatusCode = HttpStatusCode.OK;
response.Content = new ObjectContent <User>(user, new JsonMediaTypeFormatter());
return(response);
}
}
}
public IEnumerable <GET_TASK_DETAILS_Result> GetTaskDetails()
{
using (TaskManagerEntities db = new TaskManagerEntities())
{
var VTaskDetails = db.GET_TASK_DETAILS().ToList();
return(VTaskDetails);
}
}
public IEnumerable <GET_PARENT_TASK_Result> GetParentTask()
{
using (TaskManagerEntities db = new TaskManagerEntities())
{
var VParentTask = db.GET_PARENT_TASK().ToList();
return(VParentTask);
}
}
public void Create(User user)
{
TaskManagerEntities taskmanagerEntities = new TaskManagerEntities();
// taskmanagerEntities.Configuration.ProxyCreationEnabled = false;
taskmanagerEntities.Users.Add(user);
taskmanagerEntities.SaveChanges();
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public IEnumerable <Get_Task_Details_Result> GetTaskDetails()
{
using (TaskManagerEntities db = new TaskManagerEntities())
{
var VTaskDetails = db.Get_Task_Details().ToList();
return(VTaskDetails);
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public IEnumerable <Get_Parent_Task_Result> GetParentTask()
{
using (TaskManagerEntities db = new TaskManagerEntities())
{
var VParentTask = db.Get_Parent_Task().ToList();
return(VParentTask);
}
}
public void Create(Task task)
{
TaskManagerEntities taskmanagerEntities = new TaskManagerEntities();
// taskmanagerEntities.Configuration.ProxyCreationEnabled = false;
taskmanagerEntities.Tasks.Add(task);
taskmanagerEntities.SaveChanges();
}
public void Create(Project project)
{
TaskManagerEntities taskmanagerEntities = new TaskManagerEntities();
// taskmanagerEntities.Configuration.ProxyCreationEnabled = false;
taskmanagerEntities.Projects.Add(project);
taskmanagerEntities.SaveChanges();
}
public List <User> GetManager(string name)
{
//.Select(x => new { UserID = x.UserId, Name = x.Name })
using (TaskManagerEntities db = new TaskManagerEntities())
{
var manager = db.Users.Where(x => x.FirstName.Contains(name)).ToList();
return(manager);
}
}
public Project GetProject(int ProjectID)
{
using (TaskManagerEntities db = new TaskManagerEntities())
{
var Project = db.Projects.Where(i => i.ProjectID == ProjectID).FirstOrDefault();
return(Project);
}
}
public User GetUser(string employeeId)
{
using (TaskManagerEntities db = new TaskManagerEntities())
{
var user = db.Users.Where(i => i.Employee_ID == employeeId).FirstOrDefault();
return(user);
}
}
public string UpdateEndTask(GET_TASK_DETAILS_Result objGET_TASK_DETAILS_Result)
{
using (TaskManagerEntities db = new TaskManagerEntities())
{
var vUpdateEndTask = db.UPDATE_END_TASK(objGET_TASK_DETAILS_Result.Task_ID, objGET_TASK_DETAILS_Result.End_Date);
db.SaveChanges();
return(Convert.ToString(vUpdateEndTask));
}
}
public string InsertTaskDetails(GET_TASK_DETAILS_Result objGET_TASK_DETAILS_Result)
{
using (TaskManagerEntities db = new TaskManagerEntities())
{
var vInsertTaskDetails = db.INSERT_TASK_DETAILS(objGET_TASK_DETAILS_Result.Task_ID, objGET_TASK_DETAILS_Result.Parent_ID, objGET_TASK_DETAILS_Result.Task, objGET_TASK_DETAILS_Result.Start_Date, objGET_TASK_DETAILS_Result.End_Date, objGET_TASK_DETAILS_Result.Priority);
db.SaveChanges();
return(Convert.ToString(vInsertTaskDetails));
}
}
//
public HttpResponseMessage Get(int id)
{
using (TaskManagerEntities ent = new TaskManagerEntities())
{
var response = new HttpResponseMessage();
response.Content = new ObjectContent <List <List> >(ent.Lists.Where(e => e.id == id).ToList(), new JsonMediaTypeFormatter());
response.StatusCode = HttpStatusCode.OK;
return(response);
}
}
