Example #1
0
        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>);
        }
Example #3
0
        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>);
        }
Example #4
0
        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>);
        }