public int CheckOverlappingSplashScreenData(string companyCode, SplashScreenModel objSplashScreenModel) { try { SqlCommand command = new SqlCommand(SP_SC_CHECK_OVERLAPPING_SPLASH); command.CommandType = CommandType.StoredProcedure; _objSPData.AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode); _objSPData.AddParamToSqlCommand(command, "@Date_From", ParameterDirection.Input, SqlDbType.Date, 30, objSplashScreenModel.Date_From); _objSPData.AddParamToSqlCommand(command, "@Date_To", ParameterDirection.Input, SqlDbType.Date, 30, objSplashScreenModel.Date_To); int count = _objData.GetIntegerValue(companyCode, command); return(count); } catch (Exception ex) { throw ex; } }