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