private void LoadCell()
{
eDanhMuc dm = dmbll.LayDanhMucTheoIDDanhMuc(Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()));
tbIdDanhMuc.Text = dm.IdDanhMuc.ToString();
tbTenDanhMuc.Text = dm.TenDanhMuc;
tbPhiThue.Text = dm.PhiThue.ToString();
tbPhiTreHan.Text = dm.PhiTreHan.ToString();
tbSoNgayThue.Text = dm.SoNgayThue.ToString();
}
public bool SuaDanhMuc(eDanhMuc edm)
{
DanhMuc dm = new DanhMuc();
dm = db.DanhMucs.Where(a => a.IdDanhMuc == edm.IdDanhMuc).SingleOrDefault();
if (dm != null)
{
dm.TenDanhMuc = edm.TenDanhMuc;
dm.PhiThue = edm.PhiThue;
dm.PhiTreHan = edm.PhiTreHan;
db.SubmitChanges();
return(true);
}
return(false);
}
public eDanhMuc LayDanhMucTheoIDDanhMuc(int idDanhMuc)
{
eDanhMuc dm = new eDanhMuc();
DanhMuc dmm = db.DanhMucs.SingleOrDefault(p => p.IdDanhMuc == idDanhMuc);
if (dmm != null)
{
dm.IdDanhMuc = dmm.IdDanhMuc;
dm.TenDanhMuc = dmm.TenDanhMuc;
dm.PhiThue = (decimal)dmm.PhiThue;
dm.PhiTreHan = (decimal)dmm.PhiTreHan;
dm.SoNgayThue = (int)dmm.SoNgayThue;
return(dm);
}
return(null);
}
public bool ThemDanhMuc(eDanhMuc edm)
{
DanhMuc dm = new DanhMuc();
//dm.IdDanhMuc = edm.IdDanhMuc;
dm.TenDanhMuc = edm.TenDanhMuc;
dm.PhiThue = edm.PhiThue;
dm.PhiTreHan = edm.PhiTreHan;
dm.TrangThaiXoa = false;
if (!db.DanhMucs.Contains(dm))
{
db.DanhMucs.InsertOnSubmit(dm);
db.SubmitChanges();
return(true);
}
return(false);
}
public List <eDanhMuc> LayDanhSachTenDanhMuc()
{
List <eDanhMuc> list = new List <eDanhMuc>();
var query = (from a in db.DanhMucs
where a.TrangThaiXoa == false
select new
{
a.TenDanhMuc
}).ToList();
foreach (var item in query)
{
eDanhMuc etd = new eDanhMuc(item.TenDanhMuc);
list.Add(etd);
}
return(list);
}
