private void createFile() { StreamWriter file = new System.IO.StreamWriter(@"C:\Datos\Web\getevents.js"); DatosCehavi datos1 = new DatosCehavi(); datos1.Connect(); StringBuilder jsonData = new StringBuilder(); //file.WriteLine("var curEvents = "); DateTime CurTime = DateTime.Now; DateTime EndTime = CurTime.AddMonths(1); string json = datos1.getJsonEvents(CurTime, EndTime, "IdEvento in (select Id from Terapias where IdTerapeuta=" + this.curTerapeuta.ToString() + ") or IdEvento in (select Id from Citas where IdTerapeuta=" + this.curTerapeuta.ToString() + ")"); if (json.Length != 0) { jsonData.Append("var curEvents = "); jsonData.Append(json); jsonData.Append(";"); } else { jsonData.Append("var curEvent = [];"); } file.WriteLine(jsonData.ToString()); file.Close(); }