private void YearF(object obj)
{
Eventlist = new List <Events>(SQLQueries.MakeRequestRead("select [key], Event, [Date] from Calendar"));
foreach (Events i in VKlist)
{
Eventlist.Add(i);
}
Eventlist = Eventlist.OrderBy((Events h) => { return(h.days); }).ToList();
All = true;
}
public MainWindowViewModel()
{
LoadFriends.Seva = DoLoad;
Insert.Seva = InsertF;
Delete.Seva = DeleteF;
Change.Seva = ChangeF;
Month.Seva = MonthF;
Year.Seva = YearF;
ListClick.Seva = ListClickF;
Eventlist = new List <Events>(SQLQueries.MakeRequestRead("select [key], Event, [Date] from Calendar"));
}
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 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 DeleteF(object obj)
{
if (Clicked == null)
{
return;
}
SQLQueries.MakeRequestWrite($"delete from Calendar where [key] = {Clicked.key}");
if (All)
{
YearF(null);
}
else
{
MonthF(null);
}
}
private void MonthF(object obj)
{
List <Events> all = new List <Events>(SQLQueries.MakeRequestRead("select [key], Event, [Date] from Calendar"));
List <Events> hold = new List <Events>();
foreach (Events e in all)
{
if (DateTime.Now.Month == e.month)
{
hold.Add(e);
}
}
Eventlist = new List <Events>(hold);
foreach (Events i in VKlist)
{
if (DateTime.Now.Month == int.Parse(i.Date.Split('.')[1]))
{
Eventlist.Add(i);
}
}
Eventlist = Eventlist.OrderBy((Events h) => { return(h.days); }).ToList();
All = false;
}
