private void LoadDataToGridView()
{
this.dgvVoucherStt.Rows.Clear();
VoucherBLL manageVoucherBLL = new VoucherBLL();
List <VoucherBLL> manageVoucherArr = new List <VoucherBLL>();
manageVoucherArr = VoucherDAL.getManageVoucherList();
//MessageBox.Show("ok");
foreach (VoucherBLL row in manageVoucherArr)
{
this.dgvVoucherStt.Rows.Add(row.Phieutra, row.Phieumuon, row.Ngaytra, row.Docgia, row.Doituong);
}
this.GetSelectedValue();
this.dgvVoucherStt.SelectionChanged += new EventHandler(dgvCertificateStt_SelectionChanged);
}
private void btnSearch_Click(object sender, EventArgs e)
{
string key = this.txtSearch.Text;
if (key == "".Trim())
{
MessageBox.Show("Please enter keyword!", "Notice");
return;
}
string catalog = "";
//MessageBox.Show(this.cboSearch.SelectedItem.ToString());
if (this.cboSearch.SelectedItem.ToString() == "Voucher")
{
catalog += "phieutra.maphieutra";
//MessageBox.Show(catalog);
}
else if (this.cboSearch.SelectedItem.ToString() == "Certificate")
{
catalog += "sachmuon.maphieumuon";
//MessageBox.Show(catalog);
}
VoucherBLL bookStatusBLL = new VoucherBLL();
List <VoucherBLL> voucherStatusArr = new List <VoucherBLL>();
voucherStatusArr = VoucherDAL.search(key, catalog);
this.dgvVoucherStt.Rows.Clear();
if (voucherStatusArr != null)
{
//MessageBox.Show("ok");
foreach (VoucherBLL row in voucherStatusArr)
{
this.dgvVoucherStt.Rows.Add(row.Phieutra, row.Phieumuon, row.Ngaytra, row.Docgia, row.Doituong);
}
}
else
{
MessageBox.Show("Sorry! Can't find this voucher/certificate");
return;
}
this.GetSelectedValue();
this.dgvVoucherStt.SelectionChanged += new EventHandler(dgvCertificateStt_SelectionChanged);
}
public static List <VoucherBLL> search(string value, string catalog)
{
string sql = "SELECT * FROM [phieutra] INNER JOIN [sachmuon] ON sachmuon.maphieutra = phieutra.maphieutra INNER JOIN [docgia] ON phieutra.madocgia = docgia.madocgia where " + catalog + "=" + value + "";
DataTable dt = VoucherDAL._condb.getDataTable(sql);
List <VoucherBLL> voucherStatusBLLList = new List <VoucherBLL>();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
VoucherBLL voucherStatusBLL = new VoucherBLL(Int32.Parse(row["maphieutra"].ToString()), Int32.Parse(row["maphieumuon"].ToString()), row["tendocgia"].ToString(), Boolean.Parse(row["lacbcnv"].ToString()), DateTime.Parse(row["ngaytra"].ToString()));
voucherStatusBLLList.Add(voucherStatusBLL);
}
return(voucherStatusBLLList);
}
else
{
return(null);
}
}
public static List <VoucherBLL> getManageVoucherList()
{
String sql = "SELECT DISTINCT phieutra.maphieutra, sachmuon.maphieumuon, tendocgia, lacbcnv, ngaytra FROM [phieutra] INNER JOIN [sachmuon] ON sachmuon.maphieutra = phieutra.maphieutra INNER JOIN [docgia] ON phieutra.madocgia = docgia.madocgia";
DataTable dt = VoucherDAL._condb.getDataTable(sql);
List <VoucherBLL> manageVoucherBLLList = new List <VoucherBLL>();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
VoucherBLL manageVoucherBLL = new VoucherBLL(Int32.Parse(row["maphieutra"].ToString()), Int32.Parse(row["maphieumuon"].ToString()), row["tendocgia"].ToString(), Boolean.Parse(row["lacbcnv"].ToString()), DateTime.Parse(row["ngaytra"].ToString()));
manageVoucherBLLList.Add(manageVoucherBLL);
}
return(manageVoucherBLLList);
}
else
{
return(null);
}
}
