// Get one poline based on its POLineID (SQL Select) // This only works if you're already created the stored procedure. public async Task <POLine> POLine_GetOne(int @POLineID) { POLine poline = new POLine(); var parameters = new DynamicParameters(); parameters.Add("@POLineID", POLineID, DbType.Int32); using (var conn = new SqlConnection(_configuration.Value)) { poline = await conn.QueryFirstOrDefaultAsync <POLine>("spPOLine_GetOne", parameters, commandType : CommandType.StoredProcedure); } return(poline); }
// Add (create) a POLine table row (SQL Insert) // This only works if you're already created the stored procedure. public async Task <bool> POLineInsert(POLine poline) { using (var conn = new SqlConnection(_configuration.Value)) { var parameters = new DynamicParameters(); parameters.Add("POLineHeaderID", poline.POLineHeaderID, DbType.Int32); parameters.Add("POLineProductID", poline.POLineProductID, DbType.Int32); parameters.Add("POLineProductDescription", poline.POLineProductDescription, DbType.String); parameters.Add("POLineProductQuantity", poline.POLineProductQuantity, DbType.Decimal); parameters.Add("POLineProductUnitPrice", poline.POLineProductUnitPrice, DbType.Decimal); parameters.Add("POLineTaxRate", poline.POLineTaxRate, DbType.Decimal); parameters.Add("POLineTaxID", poline.POLineTaxID, DbType.Decimal); // Stored procedure method await conn.ExecuteAsync("spPOLine_Insert", parameters, commandType : CommandType.StoredProcedure); } return(true); }