private void btnUpdate_Click(object sender, EventArgs e)
{
CalendarEvent calEvent = new CalendarEvent()
{
Title = txbDelTitle.Text,
DateStart = DateTime.Parse(txbDelStart.Text),
DateEnd = DateTime.Parse(txbDellEnd.Text),
Text = rTbDellText.Text
};
DataBase.Update(calEvent);
this.Close();
}
private void btnAddEventOK_Click(object sender, EventArgs e)
{
if (dTPStart.Value.ToShortDateString() == DateTime.Now.ToShortDateString())
{
DialogResult result = MessageBox.Show("Event start today", "Check Start day", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
CalendarEvent calEvent = new CalendarEvent()
{
Title = txbTitle.Text,
DateStart = dTPStart.Value,
DateEnd = dTPEnd.Value,
Text = rTBText.Text
};
DataBase.Save(calEvent);
this.Close();
}
}
else if (dTPStart.Value > dTPEnd.Value)
{
DialogResult result = MessageBox.Show("Check end day");
}
else
{
CalendarEvent calEvent = new CalendarEvent()
{
Title = txbTitle.Text,
DateStart = dTPStart.Value,
DateEnd = dTPEnd.Value,
Text = rTBText.Text
};
DataBase.Save(calEvent);
this.Close();
}
MaimForm.getInstance().Updatepanel();
}
public CalendarEvent Load(DateTime dateStart)
{
string sqlread = "select * from events where datetimeStart='" + dateStart.ToShortDateString() + "'";
SQLiteCommand command = new SQLiteCommand(sqlread, m_dbConnection);
m_dbConnection.Open();
SQLiteDataReader reader = command.ExecuteReader();
bool isResult = false;
CalendarEvent ce = new CalendarEvent();
List<CalendarEvent> ceList = new List<CalendarEvent>();
while (reader.Read())
{
isResult = true;
ce.Title = reader["title"].ToString();
ce.DateStart = DateTime.Parse(reader["datetimeStart"].ToString());//, m_culture, System.Globalization.DateTimeStyles.AssumeLocal);
ce.DateEnd = DateTime.Parse(reader["datetimeEnd"].ToString());//, m_culture, System.Globalization.DateTimeStyles.AssumeLocal);
ce.Text = reader["text"].ToString();
}
m_dbConnection.Close();
if (isResult)
return ce;
else
return null;
}
public void Update(CalendarEvent ce)
{
Delete(ce.DateStart);
Save(ce);
}
/**
* MMethod for saving data to database
*
* @param ce calendar event for one day
*/
public void Save(CalendarEvent ce)
{
string sql = "insert into events (title, datetimeStart, datetimeEnd , text) values ('" + ce.Title + "', '" + ce.DateStart.ToShortDateString() + "', '" + ce.DateEnd.ToShortDateString() + "', '" + ce.Text + "')";
execute(sql);
}
