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);
}
