public ResponseModel gettaskdetailsbyid(int taskId) { CustomTaskMasterDetails objTaskMaster = new CustomTaskMasterDetails(); TaskCaller taskCaller = new TaskCaller(); ResponseModel objResponseModel = new ResponseModel(); int statusCode = 0; string statusMessage = ""; try { objTaskMaster = taskCaller.gettaskDetailsById(new TaskServices(Cache, Db), taskId); statusCode = objTaskMaster == null ? (int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success; statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode); objResponseModel.Status = true; objResponseModel.StatusCode = statusCode; objResponseModel.Message = statusMessage; objResponseModel.ResponseData = objTaskMaster; } catch (Exception) { throw; } return(objResponseModel); }
/// <summary> /// GetTask By ID /// </summary> /// <param name="taskID"></param> /// <returns></returns> public CustomTaskMasterDetails GetTaskbyId(int taskID) { DataSet ds = new DataSet(); CustomTaskMasterDetails taskMaster = new CustomTaskMasterDetails(); try { conn.Open(); MySqlCommand cmd = new MySqlCommand("SP_GetTaskById", conn); cmd.Connection = conn; cmd.Parameters.AddWithValue("@task_ID", taskID); cmd.CommandType = CommandType.StoredProcedure; MySqlDataAdapter da = new MySqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds); if (ds != null && ds.Tables[0] != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { taskMaster.TicketingTaskID = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"]); taskMaster.TaskStatus = ds.Tables[0].Rows[i]["Status"] == DBNull.Value ? string.Empty : Convert.ToString((EnumMaster.TaskStatus)Convert.ToInt32(ds.Tables[0].Rows[i]["Status"])); taskMaster.TaskTitle = ds.Tables[0].Rows[i]["TaskTitle"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["TaskTitle"]); taskMaster.TaskDescription = ds.Tables[0].Rows[i]["TaskDescription"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["TaskDescription"]); taskMaster.Duedate = Convert.ToDateTime(ds.Tables[0].Rows[i]["TaskEndTime"]); taskMaster.AssignName = ds.Tables[0].Rows[i]["AssignName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["AssignName"]); taskMaster.DateFormat = taskMaster.Duedate.ToString("dd/MMM/yyyy"); int MasterId = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"]); taskMaster.Comments = ds.Tables[1].AsEnumerable().Where(x => Convert.ToInt32(x.Field <int>("TicketingTaskID")). Equals(MasterId)).Select(x => new UserComment() { Name = x.Field <object>("Name") == DBNull.Value ? string.Empty : Convert.ToString(x.Field <object>("Name")), Comment = x.Field <object>("TaskComment") == DBNull.Value ? string.Empty : Convert.ToString(x.Field <object>("TaskComment")), datetime = x.Field <object>("CommentAt") == DBNull.Value ? string.Empty : Convert.ToString(x.Field <object>("CommentAt")) }).ToList(); } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } if (ds != null) { ds.Dispose(); } } return(taskMaster); }
/// <summary> /// Get Task List /// </summary> /// <param name="TicketId"></param> /// <returns></returns> public List <CustomTaskMasterDetails> GetTaskList(int TicketId) { DataSet ds = new DataSet(); List <CustomTaskMasterDetails> lsttask = new List <CustomTaskMasterDetails>(); try { conn.Open(); MySqlCommand cmd = new MySqlCommand("SP_GetTaskList", conn); cmd.Connection = conn; cmd.Parameters.AddWithValue("@Ticket_ID", TicketId); cmd.CommandType = CommandType.StoredProcedure; MySqlDataAdapter da = new MySqlDataAdapter(); da.SelectCommand = cmd; da.Fill(ds); if (ds != null && ds.Tables[0] != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { CustomTaskMasterDetails taskMaster = new CustomTaskMasterDetails(); taskMaster.TicketingTaskID = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"]); taskMaster.TaskStatus = ds.Tables[0].Rows[i]["Status"] == DBNull.Value ? string.Empty : Convert.ToString((EnumMaster.TaskStatus)Convert.ToInt32(ds.Tables[0].Rows[i]["Status"])); taskMaster.TaskTitle = ds.Tables[0].Rows[i]["TaskTitle"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["TaskTitle"]); taskMaster.DepartmentName = ds.Tables[0].Rows[i]["Departmentname"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Departmentname"]); taskMaster.StoreCode = Convert.ToInt32(ds.Tables[0].Rows[i]["Storecode"]); taskMaster.CreatedBy = ds.Tables[0].Rows[i]["Createdby"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Createdby"]); taskMaster.CreatedDate = Convert.ToDateTime(ds.Tables[0].Rows[i]["CreationOn"]); taskMaster.DateFormat = taskMaster.CreatedDate.ToString("dd/MMM/yyyy"); taskMaster.AssignName = ds.Tables[0].Rows[i]["AssignName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["AssignName"]); lsttask.Add(taskMaster); } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } if (ds != null) { ds.Dispose(); } } return(lsttask); }