public JsonResult GetInfoClient()
{
var result = Json("", JsonRequestBehavior.AllowGet);
int currentuser = clsCommon.getIdentity().Id;
int tenantid = clsCommon.getIdentity().tenatId;
tenant ctenant = (from t in db.tenant where t.tenantId == tenantid select t).FirstOrDefault();
ChargifyConnect chargify = clsCommon.Chargify;
int usercount = 1;
bool validpaid = false;
ISubscription currentSubscription = ChargifyTools.getSubscription(ctenant.billingRefNumber);
if (currentSubscription != null)
{
int componentId = clsCommon.getComponentId(currentSubscription.Product.Handle);
if (currentSubscription.State == SubscriptionState.Active)
{
if (componentId > 0)
{
IComponentAttributes newInfo = chargify.GetComponentInfoForSubscription(currentSubscription.SubscriptionID, componentId);
usercount = Convert.ToInt32(newInfo.AllocatedQuantity + 1);
}
}
validpaid = true;
}
List <userLogin> users = (from u in db.userLogin where u.tenantId == tenantid && u.active == true select u).ToList();
var tenantinfo = (from obj in db.vw_Tenant
where obj.tenantId == tenantid
select new
{
paid = validpaid,
Companyname = obj.companyName,
AllocatedUsers = obj.allocatedUsers,
address = obj.Address,
owneremail = obj.email,
codigoarea = obj.countryCode,
phone = obj.number,
ownerurl = obj.companyURL,
//userscount = (from u in db.userLogin
// join ct in db.contact
// on u.contactId
// equals ct.contactId
// where u.tenantId == tenantid && u.active == true
// select new
// {
// name = ct.name,
// alias = u.userName,
// email = ct.email
// }).ToList(),
tenantconfigs = (from obj2 in db.genConfigName
where obj2.genConfigNameGroupId == 1 && obj2.active == true
orderby obj2.code ascending
select new
{
configNameid = obj2.genConfigNameId,
parameter = "",
active = obj2.active,
code = obj2.code
}).ToList(),
settconfigs = (from obj3 in db.genConfigName
where obj3.genConfigNameGroupId == 2 && obj3.active == true
orderby obj3.code ascending
select new
{
configNameid = obj3.genConfigNameId,
parameter = "",
active = obj3.active,
code = obj3.code
}).ToList(),
languanges = (from obj4 in db.genLanguage select new { obj4.name }).ToList(),
currencies = (from obj5 in db.genCurrency select new { obj5.name, code = obj5.code }).ToList(),
regions = (from obj6 in db.genRegion select new { obj6.name }).ToList(),
Timezones = (from obj7 in db.genTimezone select new { obj7.timeZone }).ToList(),
defaultconfigs = (from dcn in db.genConfigName
join dc in db.genConfig
on dcn.genConfigNameId equals dc.genConfigNameId
where dc.tenantId == tenantid && dcn.genConfigNameGroupId == 1 && dcn.active == true
orderby dcn.code ascending
select new
{
dcn.code,
dc.parameter
}).ToList(),
settdefaultconfigs = (from dcn in db.genConfigName
join dc in db.genConfig
on dcn.genConfigNameId equals dc.genConfigNameId
where dc.tenantId == tenantid && dcn.genConfigNameGroupId == 2 && dcn.active == true
orderby dcn.code ascending
select new
{
dcn.code,
dc.parameter
}).ToList(),
userroles = (from urol in db.userLoginRole where (urol.userLoginRoleId != 1 && urol.userLoginRoleId != 2)select new { name = urol.name, id = urol.userLoginRoleId }).ToList()
}).FirstOrDefault();
if (tenantinfo != null)
{
result = Json(tenantinfo, JsonRequestBehavior.AllowGet);
}
return(result);
}
/// <summary>
/// Compare this IComponentAttributes to another
/// </summary>
public int CompareTo(IComponentAttributes other)
{
return(ComponentID.CompareTo(other.ComponentID));
}
