public List<CustomerInfo> File_GetByAll()
{
List<CustomerInfo> list = new List<CustomerInfo>();
using (SqlConnection Conn = new SqlConnection(Common.GetConnectString()))
{
try
{
Conn.Open();
using (SqlCommand cmd = new SqlCommand("DDV_GetCustomerInfo", Conn))
{
CustomerInfo obj = new CustomerInfo();
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.CustomerIDataReader(dr));
}
}
dr.Close();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
Conn.Close();
}
}
return list;
}
