//////////////////////////////////////////////////////////////////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 } }; }