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