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));
}
