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