public void loadTable(string data)
{
List <Items> lista = new List <Items>();
CtrlItems _ctrlItems = new CtrlItems();
dataGridView1.DataSource = _ctrlItems.request(data);
}
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);
}