/// <summary>
/// Function to fill additional cost grid
/// </summary>
public void AdditionalCostGridFill()
{
DataTable dtbl = new DataTable();
PurchaseMasterSP spPurchaseMaster = new PurchaseMasterSP();
AdditionalCostSP spAdditionalCost = new AdditionalCostSP();
try
{
dtbl = spPurchaseMaster.AccountLedgerViewForAdditionalCost();
DataRow dr = dtbl.NewRow();
dr["ledgerName"] = string.Empty;
dr["ledgerId"] = 0;
dtbl.Rows.InsertAt(dr, 0);
dgvcmbLedger.DataSource = dtbl;
dgvcmbLedger.DisplayMember = "ledgerName";
dgvcmbLedger.ValueMember = "ledgerId";
if (decPurchaseMasterId == 0)
{
AdditionalCostComboFill(0);
}
else
{
dtbl = spAdditionalCost.AdditionalCostViewAllByVoucherTypeIdAndVoucherNo(decPurchaseInvoiceVoucherTypeId, strVoucherNo);
dgvAdditionalCost.DataSource = dtbl;
}
AdditionalCostSerialNo();
}
catch (Exception ex)
{
MessageBox.Show("PI26:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill additional cost combo box
/// </summary>
/// <param name="inRowIndex"></param>
public void AdditionalCostComboFill(int inRowIndex)
{
DataTable dtbl = new DataTable();
PurchaseMasterSP spPurchaseMaster = new PurchaseMasterSP();
try
{
dtbl = spPurchaseMaster.AccountLedgerViewForAdditionalCost();
DataRow drow = dtbl.NewRow();
drow["ledgerName"] = string.Empty;
drow["ledgerId"] = 0;
dtbl.Rows.InsertAt(drow, 0);
if (dgvAdditionalCost.RowCount > 1)
{
foreach (DataGridViewRow dgvrow in dgvAdditionalCost.Rows)
{
foreach (DataRow drow1 in dtbl.Rows)
{
if (dgvrow.Index != inRowIndex)
{
if (dgvrow.Cells["dgvcmbLedger"].Value != null)
{
if (drow1["ledgerId"].ToString() == dgvrow.Cells["dgvcmbLedger"].Value.ToString())
{
dtbl.Rows.RemoveAt(dtbl.Rows.IndexOf(drow1));
break;
}
}
}
}
}
}
DataGridViewComboBoxCell dgvcmbLedgerCell = (DataGridViewComboBoxCell)dgvAdditionalCost.Rows[inRowIndex].Cells[dgvAdditionalCost.Columns["dgvcmbLedger"].Index];
dgvcmbLedgerCell.DataSource = dtbl;
dgvcmbLedgerCell.DisplayMember = "ledgerName";
dgvcmbLedgerCell.ValueMember = "ledgerId";
}
catch (Exception ex)
{
MessageBox.Show("PI25:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}