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();
}
}
public static List <AspectCertificateBLL> searchCertificate(string key, string value)
{
string sql = "SELECT * FROM [tinhtrangphieumuon] WHERE " + key + " LIKE N'%" + value + "%'";
DataTable dt = AspectCertificateDAL._condb.getDataTable(sql);
List <AspectCertificateBLL> certificateStatusBLLList = new List <AspectCertificateBLL>();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
AspectCertificateBLL bookStatusBLL = new AspectCertificateBLL(Int32.Parse(row["idtinhtrang"].ToString()), row["tentinhtrang"].ToString());
certificateStatusBLLList.Add(bookStatusBLL);
}
return(certificateStatusBLLList);
}
else
{
return(null);
}
}
public static List <AspectCertificateBLL> getCertifivateId()
{
String sql = "SELECT * FROM [tinhtrangphieumuon]";
DataTable dt = AspectCertificateDAL._condb.getDataTable(sql);
List <AspectCertificateBLL> aspectCertificateList = new List <AspectCertificateBLL>();
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
AspectCertificateBLL aspectCertificateBLL = new AspectCertificateBLL(Int32.Parse(row["idtinhtrang"].ToString()), row["tentinhtrang"].ToString());
aspectCertificateList.Add(aspectCertificateBLL);
}
return(aspectCertificateList);
}
else
{
return(null);
}
}
public static void updateCertificateStatus(AspectCertificateBLL certificateStatusBLL)
{
String sql = "UPDATE [tinhtrangphieumuon] SET tentinhtrang=N'" + certificateStatusBLL.Name + "' WHERE idtinhtrang=" + certificateStatusBLL.CertificateId;
AspectCertificateDAL._condb.ExecuteNonQuery(sql);
}
/*public static AspectCertificateBLL getCertificateStatusItem(int certificateStatusId)
* {
* String sql = "SELECT * FROM [tinhtrangphieumuon] WHERE idtinhtrang=" + certificateStatusId;
* DataTable dt = AspectCertificateDAL._condb.getDataTable(sql);
* if (dt.Rows.Count > 0)
* {
* DataRow row = dt.Rows[0];
* return new AspectCertificateBLL(Int32.Parse(row["idtinhtrang"].ToString()), row["tentinhtrang"].ToString());
* }
* return null;
* }*/
public static void addCertificateStatus(AspectCertificateBLL certificateStatusBLL)
{
String sql = "INSERT INTO [tinhtrangphieumuon] (tentinhtrang) VALUES ( N'" + certificateStatusBLL.Name + "')";
AspectCertificateDAL._condb.ExecuteNonQuery(sql);
}
public static void deleteCertificateStatus(AspectCertificateBLL certificateStatusBLL)
{
String sql = "DELETE FROM [tinhtrangphieumuon] WHERE idtinhtrang=" + certificateStatusBLL.CertificateId;
AspectCertificateDAL._condb.ExecuteNonQuery(sql);
}
