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;
}
}