private void AddF(object obj)
{
Regex r = new Regex("^[0-9]*$");
if (string.IsNullOrEmpty(Name) || string.IsNullOrEmpty(Date))
{
return;
}
if (Date.Split('.').Length != 2 || !r.IsMatch(Date.Split('.')[0]) || !r.IsMatch(Date.Split('.')[1]) || int.Parse(Date.Split('.')[0]) > 31 || int.Parse(Date.Split('.')[1]) > 12)
{
MessageBox.Show("Неправильный ввод"); return;
}
SQLQueries.MakeRequestWrite($"insert into Calendar (Event, [Date]) values (\'{Name}\', \'{Date}\')");
Name = string.Empty;
Date = string.Empty;
}
private void EditF(object obj)
{
Regex r = new Regex("^[0-9]*$");
if (string.IsNullOrEmpty(Name) || string.IsNullOrEmpty(Date) || a == null)
{
return;
}
if (Date.Split('.').Length != 2 || !r.IsMatch(Date.Split('.')[0]) || !r.IsMatch(Date.Split('.')[1]) || int.Parse(Date.Split('.')[0]) > 31 || int.Parse(Date.Split('.')[1]) > 12)
{
MessageBox.Show("Неправильный ввод"); return;
}
SQLQueries.MakeRequestWrite($"update Calendar set Event = \'{Name}\', [Date] = \'{Date}\' where [key]={a.key}");
a = null;
CanEdit = false;
}
private void DeleteF(object obj)
{
if (Clicked == null)
{
return;
}
SQLQueries.MakeRequestWrite($"delete from Calendar where [key] = {Clicked.key}");
if (All)
{
YearF(null);
}
else
{
MonthF(null);
}
}
