public void DefaultProperties()
{
//default ListView properties for groups
Assert.AreEqual(true, lv.ShowGroups, "#A1");
Assert.AreEqual(true, (lv.Groups != null), "#A2");
Assert.AreEqual(0, lv.Groups.Count, "#A3");
//default ListViewGroup properties
ListViewGroup lg1 = new ListViewGroup();
Assert.AreEqual("ListViewGroup", lg1.Header, "#A4");
Assert.AreEqual(null, lg1.Name, "#A5");
Assert.AreEqual(HorizontalAlignment.Left, lg1.HeaderAlignment, "#A6");
Assert.AreEqual(0, lg1.Items.Count, "#A7");
Assert.AreEqual(null, lg1.ListView, "#A8");
Assert.AreEqual(null, lg1.Tag, "#A9");
Assert.AreEqual(lg1.Header, lg1.ToString(), "#A10");
}
private void HienThiToanBoLichSuLenListView()
{
dp.OpenConnection();
string sqlNgayChuyen = "select distinct CONVERT(varchar, ThoiGianChuyen, 103) from ThongTinLichSuChuyenDiaDiem order by CONVERT(varchar, ThoiGianChuyen, 103) asc";
SqlCommand commandNgayChuyen = new SqlCommand(sqlNgayChuyen, dp.connection);
lvLichSu.Groups.Clear();
lvLichSu.Items.Clear();
SqlDataReader readerNgayChuyen = commandNgayChuyen.ExecuteReader();
while (readerNgayChuyen.Read())
{
ListViewGroup lvg = new ListViewGroup(readerNgayChuyen.GetString(0));
lvLichSu.Groups.Add(lvg);
}
readerNgayChuyen.Close();
foreach (ListViewGroup lvg in lvLichSu.Groups)
{
string sql = "select * from ThongTinLichSuChuyenDiaDiem where CONVERT(varchar, ThoiGianChuyen, 103) = CONVERT(varchar, @thoigianchuyen, 103)";
SqlCommand command = new SqlCommand(sql, dp.connection);
command.Parameters.AddWithValue("@thoigianchuyen", lvg.ToString());
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
string MaDoanVien = reader.GetString(0);
string TenDoanVien = reader.GetString(1);
DateTime ThoiGian = reader.GetDateTime(2);
string LopChuyen = reader.GetString(3);
string KhoaChuyen = reader.GetString(4);
string TruongChuyen = reader.GetString(5);
DateTime ThoiGianChuyen = reader.GetDateTime(6);
ListViewItem lvi = new ListViewItem(MaDoanVien);
lvi.SubItems.Add(TenDoanVien);
lvi.SubItems.Add(ThoiGian.ToString("dd/MM/yyyy HH:mm"));
lvi.SubItems.Add(LopChuyen);
lvi.SubItems.Add(KhoaChuyen);
lvi.SubItems.Add(TruongChuyen);
lvi.SubItems.Add(ThoiGianChuyen.ToString("dd/MM/yyyy HH:mm"));
lvLichSu.Items.Add(lvi);
lvi.Group = lvg;
}
reader.Close();
}
}
public void ListViewGroup_ToString_Invoke_ReturnsExpected(string header, string expected)
{
var group = new ListViewGroup(header);
Assert.Same(expected, group.ToString());
}
public void ListViewGroup_ToString_Invoke_ReturnsExpected(string header)
{
var group = new ListViewGroup(header);
Assert.Equal(header ?? string.Empty, group.ToString());
}
public override string ToString()
{
return(_group.ToString());
}