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