public List <SplashScreenModel> GetSplashScreenData(string companyCode)
{
SqlConnection objSqlConnection = new SqlConnection();
try
{
objSqlConnection = _objData.GetConnectionObject(companyCode);
SqlCommand command = new SqlCommand(SP_SC_GET_SPLASH_SCREEN_DATA);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
List <SplashScreenModel> lstSplashScreenModel = new List <SplashScreenModel>();
SplashScreenModel objSplashScreenModel;
objSqlConnection.Open();
command.Connection = objSqlConnection;
using (SqlDataReader sqlReader = command.ExecuteReader())
{
if (sqlReader.HasRows)
{
while (sqlReader.Read())
{
objSplashScreenModel = new SplashScreenModel();
objSplashScreenModel.Splash_Screen_Id = Convert.ToInt32(sqlReader["Splash_Screen_Id"].ToString().Trim());
objSplashScreenModel.Title = sqlReader["Title"].ToString().Trim();
objSplashScreenModel.Description = sqlReader["Description"].ToString().Trim();
objSplashScreenModel.File_Path = sqlReader["File_Path"].ToString().Trim();
objSplashScreenModel.Date_From = Convert.ToDateTime(sqlReader["Date_From"].ToString().Trim());
objSplashScreenModel.Date_To = Convert.ToDateTime(sqlReader["Date_To"].ToString().Trim());
objSplashScreenModel.Record_Status = Convert.ToBoolean(sqlReader["Record_Status"].ToString().Trim());
objSplashScreenModel.Has_Attachment = Convert.ToBoolean(sqlReader["Has_Attachment"].ToString().Trim());
if (Convert.ToBoolean(sqlReader["Record_Status"].ToString().Trim()) == true)
{
objSplashScreenModel.Record_Status_Display_Name = Active;
}
else
{
objSplashScreenModel.Record_Status_Display_Name = Inactive;
}
lstSplashScreenModel.Add(objSplashScreenModel);
}
}
}
return(lstSplashScreenModel);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objSqlConnection.Close();
}
}
