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;
}