}//End of Carousel /***** Announcement ****/ public String InsertAnnouncementData(AnnouncementDataObject announcementData) { String sqlString = "INSERT INTO aay_file ( " + " aay01, aay02, aay03, aay04 " + ") VALUES ( " + " @val01, @val02, @val03, @val04 " + ")"; OpenConnection(); actionResult = "SUCCESS"; try { SqlCommand sqlCommand = sqlConnection.CreateCommand(); sqlCommand.Connection = sqlConnection; sqlCommand.CommandText = sqlString; sqlCommand.Parameters.AddWithValue("@val01", announcementData.Aay01); sqlCommand.Parameters.AddWithValue("@val02", announcementData.Aay02); sqlCommand.Parameters.AddWithValue("@val03", announcementData.Aay03); sqlCommand.Parameters.AddWithValue("@val04", announcementData.Aay04); sqlCommand.ExecuteNonQuery(); } catch (Exception ex) { actionResult = "FAIL" + ex.Message; } finally { CloseConnection(); } return(actionResult); }//End of Insert Into
}//End of Insert Into public List <AnnouncementDataObject> GetFirstAnnouncement() { String sqlString = //"SELECT TOP " + num + "SELECT TOP 1 aay03 " + " FROM aay_file " + " ORDER BY aay01 DESC" + ""; List <AnnouncementDataObject> announcementDataObjects = new List <AnnouncementDataObject>(); OpenConnection(); actionResult = "SUCCESS"; int carousel_flag = 1; try { SqlCommand sqlCommand = sqlConnection.CreateCommand(); sqlCommand.Connection = sqlConnection; sqlCommand.CommandText = sqlString; SqlDataReader dataReader = sqlCommand.ExecuteReader(); if (dataReader.HasRows) { while (dataReader.Read()) { AnnouncementDataObject announcementDataObject = new AnnouncementDataObject(); announcementDataObject.Aay03 = dataReader["Aay02"] == DBNull.Value ? "" : dataReader.GetString(dataReader.GetOrdinal("Aay02")); announcementDataObjects.Add(announcementDataObject); carousel_flag++; } } } catch (Exception ex) { string v = "FAIL" + ex.Message; actionResult = v; } finally { CloseConnection(); } return(announcementDataObjects); }//End of Announcement