public async Task <int> CreateItem(MenuItemModel model) { try { using (SqlConnection db = new SqlConnection(connectionString)) { await db.OpenAsync(); string qry = "INSERT INTO MenuItems ([UserId],[Name],[Catergory],[Image],[Added],[Modified]) " + "VALUES (" + "@UserId,@Name,@Catergory,@Image,@Added,@Modified); SELECT CAST(SCOPE_IDENTITY() as int)"; var result = await db.QueryAsync <int>(qry, model); return(result.Single()); } } catch (Exception ex) { Trace.WriteLine("UpdateMachine exception " + ex.Message); } return(-1); }
public async Task <bool> UpdateItem(MenuItemModel model) { try { using (SqlConnection db = new SqlConnection(connectionString)) { await db.OpenAsync(); string qry = "UPDATE MenuItems SET [Name]=@Name, [Catergory]=@Catergory,[Image]=@Image,[Modified]=@Modified " + "WHERE Id=@Id"; await db.QueryAsync <int>(qry, model); return(true); } } catch (Exception ex) { Trace.WriteLine("UpdateMachine exception " + ex.Message); } return(false); }