private void SuaDangKyCho_Load(object sender, EventArgs e)
{
Sach dataSach = new Sach();
DocGia dataDocGia = new DocGia();
DataTable dtDocGia = dataDocGia.loadDocGia();
DataTable dtDauSach = dataSach.loadDauSachTuaSach();
ComboboxItem item;
string tuaSach = String.Empty;
for (int i = 0; i < dtDocGia.Rows.Count; i++)
{
if (dtDocGia.Rows[i]["Tình trạng"].ToString() != String.Empty && (bool)dtDocGia.Rows[i]["Tình trạng"] == true)//== String.Empty
cbxmdg.Items.Add(Convert.ToInt32(dtDocGia.Rows[i]["Mã độc giả"].ToString()));
}
for (int i = 0; i < dtDauSach.Rows.Count; i++)
{
//if (dtDauSach.Rows[i]["Tình trạng"].ToString() == String.Empty || (bool)dtDauSach.Rows[i]["Tình trạng"] == false)//== String.Empty
//{
//cbxmadausach.Items.Add(Convert.ToInt32(dtDauSach.Rows[i]["Mã đầu sách"].ToString()));
item = new ComboboxItem();
item.Text = dtDauSach.Rows[i]["Mã đầu sách"].ToString() + " - " + dtDauSach.Rows[i]["Tên tựa sách"].ToString() + " - " + dtDauSach.Rows[i]["Ngôn ngữ"].ToString();
item.Value = Convert.ToInt32(dtDauSach.Rows[i]["Mã đầu sách"]);
cbxmadausach.Items.Add(item);
//}
}
//cbxmadausach.SelectedIndex = inf.ma;
//cbxmdg.SelectedIndex = 0;
for (int i = 0; i < cbxmdg.Items.Count; i++)
{
if (cbxmdg.Items[i].ToString() == inf.madocgia)
{
cbxmdg.SelectedIndex = i;
break;
}
}
for (int i = 0; i < cbxmadausach.Items.Count; i++)
{
if ((cbxmadausach.Items[i] as ComboboxItem).Value.ToString() == inf.madausach)
{
cbxmadausach.SelectedIndex = i;
break;
}
}
dtngaygiodk.Value = inf.ngaygiodk;
if (inf.tinhtrang == true)
cbdamuon.Checked = true;
else
cbdamuon.Checked = false;
}
public DataTable thongKeDocGiaHetHan()
{
DocGia dataDocGia = new DocGia();
DataTable dt = dataDocGia.loadDocGia();
for (int i = 0; i < dt.Rows.Count; i++)
{
if ((bool)dt.Rows[i]["Tình trạng"] == true)
{
dt.Rows.RemoveAt(i);
i--;
}
}
return dt;
}
private void ThemDangKyCho_Load(object sender, EventArgs e)
{
Sach dataSach = new Sach();
DocGia dataDocGia = new DocGia();
DataTable dtDocGia = dataDocGia.loadDocGia();
DataTable dtDauSach = dataSach.loadDauSachTuaSach();
ComboboxItem item;
string tuaSach = String.Empty;
for (int i = 0; i < dtDocGia.Rows.Count; i++)
{
if (dtDocGia.Rows[i]["Tình trạng"].ToString() != String.Empty && (bool)dtDocGia.Rows[i]["Tình trạng"] == true)//== String.Empty
cbxmdg.Items.Add(Convert.ToInt32(dtDocGia.Rows[i]["Mã độc giả"].ToString()));
}
for (int i = 0; i < dtDauSach.Rows.Count; i++)
{
if (dtDauSach.Rows[i]["Tình trạng"].ToString() == String.Empty || (bool)dtDauSach.Rows[i]["Tình trạng"] == false)//== String.Empty
{
//cbxmadausach.Items.Add(Convert.ToInt32(dtDauSach.Rows[i]["Mã đầu sách"].ToString()));
item = new ComboboxItem();
item.Text = dtDauSach.Rows[i]["Mã đầu sách"].ToString() + " - " + dtDauSach.Rows[i]["Tên tựa sách"].ToString() + " - " + dtDauSach.Rows[i]["Ngôn ngữ"].ToString();
item.Value = Convert.ToInt32(dtDauSach.Rows[i]["Mã đầu sách"]);
cbxmadausach.Items.Add(item);
}
}
if (cbxmadausach.Items.Count > 0)
cbxmadausach.SelectedIndex = 0;
else
btnthem.Enabled = false;
if (cbxmdg.Items.Count > 0)
cbxmdg.SelectedIndex = 0;
else
btnthem.Enabled = false;
}
private void SuaMuonTraSach_Load(object sender, EventArgs e)
{
temp = data.timMuonTraSach(inf);
Sach dataSach = new Sach();
DocGia dataDocGia = new DocGia();
DataTable dtDocGia = dataDocGia.loadDocGia();
DataTable dtCuonSach = dataSach.loadCuonSach();
for (int i = 0; i < dtDocGia.Rows.Count; i++)
{
//if (dtDocGia.Rows[i]["Tình trạng"].ToString() != String.Empty && (bool)dtDocGia.Rows[i]["Tình trạng"] == true)//== String.Empty
string mdg = dtDocGia.Rows[i]["Mã độc giả"].ToString();
cbxmdg.Items.Add(mdg);
if (temp.madocgia == mdg)
cbxmdg.SelectedIndex = i;
}
for (int i = 0; i < dtCuonSach.Rows.Count; i++)
{
string macuonsach = dtCuonSach.Rows[i]["Mã cuốn sách"].ToString();
cbxmacuonsach.Items.Add(macuonsach);
if (temp.macuonsach == macuonsach)
cbxmacuonsach.SelectedIndex = i;
}
dtngaygiomuon.Value = temp.ngaygiomuon;
if (temp.ngaygiotra != null)
{
dtngaygiotra.Value = (DateTime)temp.ngaygiotra;
}
else
{
dtngaygiotra.Enabled = false;
}
}
