Example #1
0
		protected override void OnCreate (Bundle savedInstanceState)
		{
			base.OnCreate (savedInstanceState);
			SetContentView (Resource.Layout.ListeLivraisons);

			type = Intent.GetStringExtra ("TYPE");
			if (type == "RAM") {
				tyS = "RAM";
				tyM = "C";
			} else {				
				tyS = "LIV";
				tyM = "L";
			}

			//declaration des clicks btns
			Button btngrpAll = FindViewById<Button> (Resource.Id.btn_all);
			Button btngrp1 = FindViewById<Button> (Resource.Id.btn_1);
			Button btngrp2 = FindViewById<Button> (Resource.Id.btn_2);
			Button btngrp3 = FindViewById<Button> (Resource.Id.btn_3);
			Button btngrp4 = FindViewById<Button> (Resource.Id.btn_4);
			LinearLayout btnsearch = FindViewById<LinearLayout> (Resource.Id.btn_search);
			Button btntrait = FindViewById<Button> (Resource.Id.btn_traite);

			//FONTS
			btngrpAll.SetTypeface (Data.LatoRegular, Android.Graphics.TypefaceStyle.Normal);
			btngrp1.SetTypeface (Data.LatoRegular, Android.Graphics.TypefaceStyle.Normal);
			btngrp2.SetTypeface (Data.LatoRegular, Android.Graphics.TypefaceStyle.Normal);
			btngrp3.SetTypeface (Data.LatoRegular, Android.Graphics.TypefaceStyle.Normal);
			btngrp4.SetTypeface (Data.LatoRegular, Android.Graphics.TypefaceStyle.Normal);
			btntrait.SetTypeface (Data.LatoRegular, Android.Graphics.TypefaceStyle.Normal);

			if (type == "RAM") {
				btntrait.Text = "Ramasses";
			} else {
				btntrait.Text = "Livraisons";
			}

			btngrpAll.Click += delegate {
				btngrpAll_Click();
			};
			btngrp1.Click += delegate {
				btngrp1_Click();
			};
			btngrp2.Click += delegate {
				btngrp2_Click();
			};
			btngrp3.Click += delegate {
				btngrp3_Click();
			};
			btnsearch.Click += delegate {
				btnsearch_Click();
			};
			btntrait.Click += delegate {
				btntrait_Click();
			};


			//Mise dans un Array des Groupage
			string dbPath = System.IO.Path.Combine(System.Environment.GetFolderPath
				(System.Environment.SpecialFolder.Personal), "ormDMS.db3");
			var db = new SQLiteConnection(dbPath);
			var grp = db.Query<TablePositions> ("SELECT * FROM TablePositions WHERE StatutLivraison = ? AND typeMission= ? AND typeSegment= ?  AND Userandsoft = ? OR StatutLivraison = ? AND typeMission= ? AND typeSegment= ?  AND Userandsoft = ?  GROUP BY groupage",1,tyM,tyS,Data.userAndsoft,2,tyM,tyS,Data.userAndsoft);

			int i = 1;
			int countGrp = 0;
			foreach (var item in grp){				
				Arraygrp[i] = item.groupage;
				i++;
				countGrp++;
			}

			switch (countGrp) {
			case 0:
				//btn all big size
				btngrpAll.SetWidth (5000);
				//afficher pas de tournée au milieu et sur le btnall
				btngrpAll.Text = "Aucune position";
				break;
			case 1:
				//btn all avec le num de grp
				btngrpAll.SetWidth (5000);
				btngrpAll.Text = Arraygrp[1];
				break;
			case 2:
				//afficher le btn 1 et 2
				btngrp1.Visibility = ViewStates.Visible;
				btngrp1.Text = Arraygrp[1];
				btngrp2.Visibility = ViewStates.Visible;
				btngrp2.Text = Arraygrp[2];
				break;
			case 3:
				//afficher le btn 1,2 et 3
				btngrp1.Visibility = ViewStates.Visible;
				btngrp1.Text = Arraygrp[1];
				btngrp2.Visibility = ViewStates.Visible;
				btngrp2.Text = Arraygrp[2];
				btngrp3.Visibility = ViewStates.Visible;
				btngrp3.Text = Arraygrp[3];
				break;
			case 4:
				//afficher le btn 1,2,3 et 4
				btngrp1.Visibility = ViewStates.Visible;
				btngrp1.Text = Arraygrp[1];

				btngrp2.Visibility = ViewStates.Visible;
				btngrp2.Text = Arraygrp[2];

				btngrp3.Visibility = ViewStates.Visible;
				btngrp3.Text = Arraygrp[3];

				btngrp4.Visibility = ViewStates.Visible;
				btngrp4.Text = Arraygrp[4];
				break;
			default:
				//btn all big size
				btngrpAll.SetWidth (5000);
				//afficher pas de tournée au milieu et sur le btnall
				btngrpAll.Text = "Aucune position";
				break;
			}

			//LISTVIEW
			bodyListView = FindViewById<ListView> (Resource.Id.bodylist);
			bodyItems = new List<TablePositions> ();

			bodyListView.ItemClick += MListView_ItemClick;
			bodyListView.ItemLongClick += MListView_ItemLongClick;



			adapter = new ListViewAdapterMenu (this, bodyItems);
			bodyListView.Adapter = adapter;

			//bodyListView.ItemClick += MListView_ItemClick;
			initListView ("SELECT * FROM TablePositions WHERE StatutLivraison = '1' AND typeMission='"+tyM+"' AND typeSegment='"+tyS+"' AND Userandsoft='"+Data.userAndsoft+"' OR StatutLivraison = '2' AND typeMission='"+tyM+"' AND typeSegment='"+tyS+"' AND Userandsoft='"+Data.userAndsoft+"'  ORDER BY Ordremission DESC");

		}
		protected override void OnResume()
		{
			base.OnResume();
			//Mise dans un Array des Groupage
			string dbPath = System.IO.Path.Combine(System.Environment.GetFolderPath
				(System.Environment.SpecialFolder.Personal), "ormDMS.db3");
			var db = new SQLiteConnection(dbPath);
			var grp = db.Query<TablePositions> ("SELECT * FROM TablePositions WHERE StatutLivraison = ? AND typeMission= ? AND typeSegment= ?  AND Userandsoft = ?  GROUP BY groupage",0,tyM,tyS,Data.userAndsoft);

			int i = 1;
			int countGrp = 0;
			foreach (var item in grp){				
				Arraygrp[i] = item.groupage;
				i++;
				countGrp++;
			}

			switch (countGrp) {
			case 0:
				//btn all big size
				btngrpAll.SetWidth (5000);
				//afficher pas de tournée au milieu et sur le btnall
				btngrpAll.Text = "Aucune position";
				break;
			case 1:
				//btn all avec le num de grp
				btngrpAll.SetWidth (5000);
				btngrpAll.Text = Arraygrp[1];
				break;
			case 2:
				//afficher le btn 1 et 2
				btngrp1.Visibility = ViewStates.Visible;
				btngrp1.Text = Arraygrp[1];
				btngrp2.Visibility = ViewStates.Visible;
				btngrp2.Text = Arraygrp[2];
				break;
			case 3:
				//afficher le btn 1,2 et 3
				btngrp1.Visibility = ViewStates.Visible;
				btngrp1.Text = Arraygrp[1];
				btngrp2.Visibility = ViewStates.Visible;
				btngrp2.Text = Arraygrp[2];
				btngrp3.Visibility = ViewStates.Visible;
				btngrp3.Text = Arraygrp[3];
				break;
			case 4:
				//afficher le btn 1,2,3 et 4
				btngrp1.Visibility = ViewStates.Visible;
				btngrp1.Text = Arraygrp[1];

				btngrp2.Visibility = ViewStates.Visible;
				btngrp2.Text = Arraygrp[2];

				btngrp3.Visibility = ViewStates.Visible;
				btngrp3.Text = Arraygrp[3];

				btngrp4.Visibility = ViewStates.Visible;
				btngrp4.Text = Arraygrp[4];
				break;
			default:
				//btn all big size
				btngrpAll.SetWidth (5000);
				//afficher pas de tournée au milieu et sur le btnall
				btngrpAll.Text = "Aucune position";
				break;
			}

			//LISTVIEW
			bodyListView = FindViewById<ListView> (Resource.Id.bodylist);
			bodyItems = new List<TablePositions> ();

			bodyListView.ItemClick += MListView_ItemClick;
			bodyListView.ItemLongClick += MListView_ItemLongClick;


			adapter = new ListViewAdapterMenu (this, bodyItems);
			bodyListView.Adapter = adapter;

			initListView ("SELECT * FROM TablePositions WHERE StatutLivraison = '0' AND typeMission= '"+tyM+"' AND typeSegment= '"+tyS+"'  AND Userandsoft = '"+Data.userAndsoft+"'");
		}
Example #3
0
        protected override void OnCreate(Bundle savedInstanceState)
        {
            base.OnCreate (savedInstanceState);

            SetContentView (Resource.Layout.Menu);
            iniView ();
            Button ajout = FindViewById<Button> (Resource.Id.ajouttournee);

            //TEST
            //editText = FindViewById<EditText>(Resource.Id.passwordfield);

            bodyListView = FindViewById<ListView> (Resource.Id.bodylist);
            bodyItems = new List<TablePosition> ();

            adapter = new ListViewAdapterMenu (this, bodyItems);
            bodyListView.Adapter = adapter;

            initListView ("SELECT * FROM TablePosition");

            ajout.Click += delegate {
                Dialog dialog = new Dialog (this);
                dialog.Window.RequestFeature (WindowFeatures.NoTitle);
                dialog.Window.SetBackgroundDrawableResource (Resource.Drawable.bktransbox);
                dialog.SetContentView (Resource.Layout.Boxajout);
                Button cree = dialog.FindViewById<Button> (Resource.Id.btn_cree);
                EditText codeeditText = dialog.FindViewById<EditText> (Resource.Id.codetournee);
                cree.Click += delegate {
                    ShowProgress (progress => AndHUD.Shared.Show (this, "Création... " + progress + "%", progress, MaskType.Clear));
                    Thread thread = new Thread (() => CreateVoyage (codeeditText.Text));
                    thread.Start ();
                    while (thread.IsAlive) {
                        iniView ();
                    }
                    dialog.Dismiss ();
                };
                cree.LongClick += delegate {
                    DBRepository dbr = new DBRepository ();
                    dbr.DropTableStatut ();
                    initListView("SELECT * FROM TablePosition");
                    iniView ();
                };
                dialog.SetCancelable (true);
                dialog.Show ();
            };

            //SIMULATION D'insert
            Button btntest = FindViewById<Button> (Resource.Id.nomtournee);
            btntest.Click += delegate {
                ShowProgressInsert (progress => AndHUD.Shared.Show (this, "Insertion ... " + progress + "%", progress, MaskType.Clear));
                Thread threadinsert = new Thread (() => GetPosData ("1406026994"));
                threadinsert.Start ();

                //GetPosData (stringbuilder.ToString());

            };
        }