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; }