public ActionResult TravelDocumentation(string id = "", string a = "", string p = "")
{
try
{
ViewBag.StudentID = id;
ViewBag.ApplicationNo = StringCipher.Decrypt(a);
ViewBag.ProgramLevel = p;
TravelPlanRepository _objRepo = new TravelPlanRepository();
DataSet _ds = _objRepo.SELECT_Student_TravelPlan_Status(ViewBag.StudentID);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
ViewBag.HasPassportDetails = _dr["HasPassportDetails"].ToString();
ViewBag.HasAirTicketDetails = _dr["HasAirTicketDetails"].ToString();
ViewBag.HasVisaDetails = _dr["HasVisaDetails"].ToString();
ViewBag.HasInstituteSpocDetails = _dr["HasInstituteSpocDetails"].ToString();
ViewBag.IsAdmittedByInstitute = _dr["IsAdmittedByInstitute"].ToString();
}
}
}
}
catch (Exception)
{
throw;
}
return(View());
}
public JsonResult SelectAirTicket()
{
string Message = string.Empty, Code = string.Empty, Error = string.Empty;
List <mTravelPlanAirTicket> _list = new List <mTravelPlanAirTicket>();
try
{
TravelPlanRepository _objRepo = new TravelPlanRepository();
DataSet _ds = _objRepo.SELECT_StudentTravelPlanAirTicket(Session["studentid"].ToString(), Session["ApplicationNo"].ToString());
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
_list.Add(new mTravelPlanAirTicket
{
ID = _dr["ID"].ToString(),
HaveBookedTicket = (_dr["HaveBookedTicket"] != null ? _dr["HaveBookedTicket"].ToString() : ""),
LandingDate = (_dr["LandingDate"] != null ? (_dr["LandingDate"].ToString() != "" ? Convert.ToDateTime(_dr["LandingDate"].ToString()).ToString("dd-MM-yyyy") : "") : ""),
LandingTime = (_dr["LandingTime"] != null ? _dr["LandingTime"].ToString() : ""),
OriginCountry = (_dr["OriginCountry"] != null ? _dr["OriginCountry"].ToString() : ""),
OriginAirport = (_dr["OriginAirport"] != null ? _dr["OriginAirport"].ToString() : ""),
DestinationCountry = (_dr["DestinationCountry"] != null ? _dr["DestinationCountry"].ToString() : ""),
DestinationAirport = (_dr["DestinationAirport"] != null ? _dr["DestinationAirport"].ToString() : ""),
OtherOriginAirport = (_dr["OtherOriginAirport"] != null ? _dr["OtherOriginAirport"].ToString() : ""),
OtherDestinationAirport = (_dr["OtherDestinationAirport"] != null ? _dr["OtherDestinationAirport"].ToString() : ""),
ETicket = (_dr["ETicket"] != null ? _dr["ETicket"].ToString() : "")
});
}
Message = "Data filled.";
Code = "success";
}
}
}
catch (NullReferenceException ex)
{
Message = "Your session has been expired. Kindly login again.";
Code = "sessionexpired";
Error = ex.Message;
}
catch (Exception ex)
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
Error = ex.Message;
}
return(Json(new
{
m = Message,
c = Code,
e = Error,
List = _list
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult SelectPassport()
{
string Message = string.Empty, Code = string.Empty, Error = string.Empty;
List <mTravelPlanPassport> _list = new List <mTravelPlanPassport>();
try
{
TravelPlanRepository _objRepo = new TravelPlanRepository();
DataSet _ds = _objRepo.SELECT_StudentTravelPlanPassport(Session["studentid"].ToString(), Session["ApplicationNo"].ToString());
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
_list.Add(new mTravelPlanPassport
{
ID = _dr["ID"].ToString(),
HaveValidPassport = (_dr["HaveValidPassport"] != null ? _dr["HaveValidPassport"].ToString() : ""),
PassportNumber = (_dr["PassportNumber"] != null ? _dr["PassportNumber"].ToString() : ""),
PassportExpiryDate = (_dr["PassportExpiryDate"] != null ? (_dr["PassportExpiryDate"].ToString() != "" ? Convert.ToDateTime(_dr["PassportExpiryDate"].ToString()).ToString("dd-MM-yyyy") : "") : ""),
PassportDocument = (_dr["PassportDocument"] != null ? _dr["PassportDocument"].ToString() : ""),
ApplicationNumber = (_dr["ApplicationNumber"] != null ? _dr["ApplicationNumber"].ToString() : ""),
ApplicationDocument = (_dr["ApplicationDocument"] != null ? _dr["ApplicationDocument"].ToString() : ""),
CitizenshipNumber = (_dr["CitizenshipNumber"] != null ? _dr["CitizenshipNumber"].ToString() : ""),
CitizenshipIssueDate = (_dr["CitizenshipIssueDate"] != null ? (_dr["CitizenshipIssueDate"].ToString() != "" ? Convert.ToDateTime(_dr["CitizenshipIssueDate"].ToString()).ToString("dd-MM-yyyy") : "") : ""),
CitizenshipDocument = (_dr["CitizenshipDocument"] != null ? _dr["CitizenshipDocument"].ToString() : "")
});
}
Message = "Data filled.";
Code = "success";
}
}
}
catch (NullReferenceException ex)
{
Message = "Your session has been expired. Kindly login again.";
Code = "sessionexpired";
Error = ex.Message;
}
catch (Exception ex)
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
Error = ex.Message;
}
return(Json(new
{
m = Message,
c = Code,
e = Error,
List = _list
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult SaveInstituteSpoc(mTravelPlanInstituteSpoc _obj)
{
string Message = string.Empty, Code = string.Empty, Error = string.Empty;
try
{
_obj.InstituteID = Session["InstituteID"].ToString();
_obj.CreatedIP = Session["localIP"].ToString();
TravelPlanRepository _objRepo = new TravelPlanRepository();
DataSet _ds = _objRepo.INSERT_UPDATE_StudentTravelInstituteSpoc(_obj);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
if (_ds.Tables[0].Rows[0]["COUNTS"].ToString() == "1")
{
Message = "Details has been saved successfully!";
Code = "success";
}
}
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 ex)
{
Message = "Your session has been expired. Kindly login again.";
Code = "sessionexpired";
Error = ex.Message;
}
catch (Exception ex)
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
Error = ex.Message;
}
return(Json(new
{
m = Message,
c = Code,
e = Error
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult SeletAirports(string Country_id = "0")
{
string Message = string.Empty, Code = string.Empty, Error = string.Empty;
List <mTravelPlanAirports> _list = new List <mTravelPlanAirports>();
try
{
TravelPlanRepository _objRepo = new TravelPlanRepository();
DataSet _ds = _objRepo.SELECT_COUNTRY_WISE_AIRPORTS(Country_id);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
_list.Add(new mTravelPlanAirports
{
ID = _dr["ID"].ToString(),
name = (_dr["name"] != null ? _dr["name"].ToString() : ""),
Country = (_dr["Country"] != null ? _dr["Country"].ToString() : ""),
Region = (_dr["Region"] != null ? _dr["Region"].ToString() : ""),
iso_country = (_dr["iso_country"] != null ? _dr["iso_country"].ToString() : ""),
});
}
Message = "Data filled.";
Code = "success";
}
}
}
catch (NullReferenceException ex)
{
Message = "Your session has been expired. Kindly login again.";
Code = "sessionexpired";
Error = ex.Message;
}
catch (Exception ex)
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
Error = ex.Message;
}
return(Json(new
{
m = Message,
c = Code,
e = Error,
List = _list
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult DeleteInstituteSpoc(string id, string ProgramLevel = "")
{
string Message = string.Empty, Code = string.Empty, Error = string.Empty;
List <mTravelPlanInstituteSpoc> _list = new List <mTravelPlanInstituteSpoc>();
try
{
TravelPlanRepository _objRepo = new TravelPlanRepository();
DataSet _ds = _objRepo.DELETE_StudentTravelInstituteSpoc(id, Session["InstituteID"].ToString(), ProgramLevel);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
Message = "Details has been deleted successfully!";
Code = "success";
}
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 ex)
{
Message = "Your session has been expired. Kindly login again.";
Code = "sessionexpired";
Error = ex.Message;
}
catch (Exception ex)
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
Error = ex.Message;
}
return(Json(new
{
m = Message,
c = Code,
e = Error,
List = _list
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult StudentAdmitted(string StudentID = "", string ProgramLevel = "", string Admitted = "")
{
string Code = string.Empty, Message = string.Empty, Error = string.Empty;
try
{
TravelPlanRepository _objRepo = new TravelPlanRepository();
DataSet _ds = _objRepo.STUDENT_ADMITTED_BY_INSTITUTE(StudentID, Session["InstituteID"].ToString(), ProgramLevel, Admitted);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
Message = "Student [" + StudentID + "] has " + (Admitted == "1" ? "completed on-board" : "dropped out") + " successfully!";
Code = "success";
}
else
{
Message = "Error from server side. Kindly refresh the page and try again.!";
Code = "servererror";
}
}
}
catch (NullReferenceException ex)
{
Code = "error";
Message = "Your session has been expired. Kindly refresh and try again.";
Error = ex.Message;
}
catch (Exception ex)
{
Code = "error";
Message = "Error from server side. Kindly refresh and try again.";
Error = ex.Message;
}
return(Json(new
{
c = Code,
m = Message,
e = Error
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult SavePassport(mTravelPlanPassport _obj)
{
string path = "";
string folderPath = "";
string Message = string.Empty, Code = string.Empty, Error = string.Empty;
try
{
string filename = "";
string fname = "";
if (Request.Files.Count > 0)
{
if (Request.Files[0].ContentLength > 0)
{
HttpFileCollectionBase files = Request.Files;
folderPath = "Uploads/studentDocument/TravelPlan/" + Session["studentid"].ToString() + "/";
path = AppDomain.CurrentDomain.BaseDirectory + folderPath;
filename = Path.GetFileName(Request.Files[0].FileName);
HttpPostedFileBase file = files[0];
filename = Session["ApplicationNo"].ToString() + "_Passport_" + DateTime.Now.ToString("yyyyMMddhhmmss") + Path.GetExtension(file.FileName);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
else
{
string[] curentfiles = Directory.GetFiles(path);
foreach (string curentfile in curentfiles)
{
if (curentfile.IndexOf(filename) >= 0)
{
#pragma warning disable SCS0018 // Path traversal: injection possible in {1} argument passed to '{0}'
System.IO.File.Delete(path: curentfile);
#pragma warning restore SCS0018 // Path traversal: injection possible in {1} argument passed to '{0}'
}
}
}
fname = Path.Combine(Server.MapPath("~/" + folderPath), filename);
file.SaveAs(fname);
if (_obj.HaveValidPassport == "Yes, I have")
{
_obj.PassportDocument = folderPath + filename;
}
else if (_obj.HaveValidPassport == "Applied for a passport")
{
_obj.ApplicationDocument = folderPath + filename;
}
else if (_obj.HaveValidPassport == "I have Nepalese citizenship document")
{
_obj.CitizenshipDocument = folderPath + filename;
}
}
}
_obj.CreatedIP = Session["localIP"].ToString();
_obj.StudentID = Session["StudentID"].ToString();
_obj.ApplicationNo = Session["ApplicationNo"].ToString();
TravelPlanRepository _objRepository = new TravelPlanRepository();
DataSet _ds = _objRepository.INSERT_UPDATE_StudentTravelPlanPassport(_obj);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
Message = "Details saved successfully!";
Code = "success";
Session["HasPassportDetails"] = "True";
}
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 ex)
{
Message = "Your session has been expired. Kindly login again.";
Code = "sessionexpired";
Error = ex.Message;
}
catch (Exception ex)
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
Error = ex.Message;
}
return(Json(new
{
m = Message,
c = Code,
e = Error
},
JsonRequestBehavior.AllowGet
));
}
public JsonResult SelectInstituteSpoc(string id, string ProgramLevel = "")
{
string Message = string.Empty, Code = string.Empty, Error = string.Empty;
List <mTravelPlanInstituteSpoc> _list = new List <mTravelPlanInstituteSpoc>();
try
{
TravelPlanRepository _objRepo = new TravelPlanRepository();
DataSet _ds = _objRepo.SELECT_StudentTravelInstituteSpoc(id, Session["InstituteID"].ToString(), ProgramLevel);
if (_ds != null)
{
if (_ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow _dr in _ds.Tables[0].Rows)
{
_list.Add(new mTravelPlanInstituteSpoc
{
ID = _dr["ID"].ToString(),
NameOfSpoc = _dr["NameOfSpoc"].ToString(),
StudentIDs = _dr["StudentIDs"].ToString(),
Mobile = _dr["Mobile"].ToString(),
Email = _dr["Email"].ToString(),
DocumentName1 = _dr["DocumentName1"].ToString(),
OtherDocumentName1 = _dr["OtherDocumentName1"].ToString(),
DoumentPath1 = _dr["DoumentPath1"].ToString(),
DocumentName2 = _dr["DocumentName2"].ToString(),
OtherDocumentName2 = _dr["OtherDocumentName2"].ToString(),
DoumentPath2 = _dr["DoumentPath2"].ToString(),
DocumentName3 = _dr["DocumentName3"].ToString(),
OtherDocumentName3 = _dr["OtherDocumentName3"].ToString(),
DoumentPath3 = _dr["DoumentPath3"].ToString(),
DocumentName4 = _dr["DocumentName4"].ToString(),
OtherDocumentName4 = _dr["OtherDocumentName4"].ToString(),
DoumentPath4 = _dr["DoumentPath4"].ToString(),
DocumentName5 = _dr["DocumentName5"].ToString(),
OtherDocumentName5 = _dr["OtherDocumentName5"].ToString(),
DoumentPath5 = _dr["DoumentPath5"].ToString()
});
}
Message = "Details has been saved successfully!";
Code = "success";
}
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 ex)
{
Message = "Your session has been expired. Kindly login again.";
Code = "sessionexpired";
Error = ex.Message;
}
catch (Exception ex)
{
Message = "Error from server side. Kindly refresh the page and try again.";
Code = "servererror";
Error = ex.Message;
}
return(Json(new
{
m = Message,
c = Code,
e = Error,
List = _list
},
JsonRequestBehavior.AllowGet
));
}
