public List <TimelineCursosDashboard> ListarEncontros() { try { List <TimelineCursosDashboard> lista = new List <TimelineCursosDashboard>(); DBSession session = new DBSession(); Query quey = session.CreateQuery(@"select e.modulo, e.numero, c.titulo1, e.data_encontro, e.data_encontro1, d.titulo, isnull(p.nome,'') as professor, isnull(r.nome, '') as representante, isnull(r.telefone, '') as telefone, c.codigo as codigo_curso, e.codigo as codigo_encontro from encontro e inner join curso c on c.codigo = e.curso inner join disciplina d on d.codigo = e.disciplina inner join professor p on p.codigo = d.professor left join representante r on r.cidade = c.cidade_codigo where cast(e.data_encontro1 as date) >= cast(getdate() as date) and cast(e.data_encontro1 as date) <= cast(dateadd(day, 5, getdate()) as date) and e.ativo = 1 and r.ativo = 1 order by e.data_encontro, c.titulo1 "); IDataReader reader = quey.ExecuteQuery(); while (reader.Read()) { byte[] chave = Encoding.ASCII.GetBytes(Convert.ToInt32(reader["codigo_encontro"]) + "#" + Convert.ToInt32(reader["codigo_curso"])); lista.Add(new TimelineCursosDashboard() { modulo = Convert.ToInt32(reader["modulo"]), numero = Convert.ToInt32(reader["numero"]), curso = Convert.ToString(reader["titulo1"]), data1 = Convert.ToDateTime(reader["data_encontro"]), data2 = Convert.ToDateTime(reader["data_encontro1"]), disciplina = Convert.ToString(reader["titulo"]), professor = Convert.ToString(reader["professor"]), representante = Convert.ToString(reader["representante"]), codigo_curso = Convert.ToInt32(reader["codigo_curso"]), codigo_encontro = Convert.ToInt32(reader["codigo_encontro"]), telefone = Whatsapp.FormataCelular("", Convert.ToString(reader["telefone"])), chave = Crypt.Encode(chave) }); } reader.Close(); session.Close(); return(lista); } catch (Exception error) { throw error; } }
public MessageResource SendMessageWithWhatsapp(Whatsapp whatsapp) { ServicePointManager.SecurityProtocol = (SecurityProtocolType)3072; TwilioClient.Init(accountSid, authToken); var to = "whatsapp:" + whatsapp.Receiver_Contact_No; var messageOptions = new CreateMessageOptions( new Twilio.Types.PhoneNumber(to.ToString())); messageOptions.From = new Twilio.Types.PhoneNumber("whatsapp:+14155238886"); messageOptions.Body = whatsapp.Message_Body; var message = MessageResource.Create(messageOptions); return(message); }
//[Authorize(Roles ="SAdmin")] public HttpResponseMessage MessageToWhatsapp(Whatsapp whatsapp) { SmsResponse Response = new SmsResponse(); try { var message = Objwhatsapp.SendMessageWithWhatsapp(whatsapp); Response.Message = con.MessageSuccess;; Response.Status = con.StatusSuccess; } catch (Exception ex) { Response.Status = con.StatusFailed; Response.Message = con.MessageFailed + ", Exception : " + ex.Message; } return(ConvertToJSON(Response)); }
public Notification() { Email email = new Email(); Whatsapp whatsapp = new Whatsapp(); Sms sms = new Sms(); }
// evento de salvar os dados no banco de dados public bool SalvarDadosCliente(bool pIncluir) { bool ret = false; if (!Conecta()) { return(ret); } if (pIncluir) // se pincluir for verdadeiro criar a query para incluir os dados { StrQuery = "INSERT INTO CLIENTE (Nome,Endereco,Numero,Bairro,Cidade,Estado," + "Cep,Telefone,Celular,Whatsapp,Email,Nascimento,Pessoa,Cpf,Rg) VALUES (" + "@Nome,@Endereco,@Numero,@Bairro,@Cidade,@Estado,@Cep,@Telefone,@Celular," + "@Whatsapp,@Email,@Nascimento,@Pessoa,@Cpf,@Rg)"; } else { StrQuery = "UPDATE CLIENTE SET Nome=@Nome,Endereco=@Endereco,Numero=@Numero," + "Bairro=@Bairro,Cidade=@Cidade,Estado=@Estado,Cep=@Cep,Telefone=@Telefone," + "Celular=@Celular,Whatsapp=@Whatsapp,Email=@Email,Nascimento=@Nascimento," + "Pessoa=@Pessoa,Cpf=@Cpf,Rg=@Rg WHERE ID=" + Id.ToString(); } SqlCommand cmd = new SqlCommand(StrQuery, conn); cmd.Parameters.AddWithValue("@Nome", Nome.ToString()); cmd.Parameters.AddWithValue("@Endereco", Endereco.ToString()); cmd.Parameters.AddWithValue("@Numero", Numero.ToString()); cmd.Parameters.AddWithValue("@Bairro", Bairro.ToString()); cmd.Parameters.AddWithValue("@Cidade", Cidade.ToString()); cmd.Parameters.AddWithValue("@Estado", Estado.ToString()); cmd.Parameters.AddWithValue("@Cep", Cep.ToString()); cmd.Parameters.AddWithValue("@Telefone", Telefone.ToString()); cmd.Parameters.AddWithValue("@Celular", Celular.ToString()); cmd.Parameters.AddWithValue("@Whatsapp", Whatsapp.ToString()); cmd.Parameters.AddWithValue("@Email", Email.ToString()); cmd.Parameters.AddWithValue("@Nascimento", Nascimento.ToString()); cmd.Parameters.AddWithValue("@Pessoa", Pessoa.ToString()); cmd.Parameters.AddWithValue("@Cpf", Cpf.ToString()); cmd.Parameters.AddWithValue("@Rg", Rg.ToString()); cmd.CommandType = CommandType.Text; try { int i = cmd.ExecuteNonQuery(); if (i > 0) { ret = true; } } catch (Exception ex) { MessageBox.Show("Erro ao salvar os dados: Exceção: " + ex.ToString()); ret = false; } conn.Close(); return(ret); }
public async Task <HttpResponseMessage> BookingSchedule(string Slug) { Db = con.SurgeryCenterDb(Slug); BookingResponse Response = new BookingResponse(); try { MT_Patient_Booking Booking = new MT_Patient_Booking(); MT_PatientInfomation Patient = new MT_PatientInfomation(); Query ObjQuery = Db.Collection("MT_Patient_Booking").WhereEqualTo("PB_Is_Deleted", false).WhereEqualTo("PB_Is_Active", true); QuerySnapshot ObjQuerySnap = await ObjQuery.GetSnapshotAsync(); if (ObjQuerySnap != null && ObjQuerySnap.Documents.Count > 0) { foreach (DocumentSnapshot docsnap in ObjQuerySnap.Documents) { Booking = docsnap.ConvertTo <MT_Patient_Booking>(); if (Booking.PB_Notifications != null) { if (Booking.PB_Patient_ID != null && Booking.PB_Patient_ID != "") { Query PatientQuery = Db.Collection("MT_PatientInfomation").WhereEqualTo("Patient_Is_Active", true).WhereEqualTo("Patient_Is_Deleted", false).WhereEqualTo("Patient_Unique_ID", Booking.PB_Patient_ID); QuerySnapshot ObjPatientQuerySnap = await PatientQuery.GetSnapshotAsync(); if (ObjPatientQuerySnap != null) { List <string> Namelist = new List <string>(); List <string> Emaillist = new List <string>(); Patient = ObjPatientQuerySnap.Documents[0].ConvertTo <MT_PatientInfomation>(); Email = Patient.Patient_Email; Phone = Patient.Patient_Primary_No; Name = Patient.Patient_First_Name + " " + Patient.Patient_Middle_Name + " " + Patient.Patient_Last_Name; Namelist.Add(Name); Emaillist.Add(Email); BookingDate = Booking.PB_Booking_Date; foreach (MT_Notifications noti in Booking.PB_Notifications) { if (noti.NFT_Actions != null) { foreach (Notification_Action action in noti.NFT_Actions) { if (action.NFA_Status == "Pending") { if (action.NFA_DayOrWeek == 0) { if (action.NFA_Be_Af == 0) { Days = (-1) * action.NFA_Days; } else if (action.NFA_Be_Af == 1) { Days = action.NFA_Days; } } else if (action.NFA_DayOrWeek == 1) { if (action.NFA_Be_Af == 0) { Days = (-7) * action.NFA_Days; } else if (action.NFA_Be_Af == 1) { Days = 7 * action.NFA_Days; } } NoticationSendingDay = BookingDate.AddDays(Days); if (DateTime.Now.Date.ToString("MM/dd/yyyy") == NoticationSendingDay.Date.ToString("MM/dd/yyyy")) { TimeSpan NotificationTiming = TimeSpan.Parse(action.NFA_Timing); TimeSpan timeOfDay = DateTime.Now.TimeOfDay; if (TimeSpan.Compare(timeOfDay, NotificationTiming) >= 0) { switch (action.NFA_Action_Type) { case "SMS": Sms sms = new Sms(); sms.Receiver_Contact_No = Phone; sms.Message_Body = action.NFA_Message; sms.Message_Date = con.ConvertTimeZone(action.NFA_TimeZone, Convert.ToDateTime(DateTime.Now)); sms.Message_Title = action.NFA_Action_Title; SMSObj.SendSMS(sms); Response = await UpdateAction(Booking.PB_Unique_ID, action.NFA_Unique_ID, Slug); break; case "Email": Email email = new Email(); email.To_Name = Namelist; email.To_Email = Emaillist; email.PlainTextContent = ""; email.HtmlContent = action.NFA_Message; await EmailObj.Send(email); Response = await UpdateAction(Booking.PB_Unique_ID, action.NFA_Unique_ID, Slug); break; case "Whatsapp": Whatsapp whatsapp = new Whatsapp(); whatsapp.Receiver_Contact_No = Phone; whatsapp.Message_Title = action.NFA_Action_Title; whatsapp.Message_Date = con.ConvertTimeZone(action.NFA_TimeZone, Convert.ToDateTime(DateTime.Now)); whatsapp.Message_Body = action.NFA_Message; WhatsappObj.SendMessageWithWhatsapp(whatsapp); Response = await UpdateAction(Booking.PB_Unique_ID, action.NFA_Unique_ID, Slug); break; case "Voice": Voice voice = new Voice(); voice.Voice_Call_Date = con.ConvertTimeZone(action.NFA_TimeZone, Convert.ToDateTime(DateTime.Now)); voice.Voice_Receiver_Name = Patient.Patient_First_Name; voice.Voice_Call_Body = action.NFA_Message; voice.Voice_Receiver_Contact_No = Phone; VoiceObj.SetVoiceCall(voice); Response = await UpdateAction(Booking.PB_Unique_ID, action.NFA_Unique_ID, Slug); break; default: break; } } } } } } } } } } } Response.Status = con.StatusSuccess; Response.Message = con.MessageSuccess; } else { Response.Status = con.StatusDNE; Response.Message = con.MessageDNE; } } catch (Exception ex) { Response.Status = con.StatusFailed; Response.Message = con.MessageFailed + ", Exception : " + ex.Message; } return(ConvertToJSON(Response)); }
void OnGUI() { float StartY = 20; float StartX = 10; GUI.Label(new Rect(StartX, StartY, Screen.width, 40), "Twitter", style); StartY += 40; if (GUI.Button(new Rect(StartX, StartY, 150, 50), "Post")) { Twitter.Post("Twitter posting test"); } StartX += 170; if (GUI.Button(new Rect(StartX, StartY, 150, 50), "Post Screenshot")) { StartCoroutine(PostTwitterScreenshot()); } StartY += 80; StartX = 10; GUI.Label(new Rect(StartX, StartY, Screen.width, 40), "Facebook", style); StartY += 40; if (GUI.Button(new Rect(StartX, StartY, 150, 50), "Post")) { SA.IOSNative.Social.Facebook.Post("Facebook posting test"); } StartX += 170; if (GUI.Button(new Rect(StartX, StartY, 150, 50), "Post Screenshot")) { StartCoroutine(PostFBScreenshot()); } StartX += 170; if (GUI.Button(new Rect(StartX, StartY, 150, 50), "Post Image")) { SA.IOSNative.Social.Facebook.Post("Hello world", "https://www.assetstore.unity3d.com/en/#!/publisher/2256", textureForPost); } StartY += 80; StartX = 10; GUI.Label(new Rect(StartX, StartY, Screen.width, 40), "Native Sharing", style); StartY += 40; if (GUI.Button(new Rect(StartX, StartY, 150, 50), "Text")) { Meida.Share("Some text to share"); } StartX += 170; if (GUI.Button(new Rect(StartX, StartY, 150, 50), "Screenshot")) { StartCoroutine(PostScreenshot()); } StartX += 170; if (GUI.Button(new Rect(StartX, StartY, 150, 50), "Send Mail")) { Mail.Send("Mail Subject", "Mail Body <strong> text html </strong> ", new string[] { "*****@*****.**", "*****@*****.**" }, new Texture2D[] { textureForPost, textureForPost } ); } StartX += 170; if (GUI.Button(new Rect(StartX, StartY, 150, 50), "Send Txt Message")) { TextMessage.Send("Hello Google", "+18773555787", ( TextMessageComposeResult result) => { Debug.Log("Message send result: " + result); }); } StartY += 80; StartX = 10; GUI.Label(new Rect(StartX, StartY, Screen.width, 40), "Instagram", style); StartY += 40; if (GUI.Button(new Rect(StartX, StartY, 150, 50), "Post image from camera")) { IOSCamera.OnImagePicked += OnPostImageInstagram; IOSCamera.Instance.PickImage(ISN_ImageSource.Camera); } StartX += 170; if (GUI.Button(new Rect(StartX, StartY, 150, 50), "Post Screenshot")) { StartCoroutine(PostScreenshotInstagram()); } StartY += 80; StartX = 10; GUI.Label(new Rect(StartX, StartY, Screen.width, 40), "WhatsApp", style); StartY += 40; if (GUI.Button(new Rect(StartX, StartY, 150, 50), "Share Text")) { Whatsapp.Post("Some text"); } StartX += 170; if (GUI.Button(new Rect(StartX, StartY, 150, 50), "Share Image")) { Whatsapp.Post(textureForPost); } }