public DataSet SELECT_tbl_Student_Ch_Choice_Filling(mStudent_Ch_Choice_Filling_Save _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("SELECT_tbl_Student_Ch_Choice_Filling", _cn);
_cmd.Parameters.AddWithValue("@studentid", _obj.studentid);
_cmd.Parameters.AddWithValue("@ApplicationNo", _obj.ApplicationNo);
_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_UPDATE_tbl_Student_Ch_Choice_Filling(mStudent_Ch_Choice_Filling_Save _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("INSERT_UPDATE_tbl_Student_Ch_Choice_Filling", _cn);
_cmd.Parameters.AddWithValue("@studentid", _obj.studentid);
_cmd.Parameters.AddWithValue("@ApplicationNo", _obj.ApplicationNo);
_cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID);
_cmd.Parameters.AddWithValue("@InstituteCourse_ID", _obj.InstituteCourse_ID);
_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("@Branch_Course_Id", _obj.Branch_Course_Id);
_cmd.Parameters.AddWithValue("@Stud_Ch_EC", _obj.Stud_Ch_EC);
_cmd.Parameters.AddWithValue("@Stud_Ch_AE", _obj.Stud_Ch_AE);
_cmd.Parameters.AddWithValue("@CreatedIP", _obj.CreatedIP);
_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 SelectStdCh()
{
mStudent_Ch_Choice_Filling_Save _obj = new mStudent_Ch_Choice_Filling_Save();
string Code = string.Empty, Message = string.Empty;
if (Session["ApplicationNo"] != null)
{
if (Session["ApplicationNo"].ToString() != "")
{
_obj.ApplicationNo = Session["ApplicationNo"].ToString();
}
}
_obj.studentid = Session["studentid"].ToString();
List <mStudent_Ch_Choice_Filling_Saved_List> _list = new List <mStudent_Ch_Choice_Filling_Saved_List>();
try
{
ChoiceFillingRepository _objRepository = new ChoiceFillingRepository();
DataSet _ds = _objRepository.SELECT_tbl_Student_Ch_Choice_Filling(_obj);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
_list.Add(new mStudent_Ch_Choice_Filling_Saved_List
{
id = _dr["ID"].ToString(),
InstituteName = _dr["InstituteName"].ToString(),
InstituteCourseName = _dr["Coursename"].ToString(),
InstituteType = _dr["InstituteType"].ToString(),
Discipline = _dr["Discipline"].ToString(),
ProgramLevel = _dr["ProgramLevel"].ToString(),
Coursename = _dr["Coursename"].ToString(),
Specialization = _dr["Specialization"].ToString(),
SequenceNumber = _dr["SequenceNumber"].ToString()
});
}
}
}
}
catch (NullReferenceException)
{
Code = "error";
Message = "Your session has been expired. Kindly refresh and try again.";
}
catch (Exception)
{
Code = "error";
Message = "Error from server side. Kindly refresh and try again.";
}
return(Json(new
{
List = _list,
c = Code,
m = Message
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult DeleteStdCh(string id = "0")
{
mStudent_Ch_Choice_Filling_Save _obj = new mStudent_Ch_Choice_Filling_Save();
string Code = string.Empty, Message = string.Empty;
if (Session["ApplicationNo"] != null)
{
if (Session["ApplicationNo"].ToString() != "")
{
_obj.ApplicationNo = Session["ApplicationNo"].ToString();
}
}
_obj.studentid = Session["studentid"].ToString();
List <mStudent_Ch_Choice_Filling_Saved_List> _list = new List <mStudent_Ch_Choice_Filling_Saved_List>();
try
{
ChoiceFillingRepository _objRepository = new ChoiceFillingRepository();
DataSet _ds = _objRepository.DELETE_tbl_Student_Ch_Choice_Filling(id, Session["ApplicationNo"].ToString(), Session["studentid"].ToString());
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
Code = "success";
Message = "Choice has been deleted successfully.";
}
}
}
catch (NullReferenceException)
{
Code = "error";
Message = "Your session has been expired. Kindly refresh and try again.";
}
catch (Exception)
{
Code = "error";
Message = "Error from server side. Kindly refresh and try again.";
}
return(Json(new
{
List = _list,
c = Code,
m = Message
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult SaveStdCh(mStudent_Ch_Choice_Filling_Save _obj)
{
string Message = string.Empty, Code = string.Empty;
try
{
ChoiceFillingRepository _objRepository = new ChoiceFillingRepository();
string localIP = "?";
localIP = Request.ServerVariables["REMOTE_ADDR"].ToString();
_obj.CreatedIP = localIP;
if (Session["ApplicationNo"] != null)
{
if (Session["ApplicationNo"].ToString() != "")
{
_obj.ApplicationNo = Session["ApplicationNo"].ToString();
}
}
_obj.studentid = Session["studentid"].ToString();
DataSet _ds = _objRepository.INSERT_UPDATE_tbl_Student_Ch_Choice_Filling(_obj);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
if (_ds.Tables[0].Rows[0]["msg"].ToString() == "Success")
{
Message = "Choice have been saved successfully!";
Code = "success";
}
else if (_ds.Tables[0].Rows[0]["msg"].ToString() == "NotEligible")
{
Message = "You are not eligible for this course!";
Code = "servererror";
}
else
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
}
}
else
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
}
}
}
catch (NullReferenceException)
{
Message = "Your session has been expired. Kindly login again.";
Code = "sessionexpired";
}
catch (Exception)
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
}
return(Json(new
{
m = Message,
c = Code
},
JsonRequestBehavior.AllowGet
));
}