Insert events or tasks into Google Calendar

Reply

Member

19 Points

Insert events or tasks into Google Calendar

Jan 10, 2020 01:43 PM|ecocash|LINK

Hello everyone, I would like to know if there are any examples of how to use Google.Api.Calender to insert events into Google calendar using an Asp.Net application.
I thank you for your help

Reply

mgebhard

All-Star

53091 Points

23659 Posts

Re: Insert events or tasks into Google Calendar

Jan 10, 2020 02:26 PM|mgebhard|LINK

ecocash

Hello everyone, I would like to know if there are any examples of how to use Google.Api.Calender to insert events into Google calendar using an Asp.Net application.
I thank you for your help

Google Calendar has an openly published quick start for .NET.

https://forums.asp.net/post/set/1146/2163085/6290443

Once you get the quick start working then you can move on and learn the Google Calendar API features by read the reference docs.

https://developers.google.com/calendar/v3/reference

Reply

ecocash

Member

19 Points

89 Posts

Re: Insert events or tasks into Google Calendar

Jan 10, 2020 05:39 PM|ecocash|LINK

Hi mgebhad !

I am using an application where we log in for form authentication and have multiple users, do you know such an example?
Thanks for helping me with all the questions in the forum.

Reply

mgebhard

All-Star

53091 Points

23659 Posts

Re: Insert events or tasks into Google Calendar

Jan 10, 2020 05:49 PM|mgebhard|LINK

I'm not sure what you are trying to do or what you need help with. Do you need to create a login security?

Reply

ecocash

Member

19 Points

89 Posts

Re: Insert events or tasks into Google Calendar

Jan 10, 2020 06:00 PM|ecocash|LINK

Our system has a task scheduler, but today we want to integrate with the google calendar of employees, because they thought it was a good idea to use them together, but the system works using the authentication form and from what I saw in api uses oauth and google account calendar id,
and since this is the first time we will be using Google APIs I am unsure how I can communicate with calendars and how I can log into each other’s Google account

Reply

codemovement...

Contributor

2340 Points

807 Posts

Re: Insert events or tasks into Google Calendar

Jan 10, 2020 06:33 PM|codemovement.pk|LINK

Hi ecocash,

Create a console app and follow the steps.

Step 1 : https://developers.google.com/calendar

Step 2 : Enable the Google Calendar API

Step 3 :

Install-Package Google.Apis.Calendar.v3

Step 4 : Replace Program.cs with following (Must update your ClientId and ClientSecret)

using Google.Apis.Auth.OAuth2;
using Google.Apis.Calendar.v3;
using Google.Apis.Calendar.v3.Data;
using Google.Apis.Services;
using Google.Apis.Util.Store;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;

namespace CalendarQuickstart
{
    class Program
    {
        static void Main(string[] args)
        {
            var credential = GoogleWebAuthorizationBroker.AuthorizeAsync(
                            new ClientSecrets
                            {
                                ClientId = "your client id",
                                ClientSecret = "your client secret",
                            },
                            new[] { CalendarService.Scope.Calendar },
                            "user",
                            CancellationToken.None).Result;

            // Create the service.
            var service = new CalendarService(new BaseClientService.Initializer
            {
                HttpClientInitializer = credential,
                ApplicationName = "Calendar API Sample",
            });
            var myEvent = new Event
            {
                Summary = "Google Calendar Api Insert Event Sample Code by ABC",
                Location = "Islamabad, Punjab, Pakistan",
                Start = new EventDateTime()
                {
                    DateTime = new DateTime(2020, 3, 7, 14, 0, 0),
                    TimeZone = "Asia/Karachi"
                },
                End = new EventDateTime()
                {
                    DateTime = new DateTime(2020, 3, 7, 15, 0, 0),
                    TimeZone = "Asia/Karachi"
                },
                Recurrence = new String[] { "RRULE:FREQ=WEEKLY;BYDAY=MO" },
                //If you want to add attendee
                //Attendees = new List<EventAttendee>()
                //{
                //    new EventAttendee { Email = "youemail@yahoo.com"}
                //},
            };

            var recurringEvent = service.Events.Insert(myEvent, "primary");
            recurringEvent.SendNotifications = true;
            recurringEvent.Execute();

            Console.Read();
        }
    }
}

If my solution works for you, please mark it as answer! It will help others.
Get more information: http://codemovement.pk

Thanks,

Reply

ecocash

Member

19 Points

89 Posts

Re: Insert events or tasks into Google Calendar

Jan 10, 2020 07:39 PM|ecocash|LINK

Hi codemovement,

My controller for task e events

public class TarefasController : Controller
    {
        private ApplicationDbContext db = new ApplicationDbContext();

        public void  CreateTarefa(string id_oportunidade, string descricao, string data, string hora)
        {
            try
            {
                var user = db.Usuarios.Where(u => u.UsuarioNome == User.Identity.Name).FirstOrDefault();


                int horas = Int16.Parse(hora.Split(':')[0]);
                int minutos = Int16.Parse(hora.Split(':')[1]);

                var tarefa = new Tarefa();

                tarefa.descricao = descricao;
                tarefa.data_hora = DateTime.Parse(data).AddHours(horas).AddMinutes(minutos);

                if (id_oportunidade != null)
                {
                    var oportunidade = db.Oportunidades.Find(Int16.Parse(id_oportunidade));
                    
                    tarefa.oportunidade = oportunidade;
                }

                tarefa.usuario = user;

                db.Tarefas.Add(tarefa);
                db.SaveChanges();
            }
            catch (Exception)
            {
                throw;
            }
        }

        public void EditTarefa(string id_tarefa, string descricao, string data, string hora)
        {
            try
            {
                var formated_id_tarefa = Int16.Parse(id_tarefa);

                var old_tarefa = db.Tarefas.Where(t => t.id == formated_id_tarefa).FirstOrDefault();


                int horas = Int16.Parse(hora.Split(':')[0]);
                int minutos = Int16.Parse(hora.Split(':')[1]);

                old_tarefa.descricao = descricao;
                old_tarefa.data_hora = DateTime.Parse(data).AddHours(horas).AddMinutes(minutos);


                db.Entry(old_tarefa).State = EntityState.Modified;
                db.SaveChanges();
            }
            catch (Exception)
            {
                throw;
            }
        }

        public void ChangeStatusTarefa(string id_tarefa)
        {

            try
            {
                var formated_id_tarefa = Int16.Parse(id_tarefa);

                var old_tarefa = db.Tarefas.Where(t => t.id == formated_id_tarefa).FirstOrDefault();

                if (old_tarefa.status)
                {
                    old_tarefa.status = false;
                }
                else
                {
                    old_tarefa.status = true;
                }

                db.Entry(old_tarefa).State = EntityState.Modified;
                db.SaveChanges();
            }
            catch (Exception)
            {

                throw;
            }
            
        }

        public PartialViewResult _PartialListTarefas(string id_oportunidade)
        {
            var user = db.Usuarios.Where(u => u.UsuarioNome == User.Identity.Name).FirstOrDefault();

            List<Tarefa> atrasados;
            List<Tarefa> hoje;
            List<Tarefa> amanha;
            List<Tarefa> semana;
            List<Tarefa> mes;
            List<Tarefa> ano;

            var today = DateTime.Today.Date;

            atrasados = db.Tarefas.Where(
                t => EntityFunctions.TruncateTime(t.data_hora) < EntityFunctions.TruncateTime(today) && 
                t.usuario.UsuarioId == user.UsuarioId).ToList();

            hoje = db.Tarefas.Where(
                t => EntityFunctions.TruncateTime(t.data_hora) == EntityFunctions.TruncateTime(today) && 
                t.usuario.UsuarioId == user.UsuarioId && 
                !t.status).ToList();

            var tomorrow = DateTime.Today.AddDays(1);

            amanha = db.Tarefas.Where(
                t => EntityFunctions.TruncateTime(t.data_hora) == EntityFunctions.TruncateTime(tomorrow) && 
                t.usuario.UsuarioId == user.UsuarioId && 
                !t.status).ToList();

            var month = DateTime.Today.Month;
            var year = DateTime.Today.Year;

            mes = db.Tarefas.Where(
                t => t.data_hora.Month == month && 
                t.data_hora.Year == year && 
                t.usuario.UsuarioId == user.UsuarioId && 
                EntityFunctions.TruncateTime(t.data_hora) > EntityFunctions.TruncateTime(tomorrow) && 
                !t.status).ToList();

            ano = db.Tarefas.Where(
                t => t.data_hora.Year == year && 
                t.usuario.UsuarioId == user.UsuarioId && 
                t.data_hora.Month > DateTime.Now.Month && 
                !t.status).ToList();

            if (id_oportunidade != null && !id_oportunidade.Equals(""))
            {
                int converted_id = Int16.Parse(id_oportunidade);

                hoje = hoje.Where(h => h.oportunidade.id == converted_id).ToList();
                amanha = amanha.Where(h => h.oportunidade.id == converted_id).ToList();
                mes = mes.Where(h => h.oportunidade.id == converted_id).ToList();
                ano = ano.Where(h => h.oportunidade.id == converted_id).ToList();
            }

            ViewBag.Atrasados = atrasados;
            ViewBag.Hoje = hoje;
            ViewBag.Amanha = amanha;
            ViewBag.Mes = mes;
            ViewBag.Ano = ano;

            return PartialView();
        }

        // GET: Tarefas/Delete/5
        public ActionResult Delete(int? id)
        {
            if (id == null)
            {
                return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            Tarefa tarefa = db.Tarefas.Find(id);
            if (tarefa == null)
            {
                return HttpNotFound();
            }
            return View(tarefa);
        }

        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                db.Dispose();
            }
            base.Dispose(disposing);
        }
    }
}

Reply

jiadongm

Participant

1320 Points

491 Posts

Re: Insert events or tasks into Google Calendar

Jan 13, 2020 08:14 AM|jiadongm|LINK

Hi ecocash,

The insert event has been integrated into this API, you can use it directly

https://developers.google.com/calendar/v3/reference/events/insert

Best Regards,

Jiadong Meng

.NET forums are moving to a new home on Microsoft Q&A, we encourage you to go to Microsoft Q&A for .NET for posting new questions and get involved today.

Insert events or tasks into Google Calendar[Answered] RSS

7 replies

Shortcuts

Related Links

Insert events or tasks into Google Calendar

Re: Insert events or tasks into Google Calendar

ecocash

Re: Insert events or tasks into Google Calendar

Re: Insert events or tasks into Google Calendar

Re: Insert events or tasks into Google Calendar

Re: Insert events or tasks into Google Calendar

Re: Insert events or tasks into Google Calendar

Re: Insert events or tasks into Google Calendar