public static ArrayList GetFoodByType(string foodType)
{
ArrayList list = new ArrayList();
string query = string.Format("SELECT * FROM food WHERE type LIKE '{0}'", foodType);
try
{
conn.Open();
command.CommandText = query;
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int id = reader.GetInt32(0);
string name = reader.GetString(1);
string type = reader.GetString(2);
double price = reader.GetDouble(3);
string image = (reader.IsDBNull(4)) ? "" : reader.GetString(4);
string ingredient = (reader.IsDBNull(5)) ? "" : reader.GetString(5);
string description = (reader.IsDBNull(6)) ? "" : reader.GetString(6);
Food_Type fType = (Food_Type)Enum.Parse(typeof(Food_Type), type, true);
Food food = new Food(id, name, fType, price, image, ingredient, description);
list.Add(food);
}
}
finally
{
conn.Close();
}
return(list);
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Name")] Food_Type food_Type)
{
if (id != food_Type.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(food_Type);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!Food_TypeExists(food_Type.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(food_Type));
}
public Food_Type Insert(Food_Type obj)
{
using (ModelContext db = new ModelContext())
{
db.Entry <Food_Type>(obj).State = EntityState.Added;
db.SaveChanges();
return(obj);
}
}
public void delete(Food_Type obj)
{
using (ModelContext db = new ModelContext())
{
db.type_list.Attach(obj);
db.Entry <Food_Type>(obj).State = EntityState.Deleted;
db.SaveChanges();
}
}
public Food(string name, Food_Type type, double price, string image, string ingredient, string description)
{
Name = name;
Type = type;
Price = price;
Image = image;
Ingredient = ingredient;
Description = description;
}
public async Task <IActionResult> Create([Bind("Id,Name")] Food_Type food_Type)
{
if (ModelState.IsValid)
{
_context.Add(food_Type);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(food_Type));
}
public void insert(string DishName, double DishPrice, string DishDescription, string DishImage, string TypeName, string SizeName, int DStock)
{
using (ModelContext db = new ModelContext())
{
Food_Size fsi = db.size_list.FirstOrDefault(fsize => fsize.name == SizeName);
Food_Type ftyp = db.type_list.FirstOrDefault(ftype => ftype.nameType == TypeName);
db.dish_list.Add(new Food_Dish {
name = DishName, price = DishPrice, description = DishDescription, imaGeURL = DishImage, TypeId = ftyp.Id, SizeId = fsi.Id, stock = DStock
});
db.SaveChanges();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtSearch.Text))
{
MessageBox.Show("Search field is empty!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
foodTypeBindingSource.DataSource = Food_TypeBUS.search(txtSearch.Text);
Food_Type ftyp = foodTypeBindingSource.Current as Food_Type;
txtSearch.Clear();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
try
{
Food_Type ftyp = foodTypeBindingSource.Current as Food_Type;
if (MessageBox.Show("Are you sure want to delete this name ?", "Alert", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
Food_TypeBUS.delete(ftyp);
MessageBox.Show("Delete successful!", "Result", MessageBoxButtons.OK);
foodTypeBindingSource.RemoveCurrent();
}
}
catch
{
MessageBox.Show("Can not delete this name!", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void edit(Food_Dish dishEdit, string E_Dname, double E_DPrice, string E_DDescription, string E_DImage, string E_DType, string E_DSize, int E_DId, int E_DStock)
{
using (ModelContext db = new ModelContext())
{
Food_Size fsi = db.size_list.FirstOrDefault(fsize => fsize.name == E_DSize);
Food_Type ftyp = db.type_list.FirstOrDefault(typ => typ.nameType == E_DType);
dishEdit = (from dish in db.dish_list
where dish.Id == E_DId
select dish).First();
dishEdit.name = E_Dname;
dishEdit.price = E_DPrice;
dishEdit.description = E_DDescription;
dishEdit.imaGeURL = E_DImage;
dishEdit.TypeId = ftyp.Id;
dishEdit.SizeId = fsi.Id;
dishEdit.stock = E_DStock;
db.SaveChanges();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
string name = txtName.Text;
Food_Type type = (Food_Type)Enum.Parse(typeof(Food_Type), ddlType.SelectedValue, true);
double price = Convert.ToDouble(txtPrice.Text);
string image = "../Image/" + ddlImage.SelectedValue;
string ingredient = txtIngredient.Text;
string desc = txtDesc.Text;
Food food = new Food(name, type, price, image, ingredient, desc);
Connection.AddFood(food);
lblResult.Text = "Upload Successful";
ClearTextFields();
}
catch (Exception)
{
lblResult.Text = "Upload failed";
}
}
public void Respawn1(int ID, Food_Type food_Type)
{
that_food = food_Type;
//this is because I don't know why it spawns them at z = -53, even though all the location are at z= 0
int where_to_spawn = 0;
Vector3 adj_where_to = Vector3.zero;
switch (that_food)
{
case Food_Type.Carbohydrates:
where_to_spawn = Random.Range(0, 3);
prefab_carbs[ID].transform.position = new Vector3(0f, 20f, -54f);
adj_where_to = new Vector3(spawnerLocations[where_to_spawn].transform.position.x, spawnerLocations[where_to_spawn].transform.position.y, 0.0f);
prefab_carbs[Random.Range(0, prefab_carbs.Length)].transform.position = adj_where_to;
break;
case Food_Type.Proteins:
where_to_spawn = Random.Range(4, 7);
prefab_protein[ID].transform.position = new Vector3(0f, 20f, -54f);
adj_where_to = new Vector3(spawnerLocations[where_to_spawn].transform.position.x, spawnerLocations[where_to_spawn].transform.position.y, 0.0f);
prefab_protein[Random.Range(0, prefab_protein.Length)].transform.position = adj_where_to;
break;
case Food_Type.Vitamins:
where_to_spawn = Random.Range(8, 11);
prefab_vitamins[ID].transform.position = new Vector3(0f, 20f, -54f);
adj_where_to = new Vector3(spawnerLocations[where_to_spawn].transform.position.x, spawnerLocations[where_to_spawn].transform.position.y, 0.0f);
prefab_vitamins[Random.Range(0, prefab_vitamins.Length)].transform.position = adj_where_to;
break;
case Food_Type.Sugars:
where_to_spawn = Random.Range(12, 15);
prefab_sugars[ID].transform.position = new Vector3(0f, 20f, -54f);
adj_where_to = new Vector3(spawnerLocations[where_to_spawn].transform.position.x, spawnerLocations[where_to_spawn].transform.position.y, 0.0f);
prefab_sugars[Random.Range(0, prefab_sugars.Length)].transform.position = adj_where_to;
break;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Food_Type ftyp = foodTypeBindingSource.Current as Food_Type;
if (string.IsNullOrEmpty(txtTypeName.Text))
{
MessageBox.Show("Name field is empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (ftyp.Id == 0)
{
if (Food_TypeBUS.checkFoodType(txtTypeName.Text))
{
MessageBox.Show("This name is already exist.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtTypeName.Clear();
txtTypeName.Focus();
}
else
{
Food_TypeBUS.Insert(ftyp);
foodTypeBindingSource.MoveLast();
MessageBox.Show("Add successfully!", "Result", MessageBoxButtons.OK, MessageBoxIcon.Information);
panCRUD.Enabled = true;
panSave.Enabled = false;
}
}
else
{
Food_TypeBUS.update(ftyp);
MessageBox.Show("Update successfully!", "Result", MessageBoxButtons.OK, MessageBoxIcon.Information);
panCRUD.Enabled = true;
panSave.Enabled = false;
}
}
}
public static Food_Type Insert(Food_Type obj)
{
return(tye_act.Insert(obj));
}
public static void update(Food_Type obj)
{
tye_act.update(obj);
}
private void dataGird_CellClick(object sender, DataGridViewCellEventArgs e)
{
Food_Type ftyp = foodTypeBindingSource.Current as Food_Type;
}
public void SetFoodIWant(Food_Type food_I_want)
{
this.food_I_want = food_I_want;
}
public static void delete(Food_Type obj)
{
tye_act.delete(obj);
}
private void btnSave_Click(object sender, EventArgs e)
{
Food_Dish fdish = foodDishBindingSource.Current as Food_Dish;
Food_Size fsize = foodSizeBindingSource.Current as Food_Size;
Food_Type ftype = foodTypeBindingSource.Current as Food_Type;
string sizeName = fsize.name;
string typeName = ftype.nameType;
string D_Name = txtD_Name.Text;
double D_Price = double.Parse(txtD_Price.Text);
string D_Descript = txtD_Description.Text;
string D_ImageURL = fdish.imaGeURL;
int D_Stock = int.Parse(txtStock.Text);
int D_Id = fdish.Id;
if (fdish == null)
{
MessageBox.Show("Nothing to edit!", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
foodDishBindingSource.DataSource = Food_DishBUS.GetAll();
return;
}
else
{
if (string.IsNullOrEmpty(txtD_Name.Text) || string.IsNullOrEmpty(txtD_Price.Text) || string.IsNullOrEmpty(txtD_Description.Text))
{
MessageBox.Show("Please type all the information!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (fdish.Id == 0)
{
if (Food_DishBUS.chekName(txtD_Name.Text))
{
MessageBox.Show("This name is already exist!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtD_Name.Clear();
txtD_Price.Clear();
txtD_Description.Clear();
}
else
{
Food_DishBUS.insert(D_Name, D_Price, D_Descript, D_ImageURL, typeName, sizeName, D_Stock);
MessageBox.Show("Insert successfully!", "Insert dish name", MessageBoxButtons.OK, MessageBoxIcon.Information);
foodDishBindingSource.DataSource = Food_DishBUS.GetAll();
foodDishBindingSource.MoveLast();
panCRUD.Enabled = true;
panFilter.Enabled = true;
panSave.Enabled = false;
dataGridDish.Enabled = true;
}
}
else
{
Food_DishBUS.edit(fdish, D_Name, D_Price, D_Descript, D_ImageURL, typeName, sizeName, D_Id, D_Stock);
MessageBox.Show("Update successfully!", "Update dish name", MessageBoxButtons.OK, MessageBoxIcon.Information);
foodDishBindingSource.DataSource = Food_DishBUS.GetAll();
panCRUD.Enabled = true;
panSave.Enabled = false;
panFilter.Enabled = true;
dataGridDish.Enabled = true;
}
}
}
}
// Update is called once per frame
void Update()
{
//walk animation
if (Input.GetKey(rightKey) || Input.GetKey(leftKey) || Input.GetKey(downKey) || Input.GetKey(upKey))
{
walkAnim.SetBool("Moving", true);
}
else
{
walkAnim.SetBool("Moving", false);
}
//player movement
if (Input.GetKey(upKey))
{
rb.MovePosition(transform.position + transform.up * Time.deltaTime * moveSpeed);
visualPlayer.transform.eulerAngles = new Vector3(0, 0, 0);
}
else if (Input.GetKey(leftKey))
{
rb.MovePosition(transform.position + -transform.right * Time.deltaTime * moveSpeed);
visualPlayer.transform.eulerAngles = new Vector3(0, 0, 90);
}
else if (Input.GetKey(downKey))
{
rb.MovePosition(transform.position + -transform.up * Time.deltaTime * moveSpeed);
visualPlayer.transform.eulerAngles = new Vector3(0, 0, 180);
}
else if (Input.GetKey(rightKey))
{
rb.MovePosition(transform.position + transform.right * Time.deltaTime * moveSpeed);
visualPlayer.transform.eulerAngles = new Vector3(0, 0, -90);
}
if (Input.GetKeyDown(interactionKey) && standingOnPickup == true)
{
Food_Type foodType = pickUp.foodType;
pickUp.PickedUp();
if (foodType == Food_Type.Vlees)
{
if (InventorySlotIsFilled1 == false)
{
InventorySlotIsFilled1 = true;
ItemInInventorySlot1 = 1;
InventorySlot11.gameObject.SetActive(true);
PlayerAudio.Play();
}
else if (InventorySlotIsFilled2 == false)
{
InventorySlotIsFilled2 = true;
ItemInInventorySlot2 = 1;
InventorySlot21.gameObject.SetActive(true);
PlayerAudio.Play();
}
else if (InventorySlotIsFilled3 == false)
{
InventorySlotIsFilled3 = true;
ItemInInventorySlot3 = 1;
InventorySlot31.gameObject.SetActive(true);
PlayerAudio.Play();
}
}
else if (foodType == Food_Type.Vis)
{
if (InventorySlotIsFilled1 == false)
{
InventorySlotIsFilled1 = true;
ItemInInventorySlot1 = 4;
InventorySlot14.gameObject.SetActive(true);
PlayerAudio.Play();
}
else if (InventorySlotIsFilled2 == false)
{
InventorySlotIsFilled2 = true;
ItemInInventorySlot2 = 4;
InventorySlot24.gameObject.SetActive(true);
PlayerAudio.Play();
}
else if (InventorySlotIsFilled3 == false)
{
InventorySlotIsFilled3 = true;
ItemInInventorySlot3 = 4;
InventorySlot34.gameObject.SetActive(true);
PlayerAudio.Play();
}
}
else if (foodType == Food_Type.Kruidjes)
{
if (InventorySlotIsFilled1 == false)
{
InventorySlotIsFilled1 = true;
ItemInInventorySlot1 = 2;
InventorySlot12.gameObject.SetActive(true);
PlayerAudio.Play();
}
else if (InventorySlotIsFilled2 == false)
{
InventorySlotIsFilled2 = true;
ItemInInventorySlot2 = 2;
InventorySlot22.gameObject.SetActive(true);
PlayerAudio.Play();
}
else if (InventorySlotIsFilled3 == false)
{
InventorySlotIsFilled3 = true;
ItemInInventorySlot3 = 2;
InventorySlot32.gameObject.SetActive(true);
PlayerAudio.Play();
}
}
else if (foodType == Food_Type.Peper)
{
if (InventorySlotIsFilled1 == false)
{
InventorySlotIsFilled1 = true;
ItemInInventorySlot1 = 3;
InventorySlot13.gameObject.SetActive(true);
PlayerAudio.Play();
}
else if (InventorySlotIsFilled2 == false)
{
InventorySlotIsFilled2 = true;
ItemInInventorySlot2 = 3;
InventorySlot23.gameObject.SetActive(true);
PlayerAudio.Play();
}
else if (InventorySlotIsFilled3 == false)
{
InventorySlotIsFilled3 = true;
ItemInInventorySlot3 = 3;
InventorySlot33.gameObject.SetActive(true);
PlayerAudio.Play();
}
}
else if (foodType == Food_Type.Groente)
{
if (InventorySlotIsFilled1 == false)
{
InventorySlotIsFilled1 = true;
ItemInInventorySlot1 = 5;
InventorySlot15.gameObject.SetActive(true);
PlayerAudio.Play();
}
else if (InventorySlotIsFilled2 == false)
{
InventorySlotIsFilled2 = true;
ItemInInventorySlot2 = 5;
InventorySlot25.gameObject.SetActive(true);
PlayerAudio.Play();
}
else if (InventorySlotIsFilled3 == false)
{
InventorySlotIsFilled3 = true;
ItemInInventorySlot3 = 5;
InventorySlot35.gameObject.SetActive(true);
PlayerAudio.Play();
}
}
}
if (Input.GetKeyDown(interactionKey) && AttemptToTrash == true)
{
ResetInventorySlot1();
ResetInventorySlot2();
ResetInventorySlot3();
}
if (Input.GetKeyDown(interactionKey) && deliveryattempt == true && PlayerNumber == 1)
{
// check if desired food is being delivered
if (ItemInInventorySlot1 == GameObject.FindGameObjectWithTag("Delivery").GetComponent <IngrediëntQuest>().Questnumber)
{
ResetInventorySlot1();
//add score
Score += 1;
scoreTotal.text = "Score: " + Score.ToString();
CorrectObjectGiven.Play();
GameObject.FindGameObjectWithTag("Delivery").GetComponent <IngrediëntQuest>().NewQuest();
}
else if (ItemInInventorySlot2 == GameObject.FindGameObjectWithTag("Delivery").GetComponent <IngrediëntQuest>().Questnumber)
{
ResetInventorySlot2();
//add score
Score += 1;
scoreTotal.text = "Score: " + Score.ToString();
CorrectObjectGiven.Play();
GameObject.FindGameObjectWithTag("Delivery").GetComponent <IngrediëntQuest>().NewQuest();
}
else if (ItemInInventorySlot3 == GameObject.FindGameObjectWithTag("Delivery").GetComponent <IngrediëntQuest>().Questnumber)
{
ResetInventorySlot3();
//add score
Score += 1;
scoreTotal.text = "Score: " + Score.ToString();
CorrectObjectGiven.Play();
GameObject.FindGameObjectWithTag("Delivery").GetComponent <IngrediëntQuest>().NewQuest();
}
}
if (Input.GetKeyDown(interactionKey) && deliveryattempt == true && PlayerNumber == 2)
{
// check if desired food is being delivered
if (ItemInInventorySlot1 == GameObject.FindGameObjectWithTag("Delivery1").GetComponent <IngrediëntQuest>().Questnumber)
{
ResetInventorySlot1();
//add score
Score += 1;
scoreTotal.text = "Score: " + Score.ToString();
CorrectObjectGiven.Play();
GameObject.FindGameObjectWithTag("Delivery1").GetComponent <IngrediëntQuest>().NewQuest();
}
else if (ItemInInventorySlot2 == GameObject.FindGameObjectWithTag("Delivery1").GetComponent <IngrediëntQuest>().Questnumber)
{
ResetInventorySlot2();
//add score
Score += 1;
scoreTotal.text = "Score: " + Score.ToString();
CorrectObjectGiven.Play();
GameObject.FindGameObjectWithTag("Delivery1").GetComponent <IngrediëntQuest>().NewQuest();
}
else if (ItemInInventorySlot3 == GameObject.FindGameObjectWithTag("Delivery1").GetComponent <IngrediëntQuest>().Questnumber)
{
ResetInventorySlot3();
//add score
Score += 1;
scoreTotal.text = "Score: " + Score.ToString();
CorrectObjectGiven.Play();
GameObject.FindGameObjectWithTag("Delivery1").GetComponent <IngrediëntQuest>().NewQuest();
}
}
}
