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