// GET: UpdateProfile
public ActionResult Index()
{
ViewBag.MainTitle = "Applicant Registration";
ViewBag.Title = "Applicant";
ViewBag.Icon = "fa fa-user";
UpdateProfileBAL objUpdateProfileBAL = new UpdateProfileBAL();
ApplicantRegistrationBO objApplicantRegistrationBO = new ApplicantRegistrationBO();
objApplicantRegistrationBO = objUpdateProfileBAL.GetApplicantDetails(Convert.ToInt32(ViewData["EmployeeId"]));
if (objApplicantRegistrationBO != null)
{
objApplicantRegistrationBO.CountriesList = objUpdateProfileBAL.CountryList();
objApplicantRegistrationBO.TitleList = objUpdateProfileBAL.TitleList();
objApplicantRegistrationBO.GenderList = objUpdateProfileBAL.GenderList();
objApplicantRegistrationBO.RefererList = objUpdateProfileBAL.RefererList();
objApplicantRegistrationBO.IdTypeList = objUpdateProfileBAL.IdTypeList();
objApplicantRegistrationBO.AcademicQualificationsList = objUpdateProfileBAL.AcademicQualificationsList();
objApplicantRegistrationBO.TypeOfIndustryList = objUpdateProfileBAL.TypeOfIndustryList();
}
if (objApplicantRegistrationBO.PhotoSavedName == "" || objApplicantRegistrationBO.PhotoSavedName == null)
{
ViewBag.ImagePath = Url.Content("../assets/images/user-1.png");
}
else
{
ViewBag.ImagePath = Url.Content(strViewUploadPhotoPath + objApplicantRegistrationBO.PhotoSavedName);
}
return(View(objApplicantRegistrationBO));
}
public ActionResult ViewApplicantRegistration(int iApplicantId)
{
ApplicantRegistrationBAL objApplicantRegistrationBAL = new ApplicantRegistrationBAL();
ApplicantRegistrationBO objApplicantRegistrationBO = objApplicantRegistrationBAL.ViewApplicant(iApplicantId);
return(PartialView("ViewApplicantRegistration", objApplicantRegistrationBO));
}
public List <ApplicantRegistrationBO> getApplicantsList()
{
DataSet objDataSet = null;
ApplicantRegistrationBO objApplicantRegistrationBO = null;
List <ApplicantRegistrationBO> objApplicantRegistrationBOList = new List <ApplicantRegistrationBO>();
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
try
{
objDataSet = objDBAccess.execuitDataSet(ProcGetApplicantList, ref objProcParameterBOList);
if (objDataSet != null && objDataSet.Tables.Count > 0)
{
for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++)
{
objApplicantRegistrationBO = new ApplicantRegistrationBO();
objApplicantRegistrationBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString());
objApplicantRegistrationBO.FirstName = objDataSet.Tables[0].Rows[i][1].ToString();
objApplicantRegistrationBO.EmailAddress = objDataSet.Tables[0].Rows[i][2].ToString();
objApplicantRegistrationBO.PhoneNumber = objDataSet.Tables[0].Rows[i][3].ToString();
objApplicantRegistrationBO.Address = objDataSet.Tables[0].Rows[i][4].ToString();
objApplicantRegistrationBOList.Add(objApplicantRegistrationBO);
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "getApplicantsList");
throw ex;
}
return(objApplicantRegistrationBOList);
}
public ActionResult Index()
{
ViewBag.MainTitle = "Applicant Registration";
ViewBag.Title = "Applicant";
ViewBag.Icon = "fa fa-user";
ApplicantRegistrationBAL objApplicantRegistrationBAL = new ApplicantRegistrationBAL();
ApplicantRegistrationBO objApplicantRegistrationBO = new ApplicantRegistrationBO();
return(View(objApplicantRegistrationBO));
}
public ActionResult CreateApplicant()
{
ViewBag.MainTitle = "Applicant Registration";
ViewBag.Title = "Applicant";
ViewBag.Icon = "fa fa-user";
ApplicantRegistrationBO objApplicantRegistrationBO = new ApplicantRegistrationBO();
ApplicantRegistrationBAL objApplicantRegistrationBAL = new ApplicantRegistrationBAL();
objApplicantRegistrationBO.CountriesList = objApplicantRegistrationBAL.CountryList();
objApplicantRegistrationBO.TitleList = objApplicantRegistrationBAL.TitleList();
objApplicantRegistrationBO.GenderList = objApplicantRegistrationBAL.GenderList();
objApplicantRegistrationBO.RefererList = objApplicantRegistrationBAL.RefererList();
return(View("AddApplicant", objApplicantRegistrationBO));
}
public ActionResult EditApplicant(int iApplicantId)
{
ViewBag.MainTitle = "Applicant Registration";
ViewBag.Title = "Applicant";
ViewBag.Icon = "fa fa-user";
ApplicantRegistrationBAL objApplicantRegistrationBAL = new ApplicantRegistrationBAL();
ApplicantRegistrationBO objApplicantRegistrationBO = objApplicantRegistrationBAL.EditApplicantDetails(iApplicantId);
objApplicantRegistrationBO.CountriesList = objApplicantRegistrationBAL.CountryList();
objApplicantRegistrationBO.TitleList = objApplicantRegistrationBAL.TitleList();
objApplicantRegistrationBO.GenderList = objApplicantRegistrationBAL.GenderList();
objApplicantRegistrationBO.RefererList = objApplicantRegistrationBAL.RefererList();
return(PartialView("EditApplicantRegistration", objApplicantRegistrationBO));
}
public ActionResult Index()
{
ViewBag.MainTitle = "Applicant Registration";
ViewBag.Title = "Applicant";
ViewBag.Icon = "fa fa-user";
ApplicantRegistrationBO objApplicantRegistrationBO = new ApplicantRegistrationBO();
ApplicantRegistrationBAL objApplicantRegistrationBAL = new ApplicantRegistrationBAL();
objApplicantRegistrationBO.CountriesList = objApplicantRegistrationBAL.CountryList();
objApplicantRegistrationBO.TitleList = objApplicantRegistrationBAL.TitleList();
objApplicantRegistrationBO.GenderList = objApplicantRegistrationBAL.GenderList();
objApplicantRegistrationBO.RefererList = objApplicantRegistrationBAL.RefererList();
objApplicantRegistrationBO.IdTypeList = objApplicantRegistrationBAL.IdTypeList();
// @ViewBag.ImagePath = Url.Content("../assets/images/user-1.png");
if (objApplicantRegistrationBO.PhotoSavedName == "" || objApplicantRegistrationBO.PhotoSavedName == null)
{
ViewBag.ImagePath = Url.Content("../assets/images/user-1.png");
}
else
{
ViewBag.ImagePath = Url.Content(strViewUploadPhotoPath + objApplicantRegistrationBO.PhotoSavedName);
}
return(View(objApplicantRegistrationBO));
}
public JsonResult SaveApplicantRegistration(ApplicantRegistrationBO Data)
{
string strResult = "";
if (Request.Files.Count > 0)
{
string strFileName = "";
string strExtention = "";
Random objRandom = new Random();
string strRandom = objRandom.Next(10000) + "";
string strFileUploadPath = "";
string fileName = "";
string fileContentType = "";
byte[] tempFileBytes = null;
dynamic data = null;
dynamic types = null;
bool result = false;
HttpFileCollectionBase files = Request.Files;
if (files != null)
{
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
if (file.ContentLength == 0)
{
strResult = "Upload file should not be empty";
}
else if (file.ContentLength > 0)
{
strExtention = Path.GetExtension(file.FileName);
fileName = file.FileName; // getting File Name
fileContentType = file.ContentType; // getting ContentType
tempFileBytes = new byte[file.ContentLength]; // getting filebytes
data = file.InputStream.Read(tempFileBytes, 0, Convert.ToInt32(file.ContentLength));
types = CommonUtils.FileType.Image; // Setting Image type
if (strExtention.ToUpper() == ".PDF")
{
types = CommonUtils.FileType.PDF;
}
else if (strExtention.ToUpper() == ".DOC")
{
types = CommonUtils.FileType.DOC;
}
else if (strExtention.ToUpper() == ".DOCX")
{
types = CommonUtils.FileType.DOCX;
}
result = CommonUtils.isValidFile(tempFileBytes, types, fileContentType); // Validate Header
strFileName = strRandom + "_" + DateTime.UtcNow.ToString("yyyyMMddHHmmssfff", CultureInfo.InvariantCulture) + strExtention;
var strFileType = file.FileName.Split(new string[] { "_" }, StringSplitOptions.RemoveEmptyEntries);
if (result)
{
int FileLength = 1024 * 1024 * 3; //FileLength 3 MB
if (file.ContentLength > FileLength)
{
strResult = "Upload file should not be greater than 3MB";
}
if (strFileType[0] == "PHOTO")
{
Data.PhotoSavedName = strFileName;
strFileUploadPath = strPhotoUploadPath;
}
if (strFileType[0] == "RESUME")
{
Data.CVSavedName = strFileName;
strFileUploadPath = strCVSavedUploadPath;
}
if (strFileType[0] == "IDCOPY")
{
Data.CitizenShipIdCopySavedName = strFileName;
strFileUploadPath = strCitizenShipIdCopyUploadPath;
}
if (strFileType[0] == "APPLICATIONLETTER")
{
Data.ApplicationLetterSavedName = strFileName;
strFileUploadPath = strApplicationLetterUploadPath;
}
//if (strFileType[0] == "BACHELORS")
//{
// Data.BachelorsSavedName = strFileName;
// strFileUploadPath = strBachelorsUploadPath;
//}
//if (strFileType[0] == "DIPLOMA")
//{
// Data.DiplomaSavedName = strFileName;
// strFileUploadPath = strDiplomaUploadPath;
//}
//if (strFileType[0] == "MSC")
//{
// Data.MSCSavedName = strFileName;
// strFileUploadPath = strMSCUploadPath;
//}
//if (strFileType[0] == "PHD")
//{
// Data.PHDSavedName = strFileName;
// strFileUploadPath = strPHDUploadPath;
//}
strFileName = Path.Combine(strFileUploadPath, strFileName);
file.SaveAs(strFileName);
}
else
{
strResult = strResult + "Please Upload Valid file for " + strFileType[0] + "</br>";
}
}
}
}
}
ApplicantRegistrationBAL objApplicantRegistrationBAL = new ApplicantRegistrationBAL();
Data.IsActive = true;
string strReturnPassword = "";
string strEmailBody = "";
if (Data.EmailAddress != "")
{
strEmailBody = getEmailBody((Data.FirstName + Data.LastName), Data.EmailAddress, ref strReturnPassword);
}
if (strResult == "")
{
strResult = objApplicantRegistrationBAL.SaveorUpdateApplicantRegistration(Data, strReturnPassword, 1);
if (strResult == "SUCCESS" && Data.EmailAddress != "")
{
strResult = CommonUtils.SendEmail(strSenderEmailAddress, Data.EmailAddress, strEmailSubject, strEmailBody);
}
}
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveApplicantRegistration(ApplicantRegistrationBO Data)
{
if (Request.Files.Count > 0)
{
string strFileName = "";
string strExtention = "";
Random objRandom = new Random();
string strRandom = objRandom.Next(1000000) + "";
string strFileUploadPath = "";
HttpFileCollectionBase files = Request.Files;
for (int i = 0; i < files.Count; i++)
{
HttpPostedFileBase file = files[i];
strExtention = Path.GetExtension(file.FileName);
strFileName = strRandom + DateTime.UtcNow.ToString("yyyyMMddHHmmssfff", CultureInfo.InvariantCulture) + strExtention;
var strFileType = file.FileName.Split(new string[] { "_" }, StringSplitOptions.RemoveEmptyEntries);
if (strFileType[0] == "PHOTO")
{
Data.PhotoSavedName = strFileName;
strFileUploadPath = strPhotoUploadPath;
}
if (strFileType[0] == "RESUME")
{
Data.ResumSavedName = strFileName;
strFileUploadPath = strCVSavedUploadPath;
}
if (strFileType[0] == "CITIZENSHIPIDCOPY")
{
Data.CitizenShipIdCopySavedName = strFileName;
strFileUploadPath = strCitizenShipIdCopyUploadPath;
}
if (strFileType[0] == "APPLICATIONLETTER")
{
Data.ApplicationLetterSavedName = strFileName;
strFileUploadPath = strApplicationLetterUploadPath;
}
if (strFileType[0] == "BACHELORS")
{
Data.BachelorsSavedName = strFileName;
strFileUploadPath = strBachelorsUploadPath;
}
if (strFileType[0] == "DIPLOMA")
{
Data.DiplomaSavedName = strFileName;
strFileUploadPath = strDiplomaUploadPath;
}
if (strFileType[0] == "MSC")
{
Data.MSCSavedName = strFileName;
strFileUploadPath = strMSCUploadPath;
}
if (strFileType[0] == "PHD")
{
Data.PHDSavedName = strFileName;
strFileUploadPath = strPHDUploadPath;
}
strFileName = Path.Combine(strFileUploadPath, strFileName);
file.SaveAs(strFileName);
}
}
ApplicantRegistrationBAL objApplicantRegistrationBAL = new ApplicantRegistrationBAL();
Data.IsActive = true;
string strResult = "";
string strReturnPassword = "";
string strEmailBody = "";
if (Data.EmailAddress != "")
{
strEmailBody = getEmailBody((Data.FirstName + Data.LastName), Data.EmailAddress, ref strReturnPassword);
}
strResult = objApplicantRegistrationBAL.SaveorUpdateApplicantRegistration(Data, strReturnPassword, 1);
if (strResult == "SUCCESS" && Data.EmailAddress != "")
{
strResult = CommonUtils.SendEmail(strSenderEmailAddress, Data.EmailAddress, strEmailSubject, strEmailBody);
}
return(Json(strResult, JsonRequestBehavior.AllowGet));
}
public string SaveorUpdateApplicantRegistration(ApplicantRegistrationBO objApplicantRegistrationBO, string strPassword, int iUserId)
{
return(objApplicantRegistrationDAL.SaveorUpdateApplicantRegistration(objApplicantRegistrationBO, strPassword, iUserId));
}
public ApplicantRegistrationBO ViewApplicant(int iApplicantId)
{
DataSet objDataSet = null;
ApplicantRegistrationBO objApplicantRegistrationBO = null;
List <ProcParameterBO> ObjProcParameterBOList = new List <ProcParameterBO>();
try
{
ProcParameterBO objDbParameter = new ProcParameterBO();
objDbParameter.Direction = ParameterDirection.Input;
objDbParameter.ParameterName = "@iApplicantId";
objDbParameter.dbType = DbType.Int32;
objDbParameter.ParameterValue = iApplicantId;
ObjProcParameterBOList.Add(objDbParameter);
objDataSet = objDBAccess.execuitDataSet(ProcViewApplicant, ref ObjProcParameterBOList);
if (objDataSet != null && objDataSet.Tables[0].Rows.Count > 0)
{
objApplicantRegistrationBO = new ApplicantRegistrationBO();
objApplicantRegistrationBO.ApplicantId = Convert.ToInt32(objDataSet.Tables[0].Rows[0][0].ToString());
objApplicantRegistrationBO.Title = objDataSet.Tables[0].Rows[0][1].ToString();
objApplicantRegistrationBO.FirstName = objDataSet.Tables[0].Rows[0][2].ToString();
objApplicantRegistrationBO.MiddleName = objDataSet.Tables[0].Rows[0][3].ToString();
objApplicantRegistrationBO.LastName = objDataSet.Tables[0].Rows[0][4].ToString();
objApplicantRegistrationBO.DateOfBirth = objDataSet.Tables[0].Rows[0][5].ToString();
objApplicantRegistrationBO.Gender = objDataSet.Tables[0].Rows[0][6].ToString();
objApplicantRegistrationBO.Citizenship = objDataSet.Tables[0].Rows[0][7].ToString();
objApplicantRegistrationBO.CitizenShipIdCopy = objDataSet.Tables[0].Rows[0][8].ToString();
objApplicantRegistrationBO.CitizenShipIdCopySavedName = objDataSet.Tables[0].Rows[0][9].ToString();
objApplicantRegistrationBO.Country = objDataSet.Tables[0].Rows[0][10].ToString();
objApplicantRegistrationBO.EmailAddress = objDataSet.Tables[0].Rows[0][11].ToString();
objApplicantRegistrationBO.PhoneNumber = objDataSet.Tables[0].Rows[0][12].ToString();
objApplicantRegistrationBO.AlternativePhoneNumber = objDataSet.Tables[0].Rows[0][13].ToString();
objApplicantRegistrationBO.English = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][14].ToString());
objApplicantRegistrationBO.Kiswahili = Convert.ToBoolean(objDataSet.Tables[0].Rows[0][15].ToString());
objApplicantRegistrationBO.MotherTongue = objDataSet.Tables[0].Rows[0][16].ToString();
objApplicantRegistrationBO.OtherLanguages = objDataSet.Tables[0].Rows[0][17].ToString();
objApplicantRegistrationBO.Nationality = objDataSet.Tables[0].Rows[0][18].ToString();
objApplicantRegistrationBO.ApplicationLetter = objDataSet.Tables[0].Rows[0][19].ToString();
objApplicantRegistrationBO.ApplicationLetterSavedName = objDataSet.Tables[0].Rows[0][20].ToString();
objApplicantRegistrationBO.CV = objDataSet.Tables[0].Rows[0][21].ToString();
objApplicantRegistrationBO.CVSavedName = objDataSet.Tables[0].Rows[0][22].ToString();
objApplicantRegistrationBO.Address = objDataSet.Tables[0].Rows[0][23].ToString();
objApplicantRegistrationBO.Photo = objDataSet.Tables[0].Rows[0][24].ToString();
objApplicantRegistrationBO.PhotoSavedName = objDataSet.Tables[0].Rows[0][25].ToString();
objApplicantRegistrationBO.Bachelors = objDataSet.Tables[0].Rows[0][26].ToString();
objApplicantRegistrationBO.BachelorsSavedName = objDataSet.Tables[0].Rows[0][27].ToString();
objApplicantRegistrationBO.Diploma = objDataSet.Tables[0].Rows[0][28].ToString();
objApplicantRegistrationBO.DiplomaSavedName = objDataSet.Tables[0].Rows[0][29].ToString();
objApplicantRegistrationBO.MSC = objDataSet.Tables[0].Rows[0][30].ToString();
objApplicantRegistrationBO.MSCSavedName = objDataSet.Tables[0].Rows[0][31].ToString();
objApplicantRegistrationBO.PHD = objDataSet.Tables[0].Rows[0][32].ToString();
objApplicantRegistrationBO.PHDSavedName = objDataSet.Tables[0].Rows[0][33].ToString();
objApplicantRegistrationBO.QuaStartDate = objDataSet.Tables[0].Rows[0][34].ToString();
objApplicantRegistrationBO.QuaEndDate = objDataSet.Tables[0].Rows[0][35].ToString();
objApplicantRegistrationBO.Discipline = objDataSet.Tables[0].Rows[0][36].ToString();
objApplicantRegistrationBO.University = objDataSet.Tables[0].Rows[0][37].ToString();
objApplicantRegistrationBO.QuaNationality = objDataSet.Tables[0].Rows[0][38].ToString();
objApplicantRegistrationBO.Degree = objDataSet.Tables[0].Rows[0][39].ToString();
objApplicantRegistrationBO.Class = objDataSet.Tables[0].Rows[0][40].ToString();
objApplicantRegistrationBO.EmployerName = objDataSet.Tables[0].Rows[0][41].ToString();
objApplicantRegistrationBO.TypeOfIndustry = objDataSet.Tables[0].Rows[0][42].ToString();
objApplicantRegistrationBO.TelephoneNo = objDataSet.Tables[0].Rows[0][43].ToString();
objApplicantRegistrationBO.TitleOfSupervisor = objDataSet.Tables[0].Rows[0][44].ToString();
objApplicantRegistrationBO.JobTitle = objDataSet.Tables[0].Rows[0][45].ToString();
objApplicantRegistrationBO.City = objDataSet.Tables[0].Rows[0][46].ToString();
objApplicantRegistrationBO.EmpStartDate = objDataSet.Tables[0].Rows[0][47].ToString();
objApplicantRegistrationBO.EmpEndDate = objDataSet.Tables[0].Rows[0][48].ToString();
objApplicantRegistrationBO.Responsibility = objDataSet.Tables[0].Rows[0][49].ToString();
objApplicantRegistrationBO.MonthlySalary = objDataSet.Tables[0].Rows[0][50].ToString();
objApplicantRegistrationBO.NoticePeriod = objDataSet.Tables[0].Rows[0][51].ToString();
objApplicantRegistrationBO.EmpAddress = objDataSet.Tables[0].Rows[0][52].ToString();
objApplicantRegistrationBO.EmpFirstName = objDataSet.Tables[0].Rows[0][53].ToString();
objApplicantRegistrationBO.SecondName = objDataSet.Tables[0].Rows[0][54].ToString();
objApplicantRegistrationBO.Position = objDataSet.Tables[0].Rows[0][55].ToString();
objApplicantRegistrationBO.RelationshipTOApplicant = objDataSet.Tables[0].Rows[0][56].ToString();
objApplicantRegistrationBO.NameOfTheOrganization = objDataSet.Tables[0].Rows[0][57].ToString();
objApplicantRegistrationBO.TelephoneContact = objDataSet.Tables[0].Rows[0][58].ToString();
objApplicantRegistrationBO.EmpEmailAddress = objDataSet.Tables[0].Rows[0][59].ToString();
objApplicantRegistrationBO.JobDescription = objDataSet.Tables[0].Rows[0][60].ToString();
objApplicantRegistrationBO.Referer = objDataSet.Tables[0].Rows[0][61].ToString();
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "ViewApplicant");
throw ex;
}
return(objApplicantRegistrationBO);;
}
public string SaveorUpdateApplicantRegistration(ApplicantRegistrationBO objApplicantRegistrationBO, string strPassword, int iUserId)
{
List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>();
ProcParameterBO objDBparameter = null;
string strResult = "";
try
{
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strPassword";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = strPassword;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iApplicantId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objApplicantRegistrationBO.ApplicantId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iTitleId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objApplicantRegistrationBO.TitleId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strFirstName";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.FirstName;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strMiddleName";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.MiddleName;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strLastName";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.LastName;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strDateOfBirth";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.DateOfBirth;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iGender";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objApplicantRegistrationBO.GenderId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iCitizenship";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objApplicantRegistrationBO.IdTypeMasterId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strCitizenShipIdCopy";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.CitizenShipIdCopy;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strCitizenShipIdCopySavedName";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.CitizenShipIdCopySavedName;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iCountry";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objApplicantRegistrationBO.CountryId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strEmailAddress";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.EmailAddress;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strPhoneNumber";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.PhoneNumber;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strAlternativePhoneNumber";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.AlternativePhoneNumber;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strMotherTongue";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.MotherTongue;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strNationality";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.Nationality;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strApplicationLetter";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.ApplicationLetter;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strSaveApplicationLetter";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.ApplicationLetterSavedName;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strCV";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.CV;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strCVSavedName";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.CVSavedName;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iSpecialNeed";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = objApplicantRegistrationBO.SpecialNeed;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strAddress";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.Address;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strSpecialNeedDetails";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.SpecialNeedDetails;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strPhoto";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.Photo;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strPhotoSavedName";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.PhotoSavedName;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strCounty";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = objApplicantRegistrationBO.County;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@bIsActive";
objDBparameter.dbType = DbType.Boolean;
objDBparameter.ParameterValue = objApplicantRegistrationBO.IsActive;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@iUserId";
objDBparameter.dbType = DbType.Int32;
objDBparameter.ParameterValue = iUserId;
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Input;
objDBparameter.ParameterName = "@strType";
objDBparameter.dbType = DbType.String;
objDBparameter.ParameterValue = "Create";
objProcParameterBOList.Add(objDBparameter);
objDBparameter = new ProcParameterBO();
objDBparameter.Direction = ParameterDirection.Output;
objDBparameter.ParameterName = "@strResult";
objDBparameter.dbType = DbType.String;
objDBparameter.Size = 100;
objProcParameterBOList.Add(objDBparameter);
objDBAccess.executeNonQuery(ProcSaveApplicantRegistration, ref objProcParameterBOList);
for (int i = 0; i < objProcParameterBOList.Count; i++)
{
if (objProcParameterBOList[i].Direction == ParameterDirection.Output)
{
strResult = objProcParameterBOList[i].ParameterValue.ToString();
}
}
}
catch (Exception ex)
{
ExceptionError.Error_Log(ex, "SaveorUpdateApplicantRegistration");
strResult = "FAILED";
throw ex;
}
return(strResult);
}
