public static bool CheckForNotExpiredAccess(string AccessTokenStatus, string RefreshTokenStatus) { GoogleTokenModel TokenObject = new GoogleTokenModel(); TokenObject.Access_Token = AccessTokenStatus; TokenObject.Refresh_Token = RefreshTokenStatus; CalendarService CalService = GoogleCalendarManager.GetCalendarService(TokenObject); string AllCalendarFeed = @"http://www.google.com/calendar/feeds/default/allcalendars/full"; Uri postUri = new Uri(AllCalendarFeed); CalendarQuery CalendarQuery = new CalendarQuery(); CalendarQuery.Uri = postUri; bool inform = true; try { CalendarFeed calFeed = CalService.Query(CalendarQuery); } catch (Exception e) { inform = false; }; return(inform); }
// povikuvanje na id na defaultniot calendar public string GetCalendarIdentifier() { GoogleTokenModel GoogleTokenModelObject = new GoogleTokenModel(); SqlConnection konekcija3 = new SqlConnection(); konekcija3.ConnectionString = ConfigurationManager.ConnectionStrings["mojaKonekcija"].ConnectionString; SqlCommand komanda = new SqlCommand(); komanda.Connection = konekcija3; komanda.CommandText = "SELECT * FROM Users WHERE UserName=@UserName"; komanda.Parameters.Add("@UserName", (string)Session["UserName"]); try { konekcija3.Open(); SqlDataReader citac = komanda.ExecuteReader(); while (citac.Read()) { GoogleTokenModelObject.Access_Token = (string)citac["AccessToken"]; GoogleTokenModelObject.Refresh_Token = (string)citac["RefreshToken"]; } citac.Close(); } catch (Exception ex) { lblMessage.Text = ex.ToString(); } finally { konekcija3.Close(); } // zapocnuva get calendar id CalendarService CalService = GoogleCalendarManager.GetCalendarService(GoogleTokenModelObject); string AllCalendarFeed = @"http://www.google.com/calendar/feeds/default/allcalendars/full"; Uri postUri = new Uri(AllCalendarFeed); CalendarQuery CalendarQuery = new CalendarQuery(); CalendarQuery.Uri = postUri; string CalendarID = ""; try { CalendarFeed calFeed = CalService.Query(CalendarQuery); if (calFeed != null && calFeed.Entries.Count > 0) { foreach (CalendarEntry CalEntry in calFeed.Entries) { //Commented to post the new appointments on the main calendar instead of cleverfox calendar //if (CalEntry.Title.Text.Contains("Cleverfox") == true) //{ //CalendarID = CalEntry.Title.Text; CalendarID = CalEntry.EditUri.ToString().Substring(CalEntry.EditUri.ToString().LastIndexOf("/") + 1); break; //} } } } catch (Exception e) { lblMessage.Text = e.ToString(); } return(CalendarID); }