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);
}
}
