//////////////////////////////////////////////////////////////////REQUÊTE AFIN DE RECUPERER UN TYPE////////////////////////////
public static List <TypeAC> getType()
{
List <TypeAC> UnType = new List <TypeAC>();
try
{
MySqlConnection cnx = MySQL.getCnx();
cnx.Ping();
string requete = "SELECT AT_LIBELLE, AT_POIDS FROM accompagnementtype ";
MySqlCommand cmd = new MySqlCommand(requete, cnx);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
TypeAC LeGrammage = new TypeAC();
LeGrammage.Libelle = reader.GetString(0);
LeGrammage.Gramme = reader.GetInt32(1);
UnType.Add(LeGrammage);
}
cnx.Close();
return(UnType);
}
catch (MySqlException ex)
{
TypeAC erreurSQL = new TypeAC();
erreurSQL.Description = (ex.ToString());
UnType.Add(erreurSQL);
return(UnType);
}
}
//////////////////////////////////////////////////////////////////REQUÊTE AFIN DE UPDATE UN GRAMMAGE D'UN TYPE////////////////////////////
public static List <TypeAC> setUnGrammage(string poidtype, string typeaccomp)
{
List <TypeAC> NewGrammage = new List <TypeAC>();
try
{
MySqlConnection cnx = MySQL.getCnx();
cnx.Ping();
string requete = "UPDATE accompagnementtype SET AT_POIDS = '" + poidtype + "' WHERE AT_LIBELLE='" + typeaccomp + "'";
MySqlCommand cmd = new MySqlCommand(requete, cnx);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
TypeAC LeGrammage = new TypeAC();
LeGrammage.Gramme = reader.GetInt32(0);
NewGrammage.Add(LeGrammage);
}
cnx.Close();
return(NewGrammage);
}
catch (MySqlException ex)
{
TypeAC erreurSQL = new TypeAC();
erreurSQL.Description = (ex.ToString());
NewGrammage.Add(erreurSQL);
return(NewGrammage);
}
}
public ModifGrammage()
{
Title = "Modification des quantités de chaque famille d'accompagnements";
StackLayout stackPrincipal = new StackLayout();
Label header = new Label
{
Text = "Type d'Accompagnement",
FontSize = Device.GetNamedSize(NamedSize.Large, typeof(EntryCell)),
HorizontalOptions = LayoutOptions.Center
};
String Accompagnement = "";
int prop = 0;
String Accompagnement2 = "";
int prop2 = 0;
String Accompagnement3 = "";
int prop3 = 0;
List <TypeAC> lesAccompagnements = Database.MyCantineSQL.getType();
for (int i = 0; i < lesAccompagnements.Count; i++)
{
TypeAC unAccompagnement = lesAccompagnements[i];
if (Accompagnement == "")
{
Accompagnement = unAccompagnement.Libelle;
prop = unAccompagnement.Gramme;
}
else if (i + 1 == lesAccompagnements.Count)
{
Accompagnement3 = unAccompagnement.Libelle;
prop3 = unAccompagnement.Gramme;
}
else
{
Accompagnement2 = unAccompagnement.Libelle;
prop2 = unAccompagnement.Gramme;
}
}
StackLayout Layout1 = new StackLayout
{
Orientation = StackOrientation.Horizontal,
};
var label1 = new Label
{
Text = Accompagnement + " : ",
VerticalTextAlignment = TextAlignment.Center,
FontSize = 40
};
var MyEntry = new Entry {
Text = "", Placeholder = prop + "", ClassId = Accompagnement, Keyboard = Keyboard.Numeric, FontSize = 40
};
var label11 = new Label
{
Text = " g/p\n",
VerticalTextAlignment = TextAlignment.Center,
FontSize = 40
};
StackLayout Layout2 = new StackLayout
{
Orientation = StackOrientation.Horizontal
};
var label2 = new Label
{
Text = Accompagnement2 + " : ",
VerticalTextAlignment = TextAlignment.Center,
FontSize = 40
};
var MyEntry2 = new Entry {
Text = "", Placeholder = prop2 + "", ClassId = Accompagnement2, Keyboard = Keyboard.Numeric, FontSize = 40
};
var label22 = new Label
{
Text = " g/p\n",
VerticalTextAlignment = TextAlignment.Center,
FontSize = 40
};
StackLayout Layout3 = new StackLayout
{
Orientation = StackOrientation.Horizontal
};
var label3 = new Label
{
Text = Accompagnement3 + " : ",
VerticalTextAlignment = TextAlignment.Center,
FontSize = 40
};
var MyEntry3 = new Entry {
Text = "", Placeholder = prop3 + "", ClassId = Accompagnement3, Keyboard = Keyboard.Numeric, FontSize = 40
};
var label33 = new Label
{
Text = " g/p\n",
VerticalTextAlignment = TextAlignment.Center,
FontSize = 40
};
Button bouton = new Button()
{
Margin = new Thickness(1, 1, 1, 1),
BackgroundColor = Color.FromHex("#27ae60"),
BorderColor = Color.GhostWhite,
BorderWidth = 2,
CornerRadius = 10,
Text = "Validation",
IsVisible = true,
TextColor = Color.White,
};
bouton.Clicked += Validation;
async void Validation(object sender, EventArgs e)
{
if (MyEntry.Text != "")
{
if (MyEntry2.Text != "" && MyEntry3.Text != "")
{
Database.MyCantineSQL.setUnGrammage(MyEntry.Text, Accompagnement);
Database.MyCantineSQL.setUnGrammage(MyEntry2.Text, Accompagnement2);
Database.MyCantineSQL.setUnGrammage(MyEntry3.Text, Accompagnement3);
}
else if (MyEntry2.Text != "" && MyEntry3.Text == "")
{
Database.MyCantineSQL.setUnGrammage(MyEntry.Text, Accompagnement);
Database.MyCantineSQL.setUnGrammage(MyEntry2.Text, Accompagnement2);
}
else if (MyEntry2.Text == "" && MyEntry3.Text != "")
{
Database.MyCantineSQL.setUnGrammage(MyEntry.Text, Accompagnement);
Database.MyCantineSQL.setUnGrammage(MyEntry3.Text, Accompagnement3);
}
else
{
Database.MyCantineSQL.setUnGrammage(MyEntry.Text, Accompagnement);
}
}
else if (MyEntry2.Text != "")
{
if (MyEntry.Text != "" && MyEntry3.Text != "")
{
Database.MyCantineSQL.setUnGrammage(MyEntry.Text, Accompagnement);
Database.MyCantineSQL.setUnGrammage(MyEntry2.Text, Accompagnement2);
Database.MyCantineSQL.setUnGrammage(MyEntry3.Text, Accompagnement3);
}
else if (MyEntry.Text == "" && MyEntry3.Text != "")
{
Database.MyCantineSQL.setUnGrammage(MyEntry2.Text, Accompagnement2);
Database.MyCantineSQL.setUnGrammage(MyEntry3.Text, Accompagnement3);
}
else
{
Database.MyCantineSQL.setUnGrammage(MyEntry2.Text, Accompagnement2);
}
}
else if (MyEntry3.Text != "")
{
if (MyEntry.Text != "" && MyEntry2.Text != "")
{
Database.MyCantineSQL.setUnGrammage(MyEntry.Text, Accompagnement);
Database.MyCantineSQL.setUnGrammage(MyEntry2.Text, Accompagnement2);
Database.MyCantineSQL.setUnGrammage(MyEntry3.Text, Accompagnement3);
}
else
{
Database.MyCantineSQL.setUnGrammage(MyEntry3.Text, Accompagnement3);
}
}
await Navigation.PushAsync(new ModifGrammage());
}
// Accomodate iPhone status bar.
this.Padding = new Thickness(10, Device.OnPlatform(20, 0, 0), 10, 5);
Layout1.Children.Add(label1);
Layout1.Children.Add(MyEntry);
Layout1.Children.Add(label11);
menuStack.Children.Add(Layout1);
Layout2.Children.Add(label2);
Layout2.Children.Add(MyEntry2);
Layout2.Children.Add(label22);
menuStack2.Children.Add(Layout2);
Layout3.Children.Add(label3);
Layout3.Children.Add(MyEntry3);
Layout3.Children.Add(label33);
menuStack3.Children.Add(Layout3);
this.Content = new StackLayout
{
Children =
{
menuStack,
menuStack2,
menuStack3,
bouton
}
};
}
