public static bool Insert(SuKien_DieuPhoi dto) { try { VNSCDataContext VNSC = SQL_Connection.CreateSQlConnection(); VNSC.SuKien_DieuPhois.InsertOnSubmit(dto); VNSC.SubmitChanges(); return true; } catch (System.Exception ex) { return false; } }
private void pbXoa_DP_Click(object sender, EventArgs e) { pbXoa_DP.Focus(); frm_Confirm = new Form_Confirm("Đồng ý xóa " + lvThongTin_DP.SelectedItems.Count + " dữ liệu?"); if (frm_Confirm.Yes) { for (int i = 0; i < lvThongTin_DP.SelectedItems.Count; i++) { if (SuKien_DieuPhoi_BUS.Delete(iMaSuKien, int.Parse(lvThongTin_DP.SelectedItems[i].SubItems[0].Text))) { if (!DieuPhoi_BUS.Delete(int.Parse(lvThongTin_DP.SelectedItems[i].SubItems[0].Text))) { SuKien_DieuPhoi dto_Temp = new SuKien_DieuPhoi(); dto_Temp.MaSuKien = iMaSuKien; dto_Temp.MaDieuPhoi = int.Parse(lvThongTin_DP.SelectedItems[i].SubItems[0].Text); SuKien_DieuPhoi_BUS.Insert(dto_Temp); frm_Notice = new Form_Notice("Không thể xóa Hồ Sơ " + lvThongTin_DP.SelectedItems[i].SubItems[0].Text + "!", false); break; } } else { frm_Notice = new Form_Notice("Không thể xóa Hồ Sơ " + lvThongTin_DP.SelectedItems[i].SubItems[0].Text + "!", false); break; } } refreshListView_DP(list_DonViHanhChanh[cbDonViHanhChanh.SelectedIndex], list_TrachVuSuKien[cbTrachVuSuKien.SelectedIndex]); } }
private void pbTransfer_Click(object sender, EventArgs e) { if (lvThongTin_HSTD.Focused) { for (int i = 0; i < lvThongTin_HSTD.SelectedItems.Count; i++) { if (!KiemTraHoThamDuBiTrungHoSoDieuPhoi(lvThongTin_HSTD.SelectedItems[i].SubItems[0].Text)) { DieuPhoi dto_DP = new DieuPhoi(); dto_DP.MaDonViHanhChanh = list_DonViHanhChanh[cbDonViHanhChanh.SelectedIndex]; dto_DP.MaTrachVuSuKien = list_TrachVuSuKien[cbTrachVuSuKien.SelectedIndex]; dto_DP.MaSuKien_HoSo = lvThongTin_HSTD.SelectedItems[i].SubItems[0].Text; if (DieuPhoi_BUS.Insert(dto_DP)) { SuKien_DieuPhoi dto_Temp = new SuKien_DieuPhoi(); dto_Temp.MaSuKien = iMaSuKien; dto_Temp.MaDieuPhoi = dto_DP.Ma; if (SuKien_DieuPhoi_BUS.Insert(dto_Temp)) { cbTrachVuSuKien_SelectedIndexChanged(sender, e); } else { Form_Notice frm = new Form_Notice("Không thể tạo Hồ sơ điều phối!", false); } } else { Form_Notice frm = new Form_Notice("Không thể tạo Hồ sơ điều phối!", false); } } } } }
public static bool Insert(SuKien_DieuPhoi dto) { return SuKien_DieuPhoi_DAO.Insert(dto); }
partial void DeleteSuKien_DieuPhoi(SuKien_DieuPhoi instance);
partial void UpdateSuKien_DieuPhoi(SuKien_DieuPhoi instance);
partial void InsertSuKien_DieuPhoi(SuKien_DieuPhoi instance);
private void detach_SuKien_DieuPhois(SuKien_DieuPhoi entity) { this.SendPropertyChanging(); entity.DieuPhoi = null; }
private void attach_SuKien_DieuPhois(SuKien_DieuPhoi entity) { this.SendPropertyChanging(); entity.SuKien = this; }
public static bool UpdateSuKien_DieuPhoiInfo(SuKien_DieuPhoi dto) { //try //{ // VNSCDataContext VNSC = SQL_Connection.CreateSQlConnection(); // SuKien_DieuPhoi sk = VNSC.SuKien_DieuPhois.Single(P => P.Ma == dto.Ma); // sk.MaNhomTrachVu = dto.MaNhomTrachVu; // //sk.Ten = dto.Ten; // //sk.MoTa = dto.MoTa; // VNSC.SubmitChanges(); // return true; //} //catch (System.Exception ex) //{ // return false; //} return false; //Khong co update }
private bool DeleteSuKien_HoSo(string sMa) { List<DieuPhoi> list_DP = DieuPhoi_BUS.TraCuuDSDieuPhoiTheoMaSuKien_HoSo(iMaSuKien, sMa); if (list_DP.Count > 0) { frm_Notice = new Form_Notice("Hồ sơ này vẫn còn giữ TVSK", "Tiếp tục xóa?", true); if (frm_Notice.Yes) { // } else { return true; } } for (int i = 0; i < list_DP.Count; i++) { if (SuKien_DieuPhoi_BUS.Delete(iMaSuKien, list_DP[i].Ma)) { if (!DieuPhoi_BUS.Delete(list_DP[i].Ma)) { SuKien_DieuPhoi dto_Temp = new SuKien_DieuPhoi(); dto_Temp.MaSuKien = iMaSuKien; dto_Temp.MaDieuPhoi = list_DP[i].Ma; SuKien_DieuPhoi_BUS.Insert(dto_Temp); frm_Notice = new Form_Notice("Lỗi Điều phối!", "Không thể xóa Hồ Sơ " + list_DP[i].Ma + "!", false); return false; } } else { frm_Notice = new Form_Notice("Lỗi Điều phối!", "Không thể xóa Hồ Sơ " + list_DP[i].Ma + "!", false); return false; } } List<SuKien_HoSo_HuanLuyen> list_SuKien_HoSo_HuanLuyen = SuKien_HoSo_HuanLuyen_BUS.TraCuuDSSuKien_HuanLuyenTheoMaSuKien_HoSo(sMa); foreach (SuKien_HoSo_HuanLuyen dto_Temp in list_SuKien_HoSo_HuanLuyen) { int iTemp = dto_Temp.MaSuKien_HuanLuyen; if (!SuKien_HoSo_HuanLuyen_BUS.Delete(dto_Temp.MaSuKien_HoSo, dto_Temp.MaSuKien_HuanLuyen)) { return false; } if (!SuKien_HuanLuyen_BUS.Delete(iTemp)) { return false; } } string sPath = ""; sPath = Path.Combine(File_Function.getFinalFolder(list_FolderAvatar), setAvatarPath(sMa, SuKien_HoSo_BUS.TraCuuSuKien_HoSoTheoMa(sMa).NgayCapNhat)); if (File.Exists(sPath)) { File.Delete(sPath); } if (!SuKien_HoSoThamDu_BUS.Delete(iMaSuKien, sMa)) { return false; } if (!SuKien_HoSo_BUS.Delete(sMa)) { return false; } return true; }