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);
}