public StockOutChartVM GetChartThingsByItemId(int itemId) { StockOutChartVM newChart = new StockOutChartVM(); newChart = aStockGateway.GetChartThingsByItemId(itemId); return(newChart); }
public StockOutChartVM GetChartThingsByItemId(int itemId) { Connection.Open(); StockOutChartVM stockOutChartVM = new StockOutChartVM(); Query = "select * from StockChart where ID=" + itemId + ""; Command = new SqlCommand(Query, Connection); Reader = Command.ExecuteReader(); while (Reader.Read()) { stockOutChartVM.ItemId = (int)Reader["ID"]; stockOutChartVM.ItemName = Reader["Item"].ToString(); stockOutChartVM.CompanyName = Reader["Company"].ToString(); } Reader.Close(); Connection.Close(); return(stockOutChartVM); }
protected void addButton_Click(object sender, EventArgs e) { bool chartflag = false; int itemId = Convert.ToInt32(itemDropDownList.SelectedValue); List <StockOutChartVM> aTempStockChartList = new List <StockOutChartVM>(); StockOutChartVM aStockChart = new StockOutChartVM(); try { aStockChart.Quantity = Convert.ToInt32(stockTextBox.Text); } catch { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Please Insert a valid Stock Quantity value')", true); return; } aStockChart = aStockManager.GetChartThingsByItemId(itemId); aStockChart.Quantity = Convert.ToInt32(stockTextBox.Text); if ((List <StockOutChartVM>)ViewState["chart"] == null) { aTempStockChartList.Add(aStockChart); if (!aStockManager.IsItOkAdd(aTempStockChartList, itemId)) { chartflag = true; } else { aStockChartList.Add(aStockChart); ViewState["chart"] = aStockChartList; ClearAllControls(); } } else { aTempStockChartList = (List <StockOutChartVM>)ViewState["chart"]; aTempStockChartList.Add(aStockChart); if (!aStockManager.IsItOkAdd(aTempStockChartList, itemId)) { aTempStockChartList.RemoveAt(aTempStockChartList.Count - 1); aStockChartList = aTempStockChartList; chartflag = true; } else { aStockChartList = aTempStockChartList; ViewState["chart"] = aStockChartList; ClearAllControls(); } } if (chartflag) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Can not be added in chart due to quantity limit')", true); } stockOutGridView.DataSource = aStockChartList; stockOutGridView.DataBind(); }