public List <UserInfo> GetAllUsers()
{
string strSpName = "[dbo].[usp_ServiceSubscription_GetAllUsers]";
SQLGetList sqlHAsy = new SQLGetList();
return(sqlHAsy.ExecuteAsList <UserInfo>(strSpName) as List <UserInfo>);
}
public List <ProjectInfo> GetProjectAsList()
{
string strSpName = "usp_GetProjectList";
SQLGetList sqlHAsy = new SQLGetList();
return(sqlHAsy.ExecuteAsList <ProjectInfo>(strSpName) as List <ProjectInfo>);
}
public List <MyServicesInfo> GetServiceDetailsByUserId(int UserId)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@UserId", UserId));
string strSpName = "[dbo].[usp_ServiceSubscription_GetServiceDetailsByUserId]";
SQLGetList sqlHAsy = new SQLGetList();
return(sqlHAsy.ExecuteAsList <MyServicesInfo>(strSpName, Param) as List <MyServicesInfo>);
}
public List <MyServicesInfo> GetReport(ReportApiInfo apiInfo)
{
List <SQLParam> Param = new List <SQLParam>();
Param.Add(new SQLParam("@UserId", apiInfo.id));
Param.Add(new SQLParam("@FromDate", apiInfo.fromDate));
Param.Add(new SQLParam("@ToDate", apiInfo.toDate));
string strSpName = "[dbo].[usp_ServiceSubscription_GetReport]";
SQLGetList sqlHAsy = new SQLGetList();
return(sqlHAsy.ExecuteAsList <MyServicesInfo>(strSpName, Param) as List <MyServicesInfo>);
}