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