public BaseViewModel GetItem(int itemId) { var item = new BaseViewModel(); using (dbConn) { var _item = (dbConn.Table<MSPCrew>().Where(c => c.Id == itemId)).Single(); item.Id = _item.Id; item.Name = _item.Name; item.Campus = _item.Campus; } return item; }
public string SaveItem(BaseViewModel item) { string result = string.Empty; int success; using (dbConn) { try { var existingItem = (dbConn.Table<MSPCrew>().Where(c => c.Id == item.Id)).SingleOrDefault(); if (existingItem != null) { existingItem.Name = item.Name; success = dbConn.Update(existingItem); } else { success = dbConn.Insert(new MSPCrew() { Name = item.Name, Campus = item.Campus }); } result = "Success"; } catch { result = "This item was not saved"; } } return result; }