private void btnDelete_Click(object sender, EventArgs e)
{
if (this.dgvCertificateStt.SelectedCells.Count > 0)
{
int selectedrowindex = this.dgvCertificateStt.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = this.dgvCertificateStt.Rows[selectedrowindex];
AspectCertificateBLL certificateStatusBLL = new AspectCertificateBLL(Convert.ToInt32(selectedRow.Cells["clmnId"].Value), selectedRow.Cells["clmnName"].Value.ToString());
DialogResult result = MessageBox.Show("Do you want to delete certificate status: " + selectedRow.Cells["clmnName"].Value + "?", "Warning", MessageBoxButtons.OKCancel);
switch (result)
{
case DialogResult.Cancel:
break;
case DialogResult.OK:
if (AspectCertificateDAL.getCertificateStatusItem(certificateStatusBLL.CertificateId) != null)
{
MessageBox.Show("Can't delete! Please delete all book has status " + selectedRow.Cells["clmnName"].Value + " before delete this status!", "Error");
break;
}
else
{
AspectCertificateDAL.deleteCertificateStatus(certificateStatusBLL);
MessageBox.Show("Delete complete!", "Success");
this.LoadDataToGridView();
break;
}
}
}
}
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 = "";
if (this.cboSearchCertificate.SelectedItem.ToString() == "Name")
{
catalog = "tentinhtrang";
}
AspectCertificateBLL certificateStatusBLL = new AspectCertificateBLL();
List <AspectCertificateBLL> certificateStatusArr = new List <AspectCertificateBLL>();
certificateStatusArr = AspectCertificateDAL.searchCertificate(catalog, key);
this.dgvCertificateStt.Rows.Clear();
if (certificateStatusArr.Count != null)
{
foreach (AspectCertificateBLL row in certificateStatusArr)
{
this.dgvCertificateStt.Rows.Add(row.CertificateId, row.Name);
}
}
this.GetSelectedValue();
this.dgvCertificateStt.CellClick += new DataGridViewCellEventHandler(this.dgvCertificateStt_CellClick);
}
private void LoadDataToGridView()
{
this.dgvCertificateStt.Rows.Clear();
AspectCertificateBLL aspectCertificateBLL = new AspectCertificateBLL();
List <AspectCertificateBLL> aspectCertificateList = new List <AspectCertificateBLL>();
aspectCertificateList = AspectCertificateDAL.getCertifivateId();
foreach (AspectCertificateBLL row in aspectCertificateList)
{
this.dgvCertificateStt.Rows.Add(row.CertificateId, row.Name);
}
this.GetSelectedValue();
this.dgvCertificateStt.CellClick += new DataGridViewCellEventHandler(dgvCertificateStt_CellClick);
}
private void btnAdd_Click(object sender, EventArgs e)
{
AspectCertificateBLL certificateStatusBLL = new AspectCertificateBLL();
certificateStatusBLL.Name = this.txtCertificateStt.Text;
if (certificateStatusBLL.Name == "")
{
MessageBox.Show("Certificate status name is not null!", "Notice");
return;
}
AspectCertificateDAL.addCertificateStatus(certificateStatusBLL);
MessageBox.Show("Add success!", "Success");
this.LoadDataToGridView();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (this.dgvCertificateStt.SelectedCells.Count > 0)
{
int selectedrowindex = this.dgvCertificateStt.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = this.dgvCertificateStt.Rows[selectedrowindex];
AspectCertificateBLL certificateStatusBLL = new AspectCertificateBLL(Convert.ToInt32(selectedRow.Cells["clmnId"].Value), this.txtCertificateStt.Text);
if (certificateStatusBLL.Name == "")
{
MessageBox.Show("Certificate status name is not null!", "Notice");
return;
}
AspectCertificateDAL.updateCertificateStatus(certificateStatusBLL);
MessageBox.Show("Update success!", "Success");
this.LoadDataToGridView();
}
}
