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