public ActualTask GetTask()
{
#region DB functions
string query = "select at.id, at.title, at.description, at.end_date, at.assign_to, e.first_name from actual_tasks at inner join employees e on at.assign_to = e.id where at.id =" + Id + "";
ActualTask task = new ActualTask();
DbServices db = new DbServices();
DataSet ds = db.GetDataSetByQuery(query);
foreach (DataRow dr in ds.Tables[0].Rows)
{
try
{
Employee emp = new Employee();
task.Id = (int)dr["id"];
task.Title = dr["title"].ToString();
task.Description = dr["description"].ToString();
task.End_date = (DateTime)dr["end_date"];
emp.First_name = dr["first_name"].ToString();
emp.Id = (int)dr["assign_to"];
task.Assign_to = emp;
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
throw ex;
}
}
#endregion
return(task);
}
public void SetActualProjectTask(int taskID, string task_title, string end_date, int assign_to, int assign_to_project, string description, int created_by, string func)
{
DateTime task_end_date;
if (end_date.Contains("."))
{
task_end_date = DateTime.Parse(end_date);
}
else
{
task_end_date = DateTime.ParseExact(end_date, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
DateTime created_at = DateTime.Now; //REMOVE after updating the db!!
Employee emp_creator = new Employee();
emp_creator.Id = created_by;
Employee emp_assign_to = new Employee();
emp_assign_to.Id = assign_to;
Project project = new Project();
project.Id = assign_to_project;
ActualTask actualTask = new ActualTask(taskID, description, task_title, created_at, task_end_date, emp_creator, emp_assign_to);
ActualProjectTask actualProjectTask = new ActualProjectTask(project, actualTask);
actualProjectTask.SetTask(func);
}
public ActualTaskStatus(Status status, ActualTask actual_task, DateTime modified_at, bool is_current, Employee modified_by)
{
this.Status = status;
this.Actual_task = actual_task;
this.Modified_at = modified_at;
this.Is_current = is_current;
this.Modified_by = modified_by;
}
public string GetTask(int taskID)
{
JavaScriptSerializer j = new JavaScriptSerializer();
ActualTask t = new ActualTask();
t.Id = taskID;
ActualTask task = t.GetTask();
return(j.Serialize(task));
}
public ActionResult InsetActualTask([FromBody] ActualTask actualTask)
{
try
{
_context.Entry(actualTask).State = actualTask.Id == 0? EntityState.Added : EntityState.Modified;
_context.SaveChanges();
return(Ok("Task added"));
}
catch (Exception e)
{
return(StatusCode(500, "exception: " + e));
}
}
public string GetAllTasksList()
{
try
{
ActualTask actualTask = new ActualTask();
List <ActualTask> allTasksList = actualTask.GetAllTasksList();
string allTasksListJson = JsonConvert.SerializeObject(allTasksList, new IsoDateTimeConverter());
return(allTasksListJson);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(ex.ToString());
}
}
public List <Dashboard> GetMyTasksList(Employee employee)
{
#region DB functions
string query = "select at.id task_id, p.title project_title, emp.first_name, at.end_date,at.title task_title, s.title status from projects p inner join actual_project_task apt on apt.project_id = p.id inner join actual_tasks at on at.id = apt.actual_tasks_id inner join actual_tasks_statuses ats on ats.task_id = at.id inner join employees emp on emp.id = at.assign_to inner join statuses s on s.id = ats.status_id " +
"where " +
"emp.id =" + employee.Id +
"and " +
"ats.is_current = 1 " +
"and " +
"s.title = 'Mr';"; // TODO: should be change to the required status
List <Dashboard> myTaskList = new List <Dashboard>();
DbServices db = new DbServices();
DataSet ds = db.GetDataSetByQuery(query);
foreach (DataRow dr in ds.Tables[0].Rows)
{
try
{
Project project = new Project();
ActualTask actual_task = new ActualTask();
Status status = new Status();
project.Title = dr["project_title"].ToString();
actual_task.Id = (int)dr["task_id"];
actual_task.End_date = (DateTime)dr["end_date"];
actual_task.Title = dr["task_title"].ToString();
employee.First_name = dr["first_name"].ToString();
actual_task.Assign_to = employee;
status.Title = dr["status"].ToString();
Dashboard tmpMyTask = new Dashboard(actual_task.Id, project.Title, actual_task.End_date, actual_task.Title, actual_task.Assign_to.First_name, status.Title);
myTaskList.Add(tmpMyTask);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
throw ex;
}
}
#endregion
return(myTaskList);
}
public List <ActualTask> GetAllTasksList()
{
#region DB functions
string query = "select at.*,e_assign_to.first_name as assign_to_fn, e_created_by.first_name created_by_fn from actual_tasks as at inner join employees e_assign_to on at.assign_to = e_assign_to.id inner join employees e_created_by on e_created_by.id = at.created_by;";
List <ActualTask> actualTasksList = new List <ActualTask>();
DbServices db = new DbServices();
DataSet ds = db.GetDataSetByQuery(query);
foreach (DataRow dr in ds.Tables[0].Rows)
{
try
{
ActualTask actual_task_temp = new ActualTask();
Employee created_by = new Employee();
Employee assign_to = new Employee();
created_by.First_name = dr["created_by_fn"].ToString();
created_by.Id = Convert.ToInt32(dr["created_by"]);
assign_to.First_name = dr["assign_to_fn"].ToString();
assign_to.Id = Convert.ToInt32(dr["assign_to"]);
actual_task_temp.Title = dr["title"].ToString();
actual_task_temp.Description = dr["description"].ToString();
actual_task_temp.Id = Convert.ToInt32(dr["id"]);
actual_task_temp.Start_date = Convert.ToDateTime(dr["start_date"]);
actual_task_temp.End_date = Convert.ToDateTime(dr["end_date"]);
actual_task_temp.Created_by = created_by;
actual_task_temp.Assign_to = assign_to;
actualTasksList.Add(actual_task_temp);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
throw ex;
}
}
#endregion
return(actualTasksList);
}
public ActualProjectTask(Project project, ActualTask actual_task)
{
this.Project = project;
this.Actual_task = actual_task;
}
