Map Class

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Collections.Generic;
using System.Data.SqlClient;
using DBLibrary;

/// <summary>
/// Summary description for clsPickASchool
/// </summary>
public class clsPickASchool
{
    public Int64 SID { get; set; }
    public Int32 CityID { get; set; }
    public String SchoolDesc { get; set; }
    public String LocationDesc { get; set; }
    public string Location { get; set; }
    public string SchoolName { get; set; }
    public string Distance { get; set; }
    public string Address { get; set; }
    public string Longitude { get; set; }
    public string Latitude { get; set; }
    public string image1 { get; set; } 
    public string image3 { get; set; }
    public string image4 { get; set; }
    public string EmailID { get; set; }
    public string image2 { get; set; }
    public string MobileNo { get; set; } 
    public string AboutSchool { get; set; } 
    public string Amenities { get; set; }
    public string Admission { get; set; }
    public string Curriculum { get; set; }
    public string Teachers { get; set; }
    public string SchoolType { get; set; }
    public string BusRoute { get; set; }
      public string More { get; set; }
      public string Board { get; set; }
    private string ConnStr;
    public clsPickASchool()
    {
        CnSettings clsObjSetting = new CnSettings();
        ConnStr = clsObjSetting.ConnectionStr;
    }
    public System.Collections.Generic.List<clsPickASchool> ReadSchoolData(int CityID)
    {
        SqlDataReader sqlRdr = null;
        System.Collections.Generic.List<clsPickASchool> lstAllCategory = new System.Collections.Generic.List<clsPickASchool>();
        clsCommon objCommon = new clsCommon();
        try
        {

            SqlParameter[] paramlist = new SqlParameter[2];
            paramlist[0] = new SqlParameter("@Region", CityID);
            paramlist[1] = new SqlParameter("@QueryType", "Read_AllSchoolByRegion");
            sqlRdr = SqlHelper.ExecuteReader(ConnStr, CommandType.StoredProcedure, "uspSchools", paramlist);
            while (sqlRdr.Read())
            {
                clsPickASchool obj = new clsPickASchool();
                //  obj.CityID = Convert.ToInt64(sqlRdr["CategoryID"]);
                obj.SchoolDesc = sqlRdr["SchoolName"].ToString();
                obj.LocationDesc = sqlRdr["SchoolDescription"].ToString();
                lstAllCategory.Add(obj);
            }
            return lstAllCategory;
        }
        finally
        {
            if (sqlRdr != null)
                sqlRdr.Close();
        }
    }
    public List<string> GetDataSchool(string Search)
    {
        SqlDataReader sqlRdr = null;
        List<string> lstLogin = new List<string>();
        try
        {
            SqlParameter[] paramList = new SqlParameter[2];
            paramList[0] = new SqlParameter("@QueryType", "GetDataSchoolLocation");
            paramList[1] = new SqlParameter("@Search", Search);
            sqlRdr = SqlHelper.ExecuteReader(ConnStr, CommandType.StoredProcedure, "uspSchools", paramList);
            bool a = false;
            while (sqlRdr.Read())
            {

                //if (sqlRdr["c"].ToString() == "2" && a == false)
                //{
                //    lstLogin.Add("<font face='verdana' size='5' color='green'>Location</b>");
                //    a = true;
                //}
                lstLogin.Add(sqlRdr["data"].ToString());
            }
            return lstLogin;
        }
        finally
        {
            if (sqlRdr != null)
                sqlRdr.Close();
        }

    }
    public List<string> GetDataLocation(string Search)
    {
        SqlDataReader sqlRdr = null;
        List<string> lstLogin = new List<string>();
        try
        {
            SqlParameter[] paramList = new SqlParameter[2];
            paramList[0] = new SqlParameter("@QueryType", "GetDataLocation");
            paramList[1] = new SqlParameter("@Search", Search);
            sqlRdr = SqlHelper.ExecuteReader(ConnStr, CommandType.StoredProcedure, "uspSchools", paramList);
            while (sqlRdr.Read())
            {
                lstLogin.Add(sqlRdr["data"].ToString());
            }
            return lstLogin;
        }
        finally
        {
            if (sqlRdr != null)
                sqlRdr.Close();
        }

    }
    public List<clsPickASchool> GetDataSchool(string Longitude, string Latitude, string KiloMeter, string Type, string City)
    {
     //   ok1 ok1 = new ok1();
     ////   string s = ok1.();
     //   ok ok = new ok();
     //  // string x = ok.();

    //   string connectionStr = System.Configuration.ConfigurationManager.ConnectionStrings["ok"].ConnectionString;

        SqlDataReader sqlRdr = null;
        List<clsPickASchool> lstLogin = new List<clsPickASchool>();
        try
        {
            SqlParameter[] paramList = new SqlParameter[6];
            paramList[0] = new SqlParameter("@QueryType", "GetDataSchool");
            paramList[1] = new SqlParameter("@Latitude", Latitude);
            paramList[2] = new SqlParameter("@Longitude", Longitude);
            paramList[3] = new SqlParameter("@KiloMeter", KiloMeter);
            paramList[4] = new SqlParameter("@Type", Type);
            paramList[5] = new SqlParameter("@City", City);
            sqlRdr = SqlHelper.ExecuteReader(ConnStr, CommandType.StoredProcedure, "uspSchools", paramList);
            while (sqlRdr.Read())
            {
                clsPickASchool obj = new clsPickASchool();
                obj.SID = Convert.ToInt64(sqlRdr["SID"]);
               // obj.Location = sqlRdr["Location"].ToString();
                obj.SchoolName = sqlRdr["SchoolName"].ToString();
               // obj.Distance = sqlRdr["Distance"].ToString();
                obj.Address = sqlRdr["Address"].ToString();
                obj.Longitude = sqlRdr["Longitude"].ToString();
                obj.Latitude = sqlRdr["Latitude"].ToString();
                obj.image1 = sqlRdr["image1"].ToString();
                obj.MobileNo = sqlRdr["MobileNo"].ToString();
                obj.EmailID = sqlRdr["EmailID"].ToString();
                obj.image2 = sqlRdr["image2"].ToString();
                lstLogin.Add(obj);

            }
            return lstLogin;
        }
        finally
        {
            if (sqlRdr != null)
                sqlRdr.Close();
        }

    }
    public List<clsPickASchool> GetDataMicroSchool(string SchoolID)
    {
 
        SqlDataReader sqlRdr = null;
        List<clsPickASchool> lstLogin = new List<clsPickASchool>();
        try
        {
            SqlParameter[] paramList = new SqlParameter[2];
            paramList[0] = new SqlParameter("@QueryType", "GetDataMicroSchool");
            paramList[1] = new SqlParameter("@SchoolID", SchoolID);
            sqlRdr = SqlHelper.ExecuteReader(ConnStr, CommandType.StoredProcedure, "uspSchools", paramList);
            while (sqlRdr.Read())
            {
                clsPickASchool obj = new clsPickASchool();
                //  obj.CityID = Convert.ToInt64(sqlRdr["CategoryID"]);
               // obj.Location = sqlRdr["Location"].ToString();
                obj.SchoolName = sqlRdr["SchoolName"].ToString();
               // obj.Distance = sqlRdr["Distance"].ToString();
                obj.Address = sqlRdr["Address"].ToString();
               // obj.Longitude = sqlRdr["Longitude"].ToString();
              //  obj.Latitude = sqlRdr["Latitude"].ToString();
                obj.image1 = sqlRdr["image1"].ToString();  
                obj.image3 = sqlRdr["image3"].ToString(); 
                obj.image4 = sqlRdr["image4"].ToString();
                obj.MobileNo = sqlRdr["MobileNo"].ToString();
                obj.EmailID = sqlRdr["EmailID"].ToString();
                obj.image2 = sqlRdr["image2"].ToString();
               
                
                obj.AboutSchool = sqlRdr["AboutSchool"].ToString();
                obj.Amenities = sqlRdr["Amenities"].ToString();
                obj.Admission = sqlRdr["Admission"].ToString();
                obj.Curriculum = sqlRdr["Curriculum"].ToString(); 
               
                obj.Teachers = sqlRdr["Teachers"].ToString();
                obj.BusRoute = sqlRdr["BusRoute"].ToString();
                obj.More = sqlRdr["More"].ToString();
            
                lstLogin.Add(obj);

            }
            return lstLogin;
        }
        finally
        {
            if (sqlRdr != null)
                sqlRdr.Close();
        }

    }
    public List<clsPickASchool> GetDataCompareSchool(string SchoolIDS)
    {
 
        SqlDataReader sqlRdr = null;
        List<clsPickASchool> lstLogin = new List<clsPickASchool>();
        try
        {
            SqlParameter[] paramList = new SqlParameter[2];
            paramList[0] = new SqlParameter("@QueryType", "GetDataCompareSchool");
            paramList[1] = new SqlParameter("@SchoolIDS", SchoolIDS);
            sqlRdr = SqlHelper.ExecuteReader(ConnStr, CommandType.StoredProcedure, "uspSchools", paramList);
            while (sqlRdr.Read())
            {
                clsPickASchool obj = new clsPickASchool();
                //  obj.CityID = Convert.ToInt64(sqlRdr["CategoryID"]);
               // obj.Location = sqlRdr["Location"].ToString();
                obj.SchoolName = sqlRdr["SchoolName"].ToString();
               // obj.Distance = sqlRdr["Distance"].ToString();
                obj.Address = sqlRdr["Address"].ToString();
               // obj.Longitude = sqlRdr["Longitude"].ToString();
              //  obj.Latitude = sqlRdr["Latitude"].ToString();
                obj.image1 = sqlRdr["image1"].ToString();  
                obj.image3 = sqlRdr["image3"].ToString();
                obj.Board = sqlRdr["Board"].ToString();
                obj.MobileNo = sqlRdr["MobileNo"].ToString();
                obj.EmailID = sqlRdr["EmailID"].ToString();
                obj.image2 = sqlRdr["image2"].ToString();
               
                
                obj.AboutSchool = sqlRdr["AboutSchool"].ToString();
                obj.Amenities = sqlRdr["Amenities"].ToString();
               obj.Admission = sqlRdr["Admission"].ToString();
               obj.Curriculum = sqlRdr["Curriculum"].ToString(); 
               
                obj.Teachers = sqlRdr["Teachers"].ToString();
                obj.BusRoute = sqlRdr["BusRoute"].ToString();
               obj.More = sqlRdr["More"].ToString();
                obj.SchoolType = sqlRdr["SchoolType"].ToString();
            
                lstLogin.Add(obj);

            }
            return lstLogin;
        }
        finally
        {
            if (sqlRdr != null)
                sqlRdr.Close();
        }

    }
    public string GetCurrentLatLong(string Search)
    {
        SqlDataReader sqlRdr = null;
        List<clsPickASchool> lstLogin = new List<clsPickASchool>();
        try
        {
            SqlParameter[] paramList = new SqlParameter[2];
            paramList[0] = new SqlParameter("@QueryType", "GetCurrentLatLong");
            paramList[1] = new SqlParameter("@Search", Search);
            object obj = SqlHelper.ExecuteScalar(ConnStr, CommandType.StoredProcedure, "uspSchools", paramList);
            if (obj != null)
                return obj.ToString(); ;
            return "";
        }
        finally
        {
            if (sqlRdr != null)
                sqlRdr.Close();
        }

    }
    public string GetCurrentLocation(string Longitude, string Latitude)
    {
       // ok ok = new ok();
       //string a= ok.s();
       //ok1 ok1 = new ok1();
       //string b = ok1.s();
        SqlParameter[] paramList = new SqlParameter[3];
        paramList[0] = new SqlParameter("@QueryType", "GetCurrentLocation");
        paramList[1] = new SqlParameter("@Latitude", Latitude);
        paramList[2] = new SqlParameter("@Longitude", Longitude);
        object obj = SqlHelper.ExecuteScalar(ConnStr, CommandType.StoredProcedure, "uspSchools", paramList);
        if (obj != null)
            return obj.ToString(); ;
        return "";
    }

    //public class ok
    //{
    //    public void oka()
    //    {
    //        Console.WriteLine("ok");
    //    }
    //}
    //public class ok1 : ok
    //{
    //    public void oka()
    //    {
    //        Console.WriteLine("ok1");
    //    }
    //}
}