private void btn_timkiem_Click(object sender, EventArgs e) { Clearr(); if (nhapid.Text != "") { int id = Convert.ToInt32(nhapid.Text); eDVD dvd = dVDBUL.FindDVDById(id); if (dvd != null) { eTieuDe tieuDe = tieuDe = tieuDeBUL.Find(dvd.id_TieuDe); eTheLoai theLoai = tieuDeBUL.FindTheLoaiById(tieuDe.id_TieuDe); txt_tendia.Text = tieuDe.tenTieuDe; txtgiathue.Text = theLoai.giaThue.ToString(); txttgthue.Text = theLoai.thoiGianThue.ToString(); txt_iddia.Text = dvd.id_DVD.ToString(); txt_tragthai.Text = dvd.trangThai.ToString(); btn_timkiem.Text = " Tìm kiếm"; } else { MessageBox.Show("Không có đĩa trong danh sách"); } } else { MessageBox.Show("Nhap ma can tim"); } }
public void Save(eTheLoai d) { TheLoai item = new TheLoai(); item.id_TheLoai = d.id_TheLoai; item.tenTheLoai = d.tenTheLoai; item.giaThue = d.giaThue; item.thoiGianThue = d.thoiGianThue; tldal.Save(item); }
public eTheLoai FindDVDById(int id) { TheLoai t = tldal.Find(id); eTheLoai e = new eTheLoai(); e.id_TheLoai = t.id_TheLoai; e.tenTheLoai = t.tenTheLoai; e.giaThue = t.giaThue; e.thoiGianThue = t.thoiGianThue; return(e); }
private void dgv_dsdiathue_RowStateChanged(object sender, DataGridViewRowStateChangedEventArgs e) { if (dgv_dsdiathue.SelectedRows.Count > 0) { string str = e.Row.Cells["id_DVD"].Value.ToString(); eTieuDe t = td.GetTieuDeByID(Convert.ToInt32(str)); txt_tieude.Text = t.tenTieuDe; eTheLoai theloai = tl.GetTheLoaiByID(t.id_TheLoai); DateTime dt = (DateTime)e.Row.Cells["ngayThue"].Value; txt_nghethan.Text = dt.AddDays(theloai.thoiGianThue).ToShortDateString(); } }
private void cb_listkh_SelectedIndexChanged(object sender, EventArgs e) { if (cb_listkh.SelectedIndex == 1) { List <eKhachHang> lskh = khbul.getKhachHangs(); List <eKhachHang> lskh1 = new List <eKhachHang>(); foreach (var item in lskh) { List <ePhieuThueTra> lsp = phieu.getPhieuThueTraByKHBaoCao(item.id_KhachHang); foreach (var item1 in lsp) { eDVD dvd1 = dvd.FindDVDById(item1.id_DVD); eTieuDe t = td.GetTieuDeByID(dvd1.id_TieuDe); eTheLoai theloai = tl.GetTheLoaiByID(t.id_TheLoai); DateTime dt = (DateTime)item1.ngayThue; DateTime today = DateTime.Now; if (item1.ngayTra == null && DateTime.Compare(today, dt.AddDays(theloai.thoiGianThue)) == 1) { lskh1.Add(item); break; } } } dgv_dskh.DataSource = lskh1; FormatLaiDataGridviewkh(dgv_dskh); } else if (cb_listkh.SelectedIndex == 0) { List <eKhachHang> ls = khbul.getKhachHangs(); dgv_dskh.DataSource = ls; FormatLaiDataGridviewkh(dgv_dskh); } else { List <eKhachHang> lskh = khbul.getKhachHangs(); List <eKhachHang> lskh1 = new List <eKhachHang>(); foreach (var item in lskh) { List <ePhieuThueTra> lsp = phieu.getPhieuThueTraByKHBaoCao(item.id_KhachHang); foreach (var item1 in lsp) { if (item1.ngayTraPhiTreHen == null) { lskh1.Add(item); break; } } } dgv_dskh.DataSource = lskh1; FormatLaiDataGridviewkh(dgv_dskh); } }
public List <eTheLoai> getTheLoais() { List <eTheLoai> list = new List <eTheLoai>(); foreach (var item in tldal.getTheLoais()) { eTheLoai tam = new eTheLoai(); tam.id_TheLoai = item.id_TheLoai; tam.tenTheLoai = item.tenTheLoai; list.Add(tam); } return(list); }
public eTheLoai GetTheLoaiByID(int id) { eTheLoai tam = new eTheLoai(); TheLoai item = tldal.Find(id); if (item != null) { tam.id_TheLoai = item.id_TheLoai; tam.tenTheLoai = item.tenTheLoai; tam.thoiGianThue = item.thoiGianThue; tam.giaThue = item.giaThue; return(tam); } return(null); }
public eTheLoai FindTheLoaiById(int id) { TheLoai t = tddal.FindTheLoaiById(id); if (t != null) { eTheLoai e = new eTheLoai(); e.id_TheLoai = t.id_TheLoai; e.tenTheLoai = t.tenTheLoai; e.giaThue = t.giaThue; e.thoiGianThue = t.thoiGianThue; return(e); } return(null); }
private DataTable ConvertListToDataTable(List<eDVD> list) { DataTable table = new DataTable(); table.Columns.Add("id_DVD", typeof(int)); table.Columns.Add("id_TieuDe", typeof(int)); table.Columns.Add("string_TieuDe", typeof(string)); table.Columns.Add("gia", typeof(string)); table.Columns.Add("thoigian", typeof(string)); foreach (eDVD item in list) { eTheLoai theLoai = tieuDeBUL.FindTheLoaiById(tieuDeBUL.Find(item.id_TieuDe).id_TheLoai); table.Rows.Add(item.id_DVD, item.id_TieuDe, tieuDeBUL.GetTieuDeByID(item.id_TieuDe).tenTieuDe, theLoai.giaThue, theLoai.thoiGianThue); } return table; }
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) { int strMa; List <eTieuDe> ls = new List <eTieuDe>(); if (treeView1.SelectedNode != null) { eTheLoai tl = new eTheLoai(); tl = tlbul.GetTheLoaiByID(Convert.ToInt32(treeView1.SelectedNode.Tag.ToString())); txt_time.Text = tl.thoiGianThue.ToString(); txt_Gia.Text = tl.giaThue.ToString(); /// ds tieu de strMa = Convert.ToInt32(treeView1.SelectedNode.Tag.ToString()); ls = tdbul.GetTieuDeByIDTL(strMa); dgv_tieude.DataSource = ls; FormatLaiDataGridview(dgv_tieude); } }
private void dgv_dsdia_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { DataGridViewRow row = this.dgv_dsdia.Rows[e.RowIndex]; if (!row.Cells[1].Value.ToString().Trim().Equals("")) { //Lưu lại dòng dữ liệu vừa kích chọn //Đưa dữ liệu vào textbox txt_iddia.Text = row.Cells[0].Value.ToString(); txt_tragthai.Text = row.Cells[4].Value.ToString(); int s = Convert.ToInt32(row.Cells[1].Value.ToString()); eTieuDe tieuDe = new eTieuDe(); eTheLoai theLoai = new eTheLoai(); tieuDe = tieuDeBUL.Find(s); theLoai = theLoaiBUL.FindDVDById(tieuDe.id_TheLoai); txt_tendia.Text = tieuDe.tenTieuDe; txtgiathue.Text = theLoai.giaThue.ToString(); txttgthue.Text = theLoai.thoiGianThue.ToString(); } } }
private void dgv_dsdia_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { //Lưu lại dòng dữ liệu vừa kích chọn DataGridViewRow row = this.dgv_dsdia.Rows[e.RowIndex]; //Đưa dữ liệu vào textbox txt_iddia.Text = row.Cells[0].Value.ToString(); txt_tragthai.Text = row.Cells[2].Value.ToString(); int s = Convert.ToInt32(row.Cells[2].Value.ToString()); eTieuDe tieuDe = new eTieuDe(); eTheLoai theLoai = new eTheLoai(); tieuDe = tieuDeBUL.Find(s); theLoai = theLoaiBUL.FindDVDById(tieuDe.id_TieuDe); txt_tendia.Text = tieuDe.tenTieuDe; txtgiathue.Text = theLoai.giaThue.ToString(); txttgthue.Text = theLoai.thoiGianThue.ToString(); //Không cho phép sửa trường STT ///txtSTT.Enabled = false; } }