using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
/// <summary>
/// Summary description for EmpDal
/// </summary>
public class EmpDal
{
	public EmpDal()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    static SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());
    internal static System.Data.DataSet getZipData(string ZipCode)
    {
        //throw new NotImplementedException();
        SqlDataAdapter da = new SqlDataAdapter("sp_Zip", con);
        DataSet ds = new DataSet();
        da.SelectCommand.CommandType = CommandType.StoredProcedure;
        da.SelectCommand.Parameters.AddWithValue("@ZipCode", ZipCode);
        da.SelectCommand.Parameters.AddWithValue("@Type", "z");
        da.Fill(ds);
        return ds;
    }

    internal static DataSet getsZipdata(string ZipCode)
    {
        //throw new NotImplementedException();

        SqlDataAdapter da = new SqlDataAdapter("sp_Zip", con);
        DataSet ds = new DataSet();
        da.SelectCommand.CommandType = CommandType.StoredProcedure;
        da.SelectCommand.Parameters.AddWithValue("@ZipCode", ZipCode);
        da.SelectCommand.Parameters.AddWithValue("@Type", "z");
        da.Fill(ds);
        return ds;
    }
}