public List <FoodStuff> getFoodStuffsByCategoryId(int cateoryId) { List <FoodStuff> foodStuffs = new List <FoodStuff>(); string sqlQuery = "SELECT * from main.get_food_stuffs_by_category_id(:c_id)"; try { dataBase = new DataBase(); var npgComm = dataBase.getNpgCommandForRequest(sqlQuery); npgComm.Parameters.AddWithValue(":c_id", cateoryId); NpgsqlDataReader reader = npgComm.ExecuteReader(); while (reader.Read()) { FoodStuff foodStuff = new FoodStuff(); foodStuff.Id = reader.IsDBNull(reader.GetOrdinal("id")) ? 0 : reader.GetInt32(reader.GetOrdinal("id")); foodStuff.Name = reader.IsDBNull(reader.GetOrdinal("name")) ? string.Empty : reader.GetString(reader.GetOrdinal("name")); foodStuff.Price = reader.IsDBNull(reader.GetOrdinal("price")) ? 0 : reader.GetFloat(reader.GetOrdinal("price")); foodStuff.Cost = reader.IsDBNull(reader.GetOrdinal("food_cost")) ? 0 : reader.GetFloat(reader.GetOrdinal("food_cost")); foodStuff.Category.Id = reader.IsDBNull(reader.GetOrdinal("category_id")) ? 0 : reader.GetInt32(reader.GetOrdinal("category_id")); foodStuffs.Add(foodStuff); } } finally { dataBase.CloseAndDispose(); } return(foodStuffs); }
private void btn_add_edit_food_Click(object sender, EventArgs e) { FoodStuff foodStuff = new FoodStuff(); FoodStuffDao foodStuffDao = new FoodStuffDao(); foodStuff.Name = txt_food_name.Text; foodStuff.Price = float.Parse(txt_food_price.Text); foodStuff.Cost = float.Parse(txt_food_cost.Text); foodStuff.Desc = txt_food_desc.Text; int categoryId = ComboUtil.getSelectedComboValue(cb_category); foodStuff.Category.Id = categoryId; int returnId; if (isUpdate) { foodStuff.Id = addEditFoodStuff.Id; returnId = foodStuffDao.updateFoodStuff(foodStuff); } else { returnId = foodStuffDao.insertFoodStuff(foodStuff); } if (returnId != -1) { this.Close(); } }
public List <FoodStuff> listFoodStuffs() { string sqlQuery = "SELECT * from main.list_food_stuffs()"; List <FoodStuff> foodStuffs = new List <FoodStuff>(); try { dataBase = new DataBase(); var npgComm = dataBase.getNpgCommandForRequest(sqlQuery); NpgsqlDataReader reader = npgComm.ExecuteReader(); while (reader.Read()) { FoodStuff foodStuff = new FoodStuff(); foodStuff.Id = reader.IsDBNull(reader.GetOrdinal("id")) ? 0 : reader.GetInt32(reader.GetOrdinal("id")); foodStuff.Name = reader.IsDBNull(reader.GetOrdinal("name")) ? string.Empty : reader.GetString(reader.GetOrdinal("name")); foodStuff.Price = reader.IsDBNull(reader.GetOrdinal("price")) ? 0 : reader.GetFloat(reader.GetOrdinal("price")); foodStuff.Cost = reader.IsDBNull(reader.GetOrdinal("food_cost")) ? 0 : reader.GetFloat(reader.GetOrdinal("food_cost")); foodStuff.Category.Id = reader.IsDBNull(reader.GetOrdinal("category_id")) ? 0 : reader.GetInt32(reader.GetOrdinal("category_id")); foodStuff.Desc = reader.IsDBNull(reader.GetOrdinal("description")) ? string.Empty : reader.GetString(reader.GetOrdinal("description")); foodStuffs.Add(foodStuff); } } finally { dataBase.CloseAndDispose(); } return(foodStuffs); }
static void CreateFoodstuffStates( ) { foreach (GameObject selectedObject in Selection.gameObjects) { WIStates states = selectedObject.GetOrAdd <WIStates> (); states.EditorCreateStates(); FoodStuff foodstuff = selectedObject.GetOrAdd <FoodStuff> (); foodstuff.EditorCreateProps(); } }
public static void InitializeAvatar(PreparedFoodAvatar preparedFoodAvatar) { if (string.IsNullOrEmpty(preparedFoodAvatar.worlditem.Subcategory)) { //get a random category preparedFoodAvatar.worlditem.Props.Local.Subcategory = Get.PreparedFoodList[UnityEngine.Random.Range(0, Get.PreparedFoodList.LastIndex())].Name; } PreparedFood preparedFood = null; if (!mPreparedFoodLookup.TryGetValue(preparedFoodAvatar.worlditem.Subcategory, out preparedFood)) { Debug.Log("Couldn't initialize prepared food avatar " + preparedFoodAvatar.name); return; } preparedFoodAvatar.Props = preparedFood; //set up the prepared food states WIState rawState = preparedFoodAvatar.worlditem.States.GetState("Raw"); WIState cookedState = preparedFoodAvatar.worlditem.States.GetState("Cooked"); cookedState.Enabled = true; if (preparedFood.CanBeRaw) { //if it can be raw / cooked //indicate this with a suffix cookedState.Suffix = "Cooked"; rawState.Suffix = "Raw"; rawState.Enabled = true; preparedFoodAvatar.worlditem.States.DefaultState = "Raw"; } else { //otherwise just show up as the normal name cookedState.Suffix = string.Empty; rawState.Enabled = false; preparedFoodAvatar.worlditem.States.DefaultState = "Cooked"; } //set up the edible properties FoodStuff foodStuff = preparedFoodAvatar.worlditem.Get <FoodStuff>(); foodStuff.State.ConsumeOnEat = true; /*foodStuff.State.PotentialProps.Clear(); * if (preparedFood.CanBeRaw) { * foodStuff.State.PotentialProps.Add(preparedFood.RawProps); * } * //set the cook time regardless since food can still be burned */ foodStuff.CookTimeRTSeconds = preparedFood.RTCookDuration; //foodStuff.State.PotentialProps.Add(preparedFood.CookedProps); foodStuff.RefreshFoodStuffProps(); //the foodstuff will update itself based on whether the state is raw / cooked }
// Use this for initialization void Start() { audioSource = GetComponent <AudioSource>(); List <FoodStuff> foodStuffList = ItemBox.Instance.GetAllCollectedList <FoodStuff>(); Destroy(ItemBox.Instance.gameObject); Destroy(ItemBox.Instance); canvas = FindObjectOfType(typeof(Canvas)) as Canvas; grid = canvas.GetComponentInChildren <GridLayoutGroup>(); List <Image> imageList = new List <Image>(); int i = 0; Observable.Timer(TimeSpan.FromSeconds(itemDisplayInterval), TimeSpan.FromSeconds(itemDisplayInterval)) .Select(x => foodStuffList) .Take(foodStuffList.Count) .Subscribe(_ => { FoodStuff foodStuff = foodStuffList[i++]; GameObject obj = new GameObject(foodStuff.item.ToString()); obj.transform.SetParent(grid.transform, false); Instantiate(effect).transform.SetParent(obj.transform, false); Image image = obj.AddComponent <Image>(); image.sprite = foodStuff.itemSprite; imageList.Add(image); audioSource.PlayOneShot(effectSe); }, () => { GameObject obj = new GameObject("Curry"); obj.transform.SetParent(canvas.transform, false); obj.transform.localScale = new Vector3(3, 3, 3); Image image = obj.AddComponent <Image>(); if (foodStuffList.Count >= 4) { image.sprite = curryCroquette; audioSource.PlayOneShot(croquette); } else { image.sprite = croquetteImage; } Observable.Timer(TimeSpan.FromSeconds(0f), TimeSpan.FromSeconds(1f)) .Take(1) .Subscribe(_ => { var text = FindObjectOfType <Text>(); text.text = "ゲームクリア!!!!"; }); this.UpdateAsObservable() .Where(x => Input.anyKeyDown) .First() .Subscribe(_ => Application.LoadLevel("Title")); }).AddTo(gameObject); foodStuffList.ToObservable().Select(x => x.item).Subscribe(x => Debug.Log(x)); }
public void passFoodDataToEditForm(FoodStuff foodStuff) { btn_add_edit_food.Text = "Redaktə et"; addEditFoodStuff = foodStuff; txt_food_name.Text = foodStuff.Name; txt_food_price.Text = foodStuff.Price.ToString(); txt_food_cost.Text = foodStuff.Cost.ToString(); txt_food_desc.Text = foodStuff.Desc; ComboUtil.setComboItemByValue(cb_category, foodStuff.Category.Id); isUpdate = true; }
private void btnFoodDoubleClick(object sender, EventArgs e) { TableDetails total = new TableDetails(); FoodStuff foodStuff = (FoodStuff)((Button)sender).Tag; total.Table = table; total.FoodStuff = foodStuff; bool isHave = chekcIfRowExistInDtTotal(total, true); if (!isHave) { addToTotalDataTable(total); } }
public async Task <IActionResult> OnGetAsync(Guid?id) { if (id == null) { return(NotFound()); } FoodStuff = await _context.FoodStuff .Include(f => f.FoodGroup).FirstOrDefaultAsync(m => m.FoodId == id); if (FoodStuff == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnGetAsync(Guid?id) { if (id == null) { return(NotFound()); } FoodStuff = await _context.FoodStuff .Include(f => f.FoodGroup).FirstOrDefaultAsync(m => m.FoodId == id); if (FoodStuff == null) { return(NotFound()); } ViewData["FoodGroupId"] = new SelectList(_context.FoodGroup, "FoodGroupId", "FoodGroupName"); return(Page()); }
public async Task <IActionResult> OnPostAsync(Guid?id) { if (id == null) { return(NotFound()); } FoodStuff = await _context.FoodStuff.FindAsync(id); if (FoodStuff != null) { _context.FoodStuff.Remove(FoodStuff); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
private void AddFoodMessageHandler(AddFoodMessage obj) { if (!FoodStuff.Contains(obj.IngredientName)) { if (!_recipiesIdList.ContainsKey(obj.IngredientName)) { _recipiesIdList.Add(obj.IngredientName, new List <int>()); } FoodStuff.Add(obj.IngredientName); foreach (var recipeTag in obj.RecipesTagList) { _recipiesIdList[obj.IngredientName].Add(recipeTag); } } CheckIfEnoughFood(); IsTableNotEmpty = true; }
public int deleteFoodStuff(FoodStuff foodStuff) { string query = "SELECT main.delete_food_stuff(:f_id)"; dataBase = new DataBase(); var deleteCommand = dataBase.getNpgCommandForRequest(query); deleteCommand.Parameters.AddWithValue("f_id", foodStuff.Id); NpgsqlDataReader reader = deleteCommand.ExecuteReader(); int returnId = 0; while (reader.Read()) { returnId = reader.GetInt32(0); } dataBase.CloseAndDispose(); return(returnId); }
public int insertFoodStuff(FoodStuff foodStuff) { string query = "SELECT main.insert_food_stuffs(:c_name,:c_price,:c_cost,:c_category_id,:c_desc)"; dataBase = new DataBase(); var insertCommand = dataBase.getNpgCommandForRequest(query); insertCommand.Parameters.AddWithValue("c_name", foodStuff.Name); insertCommand.Parameters.AddWithValue("c_price", foodStuff.Price); insertCommand.Parameters.AddWithValue("c_cost", foodStuff.Cost); insertCommand.Parameters.AddWithValue("c_category_id", foodStuff.Category.Id); insertCommand.Parameters.AddWithValue("c_desc", foodStuff.Desc); NpgsqlDataReader dataReader = insertCommand.ExecuteReader(); int returnId = 0; while (dataReader.Read()) { returnId = dataReader.GetInt32(0); } dataBase.CloseAndDispose(); return(returnId); }
private void FoodStuffForm_Load(object sender, EventArgs e) { foodStuff = new FoodStuff(); foodStuffListOnInterface(); }
public CreateModel(KetoCalculator.Models.KetoCalcContext context) { _context = context; FoodStuff = new FoodStuff(); }
private void DeleteFoodMessageHandler(DeleteFoodMessage obj) { _recipiesIdList.Remove(obj.FoodItem); FoodStuff.Remove(obj.FoodItem); CheckIfEnoughFood(); }