private void FillSalStructureDeatailsTogrid()
{
objHRinfo = new HRInfo();
DataTable dt = new DataTable();
dgvSaltructDetails.Rows.Clear();
if (cbSalStructType.SelectedIndex > 0)
{
try
{
dt = objHRinfo.Get_SalaryStructureDetails(cbSalStructType.Tag.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
dgvSaltructDetails.Rows.Add();
dgvSaltructDetails.Rows[i].Cells["SLNO"].Value = (i + 1).ToString();
dgvSaltructDetails.Rows[i].Cells["SalStruType"].Value = dt.Rows[i]["SalStruType"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalStruCode"].Value = dt.Rows[i]["SalStruCode"].ToString();
dgvSaltructDetails.Rows[i].Cells["DesigCode"].Value = dt.Rows[i]["DesigCode"].ToString();
dgvSaltructDetails.Rows[i].Cells["DesignName"].Value = dt.Rows[i]["DesignName"].ToString();
dgvSaltructDetails.Rows[i].Cells["EffectFrom"].Value = Convert.ToDateTime(dt.Rows[i]["EffectFrom"].ToString()).ToShortDateString();
dgvSaltructDetails.Rows[i].Cells["EffectTo"].Value = dt.Rows[i]["EffectTo"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalStatus"].Value = dt.Rows[i]["SalStatus"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalBasic"].Value = dt.Rows[i]["SalBasic"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalHra"].Value = dt.Rows[i]["SalHra"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalCca"].Value = dt.Rows[i]["SalCca"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalConvAlw"].Value = dt.Rows[i]["SalConvAlw"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalLTAAlw"].Value = dt.Rows[i]["SalLTAAlw"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalSpecialAlw"].Value = dt.Rows[i]["SalSpecialAlw"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalUnfAlw"].Value = dt.Rows[i]["SalUnfAlw"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalvehicleAlw"].Value = dt.Rows[i]["SalvehicleAlw"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalChildAlw"].Value = dt.Rows[i]["SalChildAlw"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalBnpAlw"].Value = dt.Rows[i]["SalBnpAlw"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalMedReimb"].Value = dt.Rows[i]["SalMedReimb"].ToString();
dgvSaltructDetails.Rows[i].Cells["SalpET"].Value = dt.Rows[i]["SalpET"].ToString();
dgvSaltructDetails.Rows[i].Cells["Gross"].Value = dt.Rows[i]["SalGross"].ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
objHRinfo = null;
dt = null;
}
}
}