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