private void btnUpdate_Click(object sender, RoutedEventArgs e)
{
Event newEvent = createEventBody();
addAttendees(newEvent);
if (newEvent != null && selEvent != null)
{
try
{
EventsResource.UpdateRequest upReq = new EventsResource.UpdateRequest(myService, newEvent, "primary", selEvent.Id);
upReq.SendNotifications = false;
upReq.Execute();
selEvent = null;
EventListBox.SelectedItem = null;
MessageBox.Show("The selected event has been updated.");
}
catch (Google.GoogleApiException)
{
MessageBox.Show("An invalid time range has been entered. Please make sure your start date occurs before your end date.");
}
setReadRequest();
EventListBox.DataContext = request.Execute();
}
}
static void Main(string[] args)
{
UserCredential credential;
using (var stream = new FileStream("client_secret.json", FileMode.Open, FileAccess.Read))
{
string credPath = System.Environment.GetFolderPath(
System.Environment.SpecialFolder.Personal);
credPath = Path.Combine(credPath, ".credentials");
credential = GoogleWebAuthorizationBroker.AuthorizeAsync(
GoogleClientSecrets.Load(stream).Secrets,
Scopes,
"user",
CancellationToken.None,
new FileDataStore(credPath, true)).Result;
Console.WriteLine("Credential file saved to: " + credPath);
}
// Create Google Calendar API service.
var service = new CalendarService(new BaseClientService.Initializer()
{
HttpClientInitializer = credential,
ApplicationName = ApplicationName,
});
// Define parameters of request.
EventsResource.ListRequest request = service.Events.List("primary");
request.TimeMin = DateTime.Now.AddYears(-1); //DateTime.Now.AddYears(-7);
request.TimeMax = DateTime.Now;
request.ShowDeleted = false;
request.SingleEvents = true;
request.MaxResults = 1000; //{Default:25, Max:2500}
request.OrderBy = EventsResource.ListRequest.OrderByEnum.StartTime;
// List events.
Events events = request.Execute();
Console.WriteLine(String.Format("Event Count: {0}", events.Items.Count));
if (events.Items != null && events.Items.Count > 0)
{
foreach (var eventItem in events.Items)
{
Thread.Sleep(200);
eventItem.Visibility = "private";
eventItem.Transparency = "transparent";
EventsResource.UpdateRequest updateReq = service.Events.Update(eventItem, "primary", eventItem.Id);
Event updatedEvent = updateReq.Execute();
Console.WriteLine("Event Updated: " + updatedEvent.Id + " " + updatedEvent.Visibility + " " + updatedEvent.Description);
}
}
else
{
Console.WriteLine("No events found.");
}
Console.Read();
Console.Read();
}
/// <summary>
/// Edit Event with the same ID
/// </summary>
/// <param name="event1">Event with changes</param>
public void EditEvent(TCGSync.Entities.Event event1)
{
EventsResource.GetRequest getRequest = new EventsResource.GetRequest(GService, user.googleCalendarId, event1.GoogleId);
Google.Apis.Calendar.v3.Data.Event googleEvent = getRequest.Execute();
googleEvent.Start = new EventDateTime()
{
DateTime = event1.Start
};
googleEvent.End = new EventDateTime()
{
DateTime = event1.End
};
googleEvent.Summary = event1.Description;
EventsResource.UpdateRequest updateRequest = new EventsResource.UpdateRequest(GService, googleEvent, user.googleCalendarId, event1.GoogleId);
updateRequest.Execute();
}
/// <summary>
/// Обновление записи календаря
/// </summary>
/// <param name="new_event">Новая запись</param>
/// <param name="calendar">Календарь</param>
/// <param name="source_event">Исходная запись</param>
public void UpdateEvent(Event new_event, string sourceCalendarId, string newCalendarId = null)
{
if (isConnect)
{
EventsResource.UpdateRequest request = new EventsResource.UpdateRequest(Service, new_event, sourceCalendarId, new_event.Id);
Event resource = request.Execute();
WorkBD.Execution_query($"delete from Events_calendar where Id_Event = N'{resource.Id}'");
if (newCalendarId != null)
{
MoveEvent(resource.Id, sourceCalendarId, newCalendarId);
}
}
else
{
WorkBD.Execution_query($"if exists(select Id from Events_calendar where Id_Event = N'{new_event.Id}') if exists(select Id from Mod_Event where Id_Mod_Event = N'{new_event.Id}') update Mod_Event set New_Event = N'{JsonConvert.SerializeObject(new_event)}', New_Calendar = (select Id from Name_Calendar where Id_Calendar = N'{newCalendarId}' and Id_User = (select Id from Users where UserName = N'{User}')) where Id_Mod_Event = N'{new_event.Id}' else insert into Mod_Event (RecordId, New_Event, New_Calendar, Id_Mod_Event) values ((select Id from Activity where EvendId = (select Id from Events_calendar where Id_Event = N'{new_event.Id}')), N'{JsonConvert.SerializeObject(new_event)}', (select Id from Name_Calendar where Id_Calendar = N'{newCalendarId}' and Id_User = (select Id from Users where UserName = N'{User}')), N'{new_event.Id}') else update Ins_Event set New_Ev = N'{JsonConvert.SerializeObject(new_event)}', Cal_Id = (select Id from Name_Calendar where Id_Calendar = N'{newCalendarId ?? sourceCalendarId}' and Id_User = (select Id from Users where UserName = N'{User}')) where Id_New_Ev = N'{new_event.Id}'");
WorkBD.Execution_query($"if exists(select me.Id from Mod_Event me, Events_calendar ec where me.New_Event = ec.Calendar_event and me.Id_Mod_Event = N'{new_event.Id}' and ec.Id_Event = N'{new_event.Id}' and me.New_Calendar = (select ac.NameId from Activity ac where ac.EvendId = (select Id from Events_calendar where Id_Event = N'{new_event.Id}'))) delete from Mod_Event where Id_Mod_Event = N'{new_event.Id}'");
}
}
public Boolean EditEvent(Event evento)
{
try
{
EventsResource.UpdateRequest request = service.Events.Update(evento, "primary", evento.Id);
var respuesta = request.Execute();
int a = 0;
return(true);
}
catch (Exception e)
{
if (ConfiguracionAplicacion.Default.Idioma.Equals("ES"))
{
MessageBox.Show("Hubo un error " + e);
}
else
{
MessageBox.Show("There was an error " + e);
}
return(false);
throw;
}
}
public void UpdateAppointment(string id, Event _event)
{
EventsResource.UpdateRequest updateRequest = service.Events.Update(_event, "primary", id);
updateRequest.Execute();
}
private static void UpdateNewEvent(CalendarService service, string calendarId, SmEmployee employee, CrmActivityDto activity, List <EventAttendee> eventAttendees, string eventId, ILog logger, string notes)
{
var overrides = new List <EventReminder>();
if (GetEventReminderEmail())
{
overrides.Add(new EventReminder {
Method = "email", Minutes = GetEventReminderEmailMinutes()
});
}
if (GetEventReminderSMS())
{
overrides.Add(new EventReminder {
Method = "sms", Minutes = GetEventReminderSMSMinutes()
});
}
string summary = $"{activity.Topic} [ความสำคัญ:{activity.PriorityEnumName}][สถานะ:{activity.StatusEnumName}] ".Replace(System.Environment.NewLine, string.Empty);
var endDateTime = activity.EndDateTime == null ? activity.StartDateTime : activity.EndDateTime.Value;
Event newEvent = new Event()
{
ICalUID = activity.ActivityId,
Summary = summary,
Location = activity.RelateActName,
Description = activity.Detail,
Created = activity.ModifiedDate,
ColorId = GetPriorityColor(activity.PriorityEnumName),
Status = GetStatus(activity.StatusEnumName),
Start = new EventDateTime()
{
DateTime = activity.StartDateTime,
TimeZone = GetTimeZone(),
},
End = new EventDateTime()
{
DateTime = endDateTime,
TimeZone = GetTimeZone(),
},
Updated = DateTime.Now,
Attendees = eventAttendees,
Visibility = "default",
Organizer = new Event.OrganizerData
{
Email = employee.Facebook,
DisplayName = $"{employee.EmpFirstName} {employee.EmpLastName}",
},
Reminders = new Event.RemindersData()
{
UseDefault = false,
Overrides = overrides
},
ConferenceData = new ConferenceData
{
Notes = notes
}
};
EventsResource.UpdateRequest updateRequest = service.Events.Update(newEvent, calendarId, eventId);
try
{
Event updatedEvent = updateRequest.Execute();
logger.Info($"CalendarId:{calendarId} Event Id:{newEvent.ICalUID} has been updated successful.");
}
catch (Exception e)
{
logger.Error($"Update Event Id:{newEvent.ICalUID} CalendarId:{calendarId} Error:{e.Message}{e.StackTrace}");
}
}
public static void Main()
{
CalendarService service = GetCalendarService();
CalendarListEntry calendarListEntry = GetCalendarListEntry(service);
if (calendarListEntry == null)
{
Console.WriteLine("Der Kalender konnte nicht gefunden werden.");
return;
}
// Define parameters of request.
// Alternative KalenderId für den "Haupt"-Kalender: "primary"
EventsResource.ListRequest request = service.Events.List(calendarListEntry.Id);
request.TimeMin = DateTime.Now;
request.ShowDeleted = false;
request.SingleEvents = true;
request.MaxResults = 100;
request.OrderBy = EventsResource.ListRequest.OrderByEnum.StartTime;
// List events.
Events events = request.Execute();
if (events?.Items?.Any() != true)
{
Console.WriteLine("No upcoming events found.");
return;
}
int updateCounter = 0;
int skippedCounter = 0;
foreach (Event eventItem in events.Items)
{
bool eventWasUpdated = false;
bool isMuellKalenderEvent = EventIsMuellKalenderEvent(eventItem);
// Korrigiert den Zeitraum des Events
if (isMuellKalenderEvent && DateFixIsRequired(eventItem))
{
var oldDateTime = eventItem.Start.DateTime.Value;
eventItem.Start.DateTime = new DateTime(oldDateTime.Year, oldDateTime.Month, oldDateTime.Day);
eventItem.End.DateTime = eventItem.Start.DateTime.Value.AddDays(1);
eventWasUpdated = true;
}
// Setzt die Erinnerung auf 12 Stunden vor dem Termin
if (isMuellKalenderEvent && eventItem.Reminders?.UseDefault != false)
{
if (eventItem.Reminders == null)
{
eventItem.Reminders = new Event.RemindersData();
}
eventItem.Reminders.UseDefault = false;
eventItem.Reminders.Overrides = new List <EventReminder>();
// Reminder per popup (nicht per email) 12 Stunden vor dem Event
eventItem.Reminders.Overrides.Add(new EventReminder {
Method = "popup", Minutes = 12 * 60
});
eventWasUpdated = true;
}
if (!eventWasUpdated)
{
skippedCounter++;
Console.WriteLine($"Skipped #{skippedCounter}: {eventItem.Summary ?? eventItem.Id} ({eventItem.Start.DateTime})");
continue;
}
EventsResource.UpdateRequest updateRequest = service.Events.Update(eventItem, calendarListEntry.Id, eventItem.Id);
Event updateResult = updateRequest.Execute();
updateCounter++;
Console.WriteLine($"Updated #{updateCounter}: {eventItem.Summary ?? eventItem.Id} ({eventItem.Start.DateTime})");
}
}
public Event updateToGoogleCalendar(Event googleAppointment)
{
EventsResource.UpdateRequest request = service.Events.Update(googleAppointment, calendarId, googleAppointment.Id);
return(request.Execute());
}
