コード例 #1
0
       public TaskTracker GetSubTaskByID(int id)
       {
           TaskTracker _obj = new TaskTracker();

           return _obj.GetSubTaskByID(id);


       }
コード例 #2
0
 public IHttpActionResult EditTask(TaskTracker _obj)
  {
      TaskTracker _objTask = new TaskTracker();
      if (!ModelState.IsValid)
      {
          return BadRequest(ModelState);
      }
      
      try {
          _objTask.UpdateTask(_obj.Task_ID, _obj.Title, _obj.Description, Convert.ToDateTime( _obj.TaskDueDate), _obj.Task_Status, Convert.ToDateTime( _obj.StartDate));
      }
      catch (Exception ex) { }
     
      return StatusCode(HttpStatusCode.NoContent);
  }
コード例 #3
0
ファイル: TaskTracker.cs プロジェクト: Nirankari/ERC.Tasks
        public List<TaskTracker> GetTaskAndSubTask()
        {

            List<TaskTracker> _lst = new List<TaskTracker>();
            using (var db = new SqlHelper(ConfigurationManager.ConnectionStrings["collect2000ConnectionString"].ConnectionString))
            {
                var q = @"SELECT Task_ID, Task_Title, InternalRadioOption, DayInterval, MonthInterval,WeekNumber,WeekDayName,MonthName, Task_Description, TaskAssignedTo, Task_DueDate, CreatedDate, AppointmentStartTime, AppointmentEndTime, RecurrencePatternType, RecurrencePatternInterval, RecurrencePatternFallOn, RecurrenceRangeStartDate, RecurrenceRangeEndByDate, RecurrenceRangeType, RecurrenceRangeOccurrence, TaskAssignedBy  FROM dbo.ERC_Tasks ORDER BY Task_ID DESC;";
                using (var dr = db.Query(q))
                {
                    while (dr.Read())
                    {
                        TaskTracker info = new TaskTracker();
                        info.Task_ID = Convert.ToInt32(dr[0].ToString());
                        info.Title = Convert.ToString(dr["Task_Title"]);
                        info.Description = Convert.ToString(dr["Task_Description"]);
                        info.TaskDueDate = Convert.ToString(dr["Task_DueDate"]);
                        info.CreatedDate = Convert.ToString(dr["CreatedDate"]);
                        info.AppointmentStartTime = dr["AppointmentStartTime"] as string ?? "";
                        info.AppointmentEndTime = dr["AppointmentEndTime"] as string ?? "";
                        info.RecurrencePatternType = dr["RecurrencePatternType"] as string ?? "";
                        info.RecurrencePatternInterval = dr["RecurrencePatternInterval"] as int? ?? 0;
                        info.RecurrencePatternFallOn = dr["RecurrencePatternFallOn"] as string ?? "";
                        info.RecurrenceRangeStartDate = dr["RecurrenceRangeStartDate"] as string ?? "";
                        info.RecurrenceRangeEndByDate = dr["RecurrenceRangeEndByDate"] as string ?? "";
                        info.RecurrenceRangeType = dr["RecurrenceRangeType"] as string ?? "";
                        info.RecurrenceRangeOccurrence = dr["RecurrenceRangeOccurrence"] as int? ?? 0;
                        info.TaskAssignedBy = Convert.ToString(dr["TaskAssignedBy"]) as string ?? "";
                        info.TaskAssignedTo = Convert.ToString(dr["TaskAssignedTo"]) as string ?? "";
                        info.InternalRadioOption = Convert.ToString(dr["InternalRadioOption"]) as string ?? "";
                        info.DayInterval = Convert.ToString(dr["DayInterval"]) as string ?? "";
                        info.MonthInterval = Convert.ToString(dr["MonthInterval"]) as string ?? "";
                        info.WeekNumber = Convert.ToString(dr["WeekNumber"]) as string ?? "";
                        info.WeekDayName = Convert.ToString(dr["WeekDayName"]) as string ?? "";
                        info.MonthName = Convert.ToString(dr["MonthName"]) as string ?? "";

                        info.SubTask = GetSubTaskList(Convert.ToInt32(dr[0].ToString()));
                        _lst.Add(info);
                    }
                }
            }
            if (_lst == null)
            {
                throw new Exception("No match data found ");
            }
            return _lst;
        }
コード例 #4
0
ファイル: TaskTracker.cs プロジェクト: Nirankari/ERC.Tasks
        public TaskTracker GetSubTaskByID(int ID)
        {
            TaskTracker info = new TaskTracker();
            using (var db = new SqlHelper(ConfigurationManager.ConnectionStrings["collect2000ConnectionString"].ConnectionString))
            {
                var q = @"SELECT SubTask_ID, Task_ID, Task_Title, Task_Description, Task_DueDate, CreatedDate, StartDate, Task_Status FROM dbo.ERC_SubTasks WHERE SubTask_ID = @ID;";
                using (var dr = db.Query(q, new SqlParameter("@ID", ID)))
                {
                    if (dr.Read())
                    {

                        info.SubTask_ID = Convert.ToInt32(dr[0].ToString());
                        info.Task_ID = Convert.ToInt32(dr["Task_ID"].ToString());
                        info.Title = Convert.ToString(dr["Task_Title"]);
                        info.Description = Convert.ToString(dr["Task_Description"]);
                        info.TaskDueDate = Convert.ToString(dr["Task_DueDate"]);
                        info.CreatedDate = Convert.ToString(dr["CreatedDate"]);
                        info.StartDate = Convert.ToString(dr["StartDate"]);
                        info.Task_Status = Convert.ToString(dr["Task_Status"]);

                    }
                }
            }
            if (info == null)
            {
                throw new Exception("No match data found ");
            }
            return info;
        }
コード例 #5
0
ファイル: TaskTracker.cs プロジェクト: Nirankari/ERC.Tasks
        private List<TaskTracker> GetSubTaskList(int taskId)
        {

            List<TaskTracker> _lst = new List<TaskTracker>();
            using (var db = new SqlHelper(ConfigurationManager.ConnectionStrings["collect2000ConnectionString"].ConnectionString))
            {
                var q = @" EXEC USP_GetAllSubTaskByID @ID ";
                using (var dr = db.Query(q, new SqlParameter("@ID", taskId)))
                {
                    while (dr.Read())
                    {
                        TaskTracker info = new TaskTracker();
                        user usreinfo = new user();
                        usreinfo.UserName = Convert.ToString(dr["AssignedTo"]);
                        info.Task_ID = Convert.ToInt32(dr["Task_ID"].ToString());
                        info.SubTask_ID = Convert.ToInt32(dr["SubTask_ID"].ToString());
                        info.Title = Convert.ToString(dr["Task_Title"]);
                        info.Description = Convert.ToString(dr["Task_Description"]);
                        info.TaskDueDate = Convert.ToString(dr["TaskDueDate"]);
                        info.CreatedDate = Convert.ToString(dr["CreatedDate"]);
                        info.StartDate = Convert.ToString(dr["StartDate"]);
                        info.Task_Status = Convert.ToString(dr["Task_Status"]);
                        info.AssignedTo = usreinfo;
                        _lst.Add(info);
                    }
                }
            }
            if (_lst == null)
            {
                throw new Exception("No match data found ");
            }
            return _lst;
        }
コード例 #6
0
 public List<TaskTracker> GetAllTasks()
 {
     TaskTracker _obj = new TaskTracker();
     var _lst = _obj.GetTaskAndSubTask();
     return _lst;
 }
コード例 #7
0
 public IHttpActionResult AddSubTaskAssignment(Assignment _objView)
 {
    
     TaskTracker _objTask = new TaskTracker();
     if (!ModelState.IsValid)
     {
         return BadRequest(ModelState);
     }
     _objTask.AddSubTaskAssignment(_objView);
     return CreatedAtRoute("DefaultApi", new { id = _objView.TaskId }, _objView);
 }
コード例 #8
0
       public IHttpActionResult DeleteSubTasks(int id)
       {

           if (id == 0)
           {
               return NotFound();
           }

           TaskTracker _objTask = new TaskTracker();
           _objTask.DeleteSubTask(id);
           return Ok("Deleted successfully.");
       }
コード例 #9
0
 public string AddReccurrence(TaskTracker _obj)
 {
     TaskTracker _objTask = new TaskTracker();
     try
     {
         _objTask.AddReccurrence(_obj.Task_ID, _obj.InternalRadioOption, _obj.DayInterval, _obj.MonthInterval, _obj.WeekNumber, _obj.WeekDayName, _obj.MonthName ,_obj.AppointmentStartTime, _obj.AppointmentEndTime, _obj.RecurrencePatternType, _obj.RecurrencePatternInterval, _obj.RecurrencePatternFallOn,  _obj.RecurrenceRangeStartDate, _obj.RecurrenceRangeEndByDate, _obj.RecurrenceRangeType, _obj.RecurrenceRangeOccurrence);
     }
     catch (Exception ex) { return "error"; }
     return "ok";
 }
コード例 #10
0
 public string AddSubTask(TaskTracker _obj)
 {
     TaskTracker _objTask = new TaskTracker();
     try
     {
         _objTask.AddSubTask(_obj.Title, _obj.Description, Convert.ToDateTime(_obj.TaskDueDate), _obj.Task_Status, _obj.Task_ID, Convert.ToDateTime(_obj.StartDate));
     }
     catch (Exception ex) { return "error"; }
     return "ok";
 }