private void bunifuFlatButton1_Click(object sender, EventArgs e) { textBox_itemname.Show(); textBox_itemdescription.Show(); expiry_date.Show(); button_create.Show(); button_update.Show(); button_reset.Show(); label2.Show(); Item_name.Show(); labelbel.Show(); label3.Show(); textBox_initial_quant.Show(); label_initial_quant.Show(); label9.Show(); textBox_reorder.Show(); label_supplier.Show(); textBox_supplier.Show(); bunifuFlatButton2.Show(); dataGridView2.Hide(); dataGridView1.Show(); comboBox_status.Hide(); loadAll(); }
//This is definitely not the best way of doing things.... void load_item_stats(Item_name _name) { switch (_name) { case Item_name.LONG_SWORD: cost = 350; stats_add.damage = 10f; break; case Item_name.PICKAXE: cost = 875; stats_add.damage = 25; break; case Item_name.LAST_WHISPER: cost = 425; stats_add.damage = 25f; stats_mult.armor_pen_percent = 0.3f; break; case Item_name.YOUMUUS_GHOSTBLADE: cost = 1000; stats_add.damage = 60f; stats_add.crd = 0.1f; break; default: break; } }
Item_name[] comps; //components public void init(Item_name _name) { cost = 0; //cost of itself, not incluing components comps = new Item_name[5]; //max 5 components Onhit_dmg.init(); stats_add.init(); stats_mult.init(); stats_add_base.init(); stats_mult_base.init(); ItemName = _name; load_item_stats(_name); }
private void button_stock_Click(object sender, EventArgs e) { textBox_itemname.Hide(); textBox_itemdescription.Hide(); button_add.Hide(); button_deduct.Hide(); expiry_date.Hide(); button_create.Hide(); button_update.Hide(); button_reset.Hide(); label2.Hide(); Item_name.Hide(); labelbel.Hide(); label3.Hide(); checkbox_expiry.Hide(); label4.Hide(); dataGridView1.Hide(); dataGridView2.Show(); textBox_initial_quant.Hide(); label_initial_quant.Hide(); label9.Hide(); textBox_reorder.Hide(); label_supplier.Hide(); textBox_supplier.Hide(); bunifuFlatButton2.Hide(); string query = "SELECT stock_id, stock_inventory_id, stock_label, stock_name, stock_value, stock_description, stock_date," + "stock_appointment_id, stock_appointment_name from stock"; conn.Open(); MySqlCommand com = new MySqlCommand(query, conn); MySqlDataAdapter adp = new MySqlDataAdapter(com); conn.Close(); DataTable dt = new DataTable(); adp.Fill(dt); dataGridView2.DataSource = dt; dataGridView2.Columns["stock_id"].Visible = false; dataGridView2.Columns["stock_inventory_id"].Visible = false; dataGridView2.Columns["stock_label"].HeaderText = "In / out"; dataGridView2.Columns["stock_name"].HeaderText = "Item Name "; dataGridView2.Columns["stock_value"].HeaderText = "No. Items"; dataGridView2.Columns["stock_description"].HeaderText = "Reason"; dataGridView2.Columns["stock_date"].HeaderText = "Date issued"; dataGridView2.Columns["stock_appointment_id"].HeaderText = "Appointment No."; dataGridView2.Columns["stock_appointment_name"].HeaderText = "Name"; dataGridView2.Sort(dataGridView2.Columns[1], ListSortDirection.Ascending); }
private void bunifuFlatButton1_Click(object sender, EventArgs e) { textBox_itemname.Show(); textBox_itemdescription.Show(); expiry_date.Show(); button_create.Show(); button_update.Show(); button_reset.Show(); label2.Show(); Item_name.Show(); labelbel.Show(); label3.Show(); loadAll(); }
private void Add_DB_Click(object sender, RoutedEventArgs e) { if (string.Compare(Item_name.Text, "") == 0) { return; } now_DB[now_item.Id] = new ItemDB(now_item); BindingItemList.AddList(new ItemDB(now_item)); InitializeContents(); Item_name.Focus(); DB_ListBox.SelectedIndex = -1; _isNew = true; }
private void label_equip_Click(object sender, EventArgs e) { dataGridView2.Hide(); dataGridView1.Hide(); loadAll(); label4.Hide(); label5.Hide(); expiry_date.Enabled = false; button_add.Hide(); button_deduct.Hide(); Item_name.Hide(); label2.Hide(); labelbel.Hide(); label3.Hide(); label4.Hide(); textBox_itemname.Hide(); textBox_itemdescription.Hide(); expiry_date.Hide(); checkbox_expiry.Hide(); button_create.Hide(); button_update.Hide(); button_reset.Hide(); bunifuFlatButton2.Hide(); textBox_supplier.Hide(); label_supplier.Hide(); label_initial_quant.Hide(); textBox_initial_quant.Hide(); label9.Hide(); textBox_reorder.Hide(); dataGridView3.Show(); Label_equipmentname.Show(); label_equipmentdesc.Show(); label_status.Show(); textBox_equipmentname.Show(); textBox_equipmentdesc.Show(); comboBox_status.Show(); button__create.Show(); button__update.Show(); button__reset.Show(); }
private void Add_DB_Click(object sender, RoutedEventArgs e) { if (string.Compare(Item_name.Text, "") == 0) { return; } if (cmb_item_type.SelectedIndex == (int)ITEM_TYPE_ENUM.SET_OPTION) { now_item.SetName = now_item.Name; } now_DB[now_item.Id] = new ItemDB(now_item); BindingItemList.AddList(new ItemDB(now_item)); InitializeContents(); Item_name.Focus(); DB_ListBox.SelectedIndex = -1; _isNew = true; }
private void button_stock_Click(object sender, EventArgs e) { textBox_itemname.Hide(); textBox_itemdescription.Hide(); button_add.Hide(); button_deduct.Hide(); expiry_date.Hide(); button_create.Hide(); button_update.Hide(); button_reset.Hide(); label2.Hide(); Item_name.Hide(); labelbel.Hide(); label3.Hide(); string query = "SELECT * from stock"; conn.Open(); MySqlCommand com = new MySqlCommand(query, conn); MySqlDataAdapter adp = new MySqlDataAdapter(com); conn.Close(); DataTable dt = new DataTable(); adp.Fill(dt); dataGridView1.DataSource = dt; dataGridView1.Columns["stock_id"].Visible = false; dataGridView1.Columns["stock_inventory_id"].Visible = false; dataGridView1.Columns["stock_label"].HeaderText = "In / out"; dataGridView1.Columns["stock_name"].HeaderText = "Item Name "; dataGridView1.Columns["stock_value"].HeaderText = "No. Items"; dataGridView1.Columns["stock_description"].HeaderText = "Reason"; dataGridView1.Columns["stock_date"].HeaderText = "Date issued"; dataGridView1.Sort(dataGridView1.Columns[1], ListSortDirection.Ascending); }
private void New_DB_Click(object sender, RoutedEventArgs e) { InitializeContents(); Item_name.Focus(); DB_ListBox.SelectedIndex = -1; }
protected void btn_Assign_Click(object sender, EventArgs e) { conn = new MySql.Data.MySqlClient.MySqlConnection(ConnString); try { //check whether all the fields are not null bool fieldsReq = RequiredFieldValidate(); if (fieldsReq) { String listOfItemsnqty = (tb_items_withqty.Text).Trim(); if (listOfItemsnqty.EndsWith(",")) { listOfItemsnqty = listOfItemsnqty.Substring(0, listOfItemsnqty.Length - 1); } String[] arrayOfItemsnqty = listOfItemsnqty.Split(','); //Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('"+ arrayOfAssignedManagers[2] + "');</script>"); String Item_name; String Item_qty; double count = 0; for (int i = 0; i < arrayOfItemsnqty.Length; i++) { conn.Open(); try { Item_name = arrayOfItemsnqty[i].Split('-')[0].Trim(); Item_qty = arrayOfItemsnqty[i].Split('-')[1].Trim(); System.Diagnostics.Debug.WriteLine(Item_name); System.Diagnostics.Debug.WriteLine(Item_qty); cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM all_items where item_name='" + Item_name + "' "; reader = cmd.ExecuteReader(); if (reader.Read()) { hiiden_description.Text = reader.GetString("description"); hidden_itemprice.Text = reader.GetString("item_price"); hidden_uom.Text = reader.GetString("uom"); hidden_supplier.Text = reader.GetString("supplier"); hidden_sup_email.Text = reader.GetString("supplier_email"); } conn.Close(); //Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('"+ hiiden_designation.Text + "');</script>"); conn.Open(); queryStr = "insert into item (item_name,description,uom,item_price,quantity,supplier,supplier_email,reqid) values ('" + Item_name.Trim() + "','" + hiiden_description.Text + "','" + hidden_uom.Text + "','" + Convert.ToDouble(hidden_itemprice.Text) + "','" + Convert.ToDouble(Item_qty) + "','" + hidden_supplier.Text + "','" + hidden_sup_email.Text + "','" + Convert.ToInt32(tb_reqid.Text) + "')"; cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn); cmd.ExecuteNonQuery(); conn.Close(); Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Succesfully Inserted.! ');</script>"); conn.Close(); count = count + (Convert.ToDouble(hidden_itemprice.Text) * Convert.ToDouble(Item_qty)); } catch { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('failed');</script>"); } } //queryStr = "insert into assigned_employee (name,designation,email,reqid) values ('" + tb_expenseid.Text + "','" + tb_expensedate.Text + "','" + Convert.ToString(list_expensetype.SelectedValue) + "','" + tb_expensedescription.Text + "','" + tb_expenseamount.Text + "')"; //cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn); //cmd.ExecuteNonQuery(); //Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Succesfully Inserted.! ');</script>"); tb_itemPrice.Text = count.ToString(); conn = new MySql.Data.MySqlClient.MySqlConnection(ConnString); conn.Open(); double policy_amount; try { cmd = conn.CreateCommand(); cmd.CommandText = "SELECT * FROM policy where policy_name='Requisition Approval'"; reader = cmd.ExecuteReader(); if (reader.Read()) { policy_amount = reader.GetDouble("amount"); //if (count > policy_amount) //{ // //Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('ALERT..!!! \n Item cost exceeds the policy amount. Need supervisor approval for this.!!!');</script>"); // lbl_warning.Visible = true; // lbl_done.Visible = false; //} if (checkPlicyAmount(count, policy_amount)) { lbl_warning.Visible = true; lbl_done.Visible = false; } else { //Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('ALERT..!!! \n Item cost exceeds the policy amount. Need supervisor approval for this.!!!');</script>"); lbl_done.Visible = true; lbl_warning.Visible = false; } } } catch { } conn.Close(); } else { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please add items to create requisition..!!');</script>"); } } catch (Exception ex) { Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Data insertion failed');</script>"); } }