public System.Data.Linq.Table <ThanhPho> LayThanhPho() { DataSet ds = new DataSet(); QLKHDataContext qlBH = new QLKHDataContext(); return(qlBH.ThanhPhos); }
public bool XoaThanhPho(ref string err, string MaThanhPho) { QLKHDataContext qlBH = new QLKHDataContext(); var tpQuery = from tp in qlBH.ThanhPhos where tp.ThanhPho1 == MaThanhPho select tp; qlBH.ThanhPhos.DeleteAllOnSubmit(tpQuery); qlBH.ThanhPhos.Context.SubmitChanges(); return(true); }
public bool ThemThanhPho(string MaThanhPho, string TenThanhPho, ref string err) { QLKHDataContext qlKH = new QLKHDataContext(); ThanhPho tp = new ThanhPho(); tp.ThanhPho1 = MaThanhPho; tp.TenThanhPho = TenThanhPho; qlKH.ThanhPhos.InsertOnSubmit(tp); qlKH.ThanhPhos.Context.SubmitChanges(); return(true); }
public bool CapNhatThanhPho(string MaThanhPho, string TenThanhPho, ref string err) { QLKHDataContext qlBH = new QLKHDataContext(); var tpQuery = (from tp in qlBH.ThanhPhos where tp.ThanhPho1 == MaThanhPho select tp).SingleOrDefault(); if (tpQuery != null) { tpQuery.TenThanhPho = TenThanhPho; qlBH.SubmitChanges(); } return(true); }
public BaseServiceResult <IEnumerable <KhachHangInfo> > GetAllKhachHangs() { try { List <KhachHangInfo> khachhangList = new List <KhachHangInfo>(); QLKHDataContext db = new QLKHDataContext(); foreach (var item in db.KhachHangs) { khachhangList.Add(new KhachHangInfo { Id = item.KhachHangID, Name = item.ConNguoi.HoTen }); } return(new BaseServiceResult <IEnumerable <KhachHangInfo> >(ResultStatusCodes.OK, khachhangList)); } catch { return(BaseServiceResult <IEnumerable <KhachHangInfo> > .InternalErrorResult); } }