Exemple #1
0
        public DataTable GetData()
        {
            var context = new InetMagazDBDataContext(ConfigurationManager.ConnectionStrings["MyBase"].ConnectionString);

            DataTable dt = new DataTable();
            // define the table's schema
            dt.Columns.Add(new DataColumn("ID", typeof(int)));
            dt.Columns.Add(new DataColumn("Name", typeof(string)));
            dt.Columns.Add(new DataColumn("Password", typeof(string)));
            dt.Columns.Add(new DataColumn("Emai", typeof(string)));
            dt.Columns.Add(new DataColumn("isAdmin", typeof(string)));
            // Create the records

            foreach (var item in context.Users)
            {
                DataRow dr = dt.NewRow();
                dr["ID"] = Convert.ToInt32(item.ID);
                dr["Name"] = item.Name;
                dr["Password"] = item.Password;
                dr["Emai"] = item.Emai;
                dr["isAdmin"] = item.isAdmin;
                dt.Rows.Add(dr);
            }
            dt.DefaultView.Sort = "ID ASC";
            dt = dt.DefaultView.ToTable();
            return dt;
        }
Exemple #2
0
        public DataTable GetData()
        {
            var context = new InetMagazDBDataContext(ConfigurationManager.ConnectionStrings["MyBase"].ConnectionString);

            DataTable dt = new DataTable();

            // define the table's schema
            dt.Columns.Add(new DataColumn("ID", typeof(int)));
            dt.Columns.Add(new DataColumn("Name", typeof(string)));
            dt.Columns.Add(new DataColumn("Password", typeof(string)));
            dt.Columns.Add(new DataColumn("Emai", typeof(string)));
            dt.Columns.Add(new DataColumn("isAdmin", typeof(string)));
            // Create the records

            foreach (var item in context.Users)
            {
                DataRow dr = dt.NewRow();
                dr["ID"]       = Convert.ToInt32(item.ID);
                dr["Name"]     = item.Name;
                dr["Password"] = item.Password;
                dr["Emai"]     = item.Emai;
                dr["isAdmin"]  = item.isAdmin;
                dt.Rows.Add(dr);
            }
            dt.DefaultView.Sort = "ID ASC";
            dt = dt.DefaultView.ToTable();
            return(dt);
        }
Exemple #3
0
        public int SearchForProducts(string Name)
        {
            var context = new InetMagazDBDataContext(ConfigurationManager.ConnectionStrings["MyBase"].ConnectionString);
            var result  = -1;

            foreach (var item in context.Search(Name))
            {
                result = Convert.ToInt32(item.RESULT);
            }
            return(result);
        }
Exemple #4
0
        public List <Dictionary <string, string> > GetCategories()
        {
            List <Dictionary <string, string> > categories = new List <Dictionary <string, string> >();

            var context = new InetMagazDBDataContext(ConfigurationManager.ConnectionStrings["MyBase"].ConnectionString);

            foreach (var item in context.Categories)
            {
                Dictionary <string, string> categoryItem = new Dictionary <string, string>();
                categoryItem.Add("categoryType", item.categoryType.ToString());
                categoryItem.Add("CategoryName", item.CategoryName);
                categories.Add(categoryItem);
            }

            return(categories);
        }
Exemple #5
0
        public List <Dictionary <string, string> > GetProducts()
        {
            List <Dictionary <string, string> > products = new List <Dictionary <string, string> >();

            var context = new InetMagazDBDataContext(ConfigurationManager.ConnectionStrings["MyBase"].ConnectionString);

            foreach (var item in context.Products)
            {
                Dictionary <string, string> tovar = new Dictionary <string, string>();
                tovar.Add("Name", item.Name);
                tovar.Add("ProductID", item.ProductID.ToString());
                tovar.Add("Description", item.Description);
                tovar.Add("ImageUrl", item.ImageUrl);
                tovar.Add("Price", item.Price.ToString());
                tovar.Add("categoryType", item.categoryType.ToString());
                products.Add(tovar);
            }

            return(products);
        }
Exemple #6
0
 public int SearchForProducts(string Name)
 {
     var context = new InetMagazDBDataContext(ConfigurationManager.ConnectionStrings["MyBase"].ConnectionString);
     var result = -1;
     foreach (var item in context.Search(Name))
     {
         result = Convert.ToInt32(item.RESULT);
     }
     return result;
 }
Exemple #7
0
        public List<Dictionary<string, string>> GetProducts()
        {
            List<Dictionary<string, string>> products = new List<Dictionary<string, string>>();

            var context = new InetMagazDBDataContext(ConfigurationManager.ConnectionStrings["MyBase"].ConnectionString);

            foreach (var item in context.Products)
            {
                Dictionary<string, string> tovar = new Dictionary<string, string>();
                tovar.Add("Name", item.Name);
                tovar.Add("ProductID", item.ProductID.ToString());
                tovar.Add("Description", item.Description);
                tovar.Add("ImageUrl", item.ImageUrl);
                tovar.Add("Price", item.Price.ToString());
                tovar.Add("categoryType", item.categoryType.ToString());
                products.Add(tovar);
            }

            return products;
        }
Exemple #8
0
        public List<Dictionary<string, string>> GetCategories()
        {
            List<Dictionary<string, string>> categories = new List<Dictionary<string, string>>();

            var context = new InetMagazDBDataContext(ConfigurationManager.ConnectionStrings["MyBase"].ConnectionString);

            foreach (var item in context.Categories)
            {
                Dictionary<string, string> categoryItem = new Dictionary<string, string>();
                categoryItem.Add("categoryType", item.categoryType.ToString());
                categoryItem.Add("CategoryName", item.CategoryName);
                categories.Add(categoryItem);
            }

            return categories;
        }