Exemple #1
0
        public static List <DemographicInformation> GetIndividulDemographicData()
        {
            DemographicInformation IndivDemo = new DemographicInformation();
            var     IndivDemoList            = new List <DemographicInformation>();
            DataSet dsGetDemographicsReport  = new DataSet();

            //2rd Assignment
            //Get the demographics from database but get the connection string details from web.Config file
            dsGetDemographicsReport = DADemographicsInformation.GetDemographicsUsingDBWithConfig();

            //3rd Assignment
            //Calling web service - Get the demographics from database but get the connection string details from web.Config file
            //var testService = new MyDemographicsInfoService.MyDemographicsInfoServiceClient();
            //dsGetDemographicsReport = testService.GetDemographicsUsingDBWithConfig();

            //------------------------------------------------------------------------------------------
            //Get the demographics from database but define the connection string in this method
            //dsGetDemographicsReport = DADemographicsInformation.GetDemographicsUsingDBWithOutConfig();
            //dsGetDemographicsReport = testService.GetDemographicsUsingDBWithOutConfig();

            //var testServ = new DemoInformationService.DemoInformationServiceClient();
            //Get the demographics data by NOT USING the database
            //dsGetDemographicsReport = DADemographicsInformation.GetDemographicsWithOutDB();
            //dsGetDemographicsReport = testService.GetDemographicsWithOutDB();
            //------------------------------------------------------------------------------------------

            //Transfer Dataset details to List Object
            if (dsGetDemographicsReport.Tables.Count > 0)
            {
                IndivDemoList = dsGetDemographicsReport.Tables[0].AsEnumerable().Select(m => new DemographicInformation
                {
                    //Left side is Model Object - Right Side is Database columns
                    FirstName = Convert.ToString(m["FirstName"]),
                    LastName  = Convert.ToString(m["LastName"]),
                    Sex       = Convert.ToString(m["Sex"]),
                    Address   = Convert.ToString(m["Address"])
                }).ToList();
            }

            //Build the Business Logic here based on the requirements from the client

            return(IndivDemoList);
        }
 public DataSet GetDemographicsUsingDBWithConfig()
 {
     return(DADemographicsInformation.GetDemographicsUsingDBWithConfig());
 }