public DataSet delete_other_academicinformation(StudentAcademic_information _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("delete_other_academicinformation", _cn);
_cmd.Parameters.AddWithValue("@id", _obj.Academicinformationid);
_cmd.Parameters.AddWithValue("@studentid", _obj.studentid);
_cmd.Parameters.AddWithValue("@ip", _obj.Created_Ip);
_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 delete_other_academicinformation(StudentAcademic_information _obj)
{
_obj.studentid = TempData.Peek("Studentid").ToString();
_obj.Created_Ip = Request.ServerVariables["REMOTE_ADDR"].ToString();
TempData.Keep("Studentid");
StudentRepository objRepository = new StudentRepository();
DataSet _ds = objRepository.delete_other_academicinformation(_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 SaveAcademicinformation(StudentAcademic_information _obj)
{
_obj.studentid = Session["studentid"].ToString();
_obj.Created_By = Session["studentid"].ToString();
_obj.Created_Ip = Session["localIP"].ToString();
StudentRepository objRepository = new StudentRepository();
DataSet _ds = objRepository.insert_academic_information(_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 DataSet insert_academic_information(StudentAcademic_information _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("insert_academic_information", _cn);
_cmd.Parameters.AddWithValue("@studentid", _obj.studentid);
_cmd.Parameters.AddWithValue("@strjson", _obj.strjson);
_cmd.Parameters.AddWithValue("@Created_By", _obj.Created_By);
_cmd.Parameters.AddWithValue("@Created_Ip", _obj.Created_Ip);
_cmd.Parameters.AddWithValue("@jeemain", _obj.jeemain);
_cmd.Parameters.AddWithValue("@jeemainscore", _obj.jeemainscore);
_cmd.Parameters.AddWithValue("@jeeadvance", _obj.jeeadvance);
_cmd.Parameters.AddWithValue("@jeeadvancescore", _obj.jeeadvancescore);
_cmd.Parameters.AddWithValue("@gov_scheme_id", _obj.gov_scheme_id);
_cmd.Parameters.AddWithValue("@ielts", _obj.ielts);
_cmd.Parameters.AddWithValue("@ieltsscore", _obj.ieltsscore);
_cmd.Parameters.AddWithValue("@GMAT", _obj.GMAT);
_cmd.Parameters.AddWithValue("@GMATscore", _obj.GMATscore);
_cmd.Parameters.AddWithValue("@TOFEL", _obj.TOFEL);
_cmd.Parameters.AddWithValue("@TOFELscore", _obj.TOFELscore);
_cmd.Parameters.AddWithValue("@SAT", _obj.SAT);
_cmd.Parameters.AddWithValue("@SATscore", _obj.SATscore);
_cmd.Parameters.AddWithValue("@experience", _obj.experience);
_cmd.Parameters.AddWithValue("@experiencescore", _obj.experiencescore);
_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 DataSet insert_other_academicinformation(StudentAcademic_information _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("insert_other_academicinformation", _cn);
_cmd.Parameters.AddWithValue("@Academicinformationid", _obj.Academicinformationid);
_cmd.Parameters.AddWithValue("@studentid", _obj.studentid);
_cmd.Parameters.AddWithValue("@Education_Qualification_Name", _obj.Education_Qualification_Name);
_cmd.Parameters.AddWithValue("@Degree_name", _obj.Degree_name);
_cmd.Parameters.AddWithValue("@board_uni_name", _obj.board_uni_name);
_cmd.Parameters.AddWithValue("@passing_year", _obj.passing_year);
_cmd.Parameters.AddWithValue("@Marks_obtains", _obj.Marks_obtains);
_cmd.Parameters.AddWithValue("@min_marks", _obj.min_marks);
_cmd.Parameters.AddWithValue("@subject_studied", _obj.subject_studied);
_cmd.Parameters.AddWithValue("@country_id", _obj.country_id);
_cmd.Parameters.AddWithValue("@address", _obj.address);
_cmd.Parameters.AddWithValue("@Created_By", _obj.Created_By);
_cmd.Parameters.AddWithValue("@Created_Ip", _obj.Created_Ip);
_cmd.Parameters.AddWithValue("@TotalMarksinPercentage", _obj.TotalMarksinPercentage);
_cmd.Parameters.AddWithValue("@GradeConversionDocument", _obj.GradeConversionDocument);
_cmd.Parameters.AddWithValue("@NameofCourse", _obj.NameofCourse);
_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 SelectAcademicinformation()
{
//StudentAcademic_information _obj = new StudentAcademic_information();
StudentRepository objRep = new StudentRepository();
//_obj.studentid = Session["studentid"].ToString();
DataSet ds = objRep.select_StudentAcademic_information(Session["studentid"].ToString());
List <StudentAcademic_information> _list = new List <StudentAcademic_information>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
StudentAcademic_information objacademic = new StudentAcademic_information();
objacademic.studentid = row["studentid"].ToString();
objacademic.Education_Qualification_Name = row["Education_Qualification_Name"].ToString();
objacademic.Degree_name = row["Degree_name"].ToString();
objacademic.board_uni_name = row["board_uni_name"].ToString();
objacademic.passing_year = row["passing_year"].ToString();
objacademic.Marks_obtains = row["Marks_obtains"].ToString();
objacademic.min_marks = row["min_marks"].ToString();
objacademic.subject_studied = row["subject_studied"].ToString();
objacademic.country_id = row["country_id"].ToString();
objacademic.address = row["address"].ToString();
_list.Add(objacademic);
}
}
}
return(Json(new
{
List = _list
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult SelectAcademicinformation()
{
//StudentAcademic_information _obj = new StudentAcademic_information();
StudentRepository objRep = new StudentRepository();
//_obj.studentid = Session["studentid"].ToString();
DataSet ds = objRep.select_StudentAcademic_information(Session["studentid"].ToString());
List <StudentAcademic_information> _list = new List <StudentAcademic_information>();
List <StudentAcademic_information> _listJee = new List <StudentAcademic_information>();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
StudentAcademic_information objacademic = new StudentAcademic_information();
objacademic.studentid = row["studentid"].ToString();
objacademic.Education_Qualification_Name = row["Education_Qualification_Name"].ToString();
objacademic.Degree_name = row["Degree_name"].ToString();
objacademic.board_uni_name = row["board_uni_name"].ToString();
objacademic.NameofCourse = row["NameofCourse"].ToString();
objacademic.Academicinformationid = row["Academicinformationid"].ToString();
objacademic.passing_year = row["passing_year"].ToString();
objacademic.Marks_obtains = row["Marks_obtains"].ToString();
objacademic.min_marks = row["min_marks"].ToString();
objacademic.subject_studied = row["subject_studied"].ToString();
objacademic.country_id = row["country_id"].ToString();
objacademic.country_name = row["country_name"].ToString();
objacademic.address = row["address"].ToString();
objacademic.GradeConversionDocument = row["GradeConversionDocument"].ToString();
objacademic.TotalMarksinPercentage = row["TotalMarksinPercentage"].ToString();
_list.Add(objacademic);
}
}
if (ds.Tables[1].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[1].Rows)
{
StudentAcademic_information objacademicjeee = new StudentAcademic_information();
objacademicjeee.jeeadvance = row["jeeadvance"].ToString();
objacademicjeee.jeeadvancescore = row["jeeadvancescore"].ToString();
objacademicjeee.jeemain = row["jeemain"].ToString();
objacademicjeee.jeemainscore = row["jeemainscore"].ToString();
objacademicjeee.ielts = row["ielts"].ToString();
objacademicjeee.ieltsscore = row["ieltsscore"].ToString();
objacademicjeee.GMAT = row["GMAT"].ToString();
objacademicjeee.GMATscore = row["GMATscore"].ToString();
objacademicjeee.TOFEL = row["TOFEL"].ToString();
objacademicjeee.TOFELscore = row["TOFELscore"].ToString();
objacademicjeee.SAT = row["SAT"].ToString();
objacademicjeee.SATscore = row["SATscore"].ToString();
objacademicjeee.experience = row["experience"].ToString();
objacademicjeee.experiencescore = row["experiencescore"].ToString();
_listJee.Add(objacademicjeee);
}
}
}
return(Json(new
{
List = _list,
ListJee = _listJee
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult SaveOtherAcademicinformation(StudentAcademic_information _obj)
{
_obj.studentid = TempData.Peek("Studentid").ToString();
_obj.Created_By = TempData.Peek("Studentid").ToString();
_obj.Created_Ip = Request.ServerVariables["REMOTE_ADDR"].ToString();
TempData.Keep("Studentid");
string path = "";
string filename = "";
string fname = "";
string GradeConversionDocument = "";
if (Request.Files.Count > 0)
{
if (Request.Files[0].ContentLength > 0)
{
//Upload the file...
HttpFileCollectionBase files = Request.Files;
path = AppDomain.CurrentDomain.BaseDirectory + "Uploads/GradeConversionDocument/" + TempData.Peek("Studentid").ToString() + "/";
filename = Path.GetFileName(Request.Files[0].FileName);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
else
{
string[] curentfiles = Directory.GetFiles(path);
}
HttpPostedFileBase file = files[0];
filename = TempData.Peek("Studentid").ToString() + "_GradeConversionDocument_" + DateTime.Now.ToString("yyyyMMddHHmmss") + Path.GetExtension(file.FileName);
fname = Path.Combine(Server.MapPath("~/Uploads/GradeConversionDocument/" + TempData.Peek("Studentid").ToString() + "/"), filename);
file.SaveAs(fname);
GradeConversionDocument = "/Uploads/GradeConversionDocument/" + TempData.Peek("Studentid").ToString() + "/" + filename;
}
else
{
GradeConversionDocument = "";
}
}
else
{
GradeConversionDocument = "";
}
_obj.GradeConversionDocument = GradeConversionDocument;
StudentRepository objRepository = new StudentRepository();
DataSet _ds = objRepository.insert_other_academicinformation(_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
));
}
