public ResponseModel GetstoreDashboardList([FromBody] StoreDashboardModel dasbhboardmodel)
{
List <StoreDashboardResponseModel> objStoreDash = new List <StoreDashboardResponseModel>();
ResponseModel objResponseModel = new ResponseModel();
int StatusCode = 0;
string statusMessage = "";
try
{
string _token = Convert.ToString(Request.Headers["X-Authorized-Token"]);
Authenticate authenticate = new Authenticate();
//authenticate = SecurityService.GetAuthenticateDataFromToken(_radisCacheServerAddress, SecurityService.DecryptStringAES(_token));
StoreDashboard newstoreDash = new StoreDashboard();
objStoreDash = newstoreDash.getStoreDashboardTaskList(new StoreDashboardService(_connectioSting), dasbhboardmodel);
StatusCode =
objStoreDash.Count == 0 ?
(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 = objStoreDash;
}
catch (Exception)
{
throw;
}
return(objResponseModel);
}
/// <summary>
///get store Dashborad Details
/// </summary>
public List <StoreDashboardResponseModel> getStoreDashboardTaskList(IStoreDashboard dashboard, StoreDashboardModel modelname)
{
_dashboard = dashboard;
return(_dashboard.GetTaskDataForStoreDashboard(modelname));
}
/// <summary>
/// Get task Data For store dashboard
/// </summary>
/// <param name="TenantID"></param>
/// <returns></returns>
public List <StoreDashboardResponseModel> GetTaskDataForStoreDashboard(StoreDashboardModel model)
{
DataSet ds = new DataSet();
MySqlCommand cmd = new MySqlCommand();
List <StoreDashboardResponseModel> departmentMasters = new List <StoreDashboardResponseModel>();
try
{
conn.Open();
cmd.Connection = conn;
MySqlCommand cmd1 = new MySqlCommand("sp_getStoreDashboardTaskData", conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@objtaskID", model.taskid);
cmd1.Parameters.AddWithValue("@objtaskTitle", model.tasktitle);
cmd1.Parameters.AddWithValue("@objtaskStatus", model.taskstatus);
cmd1.Parameters.AddWithValue("@objticketID", model.ticketID);
cmd1.Parameters.AddWithValue("@objDepartment", model.Department);
cmd1.Parameters.AddWithValue("@objfuncation", model.functionID);
cmd1.Parameters.AddWithValue("@objcreatedFrom", model.CreatedOnFrom);
cmd1.Parameters.AddWithValue("@objcreatedTo", model.CreatedOnTo);
cmd1.Parameters.AddWithValue("@objassignTo", model.AssigntoId);
cmd1.Parameters.AddWithValue("@objtaskCreatedBy", model.createdID);
cmd1.Parameters.AddWithValue("@objtaskwithticket", model.taskwithTicket);
cmd1.Parameters.AddWithValue("@objtaskwithclaim", model.taskwithClaim);
cmd1.Parameters.AddWithValue("@objclaimID", model.claimID);
cmd1.Parameters.AddWithValue("@objtaskPriority", model.Priority);
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = cmd1;
da.Fill(ds);
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string TaskStatusName = ds.Tables[0].Rows[i]["Status"] == DBNull.Value ? string.Empty : Convert.ToString((EnumMaster.TaskStatus)Convert.ToInt32(ds.Tables[0].Rows[i]["Status"]));
StoreDashboardResponseModel storedashboard = new StoreDashboardResponseModel();
storedashboard.taskid = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"]);
storedashboard.totalCount = ds.Tables[0].Rows.Count;
storedashboard.taskstatus = TaskStatusName;
storedashboard.tasktitle = Convert.ToString(ds.Tables[0].Rows[i]["TaskTitle"]);
storedashboard.Department = Convert.ToString(ds.Tables[0].Rows[i]["DepartmentName"]);
storedashboard.storeName = Convert.ToString(ds.Tables[0].Rows[i]["StoreName"]);
storedashboard.StoreAddress = Convert.ToString(ds.Tables[0].Rows[i]["StoreAddress"]);
storedashboard.Priority = Convert.ToString(ds.Tables[0].Rows[i]["Priorty"]);
storedashboard.CreatedOn = Convert.ToString(ds.Tables[0].Rows[i]["CreationOn"]);
storedashboard.AssigntoId = Convert.ToString(ds.Tables[0].Rows[i]["Assignto"]);
storedashboard.CreatedBy = Convert.ToString(ds.Tables[0].Rows[i]["CreatedBy"]);
storedashboard.modifedOn = Convert.ToString(ds.Tables[0].Rows[i]["Modifiedon"]);
storedashboard.ModifiedBy = Convert.ToString(ds.Tables[0].Rows[i]["ModifiedBy"]);
departmentMasters.Add(storedashboard);
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(departmentMasters);
}
