public void CloseRRF(RRFListBOL objRRFListBOL)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@RRFId", SqlDbType.Int);
param[0].Value = objRRFListBOL.RRFID;
SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_CloseRRF", param);
}
public DataSet CheckOfferIssedToAnyCandidate(RRFListBOL objRRFListBOL)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@RRFId", SqlDbType.Int);
param[0].Value = objRRFListBOL.RRFID;
return(OfferIssedToAnyCandidate = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_CheckOfferissedtoAnyCandidate", param));
//return OfferIssedToAnyCandidate = Convert.ToInt32(SqlHelper.ExecuteScalar(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_CheckOfferissedtoAnyCandidate", param));
}
//int countOfOfferIssedToAnyCandidate = 0;
public DataSet GetRRFForList(RRFListBOL objRRFListBOL)
{
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@UserId", SqlDbType.Int);
param[0].Value = objRRFListBOL.UserID;
param[1] = new SqlParameter("@RoleType", SqlDbType.VarChar);
param[1].Value = objRRFListBOL.RoleType;
return(dsGetRRFForList = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_GetRRFList", param));
}
public void UdateRRFValuesToApprove(RRFListBOL objRRFListBOL)
{
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@RRFID", SqlDbType.Int);
param[0].Value = objRRFListBOL.RRFID;
param[1] = new SqlParameter("@Comments", SqlDbType.VarChar);
param[1].Value = DBNull.Value;
param[2] = new SqlParameter("@RRFStatus", SqlDbType.Int);
param[2].Value = objRRFListBOL.RRFStatus;
param[3] = new SqlParameter("@ApprovalStatus", SqlDbType.Int);
param[3].Value = objRRFListBOL.ApprovalStatus;
param[4] = new SqlParameter("@ModifiedBy", SqlDbType.Int);
param[4].Value = objRRFListBOL.UserID;
param[5] = new SqlParameter("@ModifiedDate", SqlDbType.DateTime);
param[5].Value = objRRFListBOL.ModifiedDate;
SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_UdateRRFValuesToApprove", param);
}
public DataSet SearchRRFNoData(RRFListBOL objRRfListBOL)
{
return(dsGetRRFForList = objRRFListDAL.SearchRRFNoData(objRRfListBOL));
}
public void UdateRRFValuesToApprove(RRFListBOL objRRFListBOL)
{
objRRFListDAL.UdateRRFValuesToApprove(objRRFListBOL);
}
public DataSet CheckOfferIssedToAnyCandidate(RRFListBOL objRRFListBOL)
{
return(OfferIssedToAnyCandidate = objRRFListDAL.CheckOfferIssedToAnyCandidate(objRRFListBOL));
}
public void CloseRRF(RRFListBOL objRRFListBOL)
{
objRRFListDAL.CloseRRF(objRRFListBOL);
}
public DataSet GetRRFForList(RRFListBOL objRRFListBOL)
{
return(dsGetRRFForList = objRRFListDAL.GetRRFForList(objRRFListBOL));
}
