public DataTable getIngredients(clsRecipe rec) { _strSQL = "SELECT Name, Description, Season FROM Ingredients, Recipe_Contains WHERE Ingr_fk = Ingr_id AND Rec_fk = " + rec.id + ";"; executesql(); return(_dtResult); }
public frmShowRecipe(frmShowResults resultsForm, clsRecipe thisRec) { _data = new clsSQL(); _resultsForm = resultsForm; _thisRecipe = thisRec; _ingredients = _data.getIngredients(_thisRecipe); InitializeComponent(); populate(); }
public void addRecipe(clsRecipe recNewRecipe, List <clsIngredient> ingredientsUsed, List <String> stylesUsed, List <String> catsUsed) { _strSQL = "INSERT INTO Recipes (Season, Directions, Favorite, Name) VALUES ('" + recNewRecipe.season + "', '" + recNewRecipe.directions + "', '" + recNewRecipe.favorite + "', '" + recNewRecipe.name + "'); SELECT TOP 1 Rec_id " + "FROM RECIPES ORDER BY Rec_id DESC;"; executesql(); int recID = Convert.ToInt32(_dtResult.Rows[0]["Rec_id"]); containsInsert(ingredientsUsed, recID); recStylesInsert(stylesUsed, recID); recCatsInsert(catsUsed, recID); }
public frmAddRecipe() { _recNewRecipe = new clsRecipe(); _data = new clsSQL(); _ingredientsUsed = new List <clsIngredient>(); _stylesUsed = new List <String>(); _catsUsed = new List <String>(); lstIngredients = new ListView(); lstCategories = new ListView(); lstStyles = new ListView(); InitializeComponent(); populateIngredients(); populateCategories(); populateStyles(); }
private void btnFavorite_Click(object sender, EventArgs e) { clsRecipe rec = new clsRecipe(); clsSQL data = new clsSQL(); // str = DataGridView1.Rows[DataGridView.SelectedRows[0].Index].Cells[X].Value.ToString(); rec.id = Int32.Parse(dgvResults.Rows[dgvResults.SelectedRows[0].Index].Cells[1].Value.ToString()); rec.name = dgvResults.Rows[dgvResults.SelectedRows[0].Index].Cells[2].Value.ToString(); rec.season = dgvResults.Rows[dgvResults.SelectedRows[0].Index].Cells[3].Value.ToString(); rec.directions = dgvResults.Rows[dgvResults.SelectedRows[0].Index].Cells[4].Value.ToString(); Char[] chararr = dgvResults.Rows[dgvResults.SelectedRows[0].Index].Cells[5].Value.ToString().ToCharArray(); rec.favorite = chararr[0]; data.favoriteRecipe(rec); MessageBox.Show(rec.name + " has been added to your favorites!"); dgvResults.Rows[dgvResults.SelectedRows[0].Index].Cells[5].Value = "Y"; }
private void showView() { clsRecipe rec = new clsRecipe(); // str = DataGridView1.Rows[DataGridView.SelectedRows[0].Index].Cells[X].Value.ToString(); rec.id = Int32.Parse(dgvResults.Rows[dgvResults.SelectedRows[0].Index].Cells[1].Value.ToString()); rec.name = dgvResults.Rows[dgvResults.SelectedRows[0].Index].Cells[2].Value.ToString(); rec.season = dgvResults.Rows[dgvResults.SelectedRows[0].Index].Cells[3].Value.ToString(); rec.directions = dgvResults.Rows[dgvResults.SelectedRows[0].Index].Cells[4].Value.ToString(); Char[] chararr = dgvResults.Rows[dgvResults.SelectedRows[0].Index].Cells[5].Value.ToString().ToCharArray(); rec.favorite = chararr[0]; frmShowRecipe showRec = new frmShowRecipe(this, rec); showRec.Show(); this.Hide(); }
public DataTable getCategories(clsRecipe rec) { _strSQL = "SELECT Name FROM Categories, Recipe_Categories WHERE Cat_id = Cat_fk AND Rec_fk = " + rec.id + ";"; executesql(); return(_dtResult); }
public DataTable getStyles(clsRecipe rec) { _strSQL = "SELECT Name FROM Styles, Recipe_Styles WHERE Style_id = Style_fk AND Rec_fk = " + rec.id + ";"; executesql(); return(_dtResult); }
public void favoriteRecipe(clsRecipe rec) { _strSQL = "UPDATE Recipes SET Favorite = 'Y' WHERE Rec_id = " + rec.id + ";"; executesql(); }