public List<GetAllQuanHuyenViewModels> GetAllQuanHuyen()
{
HtmlHelperGeneral.openConnection();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "GetAllQuanHuyen";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = HtmlHelperGeneral.con;
SqlDataReader reader = sqlCommand.ExecuteReader();
List<GetAllQuanHuyenViewModels> acDetails = new List<GetAllQuanHuyenViewModels>();
while (reader.Read())
{
GetAllQuanHuyenViewModels h = new GetAllQuanHuyenViewModels();
h.quanID = reader.GetInt32NullCheck(0);
h.maQuanHuyen = reader.GetStringNullCheck(1);
h.tenQuanHuyen = reader.GetStringNullCheck(2);
acDetails.Add(h);
}
HtmlHelperGeneral.Close();
return acDetails;
}
public List<GetAllQuanHuyenViewModels> GetAllQuanHuyen()
{
SqlConnection sqlConnection = new SqlConnection();
sqlConnection.ConnectionString = MyConnectionString1;
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "GetAllQuanHuyen";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = sqlConnection;
sqlConnection.Open();
SqlDataReader reader = sqlCommand.ExecuteReader();
List<GetAllQuanHuyenViewModels> acDetails = new List<GetAllQuanHuyenViewModels>();
while (reader.Read())
{
GetAllQuanHuyenViewModels h = new GetAllQuanHuyenViewModels();
h.quanID = reader.GetInt32NullCheck(0);
h.maQuanHuyen = reader.GetStringNullCheck(1);
h.tenQuanHuyen = reader.GetStringNullCheck(2);
acDetails.Add(h);
}
return acDetails;
}