public void UpdateMemory(MemoriesTable objMemoryInfo) { try { var allMemories = sqliteconnection.Table <MemoriesTable>().ToList(); var memoryInfo = allMemories.Where(X => X.MemoryId == objMemoryInfo.MemoryId) as MemoriesTable; if (memoryInfo == null) { sqliteconnection.Insert(objMemoryInfo); } else { memoryInfo.MemoryId = objMemoryInfo.MemoryId; memoryInfo.MemoryWith = objMemoryInfo.MemoryWith; memoryInfo.MemoryImage = objMemoryInfo.MemoryImage; memoryInfo.MemoryDate = objMemoryInfo.MemoryDate; memoryInfo.MemoryTime = objMemoryInfo.MemoryTime; memoryInfo.MemoryDescription = objMemoryInfo.MemoryDescription; memoryInfo.MemoryLocation = objMemoryInfo.MemoryLocation; memoryInfo.MemoryType = objMemoryInfo.MemoryType; sqliteconnection.Update(memoryInfo); } } catch (Exception ex) { var msg = ex.Message; } }
public void SaveMemory(MemoriesTable MemoryInfo) { try { sqliteconnection.Insert(new MemoriesTable { MemoryId = MemoryInfo.MemoryId, MemoryWith = MemoryInfo.MemoryWith, MemoryDate = MemoryInfo.MemoryDate, MemoryImage = MemoryInfo.MemoryImage, MemoryTime = MemoryInfo.MemoryTime, MemoryDescription = MemoryInfo.MemoryDescription, MemoryLocation = MemoryInfo.MemoryLocation, MemoryType = MemoryInfo.MemoryType }); } catch (Exception ex) { var msg = ex.Message; } }