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();
}
