public void Create(Recipe recipe) { var parsedDirections = String.Join(";", recipe.Directions).Replace("'", "\\'"); var parsedIngredients = String.Join(";", recipe.Ingredients).Replace("'", "\\'"); var query = $"insert into recipes(title, accountId, createdAt, description, calories, directions, ingredients, public) " + $"values('{recipe.Title.Replace("'", "\\'")}', {recipe.AccountId}, current_timestamp(), '{recipe.Description}', {recipe.Calories}, '{parsedDirections}', '{parsedIngredients}', {recipe.Public.Value})"; MySqlDatabase.ExecuteNoneQuery(query); }
public bool Create(CreateAccountPostData data) { bool success = false; MySqlDatabase.ExecuteNoneQuery( $"insert into accounts(username, password, email, authKey) values ('{data.Username}','{data.Password}','{data.Email}','{Hash.Sha256(data.Username + data.Password)}')", count => { if (count == 1) { success = true; } } ); return(success); }
public void UpdateAccount(Account account) { var query = "update accounts set "; if (account.FirstName != null) { query += $"firstName = '{account.FirstName}',"; } if (account.LastName != null) { query += $"lastName = '{account.LastName}',"; } if (account.Email != null) { query += $"email = '{account.Email}',"; } if (account.IsMale.HasValue) { query += $"isMale = {account.IsMale},"; } if (account.Birthdate.HasValue) { query += $"birthdate = str_to_date('{account.Birthdate.Value.ToString("dd-MM-yyyy")}','%d-%m-%Y'),"; } if (account.Weight.HasValue) { query += $"weight = {account.Weight},"; } if (account.Height.HasValue) { query += $"height = {account.Height},"; } if (account.Description != null) { query += $"description = '{account.Description}',"; } query = query.Remove(query.Length - 1); MySqlDatabase.ExecuteNoneQuery(query + $" where accounts.id = {account.Id}"); }
public void Update(int id, Recipe recipe) { var sql = "update recipes set "; if (recipe.Title != null) { sql += $"title = '{recipe.Title.Replace("'", "\\'")}',"; } if (recipe.Description != null) { sql += $"description = '{recipe.Description.Replace("'", "\\'")}',"; } if (recipe.Calories.HasValue) { sql += $"calories = {recipe.Calories.Value},"; } if (recipe.Directions != null) { sql += $"directions = '{String.Join(";", recipe.Directions).Replace("'", "\\'")}',"; } if (recipe.Ingredients != null) { sql += $"ingredients = '{String.Join(";", recipe.Ingredients).Replace("'", "\\'")}',"; } if (recipe.Public.HasValue) { sql += $"public = {recipe.Public.Value},"; } sql = sql.Remove(sql.Length - 1); if (sql != "update recipes set ") { sql += " where id = " + id; MySqlDatabase.ExecuteNoneQuery(sql); } }
public void Create(CreateAccountPostData data) { MySqlDatabase.ExecuteNoneQuery($"insert into accounts(username, password, email, authKey) values ('{data.Username}','{data.Password}','{data.Email}','{Hash.Sha256(data.Username + data.Password)}')"); }
public void Create(int accountId, int recipeId) { MySqlDatabase.ExecuteNoneQuery($"insert into eatenRecipes(accountId, recipeId, date) values({accountId}, {recipeId}, current_date())"); }
public void Delete(int id) { MySqlDatabase.ExecuteNoneQuery("delete from recipes where id = " + id); }