public void UpDateListView(eCauThu ct)
{
txtEmail.Text = ct.Email;
txtMaCauThu.Text = ct.MaCauThu;
txtMaDoiBong.Text = ct.MaDoiBong;
txtSDT.Text = ct.SoDienThoai;
txtTenCauThu.Text = ct.TenCauThu;
}
private void lvwDSCauThu_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvwDSCauThu.SelectedItems.Count > 0)
{
vt = lvwDSCauThu.SelectedIndices[0];
eCauThu ct = (eCauThu)lvwDSCauThu.SelectedItems[0].Tag;
UpDateListView(ct);
}
}
public bool AddCauThu(eCauThu e)
{
CauThu cauthu = new CauThu {
tencauthu = e.tencauthu, email = e.email, iddoibong = e.iddoibong, macauthu = e.macauthu, sodt = e.sodt
};
db.CauThus.Add(cauthu);
db.SaveChanges();
return(true);
}
public ListViewItem CreateItem(eCauThu ct)
{
ListViewItem item = new ListViewItem();
item.SubItems.Add(ct.MaCauThu);
item.SubItems.Add(ct.TenCauThu);
item.SubItems.Add(ct.Email);
item.SubItems.Add(ct.SoDienThoai);
item.SubItems.Add(ct.MaDoiBong);
item.Tag = ct;
return(item);
}
public bool suaThongTinCauThu(eCauThu ct)
{
tblCauThu nct = db.tblCauThus.Where(x => x.MaCauThu == ct.MaCauThu).FirstOrDefault();
nct.TenCauThu = ct.TenCauThu;
nct.SoDienThoai = ct.SoDienThoai;
nct.Email = ct.Email;
nct.IdDoiBong = ct.MaDoiBong;
try
{
db.SubmitChanges();
}
catch (Exception e)
{
throw new Exception("Lỗi không sửa được " + e.Message);
}
return(true);
}
public bool UpdateCauThu(eCauThu e)
{
var result = db.CauThus.Where(x => x.macauthu.Equals(e.macauthu)).FirstOrDefault();
if (result is null)
{
return(false);
}
else
{
result.iddoibong = e.iddoibong;
result.sodt = e.sodt;
result.tencauthu = e.tencauthu;
result.email = e.email;
db.SaveChanges();
return(true);
}
}
public int themThanhVien(eCauThu ct)
{
tblCauThu temp = db.tblCauThus.Where(x => x.MaCauThu == ct.MaCauThu).FirstOrDefault();
if (temp != null)
{
return(0);
}
tblCauThu newct = new tblCauThu();
newct.MaCauThu = ct.MaCauThu;
newct.TenCauThu = ct.TenCauThu;
newct.SoDienThoai = ct.SoDienThoai;
newct.Email = ct.Email;
newct.IdDoiBong = ct.MaDoiBong;
db.tblCauThus.InsertOnSubmit(newct);
db.SubmitChanges();
return(1);
}
private void btnThem_Click(object sender, EventArgs e)
{
eCauThu nct = new eCauThu();
nct.MaCauThu = txtMaCauThu.Text;
nct.MaDoiBong = txtMaDoiBong.Text;
nct.SoDienThoai = txtSDT.Text;
nct.TenCauThu = txtTenCauThu.Text;
nct.Email = txtEmail.Text;
if (cThu.themThanhVien(nct) == 1)
{
MessageBox.Show("thêm thành công");
List <eCauThu> lsCT = cThu.getAllCauThu();
foreach (eCauThu item in lsCT)
{
lvwDSCauThu.Items.Add(CreateItem(item));
}
}
else
{
MessageBox.Show("thêm thất bại");
}
}
public bool suaThongTinCauThu(eCauThu nct)
{
return(ct.suaThongTinCauThu(nct));
}
public int themThanhVien(eCauThu nct)
{
return(ct.themThanhVien(nct));
}
private void UpdateCauThu(eCauThu e)
{
dbcauthu.UpdateCauThu(e);
}
private void AddCauThu(eCauThu e)
{
dbcauthu.AddCauThu(e);
}
public bool UpdateCauThu(eCauThu e)
{
return(db.UpdateCauThu(e));
}
public bool AddCauThu(eCauThu e)
{
return(db.AddCauThu(e));
}
