public List<LOAIHOATDONG> SelectLOAIHOATDONGsAll()
{
List<LOAIHOATDONG> list = new List<LOAIHOATDONG>();
using (LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString))
{
ISingleResult<LOAIHOATDONG_getallResult> lp = db.LOAIHOATDONG_getall();
foreach (LOAIHOATDONG_getallResult LOAIHOATDONG in lp)
{
LOAIHOATDONG var1 = new LOAIHOATDONG();
var1.MaLoaiHoatDong = LOAIHOATDONG.MaLoaiHoatDong ;
var1.TenLoaiHoatDong = LOAIHOATDONG.TenLoaiHoatDong ;
list.Add(var1);
}
try
{
// Save the changes.
db.SubmitChanges();
}
// Detect concurrency conflicts.
catch (ChangeConflictException)
{
// Resolve conflicts.
db.ChangeConflicts.ResolveAll(RefreshMode.KeepChanges);
}
}
return list;
}
public int CapNhat(LOAIHOATDONG lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
return db.LOAIHOATDONG_update(
lpDTO.MaLoaiHoatDong ,
lpDTO.TenLoaiHoatDong
);
}
catch (Exception ex)
{
throw (ex);
}
}
public int Them(LOAIHOATDONG lpDTO)
{
try
{
LinQDataContext db = new LinQDataContext(global::DAOAuction.Properties.Settings.Default.webdoantruongConnectionString);
db.LOAIHOATDONG_add(
lpDTO.TenLoaiHoatDong
);
return 1;
}
catch
{
return 0;
}
}
public int Them(LOAIHOATDONG lpDTO)
{
DAOLoaiHoatDong LOAIHOATDONG = new DAOLoaiHoatDong();
return LOAIHOATDONG.Them(lpDTO);
}
public int CapNhat(LOAIHOATDONG lpDTO)
{
DAOLoaiHoatDong LOAIHOATDONG = new DAOLoaiHoatDong();
return LOAIHOATDONG.CapNhat(lpDTO);
}
