public DataSet GetEmployeeFromRole(RRFApproverBOL objRRFApproverBOL)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@Role", SqlDbType.VarChar);
param[0].Value = objRRFApproverBOL.Role;
return(dsGetEmployeeFromRole = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_GetEmployeeFromRole", param));
}
public void CancelRRF(RRFApproverBOL objRRFApproverBOL)
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@RRFId", SqlDbType.Int);
param[0].Value = objRRFApproverBOL.RRFID;
SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_CancelRRF", param);
}
public void UdateRRFValuesToApprove(RRFApproverBOL objRRFApproverBOL)
{
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@RRFID", SqlDbType.Int);
param[0].Value = objRRFApproverBOL.RRFID;
param[1] = new SqlParameter("@Comments", SqlDbType.VarChar);
param[1].Value = objRRFApproverBOL.Comments;
param[2] = new SqlParameter("@RRFStatus", SqlDbType.Int);
param[2].Value = objRRFApproverBOL.RRFStatus;
param[3] = new SqlParameter("@ApprovalStatus", SqlDbType.Int);
param[3].Value = objRRFApproverBOL.ApprovalStatus;
param[4] = new SqlParameter("@ModifiedBy", SqlDbType.Int);
param[4].Value = objRRFApproverBOL.ModifiedBy;
param[5] = new SqlParameter("@ModifiedDate", SqlDbType.DateTime);
param[5].Value = objRRFApproverBOL.ModifiedDate;
SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_UdateRRFValuesToApprove", param);
}
public DataSet GetResourcePool(RRFApproverBOL objRRFApproverBOL)
{
return(dsGetResourcePool = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_GetResourcePool"));
}
public DataSet GetDeliveryUnit(RRFApproverBOL objRRFApproverBOL)
{
return(dsGetDeliveryUnit = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_GetDeliveryUnit"));
}
public void UpdateRRFForResend(RRFApproverBOL objRRFApproverBOL)
{
SqlParameter[] param = new SqlParameter[21];
param[0] = new SqlParameter("@RequestDate", SqlDbType.DateTime);
param[0].Value = objRRFApproverBOL.RequestDate;
param[1] = new SqlParameter("@ExpectedClosureDate", SqlDbType.DateTime);
param[1].Value = objRRFApproverBOL.ExpectedClosureDate;
param[2] = new SqlParameter("@RRFForDU", SqlDbType.Int);
param[2].Value = objRRFApproverBOL.RRFForDU;
param[3] = new SqlParameter("@RRFForDT", SqlDbType.Int);
param[3].Value = objRRFApproverBOL.RRFForDT;
param[4] = new SqlParameter("@ProjectName", SqlDbType.VarChar);
param[4].Value = objRRFApproverBOL.ProjectName;
param[5] = new SqlParameter("@Designation", SqlDbType.Int);
param[5].Value = objRRFApproverBOL.Designation;
param[6] = new SqlParameter("@IndicativePanel1", SqlDbType.Int);
param[6].Value = objRRFApproverBOL.IndicativePanel1;
param[7] = new SqlParameter("@IndicativePanel2", SqlDbType.Int);
param[7].Value = objRRFApproverBOL.IndicativePanel2;
param[8] = new SqlParameter("@IndicativePanel3", SqlDbType.Int);
param[8].Value = objRRFApproverBOL.IndicativePanel3;
param[9] = new SqlParameter("@ResourcePool", SqlDbType.Int);
param[9].Value = objRRFApproverBOL.ResourcePool;
param[10] = new SqlParameter("@PositionsRequired", SqlDbType.Int);
param[10].Value = objRRFApproverBOL.PositionsRequired;
param[11] = new SqlParameter("@EmployeementType", SqlDbType.Int);
param[11].Value = objRRFApproverBOL.EmployeementType;
param[12] = new SqlParameter("@IsReplacement", SqlDbType.Bit);
param[12].Value = objRRFApproverBOL.IsReplacement;
param[13] = new SqlParameter("@ReplacementFor", SqlDbType.Int);
param[13].Value = objRRFApproverBOL.ReplacementFor;
param[14] = new SqlParameter("@KeySkills", SqlDbType.VarChar);
param[14].Value = objRRFApproverBOL.KeySkills;
param[15] = new SqlParameter("@Experience", SqlDbType.Int);
param[15].Value = objRRFApproverBOL.Experience;
param[16] = new SqlParameter("@BusinessJustification", SqlDbType.VarChar);
param[16].Value = objRRFApproverBOL.BusinessJustification;
param[17] = new SqlParameter("@AdditionalInfo", SqlDbType.VarChar);
param[17].Value = objRRFApproverBOL.AdditionalInfo;
param[18] = new SqlParameter("@RRFID", SqlDbType.Int);
param[18].Value = objRRFApproverBOL.RRFID;
param[19] = new SqlParameter("@ModifiedDate", SqlDbType.DateTime);
param[19].Value = objRRFApproverBOL.RequestDate;
param[20] = new SqlParameter("@IsBillable", SqlDbType.Bit);
param[20].Value = objRRFApproverBOL.IsBillable;
SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_UpdateRRFForResend", param);
}
public DataSet GetSkillsForSLA(RRFApproverBOL objRRFApproverBOL)
{
dsSLAForTechnology = objRRFApproverDAL.GetSkillsForSLA(objRRFApproverBOL);
return(dsSLAForTechnology);
}
public DataSet GetEmployeeFromRole(RRFApproverBOL objRRFApproverBOL)
{
dsGetEmployeeFromRole = objRRFApproverDAL.GetEmployeeFromRole(objRRFApproverBOL);
return(dsGetEmployeeFromRole);
}
public void AddRRF(RRFApproverBOL objRRFApproverBOL)
{
objRRFApproverDAL.AddRRF(objRRFApproverBOL);
}
public DataSet GetEmploymentType(RRFApproverBOL objRRFApproverBOL)
{
dsGetEmploymentType = objRRFApproverDAL.GetEmploymentType(objRRFApproverBOL);
return(dsGetEmploymentType);
}
public DataSet GetResourcePool(RRFApproverBOL objRRFApproverBOL)
{
dsGetResourcePool = objRRFApproverDAL.GetResourcePool(objRRFApproverBOL);
return(dsGetResourcePool);
}
public DataSet GetDesignation(RRFApproverBOL objRRFApproverBOL)
{
dsGetDesignation = objRRFApproverDAL.GetDesignation(objRRFApproverBOL);
return(dsGetDesignation);
}
public DataSet GetDeliveryUnit(RRFApproverBOL objRRFApproverBOL)
{
dsGetDeliveryUnit = objRRFApproverDAL.GetDeliveryUnit(objRRFApproverBOL);
return(dsGetDeliveryUnit);
}
public DataSet GetRRFValuesToApprove(RRFApproverBOL objRRFApproverBOL)
{
dsGetRRFValuesToApprove = objRRFApproverDAL.GetRRFValuesToApprove(objRRFApproverBOL);
return(dsGetRRFValuesToApprove);
}
public void UdateRRFValuesToApprove(RRFApproverBOL objRRFApproverBOL)
{
objRRFApproverDAL.UdateRRFValuesToApprove(objRRFApproverBOL);
}
public void UpdateRRFForResend(RRFApproverBOL objRRFApproverBOL)
{
objRRFApproverDAL.UpdateRRFForResend(objRRFApproverBOL);
}
public DataSet GetEmploymentType(RRFApproverBOL objRRFApproverBOL)
{
return(dsGetEmploymentType = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_GetEmploymentType"));
}
public void CancelRRF(RRFApproverBOL objRRApproverBOL)
{
objRRFListDAL.CancelRRF(objRRApproverBOL);
}