public static long Add(string catalog, int officeId, int userId, long loginId, string book, DateTime valueDate,
string partyCode, int priceTypeId, Collection<StockDetail> details, string referenceNumber,
string statementReference, Collection<long> transactionIdCollection, Collection<Attachment> attachments)
{
StockMaster stockMaster = new StockMaster();
stockMaster.PartyCode = partyCode;
stockMaster.PriceTypeId = priceTypeId;
long nonGlStockMasterId = NonGlStockTransaction.Add(catalog, book, valueDate, officeId, userId, loginId,
referenceNumber, statementReference, stockMaster, details, transactionIdCollection, attachments);
return nonGlStockMasterId;
}
public static long Add(string catalog, int officeId, int userId, long loginId, DateTime valueDate, int storeId,
string partyCode, Collection<StockDetail> details, int costCenterId, string referenceNumber,
string statementReference, Collection<long> transactionIdCollection, Collection<Attachment> attachments)
{
StockMaster stockMaster = new StockMaster();
stockMaster.PartyCode = partyCode;
stockMaster.StoreId = storeId;
stockMaster.IsCredit = true;
if (!string.IsNullOrWhiteSpace(statementReference))
{
statementReference = statementReference.Replace(" ", " ").Trim();
}
long transactionMasterId = GlTransaction.Add(catalog, valueDate, "Purchase.Receipt", officeId, userId,
loginId, costCenterId, referenceNumber, statementReference, stockMaster, details,
transactionIdCollection, attachments);
return transactionMasterId;
}
public static long Add(string catalog, int officeId, int userId, long loginId, DateTime valueDate, int storeId,
bool isCredit, int paymentTermId, string partyCode, int agentId, int priceTypeId,
Collection<StockDetail> details, int shipperId, string shippingAddressCode, decimal shippingCharge,
int costCenterId, string referenceNumber, string statementReference, Collection<Attachment> attachments,
bool nonTaxable)
{
StockMaster stockMaster = new StockMaster();
stockMaster.PartyCode = partyCode;
stockMaster.IsCredit = isCredit;
stockMaster.PaymentTermId = paymentTermId;
stockMaster.PriceTypeId = priceTypeId;
stockMaster.ShipperId = shipperId;
stockMaster.ShippingAddressCode = shippingAddressCode;
stockMaster.ShippingCharge = shippingCharge;
stockMaster.SalespersonId = agentId;
stockMaster.StoreId = storeId;
long transactionMasterId = GlTransaction.Add(catalog, "Sales.Direct", valueDate, officeId, userId, loginId,
costCenterId, referenceNumber, statementReference, stockMaster, details, attachments, nonTaxable, null);
return transactionMasterId;
}
internal static long Add(string catalog, string book, DateTime valueDate, int officeId, int userId, long loginId,
string referenceNumber, string statementReference, StockMaster stockMaster, Collection<StockDetail> details,
Collection<long> transactionIdCollection, Collection<Attachment> attachments, bool nonTaxable)
{
if (stockMaster == null)
{
return 0;
}
if (details == null)
{
return 0;
}
if (details.Count.Equals(0))
{
return 0;
}
string tranIds = ParameterHelper.CreateBigintArrayParameter(transactionIdCollection, "bigint", "@TranId");
string detail = StockMasterDetailHelper.CreateStockMasterDetailParameter(details);
string attachment = AttachmentHelper.CreateAttachmentModelParameter(attachments);
string sql = string.Format(CultureInfo.InvariantCulture,
"SELECT * FROM transactions.post_non_gl_transaction(@Book::national character varying(48), @OfficeId::integer, @UserId::integer, @LoginId::bigint, @ValueDate::date, @ReferenceNumber::national character varying(24), @StatementReference::text, @PartyCode::national character varying(12), @PriceTypeId::integer, @NonTaxable::boolean,@SalesPersonId::integer, @ShipperId::integer, @ShippingAddressCode::national character varying(12), @StoreId::integer, ARRAY[{0}]::bigint[], ARRAY[{1}], ARRAY[{2}]);",
tranIds, detail, attachment);
using (NpgsqlCommand command = new NpgsqlCommand(sql))
{
command.Parameters.AddWithValue("@Book", book);
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.AddWithValue("@PartyCode", stockMaster.PartyCode);
if (stockMaster.PriceTypeId.Equals(0))
{
command.Parameters.AddWithValue("@PriceTypeId", DBNull.Value);
}
else
{
command.Parameters.AddWithValue("@PriceTypeId", stockMaster.PriceTypeId);
}
command.Parameters.AddWithValue("@NonTaxable", nonTaxable);
command.Parameters.AddWithValue("@SalesPersonId", stockMaster.SalespersonId);
command.Parameters.AddWithValue("@ShipperId", stockMaster.ShipperId);
command.Parameters.AddWithValue("@ShippingAddressCode", stockMaster.ShippingAddressCode);
command.Parameters.AddWithValue("@StoreId", stockMaster.StoreId);
command.Parameters.AddRange(
ParameterHelper.AddBigintArrayParameter(transactionIdCollection, "@TranId").ToArray());
command.Parameters.AddRange(StockMasterDetailHelper.AddStockMasterDetailParameter(details).ToArray());
command.Parameters.AddRange(AttachmentHelper.AddAttachmentParameter(attachments).ToArray());
long tranId = Conversion.TryCastLong(DbOperation.GetScalarValue(catalog, command));
return tranId;
}
}
