protected void Page_Load(object sender, EventArgs e) { ProductGridView.EnableDynamicData(typeof(Product)); //Bind product GridView ProductGridView.DataSource = ctx.Products.ToList <Product>(); ProductGridView.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { var productSubCategoryId = Request.QueryString["ProductSubCategoryId"]; int id; if (!int.TryParse(productSubCategoryId, out id)) { throw new ApplicationException("ID wasn't an integer"); } var connString = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; var sqlString = "GetProducts"; using (var conn = new SqlConnection(connString)) { using (var command = new SqlCommand(sqlString, conn)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@ProductSubCategoryID", SqlDbType.Int).Value = id; command.Connection.Open(); ProductGridView.DataSource = command.ExecuteReader(); ProductGridView.DataBind(); } } ProductCount.Text = ProductGridView.Rows.Count.ToString("n0"); }
protected void Page_Load(object sender, EventArgs e) { Stopwatch stopWatch = new Stopwatch(); stopWatch.Start(); var widgetService = new WidgetService(); var prodService = new ProductService(); var gizmoService = new GizmoService(); var pwgVM = new ProdGizWidgetVM( widgetService.GetWidgets(), prodService.GetProducts(), gizmoService.GetGizmos() ); WidgetGridView.DataSource = pwgVM.widgetList; WidgetGridView.DataBind(); ProductGridView.DataSource = pwgVM.prodList; ProductGridView.DataBind(); GizmoGridView.DataSource = pwgVM.gizmoList; GizmoGridView.DataBind(); stopWatch.Stop(); ElapsedTimeLabel.Text = String.Format("Elapsed time: {0}", stopWatch.Elapsed.Milliseconds / 1000.0); }
protected void ProductGridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { ProductGridView.DataSource = OrganizationProducts; ProductGridView.PageIndex = e.NewPageIndex; ProductGridView.DataBind(); GlobalUtils.SetAccessToControls(this.Page, SaltShakerSession.CurrentRole); }
protected void Page_Load(object sender, EventArgs e) { var prodService = new ProductService(); ProductGridView.DataSource = prodService.GetProducts(); ProductGridView.DataBind(); }
protected void ProductGridView_SelectedIndexChanging(object sender, GridViewSelectEventArgs e) { MessageUserControl.TryRun(() => { GridViewRow row = ProductGridView.Rows[e.NewSelectedIndex]; int partId = int.Parse((row.FindControl("PartID") as HiddenField).Value); var qutity = int.Parse((row.FindControl("Qutity") as TextBox).Text); if (qutity > 0) { var securityController = new SecurityController(); var employeeId = securityController.GetCurrentUserEmployeeId(User.Identity.Name); if (employeeId != null || User.IsInRole("Administrators")) { throw new Exception("Employee or Administrators can't shopping"); } else { var controller = new SalesController(); controller.AddToCart(User.Identity.Name, partId, qutity); //Item.QuantityInCart != 0?Item.QuantityInCart.ToString():"" ProductGridView.DataBind(); CategoryGridView.DataBind(); } } else { throw new Exception("Quantities should geater than 0"); } }, "Successful", "you added a part"); }
void BindGrid(ApiResponse response) { DataTable dt = null; try { if (response.responseCode == ApiResponse.Success) { dt = response.data as DataTable; } else if (response.responseCode == ApiResponse.NoDataFound) { LblErrorMsg.Text = "No Data Found"; LblErrorMsg.Visible = true; } else if (response.responseCode == ApiResponse.Exception) { LblErrorMsg.Text = "Api Error: " + response.error; LblErrorMsg.Visible = true; } } catch (Exception ex) { LblErrorMsg.Text = "Page Error: " + ex.Message; LblErrorMsg.Visible = true; } ProductGridView.DataSource = dt; ProductGridView.DataBind(); }
private async Task LoadProductsAsync() { statistics.Add(new Statistic { ThreadId = Thread.CurrentThread.ManagedThreadId, Message = "LoadProductsAsync():Start" }); ProductProxyService.ProductServiceClient client = new ProductProxyService.ProductServiceClient(); IList <ProductProxyService.Product> products = await client.GetProductsTaskAsync(); statistics.Add(new Statistic { ThreadId = Thread.CurrentThread.ManagedThreadId, Message = "LoadProductsAsync():End" }); ProductGridView.DataSource = products.Take(10); ProductGridView.DataBind(); ThreadGridView.DataSource = statistics; ThreadGridView.DataBind(); TimeSpan ts = pageWatch.Elapsed; PageElapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds / 10); }
private async Task GetPWGsrvAsync() { var widgetService = new WidgetService(); var prodService = new ProductService(); var gizmoService = new GizmoService(); var widgetTask = widgetService.GetWidgetsAsync(); var prodTask = prodService.GetProductsAsync(); var gizmoTask = gizmoService.GetGizmosAsync(); await Task.WhenAll(widgetTask, prodTask, gizmoTask); var pwgVM = new ProdGizWidgetVM( widgetTask.Result, prodTask.Result, gizmoTask.Result ); WidgetGridView.DataSource = pwgVM.widgetList; WidgetGridView.DataBind(); ProductGridView.DataSource = pwgVM.prodList; ProductGridView.DataBind(); GizmoGridView.DataSource = pwgVM.gizmoList; GizmoGridView.DataBind(); }
void PopulateGridView() { DataTable dtbl = new DataTable(); using (SqlConnection con = new SqlConnection(CS)) //we use using to close the connection explicitly { con.Open(); SqlDataAdapter sqlDa = new SqlDataAdapter("SELECT product.product_id as productID,product.product_name,product.product_detail, product.product_price,brand.brand_name,image.image FROM product INNER JOIN image ON product.product_id = image.product_id INNER JOIN brand ON product.brand_id=brand.brand_id", con); sqlDa.Fill(dtbl); } if (dtbl.Rows.Count > 0) { ProductGridView.DataSource = dtbl; ProductGridView.DataBind(); } else { dtbl.Rows.Add(dtbl.NewRow()); ProductGridView.DataSource = dtbl; ProductGridView.DataBind(); ProductGridView.Rows[0].Cells.Clear(); ProductGridView.Rows[0].Cells.Add(new TableCell()); ProductGridView.Rows[0].Cells[0].ColumnSpan = dtbl.Columns.Count; ProductGridView.Rows[0].Cells[0].Text = "NO DATA FOUND..."; ProductGridView.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center; } }
protected void Page_Load(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(); conn.ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; /*SqlConnection conn = new SqlConnection(@"Data Source=(Local DB)\MSSQLLocalDB; * AttachDbFilename=C:\Users\NIRALI P SHAH\source\repos\orderingapp\App_Data\Database1.mdf * Integrated Security=True");*/ try { using (conn) { String command = "select * from product ;"; SqlCommand cmd = new SqlCommand(command, conn); conn.Open(); SqlDataReader rdr = cmd.ExecuteReader(); ProductGridView.DataSource = rdr; ProductGridView.DataBind(); /*while (rdr.Read()) * { * ListItem item = new ListItem(rdr["pname"].ToString()); * //item.Text = rdr["pname"].ToString(); * //Response.Write("text=" + item.Text); * ListBox1.Items.Add(item); * }*/ } } catch (Exception err) { Error.Text = "error message:" + err.Message; } }
private async Task GetProductSrvAsync() { var ProductService = new ProductService(); var ProductList = await ProductService.GetProductsAsync(); ProductGridView.DataSource = ProductList; ProductGridView.DataBind(); }
protected void ProductGridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { if (e.NewPageIndex > -1) { ProductGridView.PageIndex = e.NewPageIndex; ProductGridView.DataBind(); } }
protected void ProductDetailsViewSqlDataSource_Inserted(object sender, SqlDataSourceStatusEventArgs e) { System.Data.Common.DbCommand command = e.Command; ProductDetailsViewSqlDataSource.SelectParameters["ProductID"].DefaultValue = command.Parameters["@ProductID"].Value.ToString(); ProductGridView.DataBind(); ProductDetailsView.DataBind(); }
protected void ContinueShoppingButton_Click(object sender, EventArgs e) { PartCatelogPanel.Visible = true; PurchaseInfoPanel.Visible = false; NavigationPanel.Visible = false; ViewCartPanel.Visible = false; PlaceOrderPanel.Visible = false; ProductGridView.DataBind(); }
private void BindGridView() { Collection <MixERP.Net.Common.Models.Transactions.ProductDetailsModel> table = this.GetTable(); ProductGridView.DataSource = table; ProductGridView.DataBind(); this.ShowTotals(); }
protected void Page_Load(object sender, EventArgs e) { var productSubCategoryId = Request.QueryString["ProductSubCategoryId"]; int id; //if (!int.TryParse(productSubCategoryId, out id)) { throw new ApplicationException("ID wasn't an integer."); } var connString = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; // Unsafe string concat var sqlString = "SELECT * FROM Product WHERE ProductSubCategoryID = " + productSubCategoryId; using (var conn = new SqlConnection(connString)) { using (var command = new SqlCommand(sqlString, conn)) { command.Connection.Open(); ProductGridView.DataSource = command.ExecuteReader(); ProductGridView.DataBind(); } } /*//Paramatarised input * var sqlString = "SELECT * FROM Product WHERE ProductSubCategoryID = @ProductSubCategoryId"; * using (var conn = new SqlConnection(connString)) * { * using (var command = new SqlCommand(sqlString, conn)) * { * command.Parameters.Add("@ProductSubcategoryId", SqlDbType.VarChar).Value = productSubCategoryId; * command.Connection.Open(); * ProductGridView.DataSource = command.ExecuteReader(); * ProductGridView.DataBind(); * } * }*/ /*//Stored procedure input * var sqlString = "GetProducts"; * using (var conn = new SqlConnection(connString)) * { * using (var command = new SqlCommand(sqlString, conn)) * { * command.CommandType = CommandType.StoredProcedure; * command.Parameters.Add("@ProductSubcategoryId", SqlDbType.VarChar).Value = productSubCategoryId; * //command.Parameters.Add("@ProductSubcategoryId", SqlDbType.Int).Value = id; * command.Connection.Open(); * ProductGridView.DataSource = command.ExecuteReader(); * ProductGridView.DataBind(); * } * }*/ var dc = new InjectionEntities(); /*ProductGridView.DataSource = dc.Products.Where(p => p.ProductSubcategoryID == id).ToList(); * //ProductGridView.DataSource = dc.Products.Where(p => p.ProductSubcategoryID == productSubCategoryId).ToList(); * ProductGridView.DataBind();*/ ProductCount.Text = ProductGridView.Rows.Count.ToString("n0"); }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null) { Response.Redirect("LoginForm.aspx"); } ProductGridView.DataSource = repo.getAllProducts(); ProductGridView.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { var productSubCategoryId = Request.QueryString["ProductSubCategoryId"]; string userAgent = Request.Headers.GetValues("User-Agent")[0]; var connString = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; var sqlUserAgentString = "SELECT * FROM UserAgents WHERE UserAgent = N'" + userAgent + "'"; using (var conn = new SqlConnection(connString)) { using (var command = new SqlCommand(sqlUserAgentString, conn)) { command.Connection.Open(); SqlDataReader dr = command.ExecuteReader(); if (dr == null) { var insertString = "INSERT INTO [dbo].[UserAgents] ([UserAgent]) VALUES (N'" + userAgent + "')"; SqlCommand sc = new SqlCommand(insertString, new SqlConnection(connString)); sc.ExecuteNonQuery(); } } } if (productSubCategoryId != null) { //productSubCategoryId = productSubCategoryId.ToUpper().Replace("SELECT", ""); //productSubCategoryId = productSubCategoryId.ToUpper().Replace("UPDATE", ""); //productSubCategoryId = productSubCategoryId.ToUpper().Replace("INSERT", ""); //productSubCategoryId = productSubCategoryId.ToUpper().Replace("DELETE", ""); //productSubCategoryId = productSubCategoryId.ToUpper().Replace("WHERE", ""); //productSubCategoryId = productSubCategoryId.ToUpper().Replace("FROM", ""); injectionEntities ie = new injectionEntities(); int?pID = int.Parse(productSubCategoryId); ProductGridView.DataSource = ie.Products.Where(p => p.ProductSubcategoryID == pID).ToList(); ProductGridView.DataBind(); var sqlString = "SELECT Name, ProductNumber, ListPrice FROM Product WHERE ProductSubCategoryID = " + productSubCategoryId; using (var conn = new SqlConnection(connString)) { using (var command = new SqlCommand(sqlString, conn)) { command.Connection.Open(); ProductGridView.DataSource = command.ExecuteReader(); ProductGridView.DataBind(); } } ProductCount.Text = ProductGridView.Rows.Count.ToString("n0"); } }
private void BindingProductData() { try { List <DataAccessLayer.Modelo.Product> listProduct = logicData.GetProductList(); ProductGridView.DataSource = listProduct; ProductGridView.DataBind(); } catch (Exception) { throw; } }
protected void Page_Load(object sender, EventArgs e) { Stopwatch loadWatch = new Stopwatch(); loadWatch.Start(); pageWatch.Start(); statistics.Add(new Statistic { ThreadId = Thread.CurrentThread.ManagedThreadId, Message = "Page Load:Start" }); //RegisterAsyncTask(new PageAsyncTask(LoadProductsAsync)); RegisterAsyncTask(new PageAsyncTask(async() => { statistics.Add(new Statistic { ThreadId = Thread.CurrentThread.ManagedThreadId, Message = "LoadProductsAsync():Start" }); ProductProxyService.ProductServiceClient client = new ProductProxyService.ProductServiceClient(); IList <ProductProxyService.Product> products = await client.GetProductsTaskAsync(); statistics.Add(new Statistic { ThreadId = Thread.CurrentThread.ManagedThreadId, Message = "LoadProductsAsync():End" }); ProductGridView.DataSource = products.Take(10); ProductGridView.DataBind(); ThreadGridView.DataSource = statistics; ThreadGridView.DataBind(); TimeSpan ts1 = pageWatch.Elapsed; PageElapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts1.Hours, ts1.Minutes, ts1.Seconds, ts1.Milliseconds / 10); })); statistics.Add(new Statistic { ThreadId = Thread.CurrentThread.ManagedThreadId, Message = "Page Load::End" }); TimeSpan ts = loadWatch.Elapsed; LoadElapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}", ts.Hours, ts.Minutes, ts.Seconds, ts.Milliseconds / 10); }
private void LoadProducts() { statistics.Add(new Statistic { ThreadId = Thread.CurrentThread.ManagedThreadId, Message = "LoadProducts():Start" }); ProductProxyService.ProductServiceClient client = new ProductProxyService.ProductServiceClient(); IList <ProductProxyService.Product> products = client.GetProducts(); statistics.Add(new Statistic { ThreadId = Thread.CurrentThread.ManagedThreadId, Message = "LoadProducts():End" }); ProductGridView.DataSource = products.Take(10); ProductGridView.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { var productSubCategoryId = Request.QueryString["ProductSubCategoryId"]; int id; if (!int.TryParse(productSubCategoryId, out id)) { throw new ApplicationException("ID wasn't an integer"); } var dc = new InjectionEntities(); ProductGridView.DataSource = dc.Products.Where(p => p.ProductSubcategoryID == id).ToList(); ProductGridView.DataBind(); ProductCount.Text = ProductGridView.Rows.Count.ToString("n0"); }
protected void btGo_Click(object sender, EventArgs e) { var productSubCategoryId = ddlCategory.SelectedValue; if (productSubCategoryId != null) { var connString = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; var sqlString = "SELECT * FROM Product WHERE ProductSubCategoryID = " + productSubCategoryId; using (var conn = new SqlConnection(connString)) { using (var command = new SqlCommand(sqlString, conn)) { command.Connection.Open(); ProductGridView.DataSource = command.ExecuteReader(); ProductGridView.DataBind(); } } } }
protected void Button1_Click(object sender, EventArgs e) { var connString = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; using (var conn = new SqlConnection(connString)) { using (var command = new SqlCommand("SearchProducts", conn)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@SearchTerm", SqlDbType.VarChar).Value = SearchTerm.Text; command.Connection.Open(); ProductGridView.DataSource = command.ExecuteReader(); ProductGridView.DataBind(); } } ProductCount.Text = ProductGridView.Rows.Count.ToString("n0"); SearchPanel.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { var productSubCategoryId = Request.QueryString["ProductSubCategoryId"]; var connString = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; var sqlString = "SELECT * FROM Product WHERE ProductSubCategoryID = " + productSubCategoryId; using (var conn = new SqlConnection(connString)) { using (var command = new SqlCommand(sqlString, conn)) { command.Connection.Open(); ProductGridView.DataSource = command.ExecuteReader(); ProductGridView.DataBind(); } } ProductCount.Text = ProductGridView.Rows.Count.ToString("n0"); }
protected void ddlCategory_SelectedIndexChanged(object sender, EventArgs e) { //int productSubCategoryId = int.Parse(ddlCategory.SelectedValue); var productSubCategoryId = ddlCategory.SelectedValue; if (productSubCategoryId != null) { var connstring = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString; var sqlstring = "select * from product where productsubcategoryid = " + productSubCategoryId; using (var conn = new SqlConnection(connstring)) { using (var command = new SqlCommand(sqlstring, conn)) { command.Connection.Open(); ProductGridView.DataSource = command.ExecuteReader(); ProductGridView.DataBind(); } } } }
protected void Page_Load(object sender, EventArgs e) { string CS = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("Select * from tblProduct; Select * from tblProductCategories", con); con.Open(); using (SqlDataReader rdr = cmd.ExecuteReader()) { ProductGridView.DataSource = rdr; ProductGridView.DataBind(); while (rdr.NextResult()) { CategoriesGridView.DataSource = rdr; CategoriesGridView.DataBind(); } } } }
protected void Page_Load(object sender, EventArgs e) { MessageUserControl.TryRun(() => { //have your log in yte if (!Request.IsAuthenticated) { ProductGridView.Columns[0].Visible = false; ProductGridView.Columns[2].Visible = false; var controller = new SalesController(); AllPartsAmount.Text = controller.getAllPartsAmount().ToString(); } else { UserName.Value = User.Identity.Name; ProductGridView.Columns[0].Visible = true; ProductGridView.Columns[2].Visible = true; var controller = new SalesController(); AllPartsAmount.Text = controller.getAllPartsAmount().ToString(); ProductGridView.DataBind(); } }); }
protected void CartInfoGridView_RowCommand(object sender, GridViewCommandEventArgs e) { MessageUserControl.TryRun(() => { var controller = new SalesController(); var cartItemId = 0; switch (e.CommandName) { case "Delete": cartItemId = int.Parse(e.CommandArgument.ToString()); controller.DeleteCartItem(cartItemId); ProductGridView.DataBind(); break; case "Update": cartItemId = int.Parse(e.CommandArgument.ToString().Split(';')[0]); var idx = int.Parse(e.CommandArgument.ToString().Split(';')[1]); var quantity = int.Parse((CartInfoGridView.Rows[idx].FindControl("QutityChanged") as TextBox).Text); controller.UpdateCartItem(cartItemId, quantity); ProductGridView.DataBind(); break; } }); }