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 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 SubscribeTypeInfo HasUserSubscribed(int UserId)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@UserId", UserId));
string strSpName = "[dbo].[usp_ServiceSubscription_HasUserSubscribed]";
SQLGet sqlHAsy = new SQLGet();
return(sqlHAsy.ExecuteAsObject <SubscribeTypeInfo>(strSpName, Param));
}
public UserInfo GetUserDetailsById(int UserId)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@UserId", UserId));
string strSpName = "[dbo].[usp_ServiceSubscription_GetUserDetailsById]";
SQLGet sqlHAsy = new SQLGet();
return(sqlHAsy.ExecuteAsObject <UserInfo>(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));
}
public ProjectInfo GetProject(int?id)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@ProjectID", id));
string strSpName = "usp_GetProject";
SQLGet sqlHAsy = new SQLGet();
return(sqlHAsy.ExecuteAsObject <ProjectInfo>(strSpName, Param));
}