public DataSet Opr_TestCentreRegitration(TestCentreRegitration _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("Opr_TestCentreRegitration", _cn);
_cmd.Parameters.AddWithValue("@studentid", _obj.studentid);
_cmd.Parameters.AddWithValue("@Type", _obj.Type);
_cmd.Parameters.AddWithValue("@FatherName", _obj.FatherName);
_cmd.Parameters.AddWithValue("@TestCountry", _obj.TestCountry);
_cmd.Parameters.AddWithValue("@TestCity", _obj.TestCity);
_cmd.Parameters.AddWithValue("@CreatedIP", _obj.CreatedIP);
_cmd.Parameters.AddWithValue("@Country", _obj.Country);
_cmd.Parameters.AddWithValue("@ApplyingForCourse", _obj.ApplyingForCourse);
_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 SaveStudentBasic(TestCentreRegitration _obj)
{
_obj.Type = "INSERT";
_obj.studentid = Session["studentid"].ToString();
_obj.CreatedIP = Session["localIP"].ToString();
ChoiceFillingRepository objRepository = new ChoiceFillingRepository();
DataSet _ds = objRepository.Opr_TestCentreRegitration(_obj);
bool flag = true;
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
if (_ds.Tables[0].Rows[0]["Counts"].ToString() == "0")
{
flag = false;
}
}
}
return(Json(new
{
flag = flag
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult Select()
{
TestCentreRegitration _obj = new TestCentreRegitration
{
Type = "SELECT"
};
ChoiceFillingRepository objRep = new ChoiceFillingRepository();
_obj.studentid = Session["studentid"].ToString();
DataSet ds = objRep.Opr_TestCentreRegitration(_obj);
List <TestCentreRegitration> _list = new List <TestCentreRegitration>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
_list.Add(new TestCentreRegitration
{
FatherName = row["FatherName"].ToString(),
TestCountry = row["TestCountry"].ToString(),
TestCity = row["TestCity"].ToString()
});
}
}
}
return(Json(new
{
List = _list
},
JsonRequestBehavior.AllowGet
));
}
public void selectDropdown()
{
StudentRepository _objNationality = new StudentRepository();
DataSet ds = _objNationality.select_form_load_student();
List <Nationality> _Nationality = new List <Nationality>();
List <Country> _Country = new List <Country>();
List <Country> _TestCountry = new List <Country>();
List <TestCity> _TestCity = new List <TestCity>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
Nationality _objpro = new Nationality();
_objpro.Nationality_id = (row["Nationality_id"].ToString());
_objpro.Nationality_Name = row["Nationality"].ToString();
_Nationality.Add(_objpro);
}
}
if (ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[1].Rows)
{
Country _objcountry = new Country();
_objcountry.Country_id = (row["Country_id"].ToString());
_objcountry.Country_Name = row["Country_Name"].ToString();
_objcountry.country_code = row["country_code"].ToString() + " (" + row["Country_Name"].ToString() + ")";
_Country.Add(_objcountry);
}
}
}
ViewBag.Nationality = _Nationality;
ViewBag.Country = _Country;
ChoiceFillingRepository _objRepo = new ChoiceFillingRepository();
TestCentreRegitration _obj = new TestCentreRegitration
{
Type = "SELECTDRP"
};
DataSet _ds2 = _objRepo.Opr_TestCentreRegitration(_obj);
if (_ds2 != null)
{
if (_ds2.Tables[0].Rows.Count > 0)
{
ViewBag.TestCountry = _ds2.Tables[0];
}
if (_ds2.Tables[1].Rows.Count > 0)
{
ViewBag.TestCity = _ds2.Tables[1];
}
}
}
public JsonResult SelectStudentBasic()
{
Student_Register _obj = new Student_Register();
StudentRepository objRep = new StudentRepository();
_obj.studentid = Session["studentid"].ToString();
DataSet ds = objRep.Select_Student_Information(_obj);
List <Student_Register> _list = new List <Student_Register>();
List <Student_AddressDetails> _listAddress = new List <Student_AddressDetails>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
Student_Register objBasic = new Student_Register();
objBasic.studentid = row["studentid"].ToString();
objBasic.FirstName = row["FirstName"].ToString();
objBasic.LastName = row["LastName"].ToString();
objBasic.MiddleName = row["MiddleName"].ToString();
objBasic.DateOfBirth = row["DateOfBirth"].ToString();
objBasic.Gender = row["Gender"].ToString();
objBasic.Email = row["Email"].ToString();
objBasic.Mobile = row["Mobile"].ToString();
objBasic.CountryCode = row["CountryCode"].ToString();
objBasic.Nationality = row["Nationality"].ToString();
objBasic.Country = row["CountryID"].ToString();
objBasic.CountryToStay = row["CountryToStay"].ToString();
objBasic.student_path = row["student_path"].ToString();
objBasic.bCopyAddress = row["bCopyAddress"].ToString();
objBasic.ApplyingForCourse = row["ApplyingForCourse"].ToString();
Session["studentname"] = row["FirstName"].ToString() + ' ' + row["MiddleName"].ToString() + ' ' + row["LastName"].ToString();
_list.Add(objBasic);
}
}
}
TestCentreRegitration _obj1 = new TestCentreRegitration
{
Type = "SELECT",
studentid = Session["studentid"].ToString()
};
ChoiceFillingRepository objRep1 = new ChoiceFillingRepository();
DataSet ds1 = objRep1.Opr_TestCentreRegitration(_obj1);
List <TestCentreRegitration> _list1 = new List <TestCentreRegitration>();
if (ds1 != null)
{
if (ds1.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds1.Tables[0].Rows)
{
_list1.Add(new TestCentreRegitration
{
FatherName = row["FatherName"].ToString(),
TestCountry = row["TestCountry"].ToString(),
TestCity = row["TestCity"].ToString()
});
}
}
}
return(Json(new
{
List = _list,
List1 = _list1
},
JsonRequestBehavior.AllowGet
));
}
