public void EditInfo(DBSite site, StockTransactionType st, string trn_id) { string qry = " UPDATE tblStockTransactionMaster SET" + " TransactionName='" + st.StockTransactionName + "'" + ", Flow=" + st.StockTransactionFlow + " WHERE UserId=" + Util_BLL.User.UserId + " AND FYear=" + Util_BLL.User.fYear + " AND TransactionId=" + trn_id; site.Execute(qry); }
public void SaveInfo(DBSite site, StockTransactionType trn) { string qry = " INSERT INTO " + " tblStockTransactionMaster" + "( " + "TransactionName" + ", Flow" + ", UserId, FYear )" + " VALUES( '" + trn.StockTransactionName + "'" + ", " + trn.StockTransactionFlow + ", " + util.GetUserInsertQryMaster(Util_BLL.User) //------ user insert query ---------- + ")"; site.Execute(qry); }
private void UpdateBalance(double price, double volume, StockTransactionType transaction) { switch (transaction) { case StockTransactionType.Sell: Balance += price * volume; break; case StockTransactionType.Buy: Balance -= price * volume; break; default: throw new ArgumentOutOfRangeException(nameof(transaction), transaction, null); } }
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); }