public JsonResult SelectNatureofcourse(NatureOfCourses obj)
{
NatureOfCoursesRepository objRep = new NatureOfCoursesRepository();
DataSet ds = objRep.select_Natureofcourse(obj);
List <NatureOfCourses> _list = new List <NatureOfCourses>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
NatureOfCourses objBasic = new NatureOfCourses();
objBasic.Natureofcourse_Id = row["Natureofcourse_Id"].ToString();
objBasic.Discipline_ID = row["Discipline_ID"].ToString();
objBasic.ProgramLevel_Id = row["ProgramLevel_Id"].ToString();
objBasic.NatureOfCourse = row["NatureOfCourse"].ToString();
_list.Add(objBasic);
}
}
}
return(Json(new
{
List = _list
},
JsonRequestBehavior.AllowGet
));
}
public DataSet select_Natureofcourse(NatureOfCourses _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_select_Natureofcourse", _cn);
_cmd.Parameters.AddWithValue("@Discipline_ID", _obj.Discipline_ID);
_cmd.Parameters.AddWithValue("@ProgramLevel_Id", _obj.ProgramLevel_Id);
_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();
}
}
