public DataSet AddRRF(RRFRequestorBOL objRRFRequestorBOL) { SqlParameter[] param = new SqlParameter[25]; param[0] = new SqlParameter("@RequestedBy", SqlDbType.Int); param[0].Value = objRRFRequestorBOL.RequestedBy; param[1] = new SqlParameter("@RequestDate", SqlDbType.DateTime); param[1].Value = objRRFRequestorBOL.RequestDate; param[2] = new SqlParameter("@ExpectedClosureDate", SqlDbType.DateTime); param[2].Value = objRRFRequestorBOL.ExpectedClosureDate; param[3] = new SqlParameter("@RRFForDU", SqlDbType.Int); param[3].Value = objRRFRequestorBOL.RRFForDU; param[4] = new SqlParameter("@RRFForDT", SqlDbType.Int); if (objRRFRequestorBOL.RRFForDT == 0) { param[4].Value = DBNull.Value; } else { param[4].Value = objRRFRequestorBOL.RRFForDT; } param[5] = new SqlParameter("@ProjectName", SqlDbType.VarChar); if (objRRFRequestorBOL.ProjectName == "") { param[5].Value = DBNull.Value; } else { param[5].Value = objRRFRequestorBOL.ProjectName; } param[6] = new SqlParameter("@Designation", SqlDbType.Int); if (objRRFRequestorBOL.Designation == 0) { param[6].Value = DBNull.Value; } else { param[6].Value = objRRFRequestorBOL.Designation; } param[7] = new SqlParameter("@IndicativePanel1", SqlDbType.Int); if (objRRFRequestorBOL.IndicativePanel1 == 0) { param[7].Value = DBNull.Value; } else { param[7].Value = objRRFRequestorBOL.IndicativePanel1; } param[8] = new SqlParameter("@IndicativePanel2", SqlDbType.Int); if (objRRFRequestorBOL.IndicativePanel2 == 0) { param[8].Value = DBNull.Value; } else { param[8].Value = objRRFRequestorBOL.IndicativePanel2; } param[9] = new SqlParameter("@IndicativePanel3", SqlDbType.Int); if (objRRFRequestorBOL.IndicativePanel3 == 0) { param[9].Value = DBNull.Value; } else { param[9].Value = objRRFRequestorBOL.IndicativePanel3; } param[10] = new SqlParameter("@ResourcePool", SqlDbType.Int); if (objRRFRequestorBOL.ResourcePool == 0) { param[10].Value = DBNull.Value; } else { param[10].Value = objRRFRequestorBOL.ResourcePool; } param[11] = new SqlParameter("@PositionsRequired", SqlDbType.Int); param[11].Value = objRRFRequestorBOL.PositionsRequired; param[12] = new SqlParameter("@EmployeementType", SqlDbType.Int); if (objRRFRequestorBOL.EmployeementType == 0) { param[12].Value = DBNull.Value; } else { param[12].Value = objRRFRequestorBOL.EmployeementType; } param[13] = new SqlParameter("@IsReplacement", SqlDbType.Bit); param[13].Value = objRRFRequestorBOL.IsReplacement; param[14] = new SqlParameter("@ReplacementFor", SqlDbType.Int); if (objRRFRequestorBOL.ReplacementFor == 0) { param[14].Value = DBNull.Value; } else { param[14].Value = objRRFRequestorBOL.ReplacementFor; } param[15] = new SqlParameter("@KeySkills", SqlDbType.VarChar); param[15].Value = objRRFRequestorBOL.KeySkills; param[16] = new SqlParameter("@Experience", SqlDbType.Int); param[16].Value = objRRFRequestorBOL.Experience; param[17] = new SqlParameter("@BusinessJustification", SqlDbType.VarChar); if (objRRFRequestorBOL.BusinessJustification == "") { param[17].Value = DBNull.Value; } else { param[17].Value = objRRFRequestorBOL.BusinessJustification; } param[18] = new SqlParameter("@AdditionalInfo", SqlDbType.VarChar); if (objRRFRequestorBOL.AdditionalInfo == "") { param[18].Value = DBNull.Value; } else { param[18].Value = objRRFRequestorBOL.AdditionalInfo; } param[19] = new SqlParameter("@DUName", SqlDbType.VarChar); param[19].Value = objRRFRequestorBOL.DUName; param[20] = new SqlParameter("@ApprovedBy", SqlDbType.Int); param[20].Value = objRRFRequestorBOL.ApprovedBy; param[21] = new SqlParameter("@ModifiedBy", SqlDbType.Int); param[21].Value = objRRFRequestorBOL.RequestedBy; param[22] = new SqlParameter("@ModifiedDate", SqlDbType.DateTime); param[22].Value = objRRFRequestorBOL.RequestDate; param[23] = new SqlParameter("@IsBillable", SqlDbType.Bit); param[23].Value = objRRFRequestorBOL.IsBillable; param[24] = new SqlParameter("@SLAForSkill", SqlDbType.Int); param[24].Value = objRRFRequestorBOL.SLAForSkill; return(dsAddRRF = SqlHelper.ExecuteDataset(AppConfiguration.ConnectionString, CommandType.StoredProcedure, "sp_AddtblRRF", param)); }
public DataSet AddRRF(RRFRequestorBOL objRRFRequestorBOL) { dsAddRRF = objRRFRequestorDAL.AddRRF(objRRFRequestorBOL); return(dsAddRRF); }