public ActionResult Create([FromBody] Transaction transaction) { FirebaseResponse countGetResponse = client.Get("AI"); if (countGetResponse.Body == "null") { SetResponse countSet = client.Set("AI/Count", 0); countGetResponse = client.Get("AI"); } AutoIncrement countInstance = countGetResponse.ResultAs <AutoIncrement>(); transaction.Id = countInstance.Count; SetResponse transactionResponse = client.Set("Transaction/" + countInstance.Count, transaction); countInstance.Count++; FirebaseResponse countUpdateResponse = client.Update("AI", countInstance); return(new ObjectResult(transaction)); }
public List <KeyFire> GetListKeyFire() { fb.Init(); List <KeyFire> temp = new List <KeyFire>(); FirebaseResponse res = CommonConstants.client.Get(@"OrderInfo"); // string a = "{"21614268331423101":{"date":"22:52:11 25 - 02 - 2021","id":"0","idCus":"2","listfoodid":"11","listprice":"25000","listquan":"1","status":"0"},"21614920686884296":{"date":"23:04:46 04 - 03 - 2021","id":"1","idCus":"2","listfoodid":"13,11,19","listprice":"25000,25000,25000","listquan":"9,1,1","status":"2"}}"; Dictionary <string, Dictionary <string, Order> > data = JsonConvert.DeserializeObject <Dictionary <string, Dictionary <string, Order> > >(res.Body.ToString()); foreach (var item in data) { for (int i = 0; i < item.Value.Count; i++) { KeyFire k = new KeyFire(item.Value.ElementAt(i).Key, item.Value.ElementAt(i).Value.Code); temp.Add(k); } } return(temp); }
public async void mesajGonder(Mesajlar mesaj) { try { response = await client.GetTaskAsync("sayac"); Sayac sayac = response.ResultAs <Sayac>(); int _id = sayac.mesajSayisi; mesaj.id = _id; mesaj.icerik = sf.Sifrele(mesaj.icerik); sayac.mesajSayisi++; response = await client.SetTaskAsync("mesajlar/" + _id.ToString(), mesaj); response = await client.SetTaskAsync("sayac", sayac); } catch { MessageBox.Show("Mesaj gönderilemedi bro ! \n İnternet bağlantını bi kontrol edebilir misin sana zahmet !", "Mesaj Gönderilemedi !", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
public override long GetListCount(string key) { if (key == null) { throw new ArgumentNullException(nameof(key)); } QueryBuilder builder = QueryBuilder.New($@"equalTo=""{key}"""); builder.OrderBy("key"); FirebaseResponse response = Client.Get("lists", builder); if (response.StatusCode == HttpStatusCode.OK && !response.IsNull()) { Dictionary <string, List> lists = response.ResultAs <Dictionary <string, List> >(); return(lists.LongCount()); } return(default(long)); }
private async void btnCambios_Click(object sender, EventArgs e) { Cursor = Cursors.WaitCursor; timer1.Start(); var datosDoc = new Doctor { Id = IdOriginal, Nombre = txtnom.Text, Telefono = txtape.Text, Especialidad = cmbesp.Text, Horarios = "Autogenerado" }; FirebaseResponse response = await client.UpdateTaskAsync("Doctores/" + IdOriginal, datosDoc); Doctor result = response.ResultAs <Doctor>(); MessageBox.Show("Información actualizada correctamente" + result.Id); btnagregar.Enabled = true; exportar(); }
public override List <string> GetAllItemsFromList(string key) { if (key == null) { throw new ArgumentNullException(nameof(key)); } QueryBuilder builder = QueryBuilder.New($@"equalTo=""{key}"""); builder.OrderBy("key"); FirebaseResponse response = Client.Get("lists", builder); if (response.StatusCode == HttpStatusCode.OK && !response.IsNull()) { Dictionary <string, List> lists = response.ResultAs <Dictionary <string, List> >(); return(lists.Select(l => l.Value).Select(l => l.Value).ToList()); } return(new List <string>()); }
public override List <string> GetRangeFromSet(string key, int startingFrom, int endingAt) { if (key == null) { throw new ArgumentNullException(nameof(key)); } QueryBuilder builder = QueryBuilder.New($@"equalTo=""{key}"""); builder.OrderBy("key"); FirebaseResponse response = Client.Get("sets", builder); if (response.StatusCode == HttpStatusCode.OK && !response.IsNull()) { Dictionary <string, Set> collections = response.ResultAs <Dictionary <string, Set> >(); return(collections.Skip(startingFrom).Take(endingAt).Select(c => c.Value).Select(s => s.Value).ToList()); } return(new List <string>()); }
/// <summary> /// Retrieve all borrows info then store them to a list /// </summary> /// <returns></returns> public List <Borrow_Data> retrieve_all_borrows() { //create a list to store data List <Borrow_Data> borrow_list = new List <Borrow_Data>(); //get all the data, then transfer them to a dictionnary variable FirebaseResponse response = client.Get(sBorrowTable_path); Dictionary <string, Borrow_Data> all_data = new Dictionary <string, Borrow_Data>(); if (response.Body != "null") { all_data = response.ResultAs <Dictionary <string, Borrow_Data> >(); } foreach (var user in all_data) { borrow_list.Add(user.Value); } return(borrow_list); }
public List <ResultadosDetalle> ResultadosDetalleList(Guid ResultadoID) { Settings settings = new Settings(); var data = new List <ResultadosDetalle>(); client = new FireSharp.FirebaseClient(config); if (client != null) { FirebaseResponse response = client.Get("ACTFResultDetalle/" + ResultadoID.ToString()); var json = response.Body; if (json != null && json != "null") { JavaScriptSerializer j = new JavaScriptSerializer(); object Data = j.Deserialize(json, typeof(object)); data = JsonConvert.DeserializeObject <List <ResultadosDetalle> >(json); } } return(data); }
protected void Button1_Click(object sender, EventArgs e) { #region Condition if (string.IsNullOrWhiteSpace(TextBox1.Text) || string.IsNullOrWhiteSpace(TextBox2.Text)) { Response.Write("<script>alert('Please Fill All The Field')</script>"); return; } #endregion try { var res1 = client.Get(@"Doctors/"); MyAppointment ResAppointment = res1.ResultAs <MyAppointment>(); if (ResAppointment != null) { counter = ResAppointment.counter; } for (int i = 1; counter > i; i++) { FirebaseResponse res = client.Get(@"Doctors/" + i); MyAppointment ResUser = res.ResultAs <MyAppointment>(); //database result MyAppointment CurUser = new MyAppointment() //USER GIVEN INFO { Username = TextBox1.Text, Password = TextBox2.Text }; if (MyAppointment.IsEqual(ResUser, CurUser)) { Response.Write("<script>alert('Successfully login!')</script>"); Response.Redirect("WebForm7.aspx"); } } Response.Write("<script>alert('Username and Password does not match!')</script>"); } catch { Response.Write("<script>alert('User does not exist!')</script>"); } }
private async void ranking_Load(object sender, EventArgs e) { foreach (DataGridViewColumn column in dataGridView2.Columns) { column.SortMode = DataGridViewColumnSortMode.NotSortable; } int i = 0; loadgrid2(); loadgrid1(); IFirebaseClient client = new FireSharp.FirebaseClient(config); this.dataGridView1.Sort(this.dataGridView1.Columns["Nilai Akhir"], ListSortDirection.Descending); FirebaseResponse response = await client.GetTaskAsync("Counter"); counter ctn = response.ResultAs <counter>(); while (true) { i++; if (i > ctn.M) { break; } FirebaseResponse responseNilai = await client.GetTaskAsync("Penilaian/" + i); Penilaian obj = responseNilai.ResultAs <Penilaian>(); DataRow dr = dt2.NewRow(); dr["Nama"] = obj.nama; dr["NIP"] = obj.nip; dr["Dokumen Portofolio"] = obj.C5; dr["Kinerja Guru"] = obj.C2; dr["Presentasi Best Practice"] = obj.C3; dr["Wawancara"] = obj.C4; dr["Test Tulis"] = obj.C1; dt2.Rows.Add(dr); } }
private async void SentBtn_ClickAsync(object sender, EventArgs e) { MemoryStream ms = new MemoryStream(); pictureBox1.Image.Save(ms, ImageFormat.Jpeg); byte[] a = ms.GetBuffer(); string output = Convert.ToBase64String(a); FirebaseResponse StationPic = await Client.GetTaskAsync("Stationn/" + TbIDstation.Text); Data PicCount = StationPic.ResultAs <Data>(); int i = PicCount.CountPIC + 1; int j = PicCount.ImgHis + 1; var Data = new Image_Model { ImageID = "Img" + j, Img = output, TypeName = TypeTB.Text }; Console.WriteLine("Station/" + TbIDstation.Text); Console.WriteLine(" Pic total : " + PicCount.CountPIC); var PicStation = new DataPic { CountPIC = i, ImgHis = j }; SetResponse response2 = await Client.SetTaskAsync("Stationn/" + TbIDstation.Text, PicStation); SetResponse response3 = await Client.SetTaskAsync("Stationn/" + TbIDstation.Text + "/Img" + i, Data); Image_Model result = response3.ResultAs <Image_Model>(); var datashowref = new Image_Model { ImageID = "Img" + j }; Client.Set("Stationn/" + TbIDstation.Text + "/Showref/" + i, datashowref); ReDt(); }
public async Task <List <Promotion> > GetPromotions() { List <Promotion> promotions = new List <Promotion>(); try { //TODO: Check for internet connection... FirebaseResponse response = await Client.GetAsync("promotions"); if (response == null) { return(promotions); } if (string.IsNullOrEmpty(response.Body)) { return(promotions); } var jsonResponse = response.Body; var jsonObject = JObject.Parse(jsonResponse); foreach (var item in jsonObject) { var promotion = await Task.Run(() => JsonConvert.DeserializeObject <Promotion>(item.Value.ToJson())); if (promotion == null) { continue; } promotions.Add(promotion); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(promotions); }
private async void btnDeleteAll_expense_Click(object sender, EventArgs e) { FirebaseResponse delete1 = await client.DeleteTaskAsync($"Count for Totalexpense:{labelmonth.Text}"); FirebaseResponse delete2 = await client.DeleteTaskAsync($"Count for eatexpense:{labelmonth.Text}"); FirebaseResponse delete3 = await client.DeleteTaskAsync($"Count for eduexpense:{labelmonth.Text}"); FirebaseResponse delete4 = await client.DeleteTaskAsync($"Count for etcexpense:{labelmonth.Text}"); FirebaseResponse delete5 = await client.DeleteTaskAsync($"Expense:{labelmonth.Text}"); var node_out1 = new start_MonthOutAll { Number = Convert.ToString(0), }; SetResponse node1 = await client.SetTaskAsync($"Start_OutAll:{labelmonth.Text}", node_out1); var node_out2 = new start_MonthOutEat { Number = Convert.ToString(0), }; SetResponse node2 = await client.SetTaskAsync($"Start_OutEat:{labelmonth.Text}", node_out2); var node_out3 = new start_MonthOutEat { Number = Convert.ToString(0), }; SetResponse node3 = await client.SetTaskAsync($"Start_OutEdu:{labelmonth.Text}", node_out3); var node_out4 = new start_MonthOutEat { Number = Convert.ToString(0), }; SetResponse node4 = await client.SetTaskAsync($"Start_OutEtc:{labelmonth.Text}", node_out4); Totalexpense = 0; Newexpense_eat = 0; Newexpense_edu = 0; Newexpense_etc = 0; }
private async void updateInvoice() { try { FirebaseResponse resp = await client.GetTaskAsync("invoices/"); Dictionary <string, Products_class> dict = resp.ResultAs <Dictionary <string, Products_class> >(); //Adding product keys to Array Keys foreach (KeyValuePair <string, Products_class> ele1 in dict) { keys.Add(ele1.Key); } //traversing list keys to fetch product details for (int i = 0; i < keys.Count; i++) { FirebaseResponse resp2 = await client.GetTaskAsync("invoices/" + keys[i]); Invoices_class invoice = resp2.ResultAs <Invoices_class>(); invoicesList.Add(invoice); //Adding firebase data to the data grid DataRow row = dt.NewRow(); row["Invoice #"] = invoicesList[i].invoiceNo; row["Cashier"] = invoicesList[i].cashier; row["TimeStamp"] = invoicesList[i].timestamp; row["Total Bill"] = invoicesList[i].totalBill; dt.Rows.Add(row); // Console.WriteLine("Row added"); } } catch (Exception) { MessageBox.Show("Connectivity Error.\nCheck your INTERNET and try again."); } }
private void Chart_Load(object sender, EventArgs e) { FirebaseDB firebaseDB = new FirebaseDB("https://mobile-shoebox.firebaseio.com/"); FirebaseDB firebaseDBItem = firebaseDB.Node("restock_store"); FirebaseResponse getResponse = firebaseDBItem.Get(); JObject stuff = JObject.Parse(getResponse.JSONContent); //MessageBox.Show(getResponse.JSONContent); String tgl_akhir = Properties.Settings.Default.tgl_akhir_cs; String tgl_awal = Properties.Settings.Default.tgl_awal_cs; IEnumerable <JToken> data_item = stuff.SelectTokens("$..[?(@.tanggal_masuk >= '" + tgl_awal + "' && @.tanggal_masuk < '" + tgl_akhir + "' )].item"); foreach (JToken item in data_item) { //MessageBox.Show(item.ToString()); if (item.ToString().Equals("Cat Speatu")) { x++; } else if (item.ToString().Equals("Sol")) { y++; } else if (item.ToString().Equals("Sabun Sepatu")) { z++; } else if (item.ToString().Equals("Sabun Helm")) { a++; } else if (item.ToString().Equals("Pewangi")) { b++; } else if (item.ToString().Equals("Sikat")) { c++; } } fillChart(x, y, z, a, b, c); }
private async void UpdateExpense_delete() { FirebaseResponse value_out = await client.GetTaskAsync($"Count for Totalexpense:{labelmonth.Text}/node"); Count_Expense get_out = value_out.ResultAs <Count_Expense>(); var expense = new ExpenseTotal { //รับค่า income-All มาและเมื่อกดปุ่ม นำไปลบอีก 1 เสมอ จากนั้นก็แปลงให้อยู่ในรูปสตริง Number = (Convert.ToInt32(get_out.expense_All) - 1).ToString(), Detail = detailtxt.Text, Expense = expensetxt.Text, // จำนวนเงินของรายรับ }; var obj_amount = new Count_Expense { expense_All = expense.Number, Total_expense = Totalexpense }; int i = Convert.ToInt32(Numbertxt.Text); while (i <= Convert.ToInt32(obj_amount.expense_All) + 1) { try { FirebaseResponse response_loop = await client.GetTaskAsync($"Expense:{labelmonth.Text}/order" + (i + 1)); ExpenseTotal obj_loop = response_loop.ResultAs <ExpenseTotal>(); var expense_loop = new ExpenseTotal { Number = Convert.ToString(i), Detail = obj_loop.Detail, // รายการที่ได้รับ Expense = obj_loop.Expense, // จำนวนเงินของรายรับ Type = obj_loop.Type }; SetResponse resincome3 = await client.SetTaskAsync($"Expense:{labelmonth.Text}/order" + i, expense_loop); } catch { } i++; } FirebaseResponse response2 = await client.DeleteTaskAsync($"Expense:{labelmonth.Text}/order" + (Convert.ToInt32(obj_amount.expense_All) + 1).ToString()); }
// Insert Data In FireBase DataBase ... // public async void FireBase_Insert(List <Account_Detail> Detail) { IFirebaseConfig Config = new FirebaseConfig { AuthSecret = "VH1rdiDgj2hzD0WN5JZ67BSXTN7OdOeM0fnry50G", BasePath = "https://ctm-db.firebaseio.com/" }; IFirebaseClient Client = new FireSharp.FirebaseClient(Config); int Number_Detail = Detail.Count; FirebaseResponse CounterRespose = await Client.GetTaskAsync("Number_Account_Detail/" + "Now"); FireBase_Account_Detail_Counter Data = CounterRespose.ResultAs <FireBase_Account_Detail_Counter>(); string Counter_Value = Data.Counter; for (int i = 0; i < Number_Detail; i++) { var Account_Detail = new FireBase_Account_Detail { Account_Id = Detail[i].Get_Account_Id(), Student_Name = Detail[i].Get_Student_Name(), Class = Detail[i].Get_Class(), Study_Fee = Detail[i].Get_Study_Fee(), Registration_Fee = Detail[i].Get_Registration_Fee(), Transportaion_Fee = Detail[i].Get_Transportaion_Fee(), Extra_Fee = Detail[i].Get_Extra_Fee(), Total = Detail[i].Get_Total() }; SetResponse Respose = await Client.SetTaskAsync("Account_Detail/" + Counter_Value, Account_Detail); Counter_Value = (int.Parse(Counter_Value) + 1).ToString(); } Update_Counter(Counter_Value); return; }
private void btnLogar_Click(object sender, EventArgs e) { FirebaseResponse response = client.Get(@"usuario/" + txtMatricula.Text); Teste usuario = JsonConvert.DeserializeObject <Teste>(response.Body); var usuarioTela = new Teste { matricula = txtMatricula.Text, senha = txtSenha.Text }; if (Teste.isEqual(usuario, usuarioTela)) { Menu menu = new Menu(); menu.ShowDialog(); } else { MessageBox.Show(Teste.erro); } }
public IHttpActionResult update([FromBody] Customer c) { string uu = c.Id.Replace(".", ","); FirebaseDB firebaseDB = new FirebaseDB("https://myshop-b8424.firebaseio.com/"); FirebaseDB firebaseDBTeams = firebaseDB.Node("Users").NodePath(uu); FirebaseResponse getResponse = firebaseDBTeams.Get(); if (Convert.ToString(getResponse.JSONContent) != "null") { FirebaseResponse putResponse = firebaseDBTeams.Patch(JsonConvert.SerializeObject(c)); return(Ok("Updated Successfully")); } else { return(BadRequest("User is not Registered with this Email Id")); } }
public void DecrementCounter(string key) { if (string.IsNullOrEmpty(key)) { throw new ArgumentNullException(nameof(key)); } QueueCommand(() => { Counter data = new Counter { Value = -1 }; FirebaseResponse response = connection.Client.Push($"counters/raw/{key}", data); if (response.StatusCode != HttpStatusCode.OK) { throw new HttpRequestException(response.Body); } }); }
private bool kiemtraEmail(string email) { client = new FireSharp.FirebaseClient(config); FirebaseResponse response = client.Get("User"); dynamic data = JsonConvert.DeserializeObject <dynamic>(response.Body); var list = new List <User>(); string err = ""; foreach (var item in data) { list.Add(JsonConvert.DeserializeObject <User>(((JProperty)item).Value.ToString())); } foreach (var item in list) { if (item.Email == email) { return(true); } } return(false); }
public async Task <ActionResult> RetrieveApartmentData([FromBody] ApartmentData apartment) { client = new FireSharp.FirebaseClient(iconfig); FirebaseResponse response = await client.GetTaskAsync("OSBB/" + apartment.osbb_id + "/Apartments/" + apartment.apartment_num); ApartmentData obj = response.ResultAs <ApartmentData>(); return(StatusCode (200, new { osbb_id = obj.osbb_id, apartment_num = obj.apartment_num, apartment_owner_uid = obj.apartment_owner_uid, area_of_apartment = obj.area_of_apartment, floor_num = obj.floor_num, entrance_num = obj.entrance_num //data } )); }
private async void btnConnect_Click(object sender, EventArgs e) { //State bağlantı durumunu kontrol etmek için kullanılan bool yapısı state = true; //Client başlatma client = new FireSharp.FirebaseClient(Config); if (client != null) { MessageBox.Show("Bağlantı işlemi başarılı"); } //state true olduğu sürece Firebaseden her an veri alımı yapılır //Veriler Data internal classı yardımıyla çekilir //Alınan veri charta yazılır while (state) { FirebaseResponse response = await client.GetTaskAsync(""); Data obj = response.ResultAs <Data>(); chart1.Series[0].Points.AddY(obj.number); } }
public async void listaRetete() { this.listRetete.Clear(); FirebaseResponse idResponse = await client.GetAsync("Counter/RetCNT"); Counter get = idResponse.ResultAs <Counter>(); nrRetete = get.nr; for (int i = 1; i <= get.nr; i++) { FirebaseResponse ReteteResp = await client.GetAsync("Retete/" + i.ToString()); Reteta ret = ReteteResp.ResultAs <Reteta>(); if (ret != null) { this.listRetete.Add(ret); } } this.l4 = true; }
private async void getirButon_Click(object sender, EventArgs e) { FirebaseResponse response = await client.GetTaskAsync("Elemanlar/" + textBoxIDGetir.Text); try { Data obj = response.ResultAs <Data>(); textBoxAdSoyadGetir.Text = obj.adSoyad; textBoxDepartmanGetir.Text = obj.departman; textBoxGelirGetir.Text = obj.aylıkGelir; textBoxTelefonGetir.Text = obj.telefonNo; textBoxMailGetir.Text = obj.mailAdres; MessageBox.Show("Eleman Getirildi", "Eleman Islemleri"); } catch (Exception) { MessageBox.Show("Bu ID'ye sahip kullanici bulunmamaktadir!", "Eleman Islemleri"); } }
public IList <ServerDto> Servers() { List <ServerDto> servers = new List <ServerDto>(); FirebaseResponse response = connection.Client.Get("servers"); if (response.StatusCode == HttpStatusCode.OK && !response.IsNull()) { Dictionary <string, Entities.Server> collections = response.ResultAs <Dictionary <string, Entities.Server> >(); servers = collections?.Select(s => new ServerDto { Name = s.Value.ServerId, Heartbeat = s.Value.LastHeartbeat, Queues = s.Value.Queues, StartedAt = s.Value.CreatedOn, WorkersCount = s.Value.Workers }).ToList(); } return(servers); }
private async void btneliminar_Click(object sender, EventArgs e) { Cursor = Cursors.WaitCursor; timer1.Start(); var resultado4 = MessageBox.Show("Seguro que desea eliminar esta información", "Información", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (resultado4 == DialogResult.OK) { string id = dgvAdminUs.SelectedRows[0].Cells["ID"].Value.ToString(); string Nombre = dgvAdminUs.SelectedRows[0].Cells["Nombre"].Value.ToString(); string Usuario = dgvAdminUs.SelectedRows[0].Cells["Usuario"].Value.ToString(); string Contraseña = dgvAdminUs.SelectedRows[0].Cells["Contraseña"].Value.ToString(); string Tipo = dgvAdminUs.SelectedRows[0].Cells["Tipo"].Value.ToString(); string Dui = dgvAdminUs.SelectedRows[0].Cells["Dui"].Value.ToString(); FirebaseResponse response = await client.DeleteTaskAsync("Usuarios/" + id); MessageBox.Show(" Se ha borrado correctamente " + id); exportar(); } }
//Funtii de introducere in lista de elemente pentru fiecare tabel public async void listaProduse() { this.lista.Clear(); FirebaseResponse idResponse = await client.GetAsync("Counter/ProdCNT"); Counter get = idResponse.ResultAs <Counter>(); nrProduse = get.nr; for (int i = 1; i <= get.nr; i++) { FirebaseResponse prodResp = await client.GetAsync("Produse/" + i.ToString()); Data dt = prodResp.ResultAs <Data>(); if (dt != null) { this.lista.Add(dt); } } l1 = true; }
private async void ButtonLoad_ClickAsync(object sender, EventArgs e) { try { FirebaseResponse response = await client.GetTaskAsync( "Information/" + comboBoxName.Text); Data obj = response.ResultAs <Data>(); comboBoxName.Text = obj.Name; maskedTextBoxMobile.Text = obj.Mobile; maskedTextBoxSum.Text = obj.Sum; maskedTextBoxCard.Text = obj.Card; MessageBox.Show("Данные загружены!"); } catch { MessageBox.Show("Ошибка!\nДаное имя отсутствует!"); } }
public void enter() { //If the user has not been registed, register him if (!is_user_set) { response = client.Set(user_url, ""); } //Deliver the user details to the Firebase response = client.Update(user_url, details); //Print the response of the update Console.WriteLine(response.Body); }
public void retrivePeers() { response = client.Get(basename); local_peers_details = response.ResultAs<Dictionary<string, Dictionary<string, string>>>(); local_peers_details.Remove(username); //foreach (string outerkey in local_peers_details.Keys) //{ // Console.WriteLine(outerkey); // foreach (string inner_key in local_peers_details[outerkey].Keys) // { // Console.WriteLine("\t" + inner_key); // Console.WriteLine("\t\t" + local_peers_details[outerkey][inner_key]); // } //} }