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