private void btnTimKiem_Click(object sender, EventArgs e) { Loai loai = new Loai(); dgvDanhSachLoai.DataSource = loai.TimKiemLoai(txtTuKhoa.Text).ToList(); }
private void SetInputForm(Loai loaiTim) { txtMaLoai.Text = loaiTim.MaLoai.ToString(); txtTenLoai.Text = loaiTim.TenLoai.ToString(); txtMoTa.Text = loaiTim.MoTa.ToString(); txtHinhAnh.Text = loaiTim.Hinh.ToString(); }
public FormSuaLoai(int maLoai) { this.maLoai = maLoai; InitializeComponent(); Loai loaiSua = new Loai(); LoaiSua = loaiSua.GetLoaiById(maLoai); SetInputForm(LoaiSua); }
private void SetInputForm(Loai loaiSua) { txtMaLoai.Text = loaiSua.MaLoai.ToString(); txtTenLoai.Text = loaiSua.TenLoai; txtMoTa.Text = loaiSua.MoTa; txtHinhAnh.Text = loaiSua.Hinh; if (File.Exists(Application.StartupPath + "/images/" + loaiSua.Hinh)) { pictureBox1.Image = new Bitmap(Application.StartupPath + "/images/" + loaiSua.Hinh); } }
private void btnThemLoai_Click(object sender, EventArgs e) { try { Loai loaiThem = GetInputForm(); loaiThem.ThemLoai(); DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnThemLoai_Click(object sender, EventArgs e) { try { Loai loai = GetInputForm(); loai.ThemLoai(); LoadDanhSachLoai(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void dgvDanhSachLoai_CellContentClick(object sender, DataGridViewCellEventArgs e) { int maLoai = int.Parse(dgvDanhSachLoai.Rows[e.RowIndex].Cells["MaLoai"].Value.ToString()); Loai loai = new Loai(); Loai loaiTim = loai.GetLoaiById(maLoai); Form formSua = new FormSuaLoai(maLoai); var isOK = formSua.ShowDialog(); if (isOK == DialogResult.OK) { LoadDanhSachLoai(); } // SetInputForm(loaiTim); }
public List <Loai> GetDanhSachLoai() { List <Loai> LLoai = new List <Loai>(); string sql = "select * from Loai"; var res = this.SelectQuery(sql); while (res.Read()) { Loai loai = new Loai() { MaLoai = int.Parse(res["MaLoai"].ToString()) , TenLoai = res["TenLoai"].ToString() , MoTa = res["MoTa"].ToString() , Hinh = res["Hinh"].ToString() }; LLoai.Add(loai); } return(LLoai); }
public List <Loai> TimKiemLoai(string text) { List <Loai> LLoai = new List <Loai>(); string sql = String.Format(@"select * from Loai where TenLoai like '%{0}%' or MaLoai like '%{0}%'", text); var res = this.SelectQuery(sql); while (res.Read()) { Loai loai = new Loai() { MaLoai = int.Parse(res["MaLoai"].ToString()) , TenLoai = res["TenLoai"].ToString() , MoTa = res["MoTa"].ToString() , Hinh = res["Hinh"].ToString() }; LLoai.Add(loai); } return(LLoai); }
private void LoadDanhSachLoai() { Loai loai = new Loai(); dgvDanhSachLoai.DataSource = loai.GetDanhSachLoai().ToList(); }