public async Task <IActionResult> GetCompanyRate(int userId)
{
JsonResponse <RatePlanInfo> objResult = new JsonResponse <RatePlanInfo>();
try
{
RatePlanInfo planInfo = new RatePlanInfo();
planInfo = await this._companyService.getCompanyRatePlan(userId);
if (planInfo != null)
{
objResult.Data = planInfo;
objResult.Status = StaticResource.SuccessStatusCode;
objResult.Message = StaticResource.SuccessMessage;
return(new OkObjectResult(objResult));
}
}
catch (Exception ex)
{
HttpContext.RiseError(ex);
objResult.Data = null;
objResult.Status = StaticResource.FailStatusCode;
objResult.Message = StaticResource.FailMessage;
}
return(new OkObjectResult(objResult));
}
public async Task <RatePlanInfo> getCompanyRatePlan(int userId)
{
try
{
RatePlanInfo info = new RatePlanInfo();
info = await(from rate in this.therapistContext.CompanyRatePlan
join plan in this.therapistContext.MasterPlan
on rate.PlanId equals plan.PlanId
join usercompany in this.therapistContext.UserCompany
on rate.CompanyId equals usercompany.CompanyId
where usercompany.UserId == userId && usercompany.IsActive == true && usercompany.IsDeleted == false && rate.IsActive == true && rate.IsDeleted == false && rate.ActivePlan == 1
select new RatePlanInfo
{
PlanName = plan.PlanName,
PlanAmount = plan.PlanAmount,
PlanStartDate = rate.PlanStartDate,
PlanEndDate = rate.PlanEndDate,
IsRecurring = rate.IsRecurring,
Active = rate.ActivePlan == 1 ? true : false,
PlanId = plan.PlanId,
CompanyRateTableId = rate.CompanyRateTableId
}).FirstOrDefaultAsync();
return(info);
}
catch (Exception)
{
throw;
}
}
