ClsMemberReport

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data;

namespace SNSCT
{
    class ClsMemberReport
    {
        SqlDb Db = new SqlDb();
        StringBuilder Str = new StringBuilder();
        DataTable Dt = new DataTable();

        public DataTable Full_Details()
        {
            SqlDb Db = new SqlDb();
            StringBuilder Str = new StringBuilder();
            DataTable Dt = new DataTable();

            Str.Append("Select 0 + ROW_NUMBER() OVER(ORDER BY Name) AS [SL No], Name,RegNo,convert(varchar,DOB,103) AS DOB,BloodGroup,Father,");
            Str.Append("convert(varchar,FatherDOB,103) AS FatherDOB,FatherBloodGroup,Wife,convert(varchar,WifeDOB,103) AS WifeDOB,");
            Str.Append("WifeBloodGroup,HouseName,HouseNo,street,");
            Str.Append("City,District,State,Occupation,");
            Str.Append("Office,OfficeBuilding,OfficeStreet,OfficeCity,");
            Str.Append("OfficeDistrict,OfficeState,OfficeCountry,WifeOccupation,");
            Str.Append("WifeOffice,WifeOfficeBuilding,WifeOfficeStreet,WifeOfficeCity,");
            Str.Append("WifeOfficeDistrict,WifeOfficeState,WifeOfficeCountry,Mobile,");
            Str.Append("Landline,Phone_Office,Child1,Child1_Details,");
            Str.Append("convert(varchar,Child1_DOB,103) AS Child1_DOB,Child1_BloodGroup,Child2,Child2_Details,");
            Str.Append("convert(varchar,Child1_DOB,103) AS Child2_DOB,Child2_BloodGroup,Child3,Child3_Details,");
            Str.Append("convert(varchar,Child1_DOB,103) AS Child3_DOB,Child3_BloodGroup,Child4,Child4_Details,");
            Str.Append("convert(varchar,Child1_DOB,103) AS Child4_DOB,Child4_BloodGroup from Registration order by (Name)ASC");
            Dt = Db.getTable(Str.ToString());
            return Dt;
        }

        public DataTable Contact_Details()
        {
            SqlDb Db = new SqlDb();
            StringBuilder Str = new StringBuilder();
            DataTable Dt = new DataTable();

            Str.Append("Select 0 + ROW_NUMBER() OVER(ORDER BY Name) AS [SL No],RegNo,Name,Mobile,Landline,Phone_Office   from Registration order by (Name)ASC");  
            Dt = Db.getTable(Str.ToString());
            return Dt;

        }
        public DataTable Address_Details()
        {
            SqlDb Db = new SqlDb();
            StringBuilder Str = new StringBuilder();
            DataTable Dt = new DataTable();

            Str.Append("Select 0 + ROW_NUMBER() OVER(ORDER BY Name)  AS [SL No],RegNo,Name,");        
            Str.Append("HouseName,HouseNo,street,");
            Str.Append("City,District,State   from Registration order by (Name)ASC");
            Dt = Db.getTable(Str.ToString());
            return Dt;

        }





    }
}