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