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