void BindStock() { oblStock = new Store.Stock.BusinessLogic.Stock(); try { objStockList = oblStock.GetAllStockList(0, 0, ""); if (objStockList != null) { dgvStock.DataSource = objStockList; dgvStock.DataBind(); } else { dgvStock.DataSource = null; dgvStock.DataBind(); } } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Stock).FullName, 1); } finally { oblStock = null; objStockList = null; } }
public Store.Stock.BusinessObject.StockList GetAllStockList(int StockID, int Flag, string FlagValue) { Store.Stock.BusinessObject.Stock objstock = null; Store.Stock.BusinessObject.StockList objstockList = null; string SQL = string.Empty; ParameterList paramList = new ParameterList(); DataTableReader dr; try { SQL = "proc_stock"; objstockList = new BusinessObject.StockList(); paramList.Add(new SQLParameter("@StockID", StockID)); paramList.Add(new SQLParameter("@Flag", Flag)); paramList.Add(new SQLParameter("@FlagValue", FlagValue)); dr = ExecuteQuery.ExecuteReader(SQL, paramList); while (dr.Read()) { objstock = new BusinessObject.Stock(); if (dr.IsDBNull(dr.GetOrdinal("StockID")) == false) { objstock.StockID = dr.GetInt32(dr.GetOrdinal("StockID")); } if (dr.IsDBNull(dr.GetOrdinal("ItemID")) == false) { objstock.ItemID = dr.GetInt32(dr.GetOrdinal("ItemID")); } if (dr.IsDBNull(dr.GetOrdinal("ItemPrefix")) == false) { objstock.ItemPrefix = dr.GetString(dr.GetOrdinal("ItemPrefix")); } if (dr.IsDBNull(dr.GetOrdinal("StockQuantity")) == false) { objstock.StockQuantity = dr.GetInt32(dr.GetOrdinal("StockQuantity")); } objstockList.Add(objstock); } dr.Close(); } catch (Exception ex) { Store.Common.Utility.ExceptionLog.Exceptionlogs(ex.Message, Store.Common.Utility.ExceptionLog.LineNumber(ex), typeof(Stock).FullName, 1); } return(objstockList); }