public async Task <bool> Create_Publicacion(Publicacion o, string linkimage)
{
try
{
string ruta = "";
if (linkimage == "")
{
ruta = "default_image";
}
else
{
ruta = linkimage;
}
var firebase = new Firebase.Database.FirebaseClient("https://fir-app-cf755.firebaseio.com/");
var key_Noticia = Firebase.Database.FirebaseKeyGenerator.Next();
await firebase
.Child("Publicaciones").Child(key_Noticia)
.PutAsync(new Publicacion()
{
key_noticia = key_Noticia, key_usuario = o.key_usuario, nombre_usuario = o.nombre_usuario, img_usuario = o.img_usuario, descripcion_noticia = o.descripcion_noticia, img_noticia = ruta, fecha_noticia = DateTime.Now.Date.ToShortDateString(), telefono = o.telefono, titulo = o.titulo
});
}
catch (Exception ex)
{
// ModelState.AddModelError(string.Empty, ex.Message);
}
return(true);
}
public async Task <ActionResult> GetBuscaConductor(string id)
{
//string id = "mRe3vsjLrnapslgaMWWqKDVBphJ3";
var firebase = new Firebase.Database.FirebaseClient("https://fir-app-cf755.firebaseio.com/");
var conductores = (await firebase
.Child("Conductores")
.OrderByKey()
.OnceAsync <Conductor>()).Where(x => x.Object.id_conductor == id).ToList();
var conductores2 = (await firebase
.Child("Conductores")
.OrderByKey()
.OnceAsync <Conductor>()).ToList().Find(x => x.Object.id_conductor == id);
var lista = new List <Conductor>();
// return Json(lista, JsonRequestBehavior.AllowGet);
var list = new List <Conductor>();
// var query=list.Where() .OnceAsync<ClsUsuarios>()).Where(a => a.Object.cargo_usuario == "Abogado").ToList(); // parabuscar segun el tipo
foreach (var dino in conductores)
{
Conductor o = new Conductor();
o.nombres_conductor = dino.Object.nombres_conductor;
list.Add(o);
}
// return View(list);
string ser = (new System.Web.Script.Serialization.JavaScriptSerializer()).Serialize(conductores2);
return(Json(conductores2, JsonRequestBehavior.AllowGet));
}
private async void ContentService_Published(Umbraco.Core.Publishing.IPublishingStrategy sender, PublishEventArgs <IContent> e)
{
foreach (var content in e.PublishedEntities.Where(c => c.ContentType.Alias.Equals("question")).Where(c => c.WasPropertyDirty("Id")))
{
var umbracoHelper = new Umbraco.Web.UmbracoHelper(Umbraco.Web.UmbracoContext.Current);
var node = umbracoHelper.TypedContent(content.Id);
var question = (string)node.GetProperty("questionaire").Value;
var category = (string)node.GetProperty("category").Value;
var listAnswer = (IEnumerable <IPublishedContent>)node.GetProperty("listAnswer").Value;
var client = new Firebase.Database.FirebaseClient("https://qcmapp-4d7b3.firebaseio.com/");
var categoryFirebase = await client.Child("category").OrderBy("name").EqualTo(category).LimitToFirst(1).OnceAsync <Category>();
var catId = categoryFirebase.First().Key;
var data = await client.Child("question").PostAsync(new Question {
CategoryId = catId, Value = question
});
foreach (var list in listAnswer)
{
//listAns = new List<Listanswer>();
var answer = (string)list.GetProperty("answer").Value;
var isTrue = (bool)list.GetProperty("isTrueAnswer").Value;
await client.Child("reponse").PostAsync(new Reponse {
QuestionId = data.Key, Value = answer, IsTrue = isTrue
});
}
}
}
public async Task <ActionResult> Remove(string plantName, string currentUser)
{
var del = new Firebase.Database.FirebaseClient("https://clddb-a63b0-default-rtdb.firebaseio.com/");
await del.Child("Garden")
.Child(currentUser)
.DeleteAsync();
return(View());
}
public async Task <ActionResult> Index(string currentUser)
{
//download from firebase
var client2 = new Firebase.Database.FirebaseClient("https://clddb-a63b0-default-rtdb.firebaseio.com/");
//Retrieve data from Firebase
var nameList = new List <string>();
var locList = new List <string>();
var inList = new List <string>();
var outList = new List <string>();
var UserList = new List <string>();
if (currentUser == null)
{
var dbPlants = await client2
.Child("Garden")
.Child("default")
.OnceAsync <InfoContext>();
//Convert JSON data to original datatype
foreach (var i in dbPlants)
{
nameList.Add(i.Object.Name);
locList.Add(i.Object.Location);
inList.Add(i.Object.DateIn);
outList.Add(i.Object.DateOut);
UserList.Add(i.Object.CurrentUser);
}
}
else
{
var dbPlants = await client2
.Child("Garden")
.Child(currentUser)
.OnceAsync <InfoContext>();
//Convert JSON data to original datatype
foreach (var i in dbPlants)
{
nameList.Add(JsonConvert.ToString(i.Object.Name).ToString().Trim('"'));
locList.Add(JsonConvert.ToString(i.Object.Location).ToString().Trim('"'));
inList.Add(JsonConvert.ToString(i.Object.DateIn).ToString().Trim('"'));
outList.Add(JsonConvert.ToString(i.Object.DateOut).ToString().Trim('"'));
UserList.Add(JsonConvert.ToString(i.Object.CurrentUser).ToString().Trim('"'));
}
}
ViewBag.NameList = nameList;
ViewBag.LocList = locList;
ViewBag.InList = inList;
ViewBag.OutList = outList;
return(View());
}
static void Main(string[] args)
{
var client = new Firebase.Database.FirebaseClient("https://edugeo-37a7c-default-rtdb.firebaseio.com/", null);
var root = client.Child("Escuelas/");
var db = new EdugeoModel();
foreach (var item in db.Escuelas.OrderBy(i => i.Id).Include(i => i.GeoMarker).Where(i => i.GeoMarker != null).ToList())
{
var result = root.PostAsync(item).Result;
}
root.Dispose();
}
public async Task <List <Papeleta> > Lista_Papeletas(string id_usuario)
{
var firebase = new Firebase.Database.FirebaseClient("https://fir-app-cf755.firebaseio.com/");
return((await firebase
.Child("MisPapeletas").Child(id_usuario)
.OnceAsync <Papeleta>()).Select(item => new Papeleta
{
estado_deuda = item.Object.estado_deuda,
fecha = item.Object.fecha,
importe = item.Object.importe,
propietario = item.Object.propietario,
conductor = item.Object.conductor
}).ToList());
}
public async Task<List<Solicitudes>> Lista_Solicitudes(string id_usuario)
{
var firebase = new Firebase.Database.FirebaseClient("https://fir-app-cf755.firebaseio.com/");
return (await firebase
.Child("Solicitudes").Child(id_usuario)
.OnceAsync<Solicitudes>()).Select(item => new Solicitudes
{
nombre_usuario = item.Object.nombre_usuario,
token=item.Object.token,
estado=item.Object.estado,
dni_usuario=item.Object.dni_usuario,
img_usuario=item.Object.img_usuario,
id_usuario=item.Object.id_usuario
}).ToList();
}
public async Task <List <Usuario> > ListaTaxista()
{
var firebase = new Firebase.Database.FirebaseClient("https://fir-app-cf755.firebaseio.com/");
return((await firebase
.Child("Usuarios")
.OnceAsync <Usuario>()).Select(item => new Usuario
{
nombre_usuario = item.Object.nombre_usuario,
apellido_usuario = item.Object.apellido_usuario,
dni_usuario = item.Object.dni_usuario,
image_usuario = item.Object.image_usuario,
correo_usuario = item.Object.correo_usuario,
token = item.Object.token,
id_usuario = item.Object.id_usuario
}).ToList());
}
public async Task <List <Publicacion> > Lista_Publicacion()
{
var firebase = new Firebase.Database.FirebaseClient("https://fir-app-cf755.firebaseio.com/");
return((await firebase
.Child("Publicaciones")
.OnceAsync <Publicacion>()).Select(item => new Publicacion
{
key_noticia = item.Object.key_noticia,
titulo = item.Object.titulo,
descripcion_noticia = item.Object.descripcion_noticia,
img_noticia = item.Object.img_noticia,
fecha_noticia = item.Object.fecha_noticia,
key_usuario = item.Object.key_usuario,
contador = item.Object.contador
}).ToList());
}
private void DataTypeService_Saving(IDataTypeService sender, SaveEventArgs <Umbraco.Core.Models.IDataTypeDefinition> e)
{
foreach (var dt in e.SavedEntities.Where(dt => dt.Name.Equals("Question - category - Dropdown list")))
{
var dtService = ApplicationContext.Current.Services.DataTypeService;
var list = dtService.GetPreValuesByDataTypeId(dt.Id);
var client = new Firebase.Database.FirebaseClient("https://qcmapp-4d7b3.firebaseio.com/");
var child = client.Child("category").PostAsync(new Category {
Name = list.Last()
});
// var reponse= child.PatchAsync<Question>();
/* foreach(var item in list)
* {
* //item.Value.
* }*/
}
}
public async Task <bool> SetMensaje(SubChat o)
{
try
{
var firebase = new Firebase.Database.FirebaseClient("https://fir-app-cf755.firebaseio.com/");
await firebase
.Child("SubChat2").Child(o.id_usuario).Child(o.id_empresa)
.PutAsync(new SubChat()
{
id_empresa = o.id_empresa, nombre_usuario = o.nombre_usuario, mensaje = o.mensaje, id_usuario = o.id_usuario, fecha = DateTime.Now.ToLongDateString(), image_usuario = o.image_usuario
});
}
catch (Exception ex)
{
// ModelState.AddModelError(string.Empty, ex.Message);
}
return(true);
}
public async Task <ActionResult> About(string name, string location, string dateIn, string dateOut, string currentUser)
{
// upload to firebase <----this works
var currentTestData = new InfoContext()
{
Name = name,
Location = location,
DateIn = dateIn,
DateOut = dateOut,
CurrentUser = currentUser
};
var client = new Firebase.Database.FirebaseClient("https://clddb-a63b0-default-rtdb.firebaseio.com/");
await client
.Child("Garden")
.Child(currentUser)
.PostAsync(currentTestData);
return(View());
}
public async Task <bool> SetNotificaion(Notificacion o)
{
try
{
var firebase = new Firebase.Database.FirebaseClient("https://fir-app-cf755.firebaseio.com/");
var Key = Firebase.Database.FirebaseKeyGenerator.Next();
//o.estado_producto = "NoPublico";
await firebase
.Child("MisNotificaciones").Child(o.id_usuario).Child(Key)
.PutAsync(new Notificacion()
{
nombre_empresa = o.nombre_empresa, image_empresa = o.image_empresa, fecha = DateTime.Now.ToString(), mensaje = o.mensaje, detalle = o.detalle, ruta_documento = o.ruta_documento, estado = o.estado
});
}
catch (Exception ex)
{
// ModelState.AddModelError(string.Empty, ex.Message);
}
return(true);
}
public async Task Add(VehiculoConductor obj, string id)
{
var data = obj;
client = new FireSharp.FirebaseClient(config);
var firebase = new Firebase.Database.FirebaseClient("https://fir-app-cf755.firebaseio.com/");
// PushResponse response = client.Push("VehiculoConductor/", data);
// var key = response.Result.name;
await firebase
.Child("VehiculoConductor").Child(id)
.PostAsync(new VehiculoConductor()
{
id_conductor = obj.id_conductor, id_vehiculo = obj.id_vehiculo
});
await firebase
.Child("VehiculoConductor2")
.PostAsync(new VehiculoConductor()
{
id_conductor = obj.id_conductor, nombre_conductor = obj.nombre_conductor, id_vehiculo = obj.id_vehiculo, nombre_vehiculo = obj.nombre_vehiculo, fecha = DateTime.Now.ToShortDateString(), estado = obj.estado
});
}
// public ActionResult Index()
//{
// return View(o);
// }
public async Task <ActionResult> Index()
{
string id = LoginController.id_user;
var firebase = new Firebase.Database.FirebaseClient("https://fir-app-cf755.firebaseio.com/");
var dinos = await firebase
.Child("Archivos").Child(id)
.OrderByKey()
.OnceAsync <Carpetas>();
var list = new List <Carpetas>();
foreach (var dino in dinos)
{
Carpetas o = new Carpetas();
o.id_carpeta = dino.Object.id_carpeta;
o.nombre_carpeta = dino.Object.nombre_carpeta;
list.Add(o);
}
return(View(list));
}
public MainPageViewModel(INavigationService navigationService)
{
_navigationService = navigationService;
StartCommand = new DelegateCommand(async() =>
{
Output = "建立與 Firebase 連線";
var client = new Firebase.Database.FirebaseClient("https://xamarindb-3408d.firebaseio.com");
var child = client.Child("MyMoneys");
Output = Environment.NewLine + Environment.NewLine + "刪除掉所有的資料";
await child.DeleteAsync();
Console.WriteLine("產生 10 筆購物紀錄");
for (int i = 1; i < 10; i++)
{
await child.PostAsync <MyMoney>(new MyMoney()
{
Id = Guid.NewGuid(),
Title = $"冷泡茶 {i} 瓶",
InvoiceNo = $"0000 {i}",
Cost = 20 * i,
});
}
Output += Environment.NewLine + Environment.NewLine + "列出 Firebase 中所有的紀錄";
var fooPosts = await child.OnceAsync <MyMoney>();
foreach (var item in fooPosts)
{
Output += Environment.NewLine + $"購買商品:{item.Object.Title} 價格:{item.Object.Cost}";
}
Output += Environment.NewLine + Environment.NewLine + "查詢購物價格小於 90 的紀錄";
var fooRec = fooPosts.Where(x => x.Object.Cost <= 90);
foreach (var item in fooRec)
{
Output += Environment.NewLine + $"購買商品:{item.Object.Title} 價格:{item.Object.Cost}";
}
Output += Environment.NewLine + Environment.NewLine + "刪除購物價格小於 90 的紀錄";
var fooRecDeleted = fooPosts.Where(x => x.Object.Cost <= 90);
foreach (var item in fooRecDeleted)
{
await child.Child(item.Key).DeleteAsync();
Output += Environment.NewLine + $"購買商品:{item.Object.Title} 價格:{item.Object.Cost} 已經被刪除";
}
Output += Environment.NewLine + Environment.NewLine + "列出 Firebase 中所有的紀錄";
fooPosts = await child.OnceAsync <MyMoney>();
foreach (var item in fooPosts)
{
Output += Environment.NewLine + $"購買商品:{item.Object.Title} 價格:{item.Object.Cost}";
}
Output += Environment.NewLine + Environment.NewLine + "查詢購物價格等於 140 的紀錄";
var foo140Rec = fooPosts.FirstOrDefault(x => x.Object.Cost == 140);
foo140Rec.Object.Cost = 666;
await child.Child(foo140Rec.Key).PutAsync(foo140Rec.Object);
Output += Environment.NewLine + $"購買商品:{foo140Rec.Object.Title} 的價格已經修正為 價格:{foo140Rec.Object.Cost}";
Output += Environment.NewLine + Environment.NewLine + "列出 Firebase 中所有的紀錄";
fooPosts = await child.OnceAsync <MyMoney>();
foreach (var item in fooPosts)
{
Output += Environment.NewLine + $"購買商品:{item.Object.Title} 價格:{item.Object.Cost}";
}
});
}
