//CitasExp CRUD local
public string AddCitaExp(CitaExp citaEx)
{
conn.Insert(citaEx);
return("success :3");
}
public void CheckCitas()
{
Debug.WriteLine("-------------------------------------Eventos checados------------------------------------");
// Handle when your app sleeps
List <Cita> citas = memberDatabase.GetCitasL();
int citCount = citas.Count();
foreach (Cita ct in citas)
{
var dt = ct.fecha;
var ft = ct.hora;
var idx = ct.ID;
var razon = ct.razon;
var desc = ct.descripcion;
// string ft_f = TimeSpan.Parse(ft).ToString();
if (ft == "11:0")
{
ft = ft + "0";
}
int ft_len = ft.Length;
switch (ft_len)
{
case (5):
if (DateTime.TryParseExact(dt, "yyyy-MM-dd", null, DateTimeStyles.AssumeLocal, out DateTime datetime_))
{
dt = datetime_.ToString("dd-MM-yyyy"); //hay que probar este y el de 4
}
var chckdrx = dt + " " + ft;
DateTime dtchckx = DateTime.ParseExact(chckdrx.Trim(), "dd-MM-yyyy HH:mm",
System.Globalization.CultureInfo.InvariantCulture);
DateTime nowx = DateTime.Now;
var result_tx = DateTime.Compare(dtchckx, nowx);
var tm10x = dtchckx - nowx;
var tmm = tm10x.Minutes;
if (tmm < 0)
{
memberDatabase.DeleteCita(idx);
Debug.WriteLine("---------------------------------------Alarma eliminada -------------------------------------");
}
else
{
if (tmm <= 5)
{
var v = CrossVibrate.Current;
v.Vibration(TimeSpan.FromSeconds(3));
CrossLocalNotifications.Current.Show("Faltan " + tmm + " minutos para tu cita " + ct.razon, "Gracias");
}
if (tmm == 0)
{
//var ctI = new CitaInfo(idx);
//ctI.RingAlarm();
var v = CrossVibrate.Current;
v.Vibration(TimeSpan.FromSeconds(12));
Debug.WriteLine("-----------------------------------------------Alarma Sonando-------------------------------------");
CrossLocalNotifications.Current.Show("Tú cita " + razon + " es ahora !!!", "Entiendo");
DependencyService.Get <IAudio>().PlayAudioFile("softAlarm.mp3");
try
{
Debug.WriteLine("-----------------------------------------------Expirando cita-------------------------------------");
var ctExp = new CitaExp();
ctExp.descripcion = desc;
ctExp.fecha = dt;
ctExp.hora = ft;
ctExp.ID = idx;
ctExp.razon = razon;
memberDatabase.AddCitaExp(ctExp);
memberDatabase.DeleteCita(idx);
}
catch (Exception ex)
{
Debug.WriteLine("--------------------------Error_" + ex.ToString() + "-------------------------------------");
throw;
}
}
}
break;
case (3):
string outputdt = ft.Substring(ft.Length - 1, 1);
if (outputdt == "0")
{
ft = ft + "0";
}
if (DateTime.TryParseExact(dt, "yyyy-MM-dd", null, DateTimeStyles.AssumeLocal, out DateTime datetime))
{
dt = datetime.ToString("dd-MM-yyyy");
}
var chckdr = dt + " " + ft;
DateTime dtchck = DateTime.ParseExact(chckdr.Trim(), "dd-MM-yyyy H:mm",
System.Globalization.CultureInfo.InvariantCulture);
DateTime now = DateTime.Now;
var result_t = DateTime.Compare(dtchck, now);
var tm10 = dtchck - now;
var tmmi = tm10.Minutes;
if (tmmi < 0)
{
memberDatabase.DeleteCita(idx);
Debug.WriteLine("---------------------------------------Alarma eliminada -------------------------------------");
}
else
{
if (tmmi <= 5)
{
var v = CrossVibrate.Current;
v.Vibration(TimeSpan.FromSeconds(3));
CrossLocalNotifications.Current.Show("Faltan " + tmmi + " minutos para tu cita " + ct.razon, "Gracias");
}
if (tmmi == 0)
{
var v = CrossVibrate.Current;
v.Vibration(TimeSpan.FromSeconds(12));
Debug.WriteLine("-----------------------------------------------Alarma Sonando-------------------------------------");
CrossLocalNotifications.Current.Show("Tú cita " + razon + " es ahora !!!", "Entiendo");
DependencyService.Get <IAudio>().PlayAudioFile("softAlarm.mp3");
try
{
Debug.WriteLine("-----------------------------------------------Expirando cita-------------------------------------");
var ctExp = new CitaExp();
ctExp.descripcion = desc;
ctExp.fecha = dt;
ctExp.hora = ft;
ctExp.ID = idx;
ctExp.razon = razon;
memberDatabase.AddCitaExp(ctExp);
memberDatabase.DeleteCita(idx);
}
catch (Exception ex)
{
Debug.WriteLine("--------------------------Error_" + ex.ToString() + "-------------------------------------");
throw;
}
}
}
break;
case (4):
//string outputdtx = ft.Substring(ft.Length - 1, 1);
//if (outputdtx == "0")
//{
// ft = ft + "0";
//}
if (DateTime.TryParseExact(dt, "yyyy-MM-dd", null, DateTimeStyles.AssumeLocal, out DateTime datetimex))
{
dt = datetimex.ToString("dd-MM-yyyy");
}
var chckdrxx = dt + " " + ft;
DateTime dtchckxx = DateTime.ParseExact(chckdrxx.Trim(), "dd-MM-yyyy H:mm",
System.Globalization.CultureInfo.InvariantCulture);
DateTime nowxx = DateTime.Now;
var result_txx = DateTime.Compare(dtchckxx, nowxx);
var tm10xx = dtchckxx - nowxx;
var tmmix = tm10xx.Minutes;
if (tmmix < 0)
{
memberDatabase.DeleteCita(idx);
Debug.WriteLine("---------------------------------------Alarma eliminada -------------------------------------");
}
else
{
if (tmmix <= 5)
{
var v = CrossVibrate.Current;
v.Vibration(TimeSpan.FromSeconds(3));
CrossLocalNotifications.Current.Show("Faltan " + tmmix + " minutos para tu cita " + ct.razon, "Gracias");
}
if (tmmix == 0)
{
var v = CrossVibrate.Current;
v.Vibration(TimeSpan.FromSeconds(12));
Debug.WriteLine("-----------------------------------------------Alarma Sonando-------------------------------------");
CrossLocalNotifications.Current.Show("Tú cita " + razon + " es ahora !!!", "Entiendo");
DependencyService.Get <IAudio>().PlayAudioFile("softAlarm.mp3");
try
{
Debug.WriteLine("-----------------------------------------------Expirando cita-------------------------------------");
var ctExp = new CitaExp();
ctExp.descripcion = desc;
ctExp.fecha = dt;
ctExp.hora = ft;
ctExp.ID = idx;
ctExp.razon = razon;
memberDatabase.AddCitaExp(ctExp);
memberDatabase.DeleteCita(idx);
}
catch (Exception ex)
{
Debug.WriteLine("--------------------------Error_" + ex.ToString() + "-------------------------------------");
throw;
}
}
}
break;
}
}
}
