public ResponseModel getstoreDashboardListClaim([FromBody] StoreDashboardClaimModel ClaimSearchModel)
        {
            List <StoreDashboardClaimResponseModel> ClaimSearchResponse = new List <StoreDashboardClaimResponseModel>();
            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));

                ClaimSearchModel.tenantID = authenticate.TenantId;
                StoreDashboardCaller dashBoardcaller = new StoreDashboardCaller();

                ClaimSearchResponse = dashBoardcaller.getStoreDashboardClaimList(new StoreDashboardService(_connectioSting), ClaimSearchModel);

                StatusCode = ClaimSearchResponse.Count > 0 ? (int)EnumMaster.StatusCode.Success : (int)EnumMaster.StatusCode.RecordNotFound;

                statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)StatusCode);

                objResponseModel.Status       = true;
                objResponseModel.StatusCode   = StatusCode;
                objResponseModel.Message      = statusMessage;
                objResponseModel.ResponseData = ClaimSearchResponse;
            }
            catch (Exception)

            { throw; }
            return(objResponseModel);
        }
Ejemplo n.º 2
0
 /// <summary>
 ///get store Dashborad Details For Claim
 /// </summary>
 public List <StoreDashboardClaimResponseModel> getStoreDashboardClaimList(IStoreDashboard DashBoard, StoreDashboardClaimModel ClaimSearchModel)
 {
     _dashboard = DashBoard;
     return(_dashboard.GetClaimDataForStoreDashboard(ClaimSearchModel));
 }
Ejemplo n.º 3
0
 /// <summary>
 ///get store Dashborad Details For Claim
 /// </summary>
 public List <StoreDashboardClaimResponseModel> getStoreDashboardClaimList(IStoreDashboard dashboard, StoreDashboardClaimModel modelname)
 {
     _dashboard = dashboard;
     return(_dashboard.GetClaimDataForStoreDashboard(modelname));
 }
Ejemplo n.º 4
0
        /// <summary>
        /// Get task Data For store dashboard for claim
        /// </summary>
        /// <param name="TenantID"></param>
        /// <returns></returns>

        public List <StoreDashboardClaimResponseModel> GetClaimDataForStoreDashboard(StoreDashboardClaimModel model)
        {
            DataSet      ds  = new DataSet();
            MySqlCommand cmd = new MySqlCommand();
            List <StoreDashboardClaimResponseModel> ClaimSearchResponse = new List <StoreDashboardClaimResponseModel>();

            try
            {
                conn.Open();
                cmd.Connection = conn;
                MySqlCommand cmd1 = new MySqlCommand("sp_getStoreDashboardClaimData", conn);
                cmd1.CommandType = CommandType.StoredProcedure;
                cmd1.Parameters.AddWithValue("@objclaimID", model.claimID == null ? 0 : model.claimID);
                cmd1.Parameters.AddWithValue("@objticketID", model.ticketID == null ? 0 : model.ticketID);
                cmd1.Parameters.AddWithValue("@objclaimissueType", model.claimissueType == null ? 0 : model.claimissueType);
                cmd1.Parameters.AddWithValue("@objticketMapped", model.ticketMapped == null ? 0 : model.ticketMapped);
                cmd1.Parameters.AddWithValue("@objclaimsubcat", model.claimsubcat == null ? 0 : model.claimsubcat);
                cmd1.Parameters.AddWithValue("@objassignTo", model.assignTo == null ? 0 : model.assignTo);
                cmd1.Parameters.AddWithValue("@objclaimcat", model.claimcat == null ? 0 : model.claimcat);
                cmd1.Parameters.AddWithValue("@objclaimraise", string.IsNullOrEmpty(model.claimraiseddate) ? "" : model.claimraiseddate);
                cmd1.Parameters.AddWithValue("@objtaskID", model.taskID == null ? 0 : model.taskID);
                cmd1.Parameters.AddWithValue("@objclaimstatus", model.claimstatus == null ? 0 : model.claimstatus);
                cmd1.Parameters.AddWithValue("@objtaskmapped", model.taskmapped == null ? 0 : model.taskmapped);
                cmd1.Parameters.AddWithValue("@objraisedby", model.raisedby == null ? 0 : model.raisedby);
                cmd1.Parameters.AddWithValue("@objtenantID", model.tenantID);


                cmd1.Parameters.AddWithValue("@objbrandIDs", string.IsNullOrEmpty(model.BrandIDs) ? "" : model.BrandIDs.TrimEnd(','));
                cmd1.Parameters.AddWithValue("@objAgentIds", string.IsNullOrEmpty(model.AgentIds) ? "" : model.AgentIds.TrimEnd(','));
                cmd1.Parameters.AddWithValue("@objFromDate", string.IsNullOrEmpty(model.FromDate) ? "" : model.FromDate);
                cmd1.Parameters.AddWithValue("@objToDate", string.IsNullOrEmpty(model.ToDate) ? "" : model.ToDate);



                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++)
                    {
                        StoreDashboardClaimResponseModel StoreDashboard = new StoreDashboardClaimResponseModel();

                        StoreDashboard.ClaimID         = ds.Tables[0].Rows[i]["ClaimID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["ClaimID"]);
                        StoreDashboard.ClaimStatusId   = ds.Tables[0].Rows[i]["StatusID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["StatusID"]);
                        StoreDashboard.ClaimStatus     = StoreDashboard.ClaimStatusId.Equals(0) ? string.Empty : Convert.ToString((EnumMaster.ClaimStatus)StoreDashboard.ClaimStatusId);
                        StoreDashboard.BrandID         = ds.Tables[0].Rows[i]["BrandID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["BrandID"]);
                        StoreDashboard.BrandName       = ds.Tables[0].Rows[i]["BrandName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["BrandName"]);
                        StoreDashboard.CategoryID      = ds.Tables[0].Rows[i]["CategoryID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["CategoryID"]);
                        StoreDashboard.CategoryName    = ds.Tables[0].Rows[i]["CategoryName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CategoryName"]);
                        StoreDashboard.SubCategoryID   = ds.Tables[0].Rows[i]["SubCategoryID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["SubCategoryID"]);
                        StoreDashboard.SubCategoryName = ds.Tables[0].Rows[i]["SubCategoryName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["SubCategoryName"]);
                        StoreDashboard.IssueTypeID     = ds.Tables[0].Rows[i]["IssueTypeID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["IssueTypeID"]);
                        StoreDashboard.IssueTypeName   = ds.Tables[0].Rows[i]["IssueTypeName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["IssueTypeName"]);

                        StoreDashboard.CreatedBy       = ds.Tables[0].Rows[i]["CreatedBy"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["CreatedBy"]);
                        StoreDashboard.CreatedByName   = ds.Tables[0].Rows[i]["CreatedByName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CreatedByName"]);
                        StoreDashboard.AssignedId      = ds.Tables[0].Rows[i]["AssignedID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["AssignedID"]);
                        StoreDashboard.AssignTo        = ds.Tables[0].Rows[i]["AssignedToName"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["AssignedToName"]);
                        StoreDashboard.ClaimRaisedByID = ds.Tables[0].Rows[i]["CustomerID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["CustomerID"]);
                        StoreDashboard.ClaimRaisedBy   = ds.Tables[0].Rows[i]["Raisedby"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["Raisedby"]);
                        StoreDashboard.CreationOn      = ds.Tables[0].Rows[i]["CreationOn"] == DBNull.Value ? string.Empty : Convert.ToString(ds.Tables[0].Rows[i]["CreationOn"]);

                        ClaimSearchResponse.Add(StoreDashboard);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (conn != null)
                {
                    conn.Close();
                }
            }
            return(ClaimSearchResponse);
        }