public static bool InsertPhanCong(PhanCongDTO phancong) { bool result = false; try { //create a list parameter List <MySqlParameter> parameters = new List <MySqlParameter>(); //parameters.Add(new MySqlParameter("@MaTK", taikhoan.MaTK)); parameters.Add(new MySqlParameter("@MaPC", phancong.MaPC)); parameters.Add(new MySqlParameter("@ThoiGian", phancong.ThoiGian)); parameters.Add(new MySqlParameter("@GhiChu", phancong.GhiChu)); parameters.Add(new MySqlParameter("@FK_MaCV", phancong.MaCV)); parameters.Add(new MySqlParameter("@FK_MaNV", phancong.MaNV)); parameters.Add(new MySqlParameter("@FK_MaDV", phancong.MaDV)); //call store Procedure int n = MySqlDataAccessHelper.ExecuteNonQuery("INSERT INTO phancong (MaPC, NgayPC, GhiChu, MaCV, MaNV, MaDV) VALUES(@MaPC, @ThoiGian, @GhiChu, @FK_MaCV, @FK_MaNV, @FK_MaDV)", parameters); if (n == 1) { result = true; } } catch (Exception ex) { throw ex; } return(result); }
public int MsBanGet([PexAssumeUnderTest] PhanCongDTO target) { int result = target.MsBan; return(result); // TODO: add assertions to method PhanCongDTOTest.MsBanGet(PhanCongDTO) }
public PhanCongDTO Constructor02(PhanCongDTO pc) { PhanCongDTO target = new PhanCongDTO(pc); return(target); // TODO: add assertions to method PhanCongDTOTest.Constructor02(PhanCongDTO) }
public static bool XoaPhanCong(PhanCongDTO pc) { bool kq; string sql = string.Format("delete PhanCong where Ca = {0} and MaNV = {1} and MaSoBan = {2}", pc.Ca, pc.MsNV, pc.MsBan); kq = SqlDataAccessHelper.ExecuteNonQuery(sql); return(kq); }
public static bool ThemPhanCong(PhanCongDTO pc) { bool kq; string sql = string.Format("insert into PhanCong values({0}, {1}, {2})", pc.Ca, pc.MsNV, pc.MsBan); kq = SqlDataAccessHelper.ExecuteNonQuery(sql); return(kq); }
public void CaSet733() { PhanCongDTO s0 = new PhanCongDTO(0, 0, 0); this.CaSet(s0, 0); Assert.IsNotNull((object)s0); Assert.AreEqual <int>(0, s0.MsNV); Assert.AreEqual <int>(0, s0.Ca); Assert.AreEqual <int>(0, s0.MsBan); }
public void Constructor0221() { PhanCongDTO phanCongDTO; PhanCongDTO s0 = new PhanCongDTO(0, 0, 0); phanCongDTO = this.Constructor02(s0); Assert.IsNotNull((object)phanCongDTO); Assert.AreEqual <int>(0, phanCongDTO.MsNV); Assert.AreEqual <int>(0, phanCongDTO.Ca); Assert.AreEqual <int>(0, phanCongDTO.MsBan); }
public PhanCongDTO Constructor01( int msNV, int msBan, int ca ) { PhanCongDTO target = new PhanCongDTO(msNV, msBan, ca); return(target); // TODO: add assertions to method PhanCongDTOTest.Constructor01(Int32, Int32, Int32) }
public void MsBanGet762() { int i; PhanCongDTO s0 = new PhanCongDTO(0, 0, 0); i = this.MsBanGet(s0); Assert.AreEqual <int>(0, i); Assert.IsNotNull((object)s0); Assert.AreEqual <int>(0, s0.MsNV); Assert.AreEqual <int>(0, s0.Ca); Assert.AreEqual <int>(0, s0.MsBan); }
public List <PhanCongDTO> SearchPHANCONG(string str) { List <PhanCongDTO> list = new List <PhanCongDTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("EXEC USP_PHANCONG_SEARCH @SEARCHVALUE ", new object[] { str }); foreach (DataRow item in data.Rows) { PhanCongDTO da = new PhanCongDTO(item); list.Add(da); } return(list); }
public List <PhanCongDTO> GetPHANCONG() { List <PhanCongDTO> list = new List <PhanCongDTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("dbo.USP_GetPHANCONG"); foreach (DataRow item in data.Rows) { PhanCongDTO da = new PhanCongDTO(item); list.Add(da); } return(list); }
public bool InsertPhanCong() { //List<PhanCongDTO> listPhanCong = new List<PhanCongDTO>(); foreach (DataGridViewRow row in congViecdataGridView.Rows) { if (bool.Parse(row.Cells["Chọn"].Value.ToString()) == true) { PhanCongDTO phancong = new PhanCongDTO(); phancong.MaPC = BUS.PhanCongBUS.GenerateMaPhanCong(); phancong.MaDV = txtMaDV.Text; phancong.MaNV = BUS.NhanVienBUS.SelectNhanVienByTenNhanVien(row.Cells["Nhân viên"].Value.ToString())[0].MaNV; phancong.MaCV = (row.Cells["Công việc"].Value.ToString()); phancong.ThoiGian = dtbNgayLapHD.Value; phancong.GhiChu = row.Cells["Ghi Chú"].Value.ToString(); if (!BUS.PhanCongBUS.InsertPhanCong(phancong)) { return(false); } ; } else { ChiTietBaoDuongDTO chiTiet = new ChiTietBaoDuongDTO { MaCTBD = BUS.ChiTietBaoDuongBUS.GenerateMaChiTietBaoDuong(), MaPT = null, SoLuong = 0, DonGia = 0, Phi = 0, TrangThai = false, MaHD = null, MaCV = row.Cells["Mã CV"].Value.ToString(), MaDV = txtMaDV.Text }; } } return(true); }
private void btnLuuVaoDS_Click(object sender, EventArgs e) { if (cmbNamHoc.SelectedValue == null || cmbLop.SelectedValue == null || cmbMonHoc.SelectedValue == null || cmbGiaoVien.SelectedValue == null) { MessageBox.Show( "Giá trị của các ô không được rỗng !", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error ); } else { PhanCongDTO phanCong = new PhanCongDTO( cmbNamHoc.SelectedValue.ToString(), cmbLop.SelectedValue.ToString(), cmbMonHoc.SelectedValue.ToString(), cmbGiaoVien.SelectedValue.ToString() ); PhanCongBUS.Instance.ThemPhanCong(phanCong); bindingNavigatorRefreshItem_Click(sender, e); } }
public static bool XoaPhanCong(PhanCongDTO pc) { bool kq = PhanCongDAO.XoaPhanCong(pc); return(kq); }
public static bool ThemPhanCong(PhanCongDTO pc) { bool kq = PhanCongDAO.ThemPhanCong(pc); return(kq); }
public void MsBanSet([PexAssumeUnderTest] PhanCongDTO target, int value) { target.MsBan = value; // TODO: add assertions to method PhanCongDTOTest.MsBanSet(PhanCongDTO, Int32) }
public static bool InsertPhanCong(PhanCongDTO phancong) { return(DAO.PhanCongDAO.InsertPhanCong(phancong)); }