private void ShowClassRoom()
{
var db = new QLSV();
var ls = db.Classrooms.ToList();
dataGridView1.DataSource = ls;
}
public static void TestDSSV()
{
var dssv = new GenericList <SV>();
var dssvphu = new LinkedList();
var chon = 0;
do
{
chon = MenuDSSV();
switch (chon)
{
case 1:
{
QLSV.FileToList(dssv);
LinkedList.FileToList(dssvphu);
break;
}
case 2:
{
LinkedList.PrintListSV(dssvphu);
break;
}
case 3:
{
QLSV.Sort(dssv); break;
}
case 4:
{
LinkedList.SearchSinhVien(dssvphu); break;
}
case 5:
{
LinkedList.RemoveSinhVien(dssvphu); break;
}
case 0:
{
break;
}
default:
{
Console.WriteLine("Hello");
break;
}
}
Console.ReadKey();
Console.Clear();
} while (chon != 0);
}
private void txtFilter_KeyPress(object sender, KeyPressEventArgs e)
{
if (e.KeyChar == Convert.ToChar(Keys.Enter))
{
String name = txtFilter.Text;
if (name.Equals(""))
{
ShowClassRoom();
}
else
{
var db = new QLSV();
var ls = db.Classrooms
.Where(t => t.Name.Contains(name) || t.Room.Contains(name))
.ToList();
dataGridView1.DataSource = ls;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
String Name = textBox1.Text;
String Room = textBox2.Text;
var db = new QLSV();
var obj = db.Classrooms.Where(t => t.Name.Equals(Name)).FirstOrDefault();
if (obj == null)
{
db.Classrooms.Add(new Classroom
{
ID = Guid.NewGuid().ToString(),
Name = Name,
Room = Room
});
db.SaveChanges();
DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show("Đã tồn tại lớp");
}
}
public DBHelper()
{
this.db = new QLSV();
}
