private void txtSearch_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
string key = txtSearch.Text;
string tenNhom = (string)dgvNhom.CurrentCell.Value;
//Nhom nhom = Nhom.getNhomByName(tenNhom);
Nhom nhom = Nhom.getNhomFromDBByName(tenNhom);
//List<DanhBa> list = DanhBa.getDanhBaTheoNhom(nhom.maNhom);
List <DanhBa> list = DanhBa.getDanhBaFromDBTheoNhom(nhom.maNhom);
List <DanhBa> rs = new List <DanhBa>();
for (int i = 0; i < list.Count; i++)
{
if (list.ElementAt(i).tenGoi.Equals(key) || list.ElementAt(i).email.Equals(key) || list.ElementAt(i).sdt.Equals(key))
{
rs.Add(list.ElementAt(i));
}
}
bdsDanhBa.DataSource = rs;
dgvDanhBa.DataSource = bdsDanhBa;
}
if (txtSearch.Text.Equals(""))
{
string tenNhom = (string)dgvNhom.CurrentCell.Value;
//Nhom nhom = Nhom.getNhomByName(tenNhom);
Nhom nhom = Nhom.getNhomFromDBByName(tenNhom);
//List<DanhBa> list = DanhBa.getDanhBaTheoNhom(nhom.maNhom);
List <DanhBa> list = DanhBa.getDanhBaFromDBTheoNhom(nhom.maNhom);
bdsDanhBa.DataSource = list;
dgvDanhBa.DataSource = bdsDanhBa;
}
}
private void dgvNhom_CellClick(object sender, DataGridViewCellEventArgs e)
{
string tenNhom = (string)dgvNhom.CurrentCell.Value;
if (tenNhom != null)
{
//Nhom nhom = Nhom.getNhomByName(tenNhom);
Nhom nhom = Nhom.getNhomFromDBByName(tenNhom);
//List<DanhBa> list = DanhBa.getDanhBaTheoNhom(nhom.maNhom);
List <DanhBa> list = DanhBa.getDanhBaFromDBTheoNhom(nhom.maNhom);
bdsDanhBa.DataSource = list;
dgvDanhBa.DataSource = bdsDanhBa;
}
}
public void refreshList()
{
//List<Nhom> listNhom = Nhom.getNhom();
List <Nhom> listNhom = Nhom.getNhomFromDB();
bdsNhom.DataSource = listNhom;
dgvNhom.DataSource = bdsNhom;
if (listNhom.Count > 0)
{
string tenNhom = (string)dgvNhom.CurrentCell.Value;
//Nhom nhom = Nhom.getNhomByName(tenNhom);
Nhom nhom = Nhom.getNhomFromDBByName(tenNhom);
//List<DanhBa> list = DanhBa.getDanhBaTheoNhom(nhom.maNhom);
List <DanhBa> list = DanhBa.getDanhBaFromDBTheoNhom(nhom.maNhom);
bdsDanhBa.DataSource = list;
dgvDanhBa.DataSource = bdsDanhBa;
}
}
private void btnXoaNhom_Click(object sender, EventArgs e)
{
string tenNhomXoa = (string)dgvNhom.CurrentCell.Value;
var nhom = Nhom.getNhomFromDBByName(tenNhomXoa);
DanhBa.xoaDanhBaByNhom(nhom.maNhom);
Nhom.xoaNhomFromDBByName(tenNhomXoa);
refreshList();
//string pathNhom = Application.StartupPath + @"/DATA/Nhom.txt";
//string pathDanhBa = Application.StartupPath + @"/DATA/DanhBa.txt";
//string[] linesNhom = File.ReadAllLines(pathNhom);
//string[] linesDanhBa = File.ReadAllLines(pathDanhBa);
//File.WriteAllText(pathNhom, "");
//File.WriteAllText(pathDanhBa, "");
//string newline = System.Environment.NewLine;
//for (int i = 0; i < linesNhom.Length; i++)
//{
// string[] temp = linesNhom[i].Split(new char[] { '#' });
// if (!temp[1].Equals(tenNhomXoa))
// {
// File.AppendAllText(pathNhom, linesNhom[i] + newline, Encoding.Unicode);
// }
//}
//for (int i = 0; i < linesDanhBa.Length; i++)
//// {
// string[] temp = linesDanhBa[i].Split(new char[] { '#' });
// if (!temp[0].Equals(tenNhomXoa))
// {
// File.AppendAllText(pathDanhBa, linesDanhBa[i] + newline, Encoding.Unicode);
// }
// }
}
private void btnOK_Click(object sender, EventArgs e)
{
//string path = Application.StartupPath + @"/DATA/DanhBa.txt";
string tenGoi = txtTenGoi.Text;
string tenNhom = txtNhom.Text;
string email = txtEmail.Text;
string sdt = txtSdt.Text;
// string line = tenNhom + "#" + tenGoi + "#" + email + "#" + sdt + System.Environment.NewLine;
//File.AppendAllText(path, line, Encoding.Unicode);
Nhom temp0 = Nhom.getNhomFromDBByName(tenNhom);
DanhBa temp = new DanhBa {
tenGoi = tenGoi, maNhom = temp0.maNhom, email = email, sdt = sdt
};
bool check = DanhBa.themDanhBaToDB(temp);
if (check)
{
this.Close();
}
else
{
MessageBox.Show(null, "Không thêm được nhóm", "Error", MessageBoxButtons.OK);
}
}
