void push()
{
try
{
NetCom.ServerRequestChangeIsSchoolDagTable request = new NetCom.ServerRequestChangeIsSchoolDagTable();
foreach (Button x in Controls.OfType <Button>())
{
if (x.Name[0] == 'c')
{
DateTime deateTime = new DateTime(DateTime.Now.Year, 1, 1).AddDays(Convert.ToInt32(x.Name.Split(';')[1]) - 1);
if (fromServerEntrys.Any(y => y.Date == deateTime))
{
request.deleteList.Add(fromServerEntrys.First(z => z.Date == deateTime));
}
else
{
request.toAddToDB.Add(deateTime);
}
}
}
NetCom.ServerResponseChangeIsSchoolDagTable response = webr <NetCom.ServerResponseChangeIsSchoolDagTable>(request);
}catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static NetCom.ServerResponseChangeIsSchoolDagTable ChangeIsSchooldagTable(DBDingus.AcountTableEntry _MasterRightsEnty, NetCom.ServerRequestChangeIsSchoolDagTable _request)
{
NetCom.ServerResponseChangeIsSchoolDagTable toReturn = new NetCom.ServerResponseChangeIsSchoolDagTable();
if (_request.deleteList.Count > 0)
{
string addings = "";
foreach (var x in _request.deleteList)
{
addings += x.ID + ", ";
}
addings = addings.Substring(0, addings.Length - 2);
FuncsVSQL.SQLNonQuery($"delete from {DBDingus.IsSchoolDagTableNames.HetIsEenSchoolDagTableNames} where {DBDingus.IsSchoolDagTableNames.ID} in ({addings})");
}
if (_request.toAddToDB.Count > 0)
{
string addings = "";
for (int x = 0; x < _request.toAddToDB.Count; x++)
{
addings += $"(cast('{_request.toAddToDB[x].Date.ToString("yyyy\\/ MM\\/ dd")}' as date)), ";
}
addings += $"(cast('{_request.toAddToDB[_request.toAddToDB.Count].Date.ToString("yyyy\\/ MM\\/ dd")}' as date))";
FuncsVSQL.SQLNonQuery($"insert into {DBDingus.IsSchoolDagTableNames.HetIsEenSchoolDagTableNames} ({DBDingus.IsSchoolDagTableNames.Date}) values {addings}");
}
return(toReturn);
}
