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