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)); }