private void btnSua_Click(object sender, RoutedEventArgs e)
{
if (tbTen.Text != "")
{
if (elementType == 1)
{
DTO.BoPhanDTO bp = new DTO.BoPhanDTO();
bp.MaBP = tbMa.Text;
bp.TenBP = tbTen.Text;
bp.TruongBP = cbTruong.SelectedValue.ToString();
BUS.NguoiDungBUS.SetIsUpdated(Login.Account);
BUS.BoPhanBUS.UpdateBoPhan(bp);
}
if (elementType == 2)
{
DTO.PhongBanDTO pb = new DTO.PhongBanDTO();
pb.MaPB = tbMa.Text;
pb.ViTri = tbViTri.Text;
pb.TenPB = tbTen.Text;
pb.TruongPB = cbTruong.SelectedValue.ToString();
BUS.NguoiDungBUS.SetIsUpdated(Login.Account);
BUS.PhongBanBUS.UpdatePhongBan(pb);
}
Refresh();
}
else
{
DialogWarning dgWar = new DialogWarning();
dgWar.Content = "Không được bỏ trống tên!";
dgWar.Acc = "false";
dialogHostWarning.DataContext = dgWar;
dialogHostWarning.IsOpen = true;
}
}
private void dialogHost_DialogClosing(object sender, DialogClosingEventArgs eventArgs)
{
if ((bool)eventArgs.Parameter == true)
{
if (status == "1")
{
if (dt.Rows.Count > 0)
{
BUS.NguoiDungBUS.SetIsUpdated(Login.Account);
BUS.NhanVienBUS.LayoffNhanVien(dt);
}
if (elementType == 1)
{
DTO.BoPhanDTO bp = new DTO.BoPhanDTO();
bp.MaBP = tbMa.Text;
bp.TenBP = tbTen.Text;
bp.TruongBP = cbTruong.SelectedValue.ToString();
BUS.NguoiDungBUS.SetIsUpdated(Login.Account);
BUS.BoPhanBUS.ShutdownBoPhan(bp);
}
if (elementType == 2)
{
DTO.PhongBanDTO pb = new DTO.PhongBanDTO();
pb.MaPB = tbMa.Text;
pb.ViTri = tbViTri.Text;
pb.TenPB = tbTen.Text;
pb.TruongPB = cbTruong.SelectedValue.ToString();
BUS.NguoiDungBUS.SetIsUpdated(Login.Account);
BUS.PhongBanBUS.ShutdownPhongBan(pb);
}
}
if (status == "2")
{
if (elementType == 1)
{
DTO.BoPhanDTO bp = new DTO.BoPhanDTO();
bp.MaBP = tbMa.Text;
bp.TenBP = tbTen.Text;
bp.TruongBP = cbTruong.SelectedValue.ToString();
BUS.NguoiDungBUS.SetIsUpdated(Login.Account);
BUS.BoPhanBUS.StartBoPhan(bp);
}
if (elementType == 2)
{
DTO.PhongBanDTO pb = new DTO.PhongBanDTO();
pb.MaPB = tbMa.Text;
pb.ViTri = tbViTri.Text;
pb.TenPB = tbTen.Text;
pb.TruongPB = cbTruong.SelectedValue.ToString();
BUS.NguoiDungBUS.SetIsUpdated(Login.Account);
BUS.PhongBanBUS.StartPhongBan(pb);
}
}
Refresh();
}
}
public static void StartBoPhan(DTO.BoPhanDTO bp)
{
string query = @"UPDATE BoPhan SET MaTT=1 Where MaBP = '" + bp.MaBP + "'";
DataProvider dataProvider = new DataProvider();
try
{
dataProvider.ExecuteUpdateQuery(query);
MessageBox.Show("Đã tái hoạt động bộ phận!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static void AddBoPhan(DTO.BoPhanDTO bp)
{
string query = @"INSERT INTO BoPhan (MaBP, TenBP, MaTT) VALUES( '" + bp.MaBP + "', N'" + bp.TenBP + "', 1); ";
DataProvider dataProvider = new DataProvider();
try
{
dataProvider.ExecuteUpdateQuery(query);
MessageBox.Show("Thêm bộ phận thành công!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static void UpdateBoPhan(DTO.BoPhanDTO bp)
{
string query = @"UPDATE BoPhan SET TenBP= N'" + bp.TenBP + "', TruongBP='" + bp.TruongBP + "' Where MaBP = '" + bp.MaBP + "'";
DataProvider dataProvider = new DataProvider();
try
{
dataProvider.ExecuteUpdateQuery(query);
MessageBox.Show("Update bộ phận thành công!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static void ShutdownBoPhan(DTO.BoPhanDTO bp)
{
string query = @"UPDATE BoPhan SET MaTT=2 Where MaBP = '" + bp.MaBP + "'";
string query2 = @"UPDATE PhongBan SET MaTT=2 Where MaBP = '" + bp.MaBP + "'";
DataProvider dataProvider = new DataProvider();
try
{
dataProvider.ExecuteUpdateQuery(query);
dataProvider.ExecuteUpdateQuery(query2);
MessageBox.Show("Đã ngừng hoạt động bộ phận!");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnThem_Click(object sender, RoutedEventArgs e)
{
if (tbTenNew.Text != "")
{
if (elementType == 0)
{
DTO.BoPhanDTO bp = new DTO.BoPhanDTO();
maLast = BUS.BoPhanBUS.GetLastBoPhan().Rows[0][0].ToString();
tbMaNew.Text = NextID(maLast, "BP");
bp.MaBP = tbMaNew.Text;
bp.TenBP = tbTenNew.Text;
BUS.NguoiDungBUS.SetIsUpdated(Login.Account);
BUS.BoPhanBUS.AddBoPhan(bp);
}
if (elementType == 1)
{
DTO.PhongBanDTO pb = new DTO.PhongBanDTO();
maLast = BUS.PhongBanBUS.GetLastPhongBan().Rows[0][0].ToString();
tbMaNew.Text = NextID(maLast, "PB");
pb.MaPB = tbMaNew.Text;
pb.TenPB = tbTenNew.Text;
pb.ViTri = tbViTriNew.Text;
pb.MaBP = maBP;
BUS.NguoiDungBUS.SetIsUpdated(Login.Account);
BUS.PhongBanBUS.AddPhongBan(pb);
}
Refresh();
}
else
{
DialogWarning dgWar = new DialogWarning();
dgWar.Content = "Không được bỏ trống tên!";
dgWar.Acc = "false";
dialogHostWarning.DataContext = dgWar;
dialogHostWarning.IsOpen = true;
}
}
public static void StartBoPhan(DTO.BoPhanDTO bp)
{
DAO.BoPhanDAO.StartBoPhan(bp);
}
public static void AddBoPhan(DTO.BoPhanDTO bp)
{
DAO.BoPhanDAO.AddBoPhan(bp);
}
public static void ShutdownBoPhan(DTO.BoPhanDTO bp)
{
DAO.BoPhanDAO.ShutdownBoPhan(bp);
}
public static void UpdateBoPhan(DTO.BoPhanDTO bp)
{
DAO.BoPhanDAO.UpdateBoPhan(bp);
}
public string DeleteBoPhan(DTO.BoPhanDTO boPhanDTO)
{
string sql = "Delete BoPhan where BoPhanID = '" + boPhanDTO.BoPhanID + "'";
return(sql);
}
public string LoadBoPhanFromNhanVienBoPhan(DTO.BoPhanDTO boPhanDTO)
{
string sql = "Select * from NhanVienBoPhan where BoPhanID = '" + boPhanDTO.BoPhanID + "'";
return(sql);
}
public string UpdateBoPhan(DTO.BoPhanDTO boPhanDTO)
{
string sql = "Update BoPhan set TenBoPhan =N'" + boPhanDTO.TenBoPhan + "' where BoPhanID ='" + boPhanDTO.BoPhanID + "'";
return(sql);
}
public string ThemBoPhan(DTO.BoPhanDTO boPhanDTO)
{
string sql = "Insert into BoPhan(TenBoPhan) values(N'" + boPhanDTO.TenBoPhan + "')";
return(sql);
}
