/// <summary>
/// Function for New Row Added To Delete From tbl_StockPosting
/// </summary>
/// <param name="inI"></param>
public void StockPostingNewRows(int inI)
{
try
{
StockPostingSP spStockPosting = new StockPostingSP();
StockPostingInfo infoStockPosting = new StockPostingInfo();
int inRow = inI;
infoStockPosting.AgainstInvoiceNo = string.Empty;
infoStockPosting.AgainstVoucherNo = string.Empty;
infoStockPosting.Date = PublicVariables._dtCurrentDate;
infoStockPosting.AgainstVoucherTypeId = 0;
infoStockPosting.InvoiceNo = Convert.ToString(decProductIdForEdit);
infoStockPosting.VoucherNo = Convert.ToString(decProductIdForEdit);
infoStockPosting.VoucherTypeId = 2;
// infoStockPosting.UnitId = decUnitIdForUpdate;
infoStockPosting.UnitId = Convert.ToDecimal(dgvProductCreation.Rows[inRow].Cells["dgvcmbUnit"].Value);
infoStockPosting.GodownId = Convert.ToDecimal(dgvProductCreation.Rows[inRow].Cells["dgvcmbtgodown"].Value);
infoStockPosting.InwardQty = Convert.ToDecimal(dgvProductCreation.Rows[inRow].Cells["dgvtxtqty"].Value);
infoStockPosting.OutwardQty = 0;
infoStockPosting.RackId = Convert.ToDecimal(dgvProductCreation.Rows[inRow].Cells["dgvcmbrack"].Value);
infoStockPosting.Rate = Convert.ToDecimal(dgvProductCreation.Rows[inRow].Cells["dgvtxtrate"].Value);
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
infoStockPosting.ExtraDate = DateTime.Now;
infoStockPosting.ProductId = decProductIdForEdit;
if (cmbAllowBatch.SelectedIndex == 0)
{
int inId = spStockPosting.ReturnBatchIdFromStockPosting(decProductIdForEdit);
infoStockPosting.BatchId = inId;
}
else
{
// infoStockPosting.BatchId = decBatchId;
infoStockPosting.BatchId = Convert.ToDecimal(dgvProductCreation.Rows[inRow].Cells["dgvtxtbatchId"].Value);
}
decimal decId = spStockPosting.StockPostingAdd(infoStockPosting);
dgvProductCreation.Rows[inRow].Cells["dgvtxtstockpostId"].Value = decId;
}
catch (Exception ex)
{
MessageBox.Show("PC:72" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to Edit stockposting table
/// </summary>
public void StockPostingTableEditFill()
{
try
{
StockPostingSP spStockPosting = new StockPostingSP();
StockPostingInfo infoStockPosting = new StockPostingInfo();
BatchSP spBatch = new BatchSP();
for (int inI = 0; inI < dgvProductCreation.RowCount - 1; inI++)
{
infoStockPosting.StockPostingId = Convert.ToDecimal(dgvProductCreation.Rows[inI].Cells["dgvtxtstockpostId"].Value);
infoStockPosting.AgainstInvoiceNo = string.Empty;
infoStockPosting.AgainstVoucherNo = string.Empty;
infoStockPosting.Date = PublicVariables._dtCurrentDate;
infoStockPosting.AgainstVoucherTypeId = 0;
infoStockPosting.InvoiceNo = Convert.ToString(decProductIdForEdit);
infoStockPosting.VoucherNo = Convert.ToString(decProductIdForEdit);
infoStockPosting.VoucherTypeId = 2;
infoStockPosting.UnitId = Convert.ToDecimal(dgvProductCreation.Rows[inI].Cells["dgvcmbUnit"].Value);
infoStockPosting.InwardQty = Convert.ToDecimal(dgvProductCreation.Rows[inI].Cells["dgvtxtqty"].Value);
infoStockPosting.OutwardQty = 0;
infoStockPosting.ProductId = decProductIdForEdit;
infoStockPosting.Rate = Convert.ToDecimal(dgvProductCreation.Rows[inI].Cells["dgvtxtrate"].Value);
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
infoStockPosting.ExtraDate = DateTime.Now;
if (!dgvProductCreation.Columns["dgvcmbrack"].Visible)
{
infoStockPosting.RackId = 1;
}
else
{
infoStockPosting.RackId = Convert.ToDecimal(dgvProductCreation.Rows[inI].Cells["dgvcmbrack"].Value);
}
if (!dgvProductCreation.Columns["dgvcmbtgodown"].Visible)
{
infoStockPosting.GodownId = 1;
}
else
{
infoStockPosting.GodownId = Convert.ToDecimal(dgvProductCreation.Rows[inI].Cells["dgvcmbtgodown"].Value);
}
if (cmbAllowBatch.SelectedIndex == 0)
{
if (isBatchRemoved)
{
infoStockPosting.BatchId = spBatch.BatchIdForStockPosting(decProductIdForEdit);
}
else
{
int inId = spStockPosting.ReturnBatchIdFromStockPosting(decProductIdForEdit);
infoStockPosting.BatchId = inId;
}
}
else
{
infoStockPosting.BatchId = Convert.ToDecimal(dgvProductCreation.Rows[inI].Cells["dgvtxtbatchId"].Value);
}
isStpUpdated = spStockPosting.StockPostingEdit(infoStockPosting);
}
}
catch (Exception ex)
{
MessageBox.Show("PC:23" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
