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("แก้ไขเรียบร้อย");
}
}
