public void xoa(string id)
{
doituong dt = (from d in db.doituongs select d).Single(t => t.id == id);
db.doituongs.DeleteOnSubmit(dt);
db.SubmitChanges();
}
public void sua(string id, string ten, string nhom, string loai, string diachi, string msthue, string dienthoai, string email, string fax, string dd, string taikhoan, string nganhang, string manv, string madv)
{
doituong dt = (from d in db.doituongs select d).Single(t => t.id == id);
dt.ten = ten;
dt.nhom = nhom;
dt.loai = loai;
dt.diachi = diachi;
dt.msthue = msthue;
dt.dienthoai = dienthoai;
dt.email = email;
dt.fax = fax;
dt.dd = dd;
dt.taikhoan = taikhoan;
dt.nganhang = nganhang;
dt.manv = manv;
dt.madv = madv;
db.SubmitChanges();
}
public void moi(string id, string ten, string nhom, string loai, string diachi, string msthue, string dienthoai, string email, string fax, string dd, string taikhoan, string nganhang, string manv, string madv)
{
doituong dt = new doituong();
dt.id = id;
dt.ten = ten;
dt.nhom = nhom;
dt.loai = loai;
dt.diachi = diachi;
dt.msthue = msthue;
dt.dienthoai = dienthoai;
dt.email = email;
dt.fax = fax;
dt.dd = dd;
dt.taikhoan = taikhoan;
dt.nganhang = nganhang;
dt.manv = manv;
dt.madv = madv;
db.doituongs.InsertOnSubmit(dt);
db.SubmitChanges();
}
public void moi(string id, string ten, string nhom, string loai, string diachi, string msthue, string dienthoai, string email, string fax, string dd, string taikhoan, string nganhang)
{
var dt = db.doituongs.FirstOrDefault(t => t.id == id);
if (dt == null)
{
dt = new doituong();
dt.id = id;
dt.ten = ten;
dt.nhom = nhom;
dt.loai = loai;
dt.diachi = diachi;
dt.msthue = msthue;
dt.dienthoai = dienthoai;
dt.email = email;
dt.fax = fax;
dt.dd = dd;
dt.taikhoan = taikhoan;
dt.nganhang = nganhang;
db.doituongs.InsertOnSubmit(dt);
db.SubmitChanges();
}
else
{
dt.ten = ten;
dt.nhom = nhom;
dt.loai = loai;
dt.diachi = diachi;
dt.msthue = msthue;
dt.dienthoai = dienthoai;
dt.email = email;
dt.fax = fax;
dt.dd = dd;
dt.taikhoan = taikhoan;
dt.nganhang = nganhang;
db.SubmitChanges();
}
}
