protected void btnDelete_Click(object sender, DirectEventArgs e) { try { string sql = "Delete from " + TableForDeleting + " where " + IDProperty + " in ("; string id = ""; foreach (var item in RowSelectionModel1.SelectedRows) { id += "'" + item.RecordID + "',"; } DataHandler.GetInstance().ExecuteNonQuery(sql + id + "'-1')"); GridPanel1.Reload(); btnDelete.Disabled = true; btnEdit.Disabled = true; RowSelectionModel1.ClearSelections(); } catch (Exception ex) { if (ex.Message.Contains("REFERENCE constraint")) { X.MessageBox.Alert("Có lỗi xảy ra", "Không thể xóa được vì dữ liệu này đang được sử dụng ở chỗ khác !").Show(); } else { X.MessageBox.Alert("Có lỗi xảy ra", ex.Message).Show(); } } }
protected void btnAddSubjectList_Click(object sender, DirectEventArgs e) { try { CacMonThiTuyenController control = new CacMonThiTuyenController(); DAL.CacMonThiTuyen mt = new CacMonThiTuyen(); mt.Vong = int.Parse("0" + txt_Vong.Text); mt.TrongSo = decimal.Parse("0" + txt_TrongSo.Text); mt.PlanID = int.Parse("0" + hdfRecordID.Text); mt.GhiChu = txt_GhiChuMonThi.Text; mt.MaMonThi = int.Parse("0" + hdfMaMonThi.Text); mt.DiemDat = double.Parse("0" + txt_DiemDat.Text); mt.NguoiChamThi = int.Parse("0" + hdfNguoiChamThi.Text); var dt = DataController.DataHandler.GetInstance().ExecuteDataTable("SELECT * FROM TuyenDung.HoiDongTuyenDung hdtd WHERE hdtd.PrKeyHoSo = " + decimal.Parse("0" + hdfNguoiChamThi.Text) + "AND hdtd.PlanID = " + int.Parse("0" + hdfRecordID.Text)); if (dt.Rows.Count == 0) { HoiDongTuyenDungController ctrol = new HoiDongTuyenDungController(); DAL.HoiDongTuyenDung hd = new HoiDongTuyenDung(); hd.CreatedBy = CurrentUser.ID; hd.CreatedDate = DateTime.Now; hd.PlanID = int.Parse("0" + hdfRecordID.Text); hd.PrKeyHoSo = decimal.Parse("0" + hdfNguoiChamThi.Text); hd.VongThi = int.Parse("0" + txt_Vong.Text); ctrol.Insert(hd); grpCouncilRecruitment.Reload(); RowSelectionModel1.ClearSelections(); btnDeleteCouncilRecruitment.Disabled = true; btnEditCouncilRecruitment.Disabled = true; } if (e.ExtraParams["type"] == "edit") { mt.ID = int.Parse("0" + hdfCacMonThiTuyen.Text); control.Update(mt); wdMonThi.Hide(); } else { control.Insert(mt); if (e.ExtraParams["Close"] == "True") { wdMonThi.Hide(); } } gpCacMonThiTuyen.Reload(); RM.RegisterClientScriptBlock("resetWdMonThi", "resetWdMonThi();"); } catch (Exception ex) { Dialog.ShowError("Lỗi xảy ra " + ex.Message); } }
protected void DeleteLog(object sender, DirectEventArgs e) { try { if (!int.TryParse(hdfKeyRecordLog.Text, out var id) || id <= 0) { return; } SchedulerLogServices.Delete(id); PagingToolbar1.PageIndex = 0; RowSelectionModel1.ClearSelections(); btnDelete.Disabled = true; btnEdit.Disabled = true; gridSchedulerLog.Reload(); } catch (Exception ex) { Dialog.Alert("Có lỗi xảy ra trong quá trình xóa: {0}".FormatWith(ex.Message)); } }