public static long Add(string catalog, int officeId, int userId, long loginId, long requestId, DateTime valueDate, string referenceNumber, string statementReference, int shipperId, int sourceStoreId, Collection <StockAdjustmentDetail> details) { string detailParameter = ParameterHelper.CreateStockTransferModelParameter(details); string sql = string.Format(CultureInfo.InvariantCulture, "SELECT * FROM transactions.post_inventory_transfer_delivery(@OfficeId::integer, @UserId::integer, @LoginId::bigint, @RequestId::bigint, @ValueDate::date, @ReferenceNumber::national character varying(24), @StatementReference::text, @ShipperId, @SourceStoreId, ARRAY[{0}]);", detailParameter); using (NpgsqlCommand command = new NpgsqlCommand(sql)) { command.Parameters.AddWithValue("@OfficeId", officeId); command.Parameters.AddWithValue("@UserId", userId); command.Parameters.AddWithValue("@LoginId", loginId); command.Parameters.AddWithValue("@RequestId", requestId); command.Parameters.AddWithValue("@ValueDate", valueDate); command.Parameters.AddWithValue("@ReferenceNumber", referenceNumber); command.Parameters.AddWithValue("@StatementReference", statementReference); command.Parameters.AddWithValue("@ShipperId", shipperId); command.Parameters.AddWithValue("@SourceStoreId", sourceStoreId); command.Parameters.AddRange(ParameterHelper.AddStockTransferModelParameter(details).ToArray()); long tranId = Conversion.TryCastLong(DbOperation.GetScalarValue(catalog, command)); return(tranId); } }
public static long Add(int officeId, int userId, long loginId, DateTime valueDate, string referenceNumber, string statementReference, Collection <StockAdjustmentModel> details) { string detailParameter = ParameterHelper.CreateStockTransferModelParameter(details); string sql = string.Format(CultureInfo.InvariantCulture, "SELECT * FROM transactions.post_stock_adjustment(@OfficeId, @UserId, @LoginId, @ValueDate, @ReferenceNumber, @StatementReference, ARRAY[{0}]);", detailParameter); using (NpgsqlCommand command = new NpgsqlCommand(sql)) { command.Parameters.AddWithValue("@OfficeId", officeId); command.Parameters.AddWithValue("@UserId", userId); command.Parameters.AddWithValue("@LoginId", loginId); command.Parameters.AddWithValue("@ValueDate", valueDate); command.Parameters.AddWithValue("@ReferenceNumber", referenceNumber); command.Parameters.AddWithValue("@StatementReference", statementReference); command.Parameters.AddRange(ParameterHelper.AddStockTransferModelParameter(details).ToArray()); long tranId = Conversion.TryCastLong(DbOperation.GetScalarValue(command)); return(tranId); } }