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