public bool HasUserUnSubscribed(int UserId)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@UserId", UserId));
string strSpName = "[dbo].[usp_ServiceSubscription_HasUserUnSubscribed]";
SQLGet sqlHAsy = new SQLGet();
return(sqlHAsy.ExecuteAsScalar <bool>(strSpName, Param));
}
public string GetUserEmailById(int UserId)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@UserId", UserId));
string strSpName = "[dbo].[usp_ServiceSubscription_GetUserEmailById]";
SQLGet sqlHAsy = new SQLGet();
return(sqlHAsy.ExecuteAsScalar <string>(strSpName, Param));
}
public bool IsEmailAddressExists(string UserEmail)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@UserEmail", UserEmail));
string strSpName = "[dbo].[usp_ServiceSubscription_IsEmailAddressExists]";
SQLGet sqlHAsy = new SQLGet();
return(sqlHAsy.ExecuteAsScalar <bool>(strSpName, Param));
}