private void btnSaveItem_Click(object sender, EventArgs e) { bool flag = false; Items _items = new Items(); _items.Name_model_item = txtItem.Text; _items.Size_model_item = txtSize.Text; _items.Colour_model_item = txtColour.Text; _items.Price_model_item = double.Parse(txtPrice.Text); _items.Item_quantity = int.Parse(txtQuantity.Text); _items.Status_stock = cmbStatus.Text; CtrlItems ctrl = new CtrlItems(); if (txtItem_ID.Text != "") { _items.Id_model_item = int.Parse(txtItem_ID.Text); flag = ctrl.update(_items); } else { flag = ctrl.insert(_items); } if (flag) { MessageBox.Show("Item saved"); clear_data(); loadTable(null); } }
public void loadTable(string data) { List <Items> lista = new List <Items>(); CtrlItems _ctrlItems = new CtrlItems(); dataGridView1.DataSource = _ctrlItems.request(data); }
private void btnDeleteItem_Click(object sender, EventArgs e) { bool flag = false; DialogResult message = MessageBox.Show("Are you sure that you want to delete the item?", "Exit", MessageBoxButtons.YesNoCancel); if (message == DialogResult.Yes) { int id = int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()); CtrlItems _ctrl = new CtrlItems(); flag = _ctrl.delete(id); if (flag) { MessageBox.Show("Item saved"); clear_data(); loadTable(null); } } }
public DateTime EstimateDeliveryTime() { string sql = "SELECT max(production_date) FROM command"; MySqlConnection connectionDB = Connection.connection(); connectionDB.Open(); DateTime myDate = DateTime.Now; try { string date; MySqlCommand comando = new MySqlCommand(sql, connectionDB); MySqlDataReader reader = comando.ExecuteReader(); if (reader.Read()) { try { date = reader.GetString(0); myDate = Convert.ToDateTime(date); myDate = myDate.AddDays(1); date = myDate.ToString(); var x = date.Split(' '); x[1] = "08:00:00"; date = string.Join(" ", x); myDate = Convert.ToDateTime(date); } catch { myDate = myDate.AddDays(1); date = myDate.ToString(); var x = date.Split(' '); x[1] = "08:00:00"; date = string.Join(" ", x); myDate = Convert.ToDateTime(date); } } CtrlItems _ctrlItems = new CtrlItems(); List <Object> stock = _ctrlItems.request(null); bool notEnough = false; int production_time = 0; int days = 0; foreach (Model_Bike element in Form1.Instance.Cart.list_models) { if (!notEnough) { foreach (KeyValuePair <string, int> item in element.items) { String name = item.Key.Split('_')[0]; String color = item.Key.Split('_')[1]; String size = item.Key.Split('_')[2]; int qtt_will_use = item.Value * element.quantity; foreach (Items elem_stock in stock) { if (name == elem_stock.Name_model_item && color == elem_stock.Colour_model_item && size == elem_stock.Size_model_item) { elem_stock.Qtt_available -= qtt_will_use; notEnough = elem_stock.Qtt_available - elem_stock.Qtt_used < 0 ? true : false; if (notEnough) { days += 7; } } } } } for (int i = 0; i < element.quantity; i++) { if (element.type == "City") { production_time += 120; } else if (element.type == "Explorer") { production_time += 150; } else { production_time += 165; } if (production_time / 3 >= 8 * 60) { production_time = 0; days++; } } } Console.WriteLine(production_time); production_time = production_time / 3 + 100; myDate = myDate.AddDays(days); myDate = myDate.AddMinutes(production_time); } catch (Exception e) { MessageBox.Show(e.Message); } finally{ connectionDB.Close(); } return(myDate); }