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