public List <StockTransactionType> GetMatches(DBSite site, string value_to_search) { List <StockTransactionType> trn_list = new List <StockTransactionType>(); StockTransactionType trn = null; string qry = " SELECT " + " TransactionId" + ", TransactionName" + ", Flow" + " FROM tblStockTransactionMaster" + " WHERE " + " UserId =" + Util_BLL.User.UserId + " AND FYear=" + Util_BLL.User.fYear + " AND" + "("; qry += " (TransactionName LIKE '%" + value_to_search + "%') "; if (util.isNumeric(value_to_search)) { qry += "OR ( Flow ='" + value_to_search + "')"; } qry += ")"; DataTable dt = site.ExecuteSelect(qry); SalePurchase sp = new SalePurchase(); foreach (DataRow row in dt.Rows) { StoreBll store = new StoreBll(); trn.StockTransactionId = util.CheckNullInt(row["TransactionId"]); trn.StockTransactionName = util.CheckNull(row["TransactionName"]); trn.StockTransactionFlow = util.CheckNullInt(row["Flow"]); trn.StockTransactionFlowName = store.stock_transaction_type[trn.StockTransactionFlow]; trn_list.Add(trn); } return(trn_list); }
public List <StockTransactionType> GetInfo(DBSite site, string trn_id = "") { List <StockTransactionType> trn_list = new List <StockTransactionType>(); StockTransactionType trn = null; string qry = " SELECT " + "TransactionId " + ", TransactionName " + ", Flow" + " FROM tblStockTransactionMaster" + " WHERE " + " UserId =" + Util_BLL.User.UserId + " AND FYear=" + Util_BLL.User.fYear; if (trn_id != "") { qry += " AND TransactionId=" + trn_id; } DataTable dt = site.ExecuteSelect(qry); StoreBll store = new StoreBll(); foreach (DataRow row in dt.Rows) { trn = new StockTransactionType(); trn.StockTransactionId = util.CheckNullInt(row["TransactionId"]); trn.StockTransactionName = util.CheckNull(row["TransactionName"]); trn.StockTransactionFlow = util.CheckNullInt(row["Flow"]); trn.StockTransactionFlowName = store.stock_transaction_type[trn.StockTransactionFlow]; trn_list.Add(trn); } return(trn_list); }