public int getBookQuantityCanBorrow(ReaderBLL readerBLL)
{
if (CertificateDAL.getCertificateByReaderId(readerBLL.Code) != null)
{
return(3 - CertificateDAL.getCertificateByReaderId(readerBLL.Code).Count);
}
return(3);
}
public bool checkBookBorrowMax(ReaderBLL readerBLL)
{
if (CertificateDAL.getCertificateByReaderId(readerBLL.Code) != null && CertificateDAL.getCertificateByReaderId(readerBLL.Code).Count >= 3)
{
return(false);
}
return(true);
}
public void Add(CertificateBLL certificate, List <Int32> listBook)
{
CertificateDAL.insert(certificate);
List <CertificateBLL> certificateList = CertificateDAL.getLastCertificateByReaderId(certificate.Iddocgia);
if (certificateList != null)
{
foreach (Int32 bookId in listBook)
{
BookBorrowDAL.Insert(bookId, certificateList[certificateList.Count - 1].Idphieumuon);
BookDAL.changeStatus(bookId);
}
}
}
private void LoadDataToGridView()
{
this.dgvCertificateStt.Rows.Clear();
CertificateBLL manageCertificateBLL = new CertificateBLL();
List <CertificateBLL> manageCertificateArr = new List <CertificateBLL>();
manageCertificateArr = CertificateDAL.getManageCertificateList();
//MessageBox.Show("ok");
foreach (CertificateBLL row in manageCertificateArr)
{
this.dgvCertificateStt.Rows.Add(row.Idphieumuon, row.Tentinhtrang, row.Ngaymuon, row.Hantra, row.Tendocgia, row.Lacnvc, row.Iddocgia);
}
this.GetSelectedValue();
this.dgvCertificateStt.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() == "Certificate")
{
catalog += "phieumuon.maphieumuon";
//MessageBox.Show(catalog);
}
else if (this.cboSearch.SelectedItem.ToString() == "Certificate Stt")
{
catalog += "tinhtrangphieumuon.tentinhtrang";
//MessageBox.Show(catalog);
}
CertificateBLL bookStatusBLL = new CertificateBLL();
List <CertificateBLL> certificateStatusArr = new List <CertificateBLL>();
certificateStatusArr = CertificateDAL.search(key, catalog);
this.dgvCertificateStt.Rows.Clear();
if (certificateStatusArr != null)
{
//MessageBox.Show("ok");
foreach (CertificateBLL row in certificateStatusArr)
{
this.dgvCertificateStt.Rows.Add(row.Idphieumuon, row.Tentinhtrang, row.Ngaymuon, row.Hantra, row.Tendocgia, row.Lacnvc, row.Iddocgia);
}
}
else
{
MessageBox.Show("Sorry! Can't find this certificate");
return;
}
this.GetSelectedValue();
this.dgvCertificateStt.SelectionChanged += new EventHandler(dgvCertificateStt_SelectionChanged);
}
private void GetSelectedValue()
{
if (this.dgvCertificateStt.SelectedCells.Count > 0 && this.dgvCertificateStt.CurrentRow.Index < this.dgvCertificateStt.Rows.Count - 1)
{
int selectedrowindex = this.dgvCertificateStt.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = this.dgvCertificateStt.Rows[selectedrowindex];
DateTime current = new DateTime();
DateTime endtime = new DateTime();
TimeSpan tg;
string name = Convert.ToString(selectedRow.Cells["clmnReaderName"].Value);
bool ob = Convert.ToBoolean(selectedRow.Cells["clmnObject"].Value);
string id = Convert.ToString(selectedRow.Cells["clmnReaderCode"].Value);
DateTime daystart = Convert.ToDateTime(selectedRow.Cells["clmnDayStart"].Value);
DateTime dayend = Convert.ToDateTime(selectedRow.Cells["clmnDayEnd"].Value);
current = DateTime.Now;
endtime = Convert.ToDateTime(selectedRow.Cells["clmnDayEnd"].Value);
tg = endtime - current;
this.txtReaderName.Text = name;
this.txtReaderCode.Text = id;
this.txtDayStart.Text = daystart.ToShortDateString();
this.txtDayEnd.Text = dayend.ToShortDateString();
if (ob)
{
this.txtObject.Text = "Cán Bộ Công Nhân Viên";
}
else
{
this.txtObject.Text = "Sinh Viên";
}
int songay = Convert.ToInt16(tg.Days);
if (songay < 0)
{
if (selectedRow.Cells["clmnStt"].Value.ToString() != "mới tạo")
{
this.txtOutOfDay.Text = "";
}
else
{
this.txtOutOfDay.Text = "trễ " + Math.Abs(songay) + " ngày";
}
}
/*if (id == "")
* {
* this.btnDelete.Enabled = false;
* this.btnSave.Enabled = false;
* }
* else
* {
* this.btnDelete.Enabled = true;
* this.btnSave.Enabled = true;
* }*/
if (this.dgvCertificateStt.SelectedCells.Count > 0 && this.dgvCertificateStt.CurrentRow.Index < this.dgvCertificateStt.Rows.Count - 1)
{
this.dgvDetailCertificate.Rows.Clear();
DetailCertificateBLL manageCertificateBLL = new DetailCertificateBLL();
List <DetailCertificateBLL> manageCertificateArr = new List <DetailCertificateBLL>();
manageCertificateArr = CertificateDAL.getDetailCertificateList(Convert.ToInt32(selectedRow.Cells["clmnId"].Value));
//MessageBox.Show("ok");
foreach (DetailCertificateBLL row in manageCertificateArr)
{
this.dgvDetailCertificate.Rows.Add(row.Masach, row.Tensach);
}
}
}
else
{
this.txtReaderName.Text = "";
this.txtReaderCode.Text = "";
this.txtDayStart.Text = "";
this.txtDayEnd.Text = "";
this.txtObject.Text = "";
this.txtOutOfDay.Text = "";
this.dgvDetailCertificate.Rows.Clear();
}
}
