public Calendar getSingleCalendarData(int id)
{
Calendar cal = new Calendar();
try
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["museum.Properties.Settings.museumConnectionString"].ConnectionString))
{
connection.Open();
string sqlQuery = "SELECT * FROM calendar WHERE id = " + id;
SqlCommand command = new SqlCommand(sqlQuery, connection);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
cal.id = (int)reader["id"];
cal.eventTitle = (string)reader["EventTitle"];
cal.date = (DateTime)reader["Date"];
cal.text = (string)reader["Text"];
cal.image = (string)reader["image"];
}
}
}
}
catch (SqlException sql)
{
MessageBox.Show("The single calendar data could not be retrieved!" + sql);
return null;
}
return cal;
}
public List<Calendar> getAllCalendarData()
{
List<Calendar> calendarList = new List<Calendar>();
try
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["museum.Properties.Settings.museumConnectionString"].ConnectionString))
{
connection.Open();
string sqlQuery = "SELECT * FROM calendar";
SqlCommand command = new SqlCommand(sqlQuery, connection);
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Calendar calendar = new Calendar();
calendar.id = (int)reader["id"];
calendar.eventTitle = (string)reader["EventTitle"];
calendar.date = (DateTime)reader["Date"];
calendar.text = (string)reader["Text"];
calendar.image = (string)reader["image"];
calendarList.Add(calendar);
}
}
}
}
catch (SqlException sql)
{
MessageBox.Show("The calendar data could not be retrieved!" + sql);
return null;
}
return calendarList;
}
/*we are passing the id to the constructor*/
public MuseumCalendarEventForm(int id)
{
InitializeComponent();
calendar = calendarDao.getSingleCalendarData(id);
eventFormpictureBox.BackgroundImage = Image.FromFile("..//..//Resources//" + calendar.image);
eventFormTitle.Text = calendar.eventTitle;
eventFormDate.Text = calendar.date.ToString();
eventFormText.Text = calendar.text;
}
