//---------------------------------------------------------------------------------------------------------------------------------------------------

        //Action on item click.
        private void TypesOfProductsList_ItemClick(object sender, AdapterView.ItemClickEventArgs e)
        {
            //Setting a chooser.
            ProductLists.SetChooser(e.Position);

            //Going to adding products activity.
            StartActivity(typeof(ProductsAdd));
        }
        public List <ProductLists> GetPublicLists([FromBody] List <int> model)
        {
            var a = model;
            List <ProductLists> productLists = new List <ProductLists>();

            foreach (var item in model)
            {
                List <Products> products    = new List <Products>();
                ProductLists    productList = new ProductLists();
                try
                {
                    _context.Database.OpenConnection();
                    using (DbCommand cmd = _context.Database.GetDbConnection().CreateCommand())
                    {
                        cmd.CommandType = System.Data.CommandType.StoredProcedure;
                        cmd.CommandText = "sp_ScoolGradesListPublic";

                        List <SqlParameter> sp = new List <SqlParameter>()
                        {
                            new SqlParameter()
                            {
                                ParameterName = "@SchoolGradeId", SqlDbType = SqlDbType.Int, Value = item
                            },
                        };

                        cmd.Parameters.AddRange(sp.ToArray());

                        using (var reader = cmd.ExecuteReader())
                        {
                            products = reader.MapToList <Products>();
                        }
                    }
                    _context.Database.CloseConnection();

                    productList.Grade        = products.Select(m => m.Grade).FirstOrDefault();
                    productList.NoOfLearners = products.Select(m => m.NoOfLearners).FirstOrDefault();

                    productList.Products = products;
                    productList.Total    = "0";
                    productLists.Add(productList);
                }
                catch (Exception ex)
                {
                    var error = ex.InnerException;
                    return(new List <ProductLists>());
                }
            }

            return(productLists);
        }
        protected override void OnCreate(Bundle savedInstanceState)
        {
            base.OnCreate(savedInstanceState);
            SetContentView(Resource.Layout.product_Types);

            //Elements from the layout.
            ListView TypesOfProductsList = FindViewById <ListView>(Resource.Id.TypesOfProductsList);

            //Creating adapter for the list of product types and setting it on the form.
            var adapter = new ArrayAdapter <string>(this, Android.Resource.Layout.SimpleListItem1, ProductLists.GetMajorList());

            TypesOfProductsList.Adapter = adapter;

            //Action on item click.
            TypesOfProductsList.ItemClick += TypesOfProductsList_ItemClick;
        }