private void button1_Click(object sender, EventArgs e)
{
try
{
OpenFileDialog ofd = new OpenFileDialog()
{
Filter = "CSV|*.csv", ValidateNames = true, Multiselect = false
};
if (ofd.ShowDialog() == DialogResult.OK)
{
MessageBox.Show(ofd.FileName);
String path = ofd.FileName;
StreamReader sr = new StreamReader(ofd.FileName);
while (sr.ReadLine() != null)
{
String line = sr.ReadLine();
String[] arr = line.Split(',');
DanhBa danhBa = new DanhBa()
{
ID = arr[0],
Name = arr[1],
PhoneNumber = arr[2],
Email = arr[3],
idStudent = arr[4]
};
MessageBox.Show(danhBa.Name);
DanhBaService.addContact(danhBa);
}
}
}
catch
{
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (db != null)
{
DanhBa danhBa = new DanhBa
{
Name = txtHoTen.Text,
PhoneNumber = txtSoDT.Text,
Email = txtEmail.Text,
idStudent = idStudent
};
DanhBaService.EditContact(danhBa, idDanhBa);
if (MessageBox.Show("Cập nhật thành công", "Thông báo", MessageBoxButtons.OK) == DialogResult.OK)
{
this.Close();
}
}
else
{
DanhBa danhBa = new DanhBa
{
ID = Guid.NewGuid().ToString(),
Name = txtHoTen.Text,
PhoneNumber = txtSoDT.Text,
Email = txtEmail.Text,
idStudent = idStudent
};
DanhBaService.addContact(danhBa);
if (MessageBox.Show("Đã Thêm thành công", "Thông báo", MessageBoxButtons.OK) == DialogResult.OK)
{
this.Close();
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
var rs = MessageBox.Show("Bạn có muốn xóa không",
"Thông báo",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Warning);
if (rs == DialogResult.OK)
{
DanhBa db = bdsContact.Current as DanhBa;
DanhBaService.deleteContact(db.ID);
bdsContact.RemoveCurrent();
bdsContact.ResetBindings(true);
}
}
private void txtSearch_KeyPress(object sender, KeyPressEventArgs e)
{
bdsContact.DataSource = DanhBaService.SearchContact(txtSearch.Text, idSV);
}
private void btnNew_Click(object sender, EventArgs e)
{
Button clickedButton = (Button)sender;
bdsContact.DataSource = DanhBaService.FilterContactByCharFirst(clickedButton.Text, idSV);
}
