public void SelectDropdown()
{
NatureofCostCategory obj = new NatureofCostCategory();
NatureofCostCategoryRepository _objNationality = new NatureofCostCategoryRepository();
DataSet ds = _objNationality.select_NatureofCostCategory(obj);
List <NatureofCostCategory> _NatureofCostCategory = new List <NatureofCostCategory>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
NatureofCostCategory _objNatureofCostCategory = new NatureofCostCategory();
_objNatureofCostCategory.Natureofcostcategory_id = (row["Natureofcostcategory_id"].ToString());
_objNatureofCostCategory.Natureofcostcategoryname = row["Natureofcostcategoryname"].ToString();
_NatureofCostCategory.Add(_objNatureofCostCategory);
}
}
}
ViewBag.NatureofCostCategory = _NatureofCostCategory;
}
public DataSet select_NatureofCostCategory(NatureofCostCategory _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("select_tbl_NatureofCostCategory", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter _adp = new SqlDataAdapter(_cmd);
DataSet _ds = new DataSet();
_adp.Fill(_ds);
_adp.Dispose();
_cmd.Dispose();
return(_ds);
}
catch (Exception)
{
throw;
}
finally
{
_cn.Close();
}
}
