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); } }