public bool suadocgia(string madocgia, string tendocgia, string gioitinh, string ngaysinh, string diachi, string sodienthoai, byte[] anhqr, string ngaytao, string email, string tenloaidocgia, byte[] anhdocgia)
{
try
{
string maloaidocgia = (from a in qltv.QL_LoaiDocGias
where a.TenLoaiDocGia == tenloaidocgia
select a.MaLoaiDocGia).FirstOrDefault();
QL_DocGia edit = qltv.QL_DocGias.Where(d => d.MaDocGia.Equals(madocgia)).SingleOrDefault();
edit.TenDocGia = tendocgia;
edit.LoaiDocGia = maloaidocgia;
edit.GioiTinh = gioitinh;
edit.NgaySinh = DateTime.Parse(ngaysinh);
edit.DiaChi = diachi;
edit.SoDienThoai = sodienthoai;
edit.Anh = anhqr;
edit.NgayTao = DateTime.Parse(ngaytao);
edit.Emai = email;
edit.AnhDocGia = anhdocgia;
qltv.SubmitChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool xoadocgia(string madocgia)
{
QL_DocGia delete = qltv.QL_DocGias.Where(p => p.MaDocGia.Equals(madocgia)).SingleOrDefault();
qltv.QL_DocGias.DeleteOnSubmit(delete);
qltv.SubmitChanges();
return(true);
}
public bool themdocgia(string madocgia, string tendocgia, string gioitinh, string ngaysinh, string diachi, string sodienthoai, byte[] anhqr, string ngaytao, string email, string tenloaidocgia, byte[] anhdocgia)
{
string maloaidocgia = (from a in qltv.QL_LoaiDocGias
where a.TenLoaiDocGia == tenloaidocgia
select a.MaLoaiDocGia).FirstOrDefault();
QL_DocGia insert = new QL_DocGia();
insert.MaDocGia = madocgia;
insert.TenDocGia = tendocgia;
insert.LoaiDocGia = maloaidocgia;
insert.GioiTinh = gioitinh;
insert.NgaySinh = DateTime.Parse(ngaysinh);
insert.DiaChi = diachi;
insert.SoDienThoai = sodienthoai;
insert.Anh = anhqr;
insert.NgayTao = DateTime.Parse(ngaytao);
insert.Emai = email;
insert.AnhDocGia = anhdocgia;
qltv.QL_DocGias.InsertOnSubmit(insert);
qltv.SubmitChanges();
return(true);
}
