public List <PostJobBO> getJobsList(int iUserId) { DataSet objDataSet = null; PostJobBO objJobPostingsBO = null; List <PostJobBO> objJobPostingsBOList = new List <PostJobBO>(); List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); ProcParameterBO objDBparameter = null; try { objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iUserId"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = iUserId; objProcParameterBOList.Add(objDBparameter); objDataSet = objDBAccess.execuitDataSet(ProcGetJobsList, ref objProcParameterBOList); if (objDataSet != null && objDataSet.Tables.Count > 0) { for (int i = 0; i < objDataSet.Tables[0].Rows.Count; i++) { objJobPostingsBO = new PostJobBO(); objJobPostingsBO.JobPostingId = Convert.ToInt32(objDataSet.Tables[0].Rows[i][0].ToString()); objJobPostingsBO.JobName = objDataSet.Tables[0].Rows[i][1].ToString(); objJobPostingsBO.JobDescription = objDataSet.Tables[0].Rows[i][2].ToString(); objJobPostingsBO.JobLocation = objDataSet.Tables[0].Rows[i][3].ToString(); objJobPostingsBO.NoOfPositions = objDataSet.Tables[0].Rows[i][4].ToString(); objJobPostingsBO.Status = objDataSet.Tables[0].Rows[i][5].ToString(); objJobPostingsBO.Skills = objDataSet.Tables[0].Rows[i][6].ToString(); objJobPostingsBO.Qualification = objDataSet.Tables[0].Rows[i][7].ToString(); objJobPostingsBO.Experience = objDataSet.Tables[0].Rows[i][8].ToString(); objJobPostingsBO.DonorProgram = objDataSet.Tables[0].Rows[i][9].ToString(); objJobPostingsBOList.Add(objJobPostingsBO); } } } catch (Exception ex) { ExceptionError.Error_Log(ex, "getJobsList"); throw ex; } return(objJobPostingsBOList); }
public string SaveorUpdateJobPosting(PostJobBO objJobPostingsBO, int iUserId) { return(objJobPostingsDAL.SaveorUpdateJobPosting(objJobPostingsBO, iUserId)); }
public string SaveorUpdateJobPosting(PostJobBO objJobPostingsBO, int iUserId) { List <ProcParameterBO> objProcParameterBOList = new List <ProcParameterBO>(); ProcParameterBO objDBparameter = null; string strResult = ""; try { objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iJobPostingId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objJobPostingsBO.JobPostingId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobName"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.JobName; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobCode"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.JobCode; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobDescription"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.JobDescription; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobDescriptionFile"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.JobDescriptionFile; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobDescriptionFileSavedName"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.JobDescriptionFileSavedName; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iNoOfPositions"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.NoOfPositions; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobLocation"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.JobLocation; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobTimings"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.JobTimings; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strJobDuration"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.JobDuration; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strQualification"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.Qualification; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strExperience"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.Experience; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strSkills"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.Skills; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strStatusId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objJobPostingsBO.StatusId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@iDonorProgramId"; objDBparameter.dbType = DbType.Int32; objDBparameter.ParameterValue = objJobPostingsBO.DonorProgramId; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strComments"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.Comments; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strApproveComments"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.ApproverComments; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strRejectComments"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.RejectComments; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@strHODComments"; objDBparameter.dbType = DbType.String; objDBparameter.ParameterValue = objJobPostingsBO.HOD_Comments; objProcParameterBOList.Add(objDBparameter); objDBparameter = new ProcParameterBO(); objDBparameter.Direction = ParameterDirection.Input; objDBparameter.ParameterName = "@bIsActive"; objDBparameter.dbType = DbType.Boolean; objDBparameter.ParameterValue = objJobPostingsBO.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.Output; objDBparameter.ParameterName = "@strResult"; objDBparameter.dbType = DbType.String; objDBparameter.Size = 100; objProcParameterBOList.Add(objDBparameter); objDBAccess.executeNonQuery(ProcSaveJobPosting, 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, "SaveorUpdateJobPosting"); strResult = "FAILED"; throw ex; } return(strResult); }
public JsonResult SaveJobPosting(PostJobBO Data) { string strResult = ""; if (Request.Files.Count > 0) { string strFileName = ""; string strExtention = ""; Random objRandom = new Random(); string strRandom = objRandom.Next(10000) + ""; 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() == ".XLS") //{ // types = CommonUtils.FileType.XLS; //} if (strExtention.ToUpper() == ".PDF") { types = CommonUtils.FileType.PDF; } //else if (strExtention.ToUpper() == ".XLSX") //{ // types = CommonUtils.FileType.XLSX; //} 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 if (result) { int FileLength = 1024 * 1024 * 3; //FileLength 3 MB if (file.ContentLength > FileLength) { strResult = "Upload file should not be greater than 3MB"; } strFileName = strRandom + "_" + DateTime.UtcNow.ToString("yyyyMMddHHmmssfff", CultureInfo.InvariantCulture) + strExtention; var strFileType = file.FileName.Split(new string[] { "_" }, StringSplitOptions.RemoveEmptyEntries); Data.JobDescriptionFileSavedName = strFileName; strFileName = Path.Combine(strFileUploadPath, strFileName); file.SaveAs(strFileName); } else { strResult = "Upload Valid File"; } } } } } JobPostingBAL objJobPostingBAL = new JobPostingBAL(); Data.StatusId = 1; Data.IsActive = true; if (strResult == "") { strResult = objJobPostingBAL.SaveorUpdateJobPosting(Data, Convert.ToInt32(ViewData["LoginUserId"])); } List <string> usersList = objJobPostingBAL.getHRofficeUsersList(); string strEmailBody = ""; if (usersList.Count > 0) { strEmailBody = getEmailBody(); CommonUtils.SendEmail(strSenderEmailAddress, usersList, "New Job Approval Request", strEmailBody); } return(Json(strResult, JsonRequestBehavior.AllowGet)); }