示例#1
0
 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));
 }
示例#2
0
        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);
        }
示例#3
0
        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);
        }
示例#4
0
 public DataSet GetResourcePool(RRFApproverBOL objRRFApproverBOL)
 {
     return(dsGetResourcePool = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_GetResourcePool"));
 }
示例#5
0
 public DataSet GetDeliveryUnit(RRFApproverBOL objRRFApproverBOL)
 {
     return(dsGetDeliveryUnit = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_GetDeliveryUnit"));
 }
示例#6
0
        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);
        }
示例#7
0
 public DataSet GetSkillsForSLA(RRFApproverBOL objRRFApproverBOL)
 {
     dsSLAForTechnology = objRRFApproverDAL.GetSkillsForSLA(objRRFApproverBOL);
     return(dsSLAForTechnology);
 }
示例#8
0
 public DataSet GetEmployeeFromRole(RRFApproverBOL objRRFApproverBOL)
 {
     dsGetEmployeeFromRole = objRRFApproverDAL.GetEmployeeFromRole(objRRFApproverBOL);
     return(dsGetEmployeeFromRole);
 }
示例#9
0
 public void AddRRF(RRFApproverBOL objRRFApproverBOL)
 {
     objRRFApproverDAL.AddRRF(objRRFApproverBOL);
 }
示例#10
0
 public DataSet GetEmploymentType(RRFApproverBOL objRRFApproverBOL)
 {
     dsGetEmploymentType = objRRFApproverDAL.GetEmploymentType(objRRFApproverBOL);
     return(dsGetEmploymentType);
 }
示例#11
0
 public DataSet GetResourcePool(RRFApproverBOL objRRFApproverBOL)
 {
     dsGetResourcePool = objRRFApproverDAL.GetResourcePool(objRRFApproverBOL);
     return(dsGetResourcePool);
 }
示例#12
0
 public DataSet GetDesignation(RRFApproverBOL objRRFApproverBOL)
 {
     dsGetDesignation = objRRFApproverDAL.GetDesignation(objRRFApproverBOL);
     return(dsGetDesignation);
 }
示例#13
0
 public DataSet GetDeliveryUnit(RRFApproverBOL objRRFApproverBOL)
 {
     dsGetDeliveryUnit = objRRFApproverDAL.GetDeliveryUnit(objRRFApproverBOL);
     return(dsGetDeliveryUnit);
 }
示例#14
0
 public DataSet GetRRFValuesToApprove(RRFApproverBOL objRRFApproverBOL)
 {
     dsGetRRFValuesToApprove = objRRFApproverDAL.GetRRFValuesToApprove(objRRFApproverBOL);
     return(dsGetRRFValuesToApprove);
 }
示例#15
0
 public void UdateRRFValuesToApprove(RRFApproverBOL objRRFApproverBOL)
 {
     objRRFApproverDAL.UdateRRFValuesToApprove(objRRFApproverBOL);
 }
示例#16
0
 public void UpdateRRFForResend(RRFApproverBOL objRRFApproverBOL)
 {
     objRRFApproverDAL.UpdateRRFForResend(objRRFApproverBOL);
 }
示例#17
0
 public DataSet GetEmploymentType(RRFApproverBOL objRRFApproverBOL)
 {
     return(dsGetEmploymentType = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_GetEmploymentType"));
 }
示例#18
0
 public void CancelRRF(RRFApproverBOL objRRApproverBOL)
 {
     objRRFListDAL.CancelRRF(objRRApproverBOL);
 }