public static long Add(string book, DateTime valueDate, string partyCode, int priceTypeId, GridView grid, string referenceNumber, string statementReference)
{
MixERP.Net.Common.Models.Transactions.StockMasterModel stockMaster = new MixERP.Net.Common.Models.Transactions.StockMasterModel();
Collection <MixERP.Net.Common.Models.Transactions.StockMasterDetailModel> details = new Collection <MixERP.Net.Common.Models.Transactions.StockMasterDetailModel>();
long nonGlStockMasterId = 0;
stockMaster.PartyCode = partyCode;
stockMaster.PriceTypeId = priceTypeId;
if (grid != null)
{
if (grid.Rows.Count > 0)
{
foreach (GridViewRow row in grid.Rows)
{
MixERP.Net.Common.Models.Transactions.StockMasterDetailModel detail = new MixERP.Net.Common.Models.Transactions.StockMasterDetailModel();
detail.ItemCode = row.Cells[0].Text;
detail.Quantity = MixERP.Net.Common.Conversion.TryCastInteger(row.Cells[2].Text);
detail.UnitName = row.Cells[3].Text;
detail.Price = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[4].Text);
detail.Discount = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[6].Text);
detail.TaxRate = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[8].Text);
detail.Tax = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[9].Text);
details.Add(detail);
}
}
}
nonGlStockMasterId = MixERP.Net.DatabaseLayer.Transactions.NonGLStockTransaction.Add(book, valueDate, MixERP.Net.BusinessLayer.Helpers.SessionHelper.OfficeId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.UserId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.LogOnId(), referenceNumber, statementReference, stockMaster, details);
return(nonGlStockMasterId);
}
public static long Add(string book, DateTime valueDate, string partyCode, int priceTypeId, GridView grid, string referenceNumber, string statementReference)
{
MixERP.Net.Common.Models.Transactions.StockMasterModel stockMaster = new MixERP.Net.Common.Models.Transactions.StockMasterModel();
Collection<MixERP.Net.Common.Models.Transactions.StockMasterDetailModel> details = new Collection<MixERP.Net.Common.Models.Transactions.StockMasterDetailModel>();
long nonGlStockMasterId = 0;
stockMaster.PartyCode = partyCode;
stockMaster.PriceTypeId = priceTypeId;
if(grid != null)
{
if(grid.Rows.Count > 0)
{
foreach(GridViewRow row in grid.Rows)
{
MixERP.Net.Common.Models.Transactions.StockMasterDetailModel detail = new MixERP.Net.Common.Models.Transactions.StockMasterDetailModel();
detail.ItemCode = row.Cells[0].Text;
detail.Quantity = MixERP.Net.Common.Conversion.TryCastInteger(row.Cells[2].Text);
detail.UnitName = row.Cells[3].Text;
detail.Price = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[4].Text);
detail.Discount = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[6].Text);
detail.TaxRate = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[8].Text);
detail.Tax = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[9].Text);
details.Add(detail);
}
}
}
nonGlStockMasterId = MixERP.Net.DatabaseLayer.Transactions.NonGLStockTransaction.Add(book, valueDate, MixERP.Net.BusinessLayer.Helpers.SessionHelper.OfficeId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.UserId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.LogOnId(), referenceNumber, statementReference, stockMaster, details);
return nonGlStockMasterId;
}
public static long Add(DateTime valueDate, int storeId, bool isCredit, string partyCode, GridView grid, int cashRepositoryId, int costCenterId, string referenceNumber, string statementReference)
{
MixERP.Net.Common.Models.Transactions.StockMasterModel stockMaster = new MixERP.Net.Common.Models.Transactions.StockMasterModel();
Collection <MixERP.Net.Common.Models.Transactions.StockMasterDetailModel> details = new Collection <MixERP.Net.Common.Models.Transactions.StockMasterDetailModel>();
long transactionMasterId = 0;
stockMaster.PartyCode = partyCode;
stockMaster.StoreId = storeId;
stockMaster.CashRepositoryId = cashRepositoryId;
stockMaster.IsCredit = isCredit;
if (!string.IsNullOrWhiteSpace(statementReference))
{
statementReference = statementReference.Replace(" ", " ").Trim();
}
if (grid != null)
{
if (grid.Rows.Count > 0)
{
foreach (GridViewRow row in grid.Rows)
{
MixERP.Net.Common.Models.Transactions.StockMasterDetailModel detail = new MixERP.Net.Common.Models.Transactions.StockMasterDetailModel();
detail.StoreId = storeId;
detail.ItemCode = row.Cells[0].Text;
detail.Quantity = MixERP.Net.Common.Conversion.TryCastInteger(row.Cells[2].Text);
detail.UnitName = row.Cells[3].Text;
detail.Price = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[4].Text);
detail.Discount = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[6].Text);
detail.TaxRate = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[8].Text);
detail.Tax = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[9].Text);
details.Add(detail);
}
}
}
transactionMasterId = MixERP.Net.DatabaseLayer.Transactions.DirectPurchase.Add(valueDate, MixERP.Net.BusinessLayer.Helpers.SessionHelper.OfficeId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.UserId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.LogOnId(), costCenterId, referenceNumber, statementReference, stockMaster, details);
MixERP.Net.DatabaseLayer.Transactions.Verification.CallAutoVerification(transactionMasterId);
return(transactionMasterId);
}
public static long Add(DateTime valueDate, int storeId, bool isCredit, string partyCode, GridView grid, int cashRepositoryId, int costCenterId, string referenceNumber, string statementReference)
{
MixERP.Net.Common.Models.Transactions.StockMasterModel stockMaster = new MixERP.Net.Common.Models.Transactions.StockMasterModel();
Collection<MixERP.Net.Common.Models.Transactions.StockMasterDetailModel> details = new Collection<MixERP.Net.Common.Models.Transactions.StockMasterDetailModel>();
long transactionMasterId = 0;
stockMaster.PartyCode = partyCode;
stockMaster.StoreId = storeId;
stockMaster.CashRepositoryId = cashRepositoryId;
stockMaster.IsCredit = isCredit;
if(!string.IsNullOrWhiteSpace(statementReference))
{
statementReference = statementReference.Replace(" ", " ").Trim();
}
if(grid != null)
{
if(grid.Rows.Count > 0)
{
foreach(GridViewRow row in grid.Rows)
{
MixERP.Net.Common.Models.Transactions.StockMasterDetailModel detail = new MixERP.Net.Common.Models.Transactions.StockMasterDetailModel();
detail.StoreId = storeId;
detail.ItemCode = row.Cells[0].Text;
detail.Quantity = MixERP.Net.Common.Conversion.TryCastInteger(row.Cells[2].Text);
detail.UnitName = row.Cells[3].Text;
detail.Price = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[4].Text);
detail.Discount = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[6].Text);
detail.TaxRate = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[8].Text);
detail.Tax = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[9].Text);
details.Add(detail);
}
}
}
transactionMasterId = MixERP.Net.DatabaseLayer.Transactions.DirectPurchase.Add(valueDate, MixERP.Net.BusinessLayer.Helpers.SessionHelper.OfficeId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.UserId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.LogOnId(), costCenterId, referenceNumber, statementReference, stockMaster, details);
MixERP.Net.DatabaseLayer.Transactions.Verification.CallAutoVerification(transactionMasterId);
return transactionMasterId;
}
public static long Add(DateTime valueDate, int storeId, string partyCode, int priceTypeId, GridView grid, int shipperId, decimal shippingCharge, int costCenterId, string referenceNumber, string statementReference)
{
MixERP.Net.Common.Models.Transactions.StockMasterModel stockMaster = new MixERP.Net.Common.Models.Transactions.StockMasterModel();
Collection <MixERP.Net.Common.Models.Transactions.StockMasterDetailModel> details = new Collection <MixERP.Net.Common.Models.Transactions.StockMasterDetailModel>();
long transactionMasterId = 0;
stockMaster.PartyCode = partyCode;
stockMaster.StoreId = storeId;
stockMaster.PriceTypeId = priceTypeId;
stockMaster.ShipperId = shipperId;
stockMaster.ShippingCharge = shippingCharge;
if (grid != null)
{
if (grid.Rows.Count > 0)
{
foreach (GridViewRow row in grid.Rows)
{
MixERP.Net.Common.Models.Transactions.StockMasterDetailModel detail = new MixERP.Net.Common.Models.Transactions.StockMasterDetailModel();
detail.StoreId = storeId;
detail.ItemCode = row.Cells[0].Text;
detail.Quantity = MixERP.Net.Common.Conversion.TryCastInteger(row.Cells[2].Text);
detail.UnitName = row.Cells[3].Text;
detail.Price = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[4].Text);
detail.Discount = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[6].Text);
detail.TaxRate = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[8].Text);
detail.Tax = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[9].Text);
details.Add(detail);
}
}
}
transactionMasterId = MixERP.Net.DatabaseLayer.Transactions.SalesDelivery.Add(valueDate, MixERP.Net.BusinessLayer.Helpers.SessionHelper.OfficeId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.UserId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.LogOnId(), costCenterId, referenceNumber, statementReference, stockMaster, details);
MixERP.Net.DatabaseLayer.Transactions.Verification.CallAutoVerification(transactionMasterId);
return(transactionMasterId);
}
public static long Add(DateTime valueDate, int storeId, string partyCode, int priceTypeId, GridView grid, int shipperId, decimal shippingCharge, int costCenterId, string referenceNumber, string statementReference)
{
MixERP.Net.Common.Models.Transactions.StockMasterModel stockMaster = new MixERP.Net.Common.Models.Transactions.StockMasterModel();
Collection<MixERP.Net.Common.Models.Transactions.StockMasterDetailModel> details = new Collection<MixERP.Net.Common.Models.Transactions.StockMasterDetailModel>();
long transactionMasterId = 0;
stockMaster.PartyCode = partyCode;
stockMaster.StoreId = storeId;
stockMaster.PriceTypeId = priceTypeId;
stockMaster.ShipperId = shipperId;
stockMaster.ShippingCharge = shippingCharge;
if(grid != null)
{
if(grid.Rows.Count > 0)
{
foreach(GridViewRow row in grid.Rows)
{
MixERP.Net.Common.Models.Transactions.StockMasterDetailModel detail = new MixERP.Net.Common.Models.Transactions.StockMasterDetailModel();
detail.StoreId = storeId;
detail.ItemCode = row.Cells[0].Text;
detail.Quantity = MixERP.Net.Common.Conversion.TryCastInteger(row.Cells[2].Text);
detail.UnitName = row.Cells[3].Text;
detail.Price = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[4].Text);
detail.Discount = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[6].Text);
detail.TaxRate = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[8].Text);
detail.Tax = MixERP.Net.Common.Conversion.TryCastDecimal(row.Cells[9].Text);
details.Add(detail);
}
}
}
transactionMasterId = MixERP.Net.DatabaseLayer.Transactions.SalesDelivery.Add(valueDate, MixERP.Net.BusinessLayer.Helpers.SessionHelper.OfficeId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.UserId(), MixERP.Net.BusinessLayer.Helpers.SessionHelper.LogOnId(), costCenterId, referenceNumber, statementReference, stockMaster, details);
MixERP.Net.DatabaseLayer.Transactions.Verification.CallAutoVerification(transactionMasterId);
return transactionMasterId;
}
public static long Add(DateTime valueDate, int officeId, int userId, long logOnId, int costCenterId, string referenceNumber, string statementReference, MixERP.Net.Common.Models.Transactions.StockMasterModel stockMaster, Collection <MixERP.Net.Common.Models.Transactions.StockMasterDetailModel> details)
{
if (stockMaster == null)
{
return(0);
}
if (details == null)
{
return(0);
}
if (details.Count.Equals(0))
{
return(0);
}
string sql = string.Empty;
long transactionMasterId = 0;
long stockMasterId = 0;
decimal total = details.Sum(d => (d.Price * d.Quantity));
decimal discountTotal = details.Sum(d => d.Discount);
decimal taxTotal = details.Sum(d => d.Tax);
string creditInvariantParameter = "Sales.Receivables";
string salesInvariantParameter = "Sales";
string salesTaxInvariantParamter = "Sales.Tax";
string salesDiscountInvariantParameter = "Sales.Discount";
using (NpgsqlConnection connection = new NpgsqlConnection(DBConnection.ConnectionString()))
{
connection.Open();
using (NpgsqlTransaction transaction = connection.BeginTransaction())
{
try
{
#region TransactionMaster
sql = "INSERT INTO transactions.transaction_master(transaction_master_id, transaction_counter, transaction_code, book, value_date, user_id, login_id, office_id, cost_center_id, reference_number, statement_reference) SELECT nextval(pg_get_serial_sequence('transactions.transaction_master', 'transaction_master_id')), transactions.get_new_transaction_counter(@ValueDate), transactions.get_transaction_code(@ValueDate, @OfficeId, @UserId, @LogOnId), @Book, @ValueDate, @UserId, @LogOnId, @OfficeId, @CostCenterId, @ReferenceNumber, @StatementReference;SELECT currval(pg_get_serial_sequence('transactions.transaction_master', 'transaction_master_id'));";
using (NpgsqlCommand tm = new NpgsqlCommand(sql, connection))
{
tm.Parameters.AddWithValue("@ValueDate", valueDate);
tm.Parameters.AddWithValue("@OfficeId", officeId);
tm.Parameters.AddWithValue("@UserId", userId);
tm.Parameters.AddWithValue("@LogOnId", logOnId);
tm.Parameters.AddWithValue("@Book", "Sales.Delivery");
tm.Parameters.AddWithValue("@CostCenterId", costCenterId);
tm.Parameters.AddWithValue("@ReferenceNumber", referenceNumber);
tm.Parameters.AddWithValue("@StatementReference", statementReference);
transactionMasterId = MixERP.Net.Common.Conversion.TryCastLong(tm.ExecuteScalar());
}
#region TransactionDetails
sql = "INSERT INTO transactions.transaction_details(transaction_master_id, tran_type, account_id, statement_reference, amount) SELECT @TransactionMasterId, @TranType, core.get_account_id_by_parameter(@ParameterName), @StatementReference, @Amount;";
using (NpgsqlCommand salesRow = new NpgsqlCommand(sql, connection))
{
salesRow.Parameters.AddWithValue("@TransactionMasterId", transactionMasterId);
salesRow.Parameters.AddWithValue("@TranType", "Cr");
salesRow.Parameters.AddWithValue("@ParameterName", salesInvariantParameter);
salesRow.Parameters.AddWithValue("@StatementReference", statementReference);
salesRow.Parameters.AddWithValue("@Amount", total);
salesRow.ExecuteNonQuery();
}
if (taxTotal > 0)
{
using (NpgsqlCommand taxRow = new NpgsqlCommand(sql, connection))
{
taxRow.Parameters.AddWithValue("@TransactionMasterId", transactionMasterId);
taxRow.Parameters.AddWithValue("@TranType", "Cr");
taxRow.Parameters.AddWithValue("@ParameterName", salesTaxInvariantParamter);
taxRow.Parameters.AddWithValue("@StatementReference", statementReference);
taxRow.Parameters.AddWithValue("@Amount", taxTotal);
taxRow.ExecuteNonQuery();
}
}
if (discountTotal > 0)
{
using (NpgsqlCommand discountRow = new NpgsqlCommand(sql, connection))
{
discountRow.Parameters.AddWithValue("@TransactionMasterId", transactionMasterId);
discountRow.Parameters.AddWithValue("@TranType", "Dr");
discountRow.Parameters.AddWithValue("@ParameterName", salesDiscountInvariantParameter);
discountRow.Parameters.AddWithValue("@StatementReference", statementReference);
discountRow.Parameters.AddWithValue("@Amount", discountTotal);
discountRow.ExecuteNonQuery();
}
}
using (NpgsqlCommand creditRow = new NpgsqlCommand(sql, connection))
{
creditRow.Parameters.AddWithValue("@TransactionMasterId", transactionMasterId);
creditRow.Parameters.AddWithValue("@TranType", "Dr");
creditRow.Parameters.AddWithValue("@ParameterName", creditInvariantParameter);
creditRow.Parameters.AddWithValue("@StatementReference", statementReference);
creditRow.Parameters.AddWithValue("@Amount", total - discountTotal + taxTotal + stockMaster.ShippingCharge);
creditRow.ExecuteNonQuery();
}
if (stockMaster.ShippingCharge > 0)
{
sql = "INSERT INTO transactions.transaction_details(transaction_master_id, tran_type, account_id, statement_reference, amount) SELECT @TransactionMasterId, @TranType, core.get_account_id_by_shipper_id(@ShipperId), @StatementReference, @Amount;";
using (NpgsqlCommand shippingChargeRow = new NpgsqlCommand(sql, connection))
{
shippingChargeRow.Parameters.AddWithValue("@TransactionMasterId", transactionMasterId);
shippingChargeRow.Parameters.AddWithValue("@TranType", "Cr");
shippingChargeRow.Parameters.AddWithValue("@ShipperId", stockMaster.ShipperId);
shippingChargeRow.Parameters.AddWithValue("@StatementReference", statementReference);
shippingChargeRow.Parameters.AddWithValue("@Amount", stockMaster.ShippingCharge);
shippingChargeRow.ExecuteNonQuery();
}
}
#endregion
#endregion
#region StockMaster
sql = "INSERT INTO transactions.stock_master(stock_master_id, transaction_master_id, party_id, agent_id, price_type_id, is_credit, shipper_id, shipping_charge, store_id) SELECT nextval(pg_get_serial_sequence('transactions.stock_master', 'stock_master_id')), @TransactionMasterId, core.get_party_id_by_party_code(@PartyCode), @AgentId, @PriceTypeId, @IsCredit, @ShipperId, @ShippingCharge, @StoreId; SELECT currval(pg_get_serial_sequence('transactions.stock_master', 'stock_master_id'));";
using (NpgsqlCommand stockMasterRow = new NpgsqlCommand(sql, connection))
{
stockMasterRow.Parameters.AddWithValue("@TransactionMasterId", transactionMasterId);
stockMasterRow.Parameters.AddWithValue("@PartyCode", stockMaster.PartyCode);
stockMasterRow.Parameters.AddWithValue("@AgentId", stockMaster.AgentId);
stockMasterRow.Parameters.AddWithValue("@PriceTypeId", stockMaster.PriceTypeId);
stockMasterRow.Parameters.AddWithValue("@IsCredit", true);
if (stockMaster.ShipperId.Equals(0))
{
stockMasterRow.Parameters.AddWithValue("@ShipperId", DBNull.Value);
}
else
{
stockMasterRow.Parameters.AddWithValue("@ShipperId", stockMaster.ShipperId);
}
stockMasterRow.Parameters.AddWithValue("@ShippingCharge", stockMaster.ShippingCharge);
stockMasterRow.Parameters.AddWithValue("@StoreId", stockMaster.StoreId);
stockMasterId = MixERP.Net.Common.Conversion.TryCastLong(stockMasterRow.ExecuteScalar());
}
#region StockDetails
sql = @"INSERT INTO
transactions.stock_details(stock_master_id, tran_type, store_id, item_id, quantity, unit_id, base_quantity, base_unit_id, price, discount, tax_rate, tax)
SELECT @StockMasterId, @TranType, @StoreId, core.get_item_id_by_item_code(@ItemCode), @Quantity, core.get_unit_id_by_unit_name(@UnitName), core.get_base_quantity_by_unit_name(@UnitName, @Quantity), core.get_base_unit_id_by_unit_name(@UnitName), @Price, @Discount, @TaxRate, @Tax;";
foreach (MixERP.Net.Common.Models.Transactions.StockMasterDetailModel model in details)
{
using (NpgsqlCommand stockMasterDetailRow = new NpgsqlCommand(sql, connection))
{
stockMasterDetailRow.Parameters.AddWithValue("@StockMasterId", stockMasterId);
stockMasterDetailRow.Parameters.AddWithValue("@TranType", "Cr");
stockMasterDetailRow.Parameters.AddWithValue("@StoreId", model.StoreId);
stockMasterDetailRow.Parameters.AddWithValue("@ItemCode", model.ItemCode);
stockMasterDetailRow.Parameters.AddWithValue("@Quantity", model.Quantity);
stockMasterDetailRow.Parameters.AddWithValue("@UnitName", model.UnitName);
stockMasterDetailRow.Parameters.AddWithValue("@Price", model.Price);
stockMasterDetailRow.Parameters.AddWithValue("@Discount", model.Discount);
stockMasterDetailRow.Parameters.AddWithValue("@TaxRate", model.TaxRate);
stockMasterDetailRow.Parameters.AddWithValue("@Tax", model.Tax);
stockMasterDetailRow.ExecuteNonQuery();
}
}
#endregion
#endregion
transaction.Commit();
return(transactionMasterId);
}
catch (NpgsqlException)
{
transaction.Rollback();
throw;
}
}
}
}
public static long Add(string book, DateTime valueDate, int officeId, int userId, long logOnId, string referenceNumber, string statementReference, MixERP.Net.Common.Models.Transactions.StockMasterModel stockMaster, Collection <MixERP.Net.Common.Models.Transactions.StockMasterDetailModel> details)
{
if (stockMaster == null)
{
return(0);
}
if (details == null)
{
return(0);
}
if (details.Count.Equals(0))
{
return(0);
}
string sql = string.Empty;
long nonGlStockMasterId = 0;
//decimal total = details.Sum(d => (d.Price * d.Quantity));
//decimal discountTotal = details.Sum(d => d.Discount);
//decimal taxTotal = details.Sum(d => d.Tax);
using (NpgsqlConnection connection = new NpgsqlConnection(DBFactory.DBConnection.ConnectionString()))
{
connection.Open();
using (NpgsqlTransaction transaction = connection.BeginTransaction())
{
try
{
#region NonGLStockMaster
sql = "INSERT INTO transactions.non_gl_stock_master(non_gl_stock_master_id, value_date, book, party_id, price_type_id, login_id, user_id, office_id, reference_number, statement_reference) SELECT nextval(pg_get_serial_sequence('transactions.non_gl_stock_master', 'non_gl_stock_master_id')), @ValueDate, @Book, core.get_party_id_by_party_code(@PartyCode), @PriceTypeId, @LoginId, @UserId, @OfficeId, @ReferenceNumber, @StatementReference; SELECT currval(pg_get_serial_sequence('transactions.non_gl_stock_master', 'non_gl_stock_master_id'));";
using (NpgsqlCommand stockMasterRow = new NpgsqlCommand(sql, connection))
{
stockMasterRow.Parameters.AddWithValue("@ValueDate", valueDate);
stockMasterRow.Parameters.AddWithValue("@Book", book);
stockMasterRow.Parameters.AddWithValue("@PartyCode", stockMaster.PartyCode);
if (stockMaster.PriceTypeId.Equals(0))
{
stockMasterRow.Parameters.AddWithValue("@PriceTypeId", DBNull.Value);
}
else
{
stockMasterRow.Parameters.AddWithValue("@PriceTypeId", stockMaster.PriceTypeId);
}
stockMasterRow.Parameters.AddWithValue("@LoginId", logOnId);
stockMasterRow.Parameters.AddWithValue("@UserId", userId);
stockMasterRow.Parameters.AddWithValue("@OfficeId", officeId);
stockMasterRow.Parameters.AddWithValue("@ReferenceNumber", referenceNumber);
stockMasterRow.Parameters.AddWithValue("@StatementReference", statementReference);
nonGlStockMasterId = MixERP.Net.Common.Conversion.TryCastLong(stockMasterRow.ExecuteScalar());
}
#region NonGLStockDetails
sql = @"INSERT INTO
transactions.non_gl_stock_details(non_gl_stock_master_id, item_id, quantity, unit_id, base_quantity, base_unit_id, price, discount, tax_rate, tax)
SELECT @NonGlStockMasterId, core.get_item_id_by_item_code(@ItemCode), @Quantity, core.get_unit_id_by_unit_name(@UnitName), core.get_base_quantity_by_unit_name(@UnitName, @Quantity), core.get_base_unit_id_by_unit_name(@UnitName), @Price, @Discount, @TaxRate, @Tax;";
foreach (MixERP.Net.Common.Models.Transactions.StockMasterDetailModel model in details)
{
using (NpgsqlCommand stockMasterDetailRow = new NpgsqlCommand(sql, connection))
{
stockMasterDetailRow.Parameters.AddWithValue("@NonGlStockMasterId", nonGlStockMasterId);
stockMasterDetailRow.Parameters.AddWithValue("@ItemCode", model.ItemCode);
stockMasterDetailRow.Parameters.AddWithValue("@Quantity", model.Quantity);
stockMasterDetailRow.Parameters.AddWithValue("@UnitName", model.UnitName);
stockMasterDetailRow.Parameters.AddWithValue("@Price", model.Price);
stockMasterDetailRow.Parameters.AddWithValue("@Discount", model.Discount);
stockMasterDetailRow.Parameters.AddWithValue("@TaxRate", model.TaxRate);
stockMasterDetailRow.Parameters.AddWithValue("@Tax", model.Tax);
stockMasterDetailRow.ExecuteNonQuery();
}
}
#endregion
#endregion
transaction.Commit();
return(nonGlStockMasterId);
}
catch (NpgsqlException)
{
transaction.Rollback();
throw;
}
}
}
}
