public async void start200insertion() { string path = @"C:\Users\rikke\Dropbox\Bachelorprojekt\Data\rapport2.csv"; using (TextFieldParser csvParser = new TextFieldParser(path)) { csvParser.CommentTokens = new string[] { "#" }; csvParser.SetDelimiters(new string[] { ";" }); csvParser.HasFieldsEnclosedInQuotes = true; csvParser.ReadLine(); for (int i = 0; i < 200; i++) { string[] fields = csvParser.ReadFields(); var trackEvent = new TrackEvent { localitykey = fields[0], objectkey = fields[1], eventTime = fields[2], latitude = fields[3], longitude = fields[4], floor = fields[5], distanceMtr = fields[6], distanceFloor = fields[7], durationSec = fields[8], locationSgln = fields[9], comments = fields[10] }; FirebaseResponse getresponse = await client.GetTaskAsync("TrackEvents/" + trackEvent.objectkey); if (getresponse.Body != "null") { String jsonResponse = getresponse.Body; dynamic array = JsonConvert.DeserializeObject(jsonResponse); List <String> timestamp = new List <string>(); foreach (var var in array) { String time = var.Name; timestamp.Add(time); } if (timestamp.Count < 2) { FirebaseResponse response = await client.SetTaskAsync( "TrackEvents/" + trackEvent.objectkey + "/" + trackEvent.eventTime, trackEvent); } else { FirebaseResponse deleteTask = await client.DeleteTaskAsync( "TrackEvents/" + trackEvent.objectkey + "/" + timestamp[0]); FirebaseResponse response = await client.SetTaskAsync( "TrackEvents/" + trackEvent.objectkey + "/" + trackEvent.eventTime, trackEvent); } } else { FirebaseResponse response = await client.SetTaskAsync( "TrackEvents/" + trackEvent.objectkey + "/" + trackEvent.eventTime, trackEvent); } } } }
// xoa du lieu theo ma sinh vien private async void btx_Click(object sender, EventArgs e) { FirebaseResponse response = await client.DeleteTaskAsync("Information/" + tbMasv.Text); MessageBox.Show("Đã xóa " + tbMasv.Text); }
private async void Delete_Click(object sender, RoutedEventArgs e) { FirebaseResponse response = await client.DeleteTaskAsync("League/" + textBox1.Text); MessageBox.Show("Deleted Element of ID: " + textBox1.Text); }
public static async Task DataRemover(CallbackQuery callbackQuery) { await client.DeleteTaskAsync(callbackQuery.From.Id + "/" + callbackQuery.Data); Console.WriteLine("Data has been deleted"); }
private async void button4_Click(object sender, EventArgs e) { FirebaseResponse response = await client.DeleteTaskAsync("Information/" + textBox1.Text); MessageBox.Show("Deleted Record of ID: " + textBox1.Text); }
private async void DeleteButton_Click(object sender, EventArgs e) { FirebaseResponse response = await client.DeleteTaskAsync("Information/" + idTextBox.Text); MessageBox.Show("Data Successfully Deleted, Id as" + idTextBox.Text); }
private async void btnDelAll_Click(object sender, EventArgs e) { FirebaseResponse response = await client.DeleteTaskAsync("information/" + textBox1.Text); }
private async void DeleteButton_Click(object sender, RoutedEventArgs e) { FirebaseResponse response = await client.DeleteTaskAsync("information/" + Id.Text); }
private async void btnConfirmarCambio_Click(object sender, EventArgs e) { if (encontrados.Count != 0) { client = new FireSharp.FirebaseClient(config); var cita = new Cita { citaId = long.Parse(encontrados[seleccionado]) }; //Sección de recuperación FirebaseResponse recuperacion = await client.GetTaskAsync("PACIENTES/" + cita.citaId); Cita obj = recuperacion.ResultAs <Cita>(); switch (tipoCambio) { case 1: //CAMBIO DE FECHA //Sección de insersión var citaModificada = new Cita { day = comboDia2.Text, mounth = comboMes2.Text, year = comboAño2.Text, hora = comboHora2.Text, minuto = comboMin2.Text, citaId = long.Parse(comboAño2.Text + comboMes2.Text + comboDia2.Text + comboHora2.Text + comboMin2.Text), nombrePaciente = obj.nombrePaciente, telefonoPciente = obj.telefonoPciente, correoPaciente = obj.correoPaciente }; SetResponse response = await client.SetTaskAsync("PACIENTES/" + citaModificada.citaId, citaModificada); FirebaseResponse eliminar = await client.DeleteTaskAsync("PACIENTES/" + obj.citaId); this.Close(); break; case 2: //CAMBIO DE NOMBRE var citaModificada2 = new Cita { day = obj.day, mounth = obj.mounth, year = obj.year, hora = obj.hora, minuto = obj.minuto, citaId = obj.citaId, nombrePaciente = txtbModificacion.Text, telefonoPciente = obj.telefonoPciente, correoPaciente = obj.correoPaciente }; FirebaseResponse response2 = await client.UpdateTaskAsync("PACIENTES/" + cita.citaId, citaModificada2); this.Close(); break; case 3: //CAMBIO DE TELÉFONO var citaModificada3 = new Cita { day = obj.day, mounth = obj.mounth, year = obj.year, hora = obj.hora, minuto = obj.minuto, citaId = obj.citaId, nombrePaciente = obj.nombrePaciente, telefonoPciente = txtbModificacion.Text, correoPaciente = obj.correoPaciente }; FirebaseResponse response3 = await client.UpdateTaskAsync("PACIENTES/" + cita.citaId, citaModificada3); Cita resultado3 = response3.ResultAs <Cita>(); MessageBox.Show("Modificación realizada en" + resultado3.citaId, "BASE DE DATOS", MessageBoxButtons.OK); this.Close(); break; case 4: //CAMBIO DE CORREO var citaModificada4 = new Cita { day = obj.day, mounth = obj.mounth, year = obj.year, hora = obj.hora, minuto = obj.minuto, citaId = obj.citaId, nombrePaciente = obj.nombrePaciente, telefonoPciente = obj.telefonoPciente, correoPaciente = txtbModificacion.Text }; FirebaseResponse response4 = await client.UpdateTaskAsync("PACIENTES/" + cita.citaId, citaModificada4); Cita resultado4 = response4.ResultAs <Cita>(); this.Close(); break; } encontrados.Clear(); pacientes.Clear(); } else { MessageBox.Show("No se ha seleccionado ninguna cita."); } }
//Function that calls when delete button is clicked //Adjust depending on node that was selected private async void Delete_Click(object sender, RoutedEventArgs e) { int startID = 0; FirebaseResponse response = await client.GetTaskAsync(Node + "/" + txt1.Text); //Get instance from databse FirebaseResponse resp = await client.GetTaskAsync("Counter/" + Node); //Get amount of instances for a certain node Counter cnt = resp.ResultAs <Counter>(); //Set counter object to the response try { //Check if ID entered is valid int count = cnt.cnt; int ID = int.Parse(txt1.Text); if (ID > count || ID < 1) { MessageBox.Show(txt1.Text + " is not a valid ID"); return; } } catch (Exception ex) //Catch exception when input data is incorrect { MessageBox.Show(ex.Message + ", Check what you inserted in the Textbox"); return; } //Depending on node that is selected //Create new instance and set starting ID to the instance ID if (Node == "Coaches") { Coaches data = response.ResultAs <Coaches>(); startID = data.CoachId; } else if (Node == "Extras") { Extras data = response.ResultAs <Extras>(); startID = data.ExtraID; } else if (Node == "League") { League data = response.ResultAs <League>(); startID = data.LeagueID; } else if (Node == "Sports") { Sport data = response.ResultAs <Sport>(); startID = data.SportID; } else if (Node == "Sport Teams") { SportTeams data = response.ResultAs <SportTeams>(); startID = data.SportID; } else if (Node == "Players") { Players data = response.ResultAs <Players>(); startID = data.PlayerID; } //In order to keep unique IDs and count we had to overwrite data //This for loop goes througth all instances from the startId to the last instance in database //It overwrites the startId instance with the next instance in the database and so on //While overwriting it is changing the unique ID //If it is on the last instance then it deletes that instance for (int i = startID; i <= cnt.cnt; i++) { if (i == cnt.cnt) { FirebaseResponse delete = await client.DeleteTaskAsync(Node + "/" + cnt.cnt); cnt.cnt -= 1; resp = await client.UpdateTaskAsync("Counter/" + Node, cnt); break; } FirebaseResponse overwrite = await client.GetTaskAsync(Node + "/" + (i + 1)); if (Node == "Coaches") { Coaches data = overwrite.ResultAs <Coaches>(); data.CoachId = i; FirebaseResponse updateIndex = await client.UpdateTaskAsync(Node + "/" + i, data); } else if (Node == "Extras") { Extras data = overwrite.ResultAs <Extras>(); data.ExtraID = i; FirebaseResponse updateIndex = await client.UpdateTaskAsync(Node + "/" + i, data); } else if (Node == "League") { League data = overwrite.ResultAs <League>(); data.LeagueID = i; FirebaseResponse updateIndex = await client.UpdateTaskAsync(Node + "/" + i, data); } else if (Node == "Sports") { Sport data = overwrite.ResultAs <Sport>(); data.SportID = i; FirebaseResponse updateIndex = await client.UpdateTaskAsync(Node + "/" + i, data); } else if (Node == "Sport Teams") { SportTeams data = overwrite.ResultAs <SportTeams>(); data.TeamID = i; FirebaseResponse updateIndex = await client.UpdateTaskAsync(Node + "/" + i, data); } else if (Node == "Players") { Players data = overwrite.ResultAs <Players>(); data.PlayerID = i; FirebaseResponse updateIndex = await client.UpdateTaskAsync(Node + "/" + i, data); } } MessageBox.Show("Deleted Element of ID: " + txt1.Text); }
async void DelTableFirebase() { FirebaseResponse response = await client.DeleteTaskAsync("Tables/L1/B" + idTable); }
private async void BtnDelete_Click(object sender, EventArgs e) { FirebaseResponse response = await client.DeleteTaskAsync("Micro/" + txtMicroName.Text); MessageBox.Show("Deletado com sucesso!"); }
private async void Button4_Click(object sender, EventArgs e) { FirebaseResponse response = await client.DeleteTaskAsync("Cliente/" + textBoxId.Text); MessageBox.Show("Registro eliminado correctamente"); }
private async void btnDelete_Click(object sender, EventArgs e) { int parsedValue; if (!int.TryParse(Numbertxt.Text, out parsedValue)) { MessageBox.Show("กรอกข้อมูลไม่ถูกต้อง กรุณาใส่ตัวเลข", "เกิดข้อผิดพลาด", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { btnDelete.Enabled = false; //สำหรับเรียกค่า Income และ Number เก่าใน firebase FirebaseResponse value_income = await client.GetTaskAsync($"Count for Income:{labelmonth.Text}/node/"); //FirebaseResponse value_income = await client.GetTaskAsync("Count for income/node"); Count_Income get_in = value_income.ResultAs <Count_Income>(); var income = new IncomeTotal { //รับค่า income-All มาและเมื่อกดปุ่ม นำไปบวกอีก -1 เสมอ จากนั้นก็แปลงให้อยู่ในรูปสตริง Number = (Convert.ToInt32(get_in.income_All) - 1).ToString(), Detail = detailtxt.Text, // รายการที่ได้รับ Income = incometxt.Text, // จำนวนเงินของรายรับ }; //สำหรับเรียกค่ารายลับและลำดับโดยการกำหนด FirebaseResponse response1 = await client.GetTaskAsync($"Income:{labelmonth.Text}/order" + Numbertxt.Text); IncomeTotal obj = response1.ResultAs <IncomeTotal>(); Total_old = 0; //เซ็ตค่าให้ Total_old ให้เป็น 0 ทุกครั้งที่กดปุ่มบันทึก Total_old = get_in.Total_income; //รับค่าจาก firebase เก็บไว้ใน Total_old Totalincome = Total_old - Convert.ToInt32(obj.Income); //obj.Income คือ เรียกค่ารายจ่ายที่จะลบ var obj_amount = new Count_Income { income_All = income.Number, Total_income = Totalincome }; SetResponse resincome2 = await client.SetTaskAsync($"Count for Income:{labelmonth.Text}/node/", obj_amount); //SetResponse resincome2 = await client.SetTaskAsync("Count for income/node", obj_amount); var obj_start = new start_Monthin { //รับค่า income-All มาและเมื่อกดปุ่ม นำไปบวกอีก -1 เสมอ จากนั้นก็แปลงให้อยู่ในรูปสตริง Number = obj_amount.income_All }; //สำหรับเรียกค่ารายลับและลำดับโดยการกำหนด$"Start_in:{labelmonth.Text}/" SetResponse start = await client.SetTaskAsync($"Start_in:{labelmonth.Text}/", obj_start); //---------------------------------------------------------------- int i = Convert.ToInt32(Numbertxt.Text); while (i <= Convert.ToInt32(obj_amount.income_All)) { //i++; try { FirebaseResponse response_loop = await client.GetTaskAsync($"Income:{labelmonth.Text}/order" + (i + 1)); IncomeTotal obj_loop = response_loop.ResultAs <IncomeTotal>(); var income_loop = new IncomeTotal { Number = Convert.ToString(i), Detail = obj_loop.Detail, // รายการที่ได้รับ Income = obj_loop.Income, // จำนวนเงินของรายรับ }; SetResponse resincome3 = await client.SetTaskAsync($"Income:{labelmonth.Text}/order" + i, income_loop); } catch { } i++; } //ลบค่าสุดท้าย FirebaseResponse response2 = await client.DeleteTaskAsync($"Income:{labelmonth.Text}/order" + (Convert.ToInt32(obj_amount.income_All) + 1).ToString()); MessageBox.Show("แก้ไขเรียบร้อย"); } }