public Form1()
{
InitializeComponent();
string MyConString = "SERVER=db4free.net;" + "DATABASE=kitbox_kewlax;" + "UID=kewlaw;" + "PASSWORD=locomac6; old guids = true";
MySqlConnection conn = new MySqlConnection(MyConString);
conn.Open();
List <string> WidthBoxList = QueryKitbox.SpecsBoxList(conn, "Largeur", "Ref = \"Panneau Ar\"");
conn.Close();
conn.Open();
List <string> HeightBoxList = QueryKitbox.SpecsBoxList(conn, "hauteur", "Ref = \"Panneau GD\"");
conn.Close();
conn.Open();
List <string> ColorBoxList = QueryKitbox.SpecsBoxList(conn, "Couleur", "Ref = \"Porte\"");
conn.Close();
conn.Open();
List <string> DepthBoxList = QueryKitbox.SpecsBoxList(conn, "profondeur", "Ref = \"Panneau GD\"");
conn.Close();
/*
* conn.Open();
* List<string> ColorcrossList = QueryKitbox.SpecsBoxList(conn, "Couleur", "Ref = \"Traverse AR\"");
* conn.Close();
*/
comboBox3.Items.AddRange(new object[] { "1", "2", "3", "4", "5", "6", "7" });
comboBox4.Items.AddRange(WidthBoxList.Cast <object>().ToArray());
comboBox5.Items.AddRange(DepthBoxList.Cast <object>().ToArray());
comboBox6.Items.AddRange(HeightBoxList.Cast <object>().ToArray());
comboBox2.Items.AddRange(ColorBoxList.Cast <object>().ToArray());
}
public Form_purchase()
{
InitializeComponent();
int totalHeight = 0;
Locker locker;
foreach (ICupboardComponents cupCompo in ShoppingCart.cupboardComponentsList)
{
if (cupCompo is Locker)
{
locker = (Locker)cupCompo;
int currentbox = locker.ID;
string height = locker.height.ToString();
//string depth = locker.depth.ToString();
string doorsColor = EnumParse.parseColorEnumToStr(locker.doorsColor);
string panelColor = EnumParse.parseColorEnumToStr(locker.panelColor);
string price = locker.price.ToString();
totalHeight += locker.height + 4;
dataGridView1.Rows.Add(currentbox, height, doorsColor, false, panelColor, price);
}
}
string MyConString = "SERVER=db4free.net;" + "DATABASE=kitbox_kewlax;" + "UID=kewlaw;" + "PASSWORD=locomac6; old guids = true";
MySqlConnection conn = new MySqlConnection(MyConString);
conn.Open();
List <string> HeightBracketsList = QueryKitbox.SpecsBoxList(conn, "Height", "Ref = \"AngleBracket\"");
conn.Close();
int angleBracketHeight = 0;
int diff;
int minDiff = 1000;
foreach (string heightBracket in HeightBracketsList)
{
diff = Int32.Parse(heightBracket) - totalHeight;
if (diff >= 0 && diff < minDiff)
{
minDiff = diff;
angleBracketHeight = Int32.Parse(heightBracket);
}
}
conn.Open();
string angleBracketPrices = DbUtils.BigMoney(conn, "CustPrice", "AngleBracket", angleBracketHeight.ToString(), "0", "0", EnumParse.parseColorEnumToStr(ShoppingCart.colorAngleBracketChosen))[0];
conn.Close();
double angleBracketPrice = Double.Parse(angleBracketPrices);
AngleBracket angleBrackets = new AngleBracket(angleBracketPrice, "null", "0000", new ComponentSize(0, 0, 0), true, ShoppingCart.colorAngleBracketChosen);
ShoppingCart.addCupboardComponent(angleBrackets);
dataGridView1.Rows.Add("Anglebrackets", angleBracketHeight, " ", null, " ", angleBracketPrice.ToString() + " x4");
}
private void button3_Click(object sender, EventArgs e)
{
//refresh combobox height
string MyConString = "SERVER=db4free.net;" + "DATABASE=kitbox_kewlax;" + "UID=kewlaw;" + "PASSWORD=locomac6; old guids = true";
MySqlConnection conn = new MySqlConnection(MyConString);
conn.Open();
List <string> HeightBoxList = QueryKitbox.SpecsBoxList(conn, "hauteur", "Ref = \"Panneau GD\"");
conn.Close();
comboBox6.Items.Clear();
comboBox6.Items.AddRange(HeightBoxList.Cast <object>().ToArray());
//allow to create new cupboard
button1.Enabled = true;
}
private void button3_Click(object sender, EventArgs e)
{
button2.Visible = false;
button2.Enabled = false;
button4.Visible = true;
button4.Enabled = true;
dataGridView1.Enabled = true;
string MyConString = "SERVER=db4free.net;" + "DATABASE=kitbox_kewlax;" + "UID=kewlaw;" + "PASSWORD=locomac6; old guids = true";
MySqlConnection conn = new MySqlConnection(MyConString);
conn.Open();
List <string> HeightBoxList = QueryKitbox.SpecsBoxList(conn, "Height", "Ref = \"Panel B\"");
conn.Close();
comboBox5.Items.Clear();
comboBox5.Items.AddRange(HeightBoxList.Cast <object>().ToArray());
}
public User_Interface()
{
InitializeComponent();
this.WindowState = FormWindowState.Maximized;
string MyConString = "SERVER=localhost;" + "DATABASE=kitbox;" + "UID=root;" + "PASSWORD=K8tB0x_sql; old guids = true";
//string MyConString = "SERVER=db4free.net;" + "DATABASE=kitbox_kewlax;" + "UID=kewlaw;" + "PASSWORD=locomac6; old guids = true";
MySqlConnection conn = new MySqlConnection(MyConString);
conn.Open();
List <string> WidthBoxList = QueryKitbox.SpecsBoxList(conn, "Width", "Ref = \"Panel B\"");
conn.Close();
conn.Open();
List <string> DepthBoxList = QueryKitbox.SpecsBoxList(conn, "Depth", "Ref = \"Panel LR\"");
conn.Close();
conn.Open();
List <string> BracketsColorList = QueryKitbox.SpecsBoxList(conn, "Colour", "Ref = \"AngleBracket\"");
conn.Close();
conn.Open();
List <string> HeightBoxList = QueryKitbox.SpecsBoxList(conn, "Height", "Ref = \"Panel B\"");
conn.Close();
conn.Open();
List <string> ColorDoorList = QueryKitbox.SpecsBoxList(conn, "Colour", "Ref = \"Door\"");
conn.Close();
conn.Open();
List <string> ColorPannelBaList = QueryKitbox.SpecsBoxList(conn, "Colour", "Ref = \"Panel B\"");
conn.Close();
conn.Open();
List <string> HeightBracketsList = QueryKitbox.SpecsBoxList(conn, "Height", "Ref = \"AngleBracket\"");
conn.Close();
comboBox1.Items.AddRange(new object[] { "1", "2", "3", "4", "5", "6", "7" });
//TODO : get variable globale max_lockers puis boucle pour remplir combobox3
comboBox2.Items.AddRange(WidthBoxList.Cast <object>().ToArray());
comboBox3.Items.AddRange(DepthBoxList.Cast <object>().ToArray());
comboBox4.Items.AddRange(BracketsColorList.Cast <object>().ToArray());
comboBox5.Items.AddRange(HeightBoxList.Cast <object>().ToArray());
comboBox6.Items.AddRange(ColorDoorList.Cast <object>().ToArray());
comboBox6.Items.Add("none");
comboBox7.Items.AddRange(ColorPannelBaList.Cast <object>().ToArray());
comboBox9.Items.AddRange(new object[] { "yes", "no" });
int maxHeight = 0;
foreach (string heightB in HeightBracketsList)
{
int heightBP = Int32.Parse(heightB);
if (heightBP > maxHeight)
{
maxHeight = heightBP;
}
}
textBox12.Text = "0";
textBox14.Text = maxHeight.ToString();
textBox16.Text = "0";
dataGridView1.Enabled = false;
}
