public static bool CrearAlerta(string email, string comentarios, double longitud, double latitude)
{
try
{
EcolectModelDataContext ecolectEntities = new EcolectModelDataContext();
Alerta nuevaAlerta = new Alerta
{
email = email,
comentarios = comentarios,
longitud = longitud,
latitud = latitude,
estado = 0
};
ecolectEntities.Alertas.InsertOnSubmit(nuevaAlerta);
ecolectEntities.SubmitChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
public static bool EliminarAlertas(int idAlerta)
{
try
{
EcolectModelDataContext ecolectEntities = new EcolectModelDataContext();
var alerta = ecolectEntities.Alertas.Where(cmp => cmp.idAlerta == idAlerta).FirstOrDefault();
ecolectEntities.Alertas.DeleteOnSubmit(alerta);
ecolectEntities.SubmitChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}
public static bool CambiarEstado(int idAlerta)
{
try
{
EcolectModelDataContext ecolectEntities = new EcolectModelDataContext();
var alerta = ecolectEntities.Alertas.Where(cmp => cmp.idAlerta == idAlerta).FirstOrDefault();
if (alerta.estado == 1)
{
alerta.estado = 0;
}
else if (alerta.estado == 0)
{
alerta.estado = 1;
}
ecolectEntities.SubmitChanges();
return true;
}
catch (Exception ex)
{
return false;
}
}