public Task <int> SaveItemAsync(MainTable_SQLite item) { if (item.ID != 0) { return(database.UpdateAsync(item)); } else { return(database.InsertAsync(item)); } }
public async Task handleDataForSQLiteAsync(byte[] dataStr) { //need to break the reply up andthen sqlite it byte[] choppedMsg = new byte[1000]; int choppedLen = 0; for (int i = 0; i < dataStr.Length; i++) { if (dataStr[i + 2] == 0x04) { choppedLen = i; break; } choppedMsg[i] = dataStr[i + 2]; } string str = System.Text.Encoding.UTF8.GetString(choppedMsg, 0, (choppedLen - 1)); int commas = str.Split(',').Length - 1; string[] strDBLINES = str.Split(','); string[] strENTRYMODEL = new string[] { }; for (int i = 0; i < (commas + 1); i++) { strENTRYMODEL = new string[] { }; strENTRYMODEL = strDBLINES[i].Split(':'); mainTable_SQLite = new MainTable_SQLite() { }; mainTable_SQLite.ID_BBB = strENTRYMODEL[0]; mainTable_SQLite.Device = strENTRYMODEL[1]; mainTable_SQLite.Data_Time = strENTRYMODEL[2]; mainTable_SQLite.Data_State = strENTRYMODEL[3]; mainTable_SQLite.Has_Sent = 0; await App.Database.SaveItemAsync(mainTable_SQLite); } }
public Task <int> DeleteItemAsync(MainTable_SQLite item) { return(database.DeleteAsync(item)); }