/// <summary>
/// function to fill budget combo
/// </summary>
public void BudgetComboFill()
{
try
{
BudgetBll BllBudget = new BudgetBll();
List<DataTable> listObj = new List<DataTable>();
listObj = BllBudget.BudgetViewAll();
DataRow drow = listObj[0].NewRow();
drow[0] = 0;
drow[1] = "Select";
drow[2] = 0;
drow[3] = 0;
listObj[0].Rows.InsertAt(drow, 0);
cmbBudget.ValueMember = "budgetMasterId";
cmbBudget.DisplayMember = "budgetName";
cmbBudget.DataSource = listObj[0];
}
catch (Exception ex)
{
MessageBox.Show("BV:02" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// function to fill datagridview
/// </summary>
public void GridFill()
{
try
{
List<DataTable> listObj = new List<DataTable>();
BudgetBll BllBudget = new BudgetBll();
dgvBudgetVariance.Rows.Clear();
decimal decId = Convert.ToDecimal(cmbBudget.SelectedValue.ToString());
listObj = BllBudget.BudgetVariance(decId);
decimal decrindx = dgvBudgetVariance.Rows.Count;
int index = 0;
foreach (DataRow rw in listObj[0].Rows)
{
dgvBudgetVariance.Rows.Add();
dgvBudgetVariance.Rows[index].Cells["dgvtxtSlNo"].Value = rw["Sl NO"].ToString();
dgvBudgetVariance.Rows[index].Cells["dgvtxtParticulars"].Value = rw["Particular"].ToString();
dgvBudgetVariance.Rows[index].Cells["dgvtxtBudgetDr"].Value = rw["BudgetDr"].ToString();
dgvBudgetVariance.Rows[index].Cells["dgvtxtActualDr"].Value = rw["ActualDr"].ToString();
dgvBudgetVariance.Rows[index].Cells["dgvtxtVarianceDr"].Value = rw["VarianceDr"].ToString();
dgvBudgetVariance.Rows[index].Cells["dgvtxtBudgetCr"].Value = rw["BudgetCr"].ToString();
dgvBudgetVariance.Rows[index].Cells["dgvtxtActualCr"].Value = rw["ActualCr"].ToString();
dgvBudgetVariance.Rows[index].Cells["dgvtxtVarianceCr"].Value = rw["VarianceCr"].ToString();
index++;
}
}
catch (Exception ex)
{
MessageBox.Show("BV:01" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
