public DataSet SearchItems(ItemsSearch itemsSearch) { try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Items_Search); db.AddInParameter(dbCommand, "@sItemCode", DbType.String, itemsSearch.ItemCode); db.AddInParameter(dbCommand, "@sItemDescription", DbType.String, itemsSearch.ItemDescription); db.AddInParameter(dbCommand, "@mSellingPrice", DbType.Currency, itemsSearch.SellingPrice); db.AddInParameter(dbCommand, "@iOption", DbType.Int32, itemsSearch.Option); db.AddInParameter(dbCommand, "@iSupId", DbType.Int32, itemsSearch.SupId); db.AddInParameter(dbCommand, "@iCategoryId", DbType.Int32, itemsSearch.CategoryId); db.AddInParameter(dbCommand, "@biQuantityInHand", DbType.Int64, itemsSearch.QuantityInHand); db.AddInParameter(dbCommand, "@iROL", DbType.Int32, itemsSearch.ROL); db.AddInParameter(dbCommand, "@iBranchId", DbType.Int32, itemsSearch.BranchID); db.AddInParameter(dbCommand, "@iBrandId", DbType.Int32, itemsSearch.BrandID); return(db.ExecuteDataSet(dbCommand)); } catch (System.Exception ex) { ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public DataSet SearchItems(Item item)"); return(null); throw ex; } }
public DataSet SearchItems(ItemsSearch itemsSearch) { try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Items_Search); db.AddInParameter(dbCommand, "@sItemCode", DbType.String, itemsSearch.ItemCode); db.AddInParameter(dbCommand, "@sItemDescription", DbType.String, itemsSearch.ItemDescription); db.AddInParameter(dbCommand, "@mSellingPrice", DbType.Currency, itemsSearch.SellingPrice); db.AddInParameter(dbCommand, "@iOption", DbType.Int32, itemsSearch.Option); db.AddInParameter(dbCommand, "@iSupId", DbType.Int32, itemsSearch.SupId); db.AddInParameter(dbCommand, "@iCategoryId", DbType.Int32, itemsSearch.CategoryId); db.AddInParameter(dbCommand, "@biQuantityInHand", DbType.Int64, itemsSearch.QuantityInHand); db.AddInParameter(dbCommand, "@iROL", DbType.Int32, itemsSearch.ROL); db.AddInParameter(dbCommand, "@iBranchId", DbType.Int32, itemsSearch.BranchID); db.AddInParameter(dbCommand, "@iBrandId", DbType.Int32, itemsSearch.BrandID); return db.ExecuteDataSet(dbCommand); } catch (System.Exception ex) { ex.Data.Add("BusinessLayerException", GetType().ToString() + Constant.Error_Seperator + "public DataSet SearchItems(Item item)"); return null; throw ex; } }
/// <summary> /// Search the products using the values provided in the search controls /// </summary> public void Search() { try { this.ShowHideGrids(); ItemsSearch searchItem = new ItemsSearch(); searchItem.ItemCode = txtItemCode.Text.Trim(); searchItem.ItemDescription = txtItemDescription.Text.Trim(); decimal selPrice = 0; Decimal.TryParse(txtPrice.Text.Trim(), out selPrice); searchItem.SellingPrice = selPrice; searchItem.Option = ddlStatus.SelectedValue != "-1" ? Int32.Parse(ddlStatus.SelectedValue.Trim()):-1; searchItem.SupId = ddlSupplier.SelectedValue != "-1" ? Int32.Parse(ddlSupplier.SelectedValue.Trim()): 0; searchItem.CategoryId = ddlCategory.SelectedValue != "-1" ? Int32.Parse(ddlCategory.SelectedValue.Trim()):0; Int64 qih = 0; Int64.TryParse(txtQuantityInHand.Text.Trim(), out qih); searchItem.QuantityInHand = qih; int rol = 0; int.TryParse(txtROL.Text.Trim(), out rol); searchItem.ROL = rol; searchItem.BranchID = ddlBranch.SelectedIndex != -1 ? Int32.Parse(ddlBranch.SelectedItem.Value.ToString().Trim()) : 0; searchItem.BrandID = ddlBrands.SelectedValue != "-1" ? Int32.Parse(ddlBrands.SelectedValue.Trim()): 0; DataSet dsProd = searchItem.Search(); Session["SearchItems"] = dsProd; if (dsProd != null && dsProd.Tables.Count > 0 && dsProd.Tables[0] != null && dsProd.Tables[0].Rows.Count > 0) { dxgvItemList.DataSource = dsProd; dxgvItemList.DataBind(); trItemList.Visible = true; } else { dxgvItemList.DataSource = null; dxgvItemList.DataBind(); } } catch (Exception ex) { throw ex; } }