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