public bool InsertOrUpdateQuan(QUAN[] quans)
{
try
{
using (QLDLEntities db = new QLDLEntities())
{
foreach (QUAN quan in quans)
{
if (quan.MAQUAN == 0)
{
QUAN item = new QUAN()
{
TENQUAN = quan.TENQUAN,
SODLTOIDA = quan.SODLTOIDA
};
db.QUANs.Add(item);
}
else
{
QUAN item = db.QUANs.FirstOrDefault(x => x.MAQUAN == quan.MAQUAN);
item.TENQUAN = quan.TENQUAN;
item.SODLTOIDA = quan.SODLTOIDA;
}
}
db.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
//update by ID
public bool Update(string MaQ, QUAN q)
{
using (QLDLDataContext db = new QLDLDataContext())
{
QUAN temp = db.QUANs.Where(p => p.MaQuan == MaQ).SingleOrDefault();
temp.TenQuan = q.TenQuan;
try
{
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
}
public frmTiepNhanKN(string db, string loai)
{
danhbo = db;
loaikh = loai;
InitializeComponent();
fLoad(loaikh);
if ("KH".Equals(loaikh))
{
TB_DULIEUKHACHHANG khachhang = DAL.KhachHang.CKhachHang.finByDanhBo(danhbo);
if (khachhang != null)
{
txtSoDanhBo.Text = khachhang.DANHBO;
txtTenKH.Text = khachhang.HOTEN;
txtsonha.Text = khachhang.SONHA;
txtDuong.Text = khachhang.TENDUONG;
txtDienThoai.Text = khachhang.DIENTHOAI;
cbQuan.SelectedValue = khachhang.QUAN;
cbPhuong.SelectedValue = khachhang.PHUONG;
}
}
else if ("GM".Equals(loaikh))
{
BIENNHANDON donkh = DAL.KhachHang.CGanMoi.searchBienNhan(danhbo);
if (donkh != null)
{
txtSoDanhBo.Text = donkh.SHS;
txtTenKH.Text = donkh.HOTEN;
txtsonha.Text = donkh.SONHA;
txtDuong.Text = donkh.DUONG;
txtDienThoai.Text = donkh.DIENTHOAI;
QUAN q = CHeThongDuong.finByMaQuan(donkh.QUAN);
cbQuan.Text = q.TENQUAN;
cbPhuong.Text = CHeThongDuong.finbyPhuong(q.MAQUAN, donkh.PHUONG).TENPHUONG;
}
}
}
//Update by ID
public bool Update(string MaQ, QUAN q)
{
return(QuanDAO.Instance.Update(MaQ, q));
}
