public RecipeDomain GetRecipeByRecipeId(int RecipeId) { RecipeDomain RecipeDomain = null; MediaDomain MediaDomain = null; IngredientDomain IngredientDomain = null; DataProvider.ExecuteCmd(GetConnection, "dbo.Recipes_GetByRecipeId" , inputParamMapper : delegate(SqlParameterCollection paramcollection) { paramcollection.AddWithValue("@Id", RecipeId); }, map : delegate(IDataReader reader, short set) { if (set == 0) { int startingIndex = 0; RecipeDomain = new RecipeDomain(); RecipeDomain.Id = reader.GetSafeInt32(startingIndex++); RecipeDomain.CreatedDate = reader.GetSafeDateTime(startingIndex++); RecipeDomain.Name = reader.GetSafeString(startingIndex++); RecipeDomain.Description = reader.GetSafeString(startingIndex++); RecipeDomain.Directions = reader.GetSafeString(startingIndex++); RecipeDomain.Preptime = reader.GetSafeInt32(startingIndex++); RecipeDomain.Totaltime = reader.GetSafeInt32(startingIndex++); RecipeDomain.NumberOfServings = reader.GetSafeInt32(startingIndex++); RecipeDomain.UserId = reader.GetSafeString(startingIndex++); MediaDomain = new MediaDomain(); MediaDomain.Id = reader.GetSafeInt32(startingIndex++); MediaDomain.DataType = reader.GetSafeString(startingIndex++); MediaDomain.Url = reader.GetSafeString(startingIndex++); MediaDomain.Created = reader.GetSafeDateTime(startingIndex++); RecipeDomain.Media = MediaDomain; if (RecipeDomain == null) { RecipeDomain = new RecipeDomain(); } } else if (set == 1) { IngredientDomain = new IngredientDomain(); int startingIndex = 0; IngredientDomain.Id = reader.GetSafeInt32(startingIndex++); IngredientDomain.RecipeId = reader.GetSafeInt32(startingIndex++); IngredientDomain.Name = reader.GetSafeString(startingIndex++); IngredientDomain.MeasurementType = reader.GetSafeEnum <IngredientMeasurementType>(startingIndex++); IngredientDomain.Quantity = reader.GetSafeInt32(startingIndex++); RecipeDomain.Ingredients.Add(IngredientDomain); } }); return(RecipeDomain); }
private void btnFind_Click(object sender, EventArgs e) { MessageBox.Show("Enter the Recipe Id in the textbox and click Find button", "Find Recipe", MessageBoxButtons.OK, MessageBoxIcon.Information); currentRecipeDomain = RecipeService.GetEntityById(int.Parse(txtRecipeId.Text)); txtRecipeId.Text = currentRecipeDomain?.RecipeId.ToString(); txtRecipeName.Text = currentRecipeDomain?.RecipeName; txtRecipeCategoryId.Text = currentRecipeDomain?.CategoryId.ToString(); }
private void btnSave_Click(object sender, EventArgs e) { RecipeDomain recipe = new RecipeDomain() { RecipeName = textBox1.Text, CategoryId = Convert.ToInt32(numericUpDown1.Value) }; RecipeService.Insert(recipe); RecipeService.Save(); }
public HttpResponseMessage GetRecipeByRecipeId(int recipeid) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } RecipeDomain Recipe = _RecipesService.GetRecipeByRecipeId(recipeid); ItemResponse <RecipeDomain> Response = new ItemResponse <RecipeDomain>(); Response.Item = Recipe; return(Request.CreateResponse(HttpStatusCode.OK, Response)); }
//Get public List <RecipeDomain> GetRecipesByUserId(string UserId) { List <RecipeDomain> ListRecipeDomain = null; MediaDomain MediaDomain = null; DataProvider.ExecuteCmd(GetConnection, "dbo.Recipes_GetAllRecipesByUserId" , inputParamMapper : delegate(SqlParameterCollection paramcollection) { paramcollection.AddWithValue("@userid", UserId); }, map : delegate(IDataReader reader, short set) { RecipeDomain p = new RecipeDomain(); int startingIndex = 0; p.Id = reader.GetSafeInt32(startingIndex++); p.CreatedDate = reader.GetSafeDateTime(startingIndex++); p.Name = reader.GetSafeString(startingIndex++); p.Directions = reader.GetSafeString(startingIndex++); p.Preptime = reader.GetSafeInt32(startingIndex++); p.Totaltime = reader.GetSafeInt32(startingIndex++); p.NumberOfServings = reader.GetSafeInt32(startingIndex++); p.Description = reader.GetSafeString(startingIndex++); MediaDomain = new MediaDomain(); MediaDomain.Id = reader.GetSafeInt32(startingIndex++); MediaDomain.DataType = reader.GetSafeString(startingIndex++); MediaDomain.Url = reader.GetSafeString(startingIndex++); MediaDomain.Created = reader.GetSafeDateTime(startingIndex++); p.Media = MediaDomain; if (ListRecipeDomain == null) { ListRecipeDomain = new List <RecipeDomain>(); } ListRecipeDomain.Add(p); }); return(ListRecipeDomain); }