public DataSet InstituteStudentsFacility_Select(InstituteStudentsFacility _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_Select_tbl_InstituteStudentsFacility", _cn);
_cmd.Parameters.AddWithValue("@ID", _obj.ID);
_cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID);
_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 Save_StudentFacility(InstituteStudentsFacility _obj)
{
bool flag = false;
try
{
InstituteStudentsFacilityRepository _objRepository = new InstituteStudentsFacilityRepository();
_obj.InstituteID = Session["InstituteID"].ToString();
_obj.CreatedIP = Session["localIP"].ToString();
DataSet _ds = _objRepository.InstituteStudentsFacility_Insert(_obj);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
if (_ds.Tables[0].Rows[0]["FLAG"].ToString() == "1")
{
flag = true;
}
}
}
}
catch (System.Exception)
{
throw;
}
return(Json(new
{
flag = flag
},
JsonRequestBehavior.AllowGet
));
}
public DataSet InstituteStudentsFacility_Insert(InstituteStudentsFacility _obj)
{
try
{
_cn.Open();
SqlCommand _cmd = new SqlCommand("sp_Insert_tbl_InstituteStudentsFacility", _cn);
_cmd.Parameters.AddWithValue("@ID", _obj.ID);
_cmd.Parameters.AddWithValue("@InstituteID", _obj.InstituteID);
_cmd.Parameters.AddWithValue("@HasCellOffice", _obj.HasCellOffice);
_cmd.Parameters.AddWithValue("@CellOfficeDesc", _obj.CellOfficeDesc);
_cmd.Parameters.AddWithValue("@HasVisaAssistance", _obj.HasVisaAssistance);
_cmd.Parameters.AddWithValue("@VisaAssistanceDesc", _obj.VisaAssistanceDesc);
_cmd.Parameters.AddWithValue("@OtherFacility", _obj.OtherFacility);
_cmd.Parameters.AddWithValue("@HasCulturalEngagement", _obj.HasCulturalEngagement);
_cmd.Parameters.AddWithValue("@HasStudentBoarding", _obj.HasStudentBoarding);
_cmd.Parameters.AddWithValue("@HasArrival", _obj.HasArrival);
_cmd.Parameters.AddWithValue("@HasMentor", _obj.HasMentor);
_cmd.Parameters.AddWithValue("@IntroProgram", _obj.IntroProgram);
_cmd.Parameters.AddWithValue("@ContactPersonName", _obj.ContactPersonName);
_cmd.Parameters.AddWithValue("@ContactPersonEmail", _obj.ContactPersonEmail);
_cmd.Parameters.AddWithValue("@ContactPersonMobile", _obj.ContactPersonMobile);
_cmd.Parameters.AddWithValue("@ContactPersonPhone", _obj.ContactPersonPhone);
_cmd.Parameters.AddWithValue("@CreatedIP", _obj.CreatedIP);
_cmd.Parameters.AddWithValue("@Edited_by", _obj.Edited_by);
_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_InternationalSchool(InstituteStudentsFacility obj)
{
List <InstituteStudentsFacility> _list = new List <InstituteStudentsFacility>();
obj.InstituteID = Session["InstituteID"].ToString();
InstituteStudentsFacilityRepository _objRepository = new InstituteStudentsFacilityRepository();
DataSet ds = _objRepository.InstituteStudentsFacility_Select(obj);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
InstituteStudentsFacility _objList = new InstituteStudentsFacility();
_objList.ID = row["ID"].ToString();
_objList.InstituteID = row["InstituteID"].ToString();
_objList.HasCellOffice = row["HasCellOffice"].ToString();
_objList.CellOfficeDesc = row["CellOfficeDesc"].ToString();
_objList.HasVisaAssistance = row["HasVisaAssistance"].ToString();
_objList.VisaAssistanceDesc = row["VisaAssistanceDesc"].ToString();
_objList.HasCulturalEngagement = row["HasCulturalEngagement"].ToString();
_objList.HasStudentBoarding = row["HasStudentBoarding"].ToString();
_objList.HasArrival = row["HasArrival"].ToString();
_objList.IntroProgram = row["IntroProgram"].ToString();
_objList.ContactPersonName = row["ContactPersonName"].ToString();
_objList.ContactPersonEmail = row["ContactPersonEmail"].ToString();
_objList.ContactPersonMobile = row["ContactPersonMobile"].ToString();
_objList.ContactPersonPhone = row["ContactPersonPhone"].ToString();
_list.Add(_objList);
}
}
}
return(Json(new
{
List = _list
},
JsonRequestBehavior.AllowGet
));
}
