Пример #1
0
        public ResponseModel GetFeaturePlanList()
        {
            ResponseModel    objResponseModel = new ResponseModel();
            FeaturePlanModel feature          = new FeaturePlanModel();
            int    statusCode    = 0;
            string statusMessage = "";

            try
            {
                string            token        = Convert.ToString(Request.Headers["X-Authorized-Token"]);
                Authenticate      authenticate = new Authenticate();
                FeaturePlanCaller fCaller      = new FeaturePlanCaller();
                authenticate = SecurityService.GetAuthenticateDataFromTokenCache(Cache, SecurityService.DecryptStringAES(token));

                feature = fCaller.GetFeaturePlan(new FeaturePlanService(Cache, Db), authenticate.TenantId);

                statusCode = feature == 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 = feature;
            }
            catch (Exception)
            {
                throw;
            }
            return(objResponseModel);
        }
Пример #2
0
        /// <summary>
        /// GetFeaturePlanList
        /// </summary>
        /// <returns></returns>

        public FeaturePlanModel GetFeaturePlanList(int TenantID)
        {
            DataSet          ds  = new DataSet();
            MySqlCommand     cmd = new MySqlCommand();
            MySqlDataAdapter da  = new MySqlDataAdapter();
            FeaturePlanModel featurePlanModel = new FeaturePlanModel();

            try
            {
                conn           = Db.Connection;
                cmd.Connection = conn;

                MySqlCommand cmd1 = new MySqlCommand("SP_GetFeatureList", conn);
                cmd1.CommandType = CommandType.StoredProcedure;

                da = new MySqlDataAdapter();
                da.SelectCommand = cmd1;
                da.Fill(ds);
                if (ds != null && ds.Tables.Count > 0)
                {
                    if (ds.Tables[0].Rows.Count > 0) //plans
                    {
                        featurePlanModel.Plans = ds.Tables[0].AsEnumerable().Select(r => new PlanModel()
                        {
                            PlanID        = Convert.ToInt32(r.Field <object>("PlanID")),
                            PlanName      = Convert.ToString(r.Field <object>("PlanName")),
                            MonthlyAmount = Convert.ToDecimal(r.Field <object>("MonthlyAmount")),
                            YearlyAmount  = Convert.ToDecimal(r.Field <object>("YearlyAmount")),
                        }).ToList();
                    }

                    if (ds.Tables[1].Rows.Count > 0) //Features
                    {
                        featurePlanModel.Features = ds.Tables[1].AsEnumerable().Select(r => new FeatureModel()
                        {
                            FeatureName = Convert.ToString(r.Field <object>("FeatureName")),
                            FeatureID   = Convert.ToInt32(r.Field <object>("FeatureID")),
                            Tooltip     = Convert.ToString(r.Field <object>("Tooltip"))
                        }).ToList();
                    }

                    if (ds.Tables[2].Rows.Count > 0) //planCheckeds
                    {
                        featurePlanModel.PlanCheckeds = ds.Tables[2].AsEnumerable().Select(r => new PlanCheckedModel()
                        {
                            FeatureID = Convert.ToInt32(r.Field <object>("FeatureID")),
                            PlanName  = Convert.ToString(r.Field <object>("PlanName")),
                            PlanID    = Convert.ToInt32(r.Field <object>("PlanID")),
                            Checked   = Convert.ToString(r.Field <object>("checked")),
                        }).ToList();
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(featurePlanModel);
        }