public bool XoaCC(ChamCongNV ccnv)
{
string[] param = { "@MaNV", "@TenNV", "@CaLam", "@Ngay", "@SoGioLam" };
object[] values = { ccnv.MaNV, ccnv.TenNV, ccnv.CaLam, ccnv.NgayLam, ccnv.SoGioLam };
string query = "Delete from tblChamCongNV where MaNV=@MaNV and TenNV=@TenNV and CaLam=@CaLam and Ngay=@Ngay";
return(db.ExecuteNonQueryPara(query, param, values));
}
public bool SuaCC(ChamCongNV ccnv)
{
string[] param = { "@MaNV", "@CaLam", "@Ngay", "@SoGioLam" };
object[] values = { ccnv.MaNV, ccnv.CaLam, ccnv.NgayLam, ccnv.SoGioLam };
string query = "Update tblChamCongNV set SoGioLam=@SoGioLam where MaNV=@MaNV and CaLam=@CaLam and Ngay=@Ngay";
return(db.ExecuteNonQueryPara(query, param, values));
}
public bool ThemCC(ChamCongNV ccnv)
{
string[] param = { "@MaNV", "@TenNV", "@CaLam", "@Ngay", "@SoGioLam" };
object[] values = { ccnv.MaNV, ccnv.TenNV, ccnv.CaLam, ccnv.NgayLam, ccnv.SoGioLam };
string query = "Insert into tblChamCongNV(MaNV,TenNV,CaLam,Ngay,SoGioLam) values (@MaNV,@TenNV,@CaLam,@Ngay,@SoGioLam)";
return(db.ExecuteNonQueryPara(query, param, values));
}
public bool XoaCC(ChamCongNV ccnv)
{
return(dalcc.XoaCC(ccnv));
}
public bool SuaCC(ChamCongNV ccnv)
{
return(dalcc.SuaCC(ccnv));
}
public bool ThemCC(ChamCongNV ccnv)
{
return(dalcc.ThemCC(ccnv));
}
