private void XoaTaiKhoanButton_Click(object sender, EventArgs e)
{
if (DsNguoidungListbox.SelectedItems.Count != 0)
{
string selecttodl= DsNguoidungListbox.SelectedValue.ToString();
DialogResult dr = MessageBox.Show("Bạn có muốn xóa tài khỏan '" + selecttodl + "' không? \r\nTòan bộ từ điển và từ vựng trong tài khỏan sẽ bị xóa theo\r\nBạn cân nhắc kỹ trứơc khi xóa ", "Xóa", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dr == DialogResult.OK)
{
EnglishLinqDataContext db = new EnglishLinqDataContext();
var delNguoiDung = from p in db.NguoiDungs
where p.IDNguoiDung.Contains(selecttodl)
select p;
foreach (NguoiDung nd in delNguoiDung)
db.NguoiDungs.DeleteOnSubmit(nd);
db.SubmitChanges();
//reload
var query = from p1 in db.NguoiDungs
select p1;
DsNguoidungListbox.DisplayMember = "IDNguoiDung";
DsNguoidungListbox.ValueMember = "IDNguoiDung";
DsNguoidungListbox.DataSource = query;
}
}
}
private void BatDau_Load(object sender, EventArgs e)
{
EnglishLinqDataContext db = new EnglishLinqDataContext();
var query = from p in db.NguoiDungs
select p;
DsNguoidungListbox.DisplayMember = "IDNguoiDung";
DsNguoidungListbox.ValueMember = "IDNguoiDung";
DsNguoidungListbox.DataSource = query;
}
private void ThemButton_Click(object sender, EventArgs e)
{
string taikhoanmoi = TenTaiKhoanTextBox.Text;
if (taikhoanmoi.Trim() != "")
{
EnglishLinqDataContext db = new EnglishLinqDataContext();
NguoiDung nd = new NguoiDung();
nd.IDNguoiDung = taikhoanmoi;
db.NguoiDungs.InsertOnSubmit(nd);
db.SubmitChanges();
}
}
private void TaoTaiKhoanMoiButton_Click(object sender, EventArgs e)
{
EnglishLinqDataContext db = new EnglishLinqDataContext();
TaoTaiKhoanMoi ttkm = new TaoTaiKhoanMoi();
if (ttkm.ShowDialog() == DialogResult.OK)
{
//reload
var query = from p in db.NguoiDungs
select p;
DsNguoidungListbox.DisplayMember = "IDNguoiDung";
DsNguoidungListbox.ValueMember = "IDNguoiDung";
DsNguoidungListbox.DataSource = query;
}
db.SubmitChanges();
}