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 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(); }
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; } }
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(); } }
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 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); }
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 void deleteCertificateStatus(AspectCertificateBLL certificateStatusBLL) { String sql = "DELETE FROM [tinhtrangphieumuon] 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 updateCertificateStatus(AspectCertificateBLL certificateStatusBLL) { String sql = "UPDATE [tinhtrangphieumuon] SET tentinhtrang=N'" + certificateStatusBLL.Name + "' WHERE idtinhtrang=" + certificateStatusBLL.CertificateId; AspectCertificateDAL._condb.ExecuteNonQuery(sql); }