public List<GetSearchThoiGianDangViewModels> GetSearchThoiGianDang()
{
HtmlHelperGeneral.openConnection();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "GetSearchThoiGianDang";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = HtmlHelperGeneral.con;
SqlDataReader reader = sqlCommand.ExecuteReader();
List<GetSearchThoiGianDangViewModels> acDetails = new List<GetSearchThoiGianDangViewModels>();
while (reader.Read())
{
GetSearchThoiGianDangViewModels h = new GetSearchThoiGianDangViewModels();
h.ThoiGianDangID = reader.GetInt32NullCheck(0);
h.SoThoiGian = reader.GetInt32NullCheck(1);
acDetails.Add(h);
}
HtmlHelperGeneral.Close();
return acDetails;
}
public List<GetSearchThoiGianDangViewModels> GetSearchThoiGianDang()
{
SqlConnection sqlConnection = new SqlConnection();
sqlConnection.ConnectionString = MyConnectionString1;
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = "GetSearchThoiGianDang";
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Connection = sqlConnection;
sqlConnection.Open();
SqlDataReader reader = sqlCommand.ExecuteReader();
List<GetSearchThoiGianDangViewModels> acDetails = new List<GetSearchThoiGianDangViewModels>();
while (reader.Read())
{
GetSearchThoiGianDangViewModels h = new GetSearchThoiGianDangViewModels();
h.ThoiGianDangID = reader.GetInt32NullCheck(0);
h.SoThoiGian = reader.GetInt32NullCheck(1);
acDetails.Add(h);
}
return acDetails;
}
