public DataSet Select_InstituteList(Mockcounselling _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("Mockcounselling_Student", _cn);
_cmd.Parameters.AddWithValue("@Created_By", _obj.studentid);
_cmd.Parameters.AddWithValue("@Type", _obj.Type);
_cmd.Parameters.AddWithValue("@Control", _obj.Control);
_cmd.Parameters.AddWithValue("@Discipline_ID", _obj.Discipline_ID);
_cmd.Parameters.AddWithValue("@ProgramLevel_Id", _obj.ProgramLevel_Id);
_cmd.Parameters.AddWithValue("@Natureofcourse_Id", _obj.Natureofcourse_Id);
_cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID);
_cmd.Parameters.AddWithValue("@Branch_Id", _obj.Branch_Id);
_cmd.Parameters.AddWithValue("@studentid", _obj.studentid);
_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();
}
}
public JsonResult Select_Result(Mockcounselling obj)
{
MockResultRepository objRep = new MockResultRepository();
obj.Type = "AllotedSeat";
obj.studentid = Session["studentid"].ToString();
obj.ProgramLevel_Id = Session["ProgramlevelId"].ToString();
obj.Discipline_ID = Session["Discipline_Id"].ToString();
DataSet ds = objRep.Select_InstituteList(obj);
List <Mockcounselling> _list = new List <Mockcounselling>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
Mockcounselling objChoice = new Mockcounselling();
objChoice.ID = row["ID"].ToString();//Primary key
objChoice.InstituteID = row["Institute_Id"].ToString();
objChoice.InstituteName = row["InstituteName"].ToString();
objChoice.SequenceNumber = row["SequenceNumber"].ToString();
objChoice.Natureofcourse = row["NoC"].ToString();
objChoice.ProgramLevel = row["ProgramLevel"].ToString();
objChoice.BranchName = row["BranchName"].ToString();
objChoice.Discipline = row["Discipline"].ToString();
objChoice.SeatWaivertype = row["SeatWaivertype"].ToString();
objChoice.Isalloted = row["Isalloted"].ToString();
_list.Add(objChoice);
}
}
}
return(Json(new
{
List = _list
},
JsonRequestBehavior.AllowGet
));
}