public static DataTable GetEmployeeSearchResults(ArrayList Gender,
ArrayList AgeRange,
ArrayList MaritalStates,
ArrayList MilitaryStates,
int DriverLicenceTypes,
bool Handicapped,
bool Convicted,
bool MartyrRelative,
bool TerrorAggrieved,
ArrayList Countries,
ArrayList TurkeyCities,
ArrayList EducationLevels,
ArrayList EducationStates,
ArrayList HighSchoolEducationLevels,
int HighSchoolTypes,
ArrayList UniversityEducationLevels,
int UniversityNames,
int DepartmentNames,
ArrayList Sectors,
ArrayList Positions,
ArrayList Experience,
ArrayList LabouringTypes,
int ForeignLanguages1,
int ForeignLanguages1Reading,
int ForeignLanguages1Writing,
int ForeignLanguages1Speaking,
int ForeignLanguages2,
int ForeignLanguages2Reading,
int ForeignLanguages2Writing,
int ForeignLanguages2Speaking,
int ForeignLanguages3,
int ForeignLanguages3Reading,
int ForeignLanguages3Writing,
int ForeignLanguages3Speaking,
ArrayList ComputerKnowledgeTypes,
ArrayList SectorsDesired,
ArrayList PositionsDesired,
ArrayList CountriesDesired,
ArrayList CitiesDesired,
ArrayList LabouringTypesDesired,
int EmployeeSearchType,
int CompanyID,
int JobID,
ArrayList ApplicationStatus)
{
//int EmployeeSearchType
//int UniversityNames,
//int DepartmentNames,
//int HighSchoolTypes,
string strGender;
if (Gender != null && Gender.Count != 0)
{
strGender = XMLHelper.BuildXmlString("Gender", "Gender", Gender);
}
else
{
strGender = "";
}
string strAgeRange;
if (AgeRange != null && AgeRange.Count != 0)
{
strAgeRange = XMLHelper.BuildXmlString("AgeRange", "AgeRange", AgeRange);
}
else
{
strAgeRange = "";
}
string strMaritalStates;
if (MaritalStates != null && MaritalStates.Count != 0)
{
strMaritalStates = XMLHelper.BuildXmlString("MaritalStates", "MaritalStates", MaritalStates);
}
else
{
strMaritalStates = "";
}
string strMilitaryStates;
if (MilitaryStates != null && MilitaryStates.Count != 0)
{
strMilitaryStates = XMLHelper.BuildXmlString("MilitaryStates", "MilitaryStates", MilitaryStates);
}
else
{
strMilitaryStates = "";
}
string strCountries;
if (Countries != null && Countries.Count != 0)
{
strCountries = XMLHelper.BuildXmlString("Countries", "Countries", Countries);
}
else
{
strCountries = "";
}
string strTurkeyCities;
if (TurkeyCities != null && TurkeyCities.Count != 0)
{
strTurkeyCities = XMLHelper.BuildXmlString("TurkeyCities", "TurkeyCities", TurkeyCities);
}
else
{
strTurkeyCities = "";
}
string strEducationLevels;
if (EducationLevels != null && EducationLevels.Count != 0)
{
strEducationLevels = XMLHelper.BuildXmlString("EducationLevels", "EducationLevels", EducationLevels);
}
else
{
strEducationLevels = "";
}
string strEducationStates;
if (EducationStates != null && EducationStates.Count != 0)
{
strEducationStates = XMLHelper.BuildXmlString("EducationStates", "EducationStates", EducationStates);
}
else
{
strEducationStates = "";
}
string strHighSchoolEducationLevels;
if (HighSchoolEducationLevels != null && HighSchoolEducationLevels.Count != 0)
{
strHighSchoolEducationLevels = XMLHelper.BuildXmlString("HighSchoolEducationLevels", "HighSchoolEducationLevels", HighSchoolEducationLevels);
}
else
{
strHighSchoolEducationLevels = "";
}
string strUniversityEducationLevels;
if (UniversityEducationLevels != null && UniversityEducationLevels.Count != 0)
{
strUniversityEducationLevels = XMLHelper.BuildXmlString("UniversityEducationLevels", "UniversityEducationLevels", UniversityEducationLevels);
}
else
{
strUniversityEducationLevels = "";
}
string strSectors;
if (Sectors != null && Sectors.Count != 0)
{
strSectors = XMLHelper.BuildXmlString("Sectors", "Sectors", Sectors);
}
else
{
strSectors = "";
}
string strPositions;
if (Positions != null && Positions.Count != 0)
{
strPositions = XMLHelper.BuildXmlString("Positions", "Positions", Positions);
}
else
{
strPositions = "";
}
string strExperience;
if (Experience != null && Experience.Count != 0)
{
strExperience = XMLHelper.BuildXmlString("Experience", "Experience", Experience);
}
else
{
strExperience = "";
}
string strLabouringTypes;
if (LabouringTypes != null && LabouringTypes.Count != 0)
{
strLabouringTypes = XMLHelper.BuildXmlString("LabouringTypes", "LabouringTypes", LabouringTypes);
}
else
{
strLabouringTypes = "";
}
string strComputerKnowledgeTypes;
if (ComputerKnowledgeTypes != null && ComputerKnowledgeTypes.Count != 0)
{
strComputerKnowledgeTypes = XMLHelper.BuildXmlString("ComputerKnowledgeTypes", "ComputerKnowledgeTypes", ComputerKnowledgeTypes);
}
else
{
strComputerKnowledgeTypes = "";
}
string strSectorsDesired;
if (SectorsDesired != null && SectorsDesired.Count != 0)
{
strSectorsDesired = XMLHelper.BuildXmlString("SectorsDesired", "SectorsDesired", SectorsDesired);
}
else
{
strSectorsDesired = "";
}
string strPositionsDesired;
if (PositionsDesired != null && PositionsDesired.Count != 0)
{
strPositionsDesired = XMLHelper.BuildXmlString("PositionsDesired", "PositionsDesired", PositionsDesired);
}
else
{
strPositionsDesired = "";
}
string strCountriesDesired;
if (CountriesDesired != null && CountriesDesired.Count != 0)
{
strCountriesDesired = XMLHelper.BuildXmlString("CountriesDesired", "CountriesDesired", CountriesDesired);
}
else
{
strCountriesDesired = "";
}
string strCitiesDesired;
if (CitiesDesired != null && CitiesDesired.Count != 0)
{
strCitiesDesired = XMLHelper.BuildXmlString("CitiesDesired", "CitiesDesired", CitiesDesired);
}
else
{
strCitiesDesired = "";
}
string strLabouringTypesDesired;
if (LabouringTypesDesired != null && LabouringTypesDesired.Count != 0)
{
strLabouringTypesDesired = XMLHelper.BuildXmlString("LabouringTypesDesired", "LabouringTypesDesired", LabouringTypesDesired);
}
else
{
strLabouringTypesDesired = "";
}
string strApplicationStatus;
if (ApplicationStatus != null && ApplicationStatus.Count != 0)
{
strApplicationStatus = XMLHelper.BuildXmlString("ApplicationStatus", "ApplicationStatus", ApplicationStatus);
}
else
{
strApplicationStatus = "";
}
//string strForeignLanguages;
//if (ForeignLanguages != null && ForeignLanguages.Count != 0)
// strForeignLanguages = "";
// //strForeignLanguages = XMLHelper.BuildXmlString("ForeignLanguages", "ForeignLanguages", ForeignLanguages);
//else
// strForeignLanguages = "";
//string strForeignLanguagesReading;
//if (ForeignLanguagesReading != null && ForeignLanguagesReading.Count != 0)
// strForeignLanguagesReading = "";
// //strForeignLanguagesReading = XMLHelper.BuildXmlString("ForeignLanguagesReading", "ForeignLanguagesReading", ForeignLanguagesReading);
//else
// strForeignLanguagesReading = "";
//string strForeignLanguagesWriting;
//if (ForeignLanguagesWriting != null && ForeignLanguagesWriting.Count != 0)
// strForeignLanguagesWriting = "";
// //strForeignLanguagesWriting = XMLHelper.BuildXmlString("ForeignLanguagesWriting", "ForeignLanguagesWriting", ForeignLanguagesWriting);
//else
// strForeignLanguagesWriting = "";
//string strForeignLanguagesSpeaking;
//if (ForeignLanguagesSpeaking != null && ForeignLanguagesSpeaking.Count != 0)
// strForeignLanguagesSpeaking = "";
// //strForeignLanguagesSpeaking = XMLHelper.BuildXmlString("ForeignLanguagesSpeaking", "ForeignLanguagesSpeaking", ForeignLanguagesSpeaking);
//else
// strForeignLanguagesSpeaking = "";
string strForeignLanguages = "";
if (ForeignLanguages1 != 0 || ForeignLanguages2 != 0 || ForeignLanguages3 != 0)
{
strForeignLanguages = "<ForeignLanguages> ";
if (ForeignLanguages1 != 0)
{
strForeignLanguages += "<flng fl=\"" + ForeignLanguages1.ToString() + "\" fls=\"" + ForeignLanguages1Speaking.ToString() + "\" flw=\"" + ForeignLanguages1Writing.ToString() + "\" flr=\"" + ForeignLanguages1Reading.ToString() + "\" /> ";
}
if (ForeignLanguages2 != 0)
{
strForeignLanguages += "<flng fl=\"" + ForeignLanguages2.ToString() + "\" fls=\"" + ForeignLanguages2Speaking.ToString() + "\" flw=\"" + ForeignLanguages2Writing.ToString() + "\" flr=\"" + ForeignLanguages2Reading.ToString() + "\" /> ";
}
if (ForeignLanguages3 != 0)
{
strForeignLanguages += "<flng fl=\"" + ForeignLanguages3.ToString() + "\" fls=\"" + ForeignLanguages3Speaking.ToString() + "\" flw=\"" + ForeignLanguages3Writing.ToString() + "\" flr=\"" + ForeignLanguages3Reading.ToString() + "\" /> ";
}
strForeignLanguages += " </ForeignLanguages>";
}
DataTable dt;
try
{
PIKCV.DAL.User obj = new PIKCV.DAL.User();
dt = null;
dt = obj.GetEmployeeSearchResults(strGender, strAgeRange, strMaritalStates, strMilitaryStates, DriverLicenceTypes,
Handicapped, Convicted, MartyrRelative, TerrorAggrieved,
strCountries, strTurkeyCities, strEducationLevels, strEducationStates, strHighSchoolEducationLevels,
HighSchoolTypes, strUniversityEducationLevels, UniversityNames, DepartmentNames, strSectors, strPositions, strExperience,
strLabouringTypes, strForeignLanguages, strComputerKnowledgeTypes, strSectorsDesired,
strPositionsDesired, strCountriesDesired, strCitiesDesired, strLabouringTypesDesired, EmployeeSearchType, CompanyID, JobID, strApplicationStatus);
}
catch (Exception)
{
dt = null;
throw;
}
return(dt);
}
public void DataBind(PIKCV.COM.Enumerations.ListTypes ListType)
{
DataTable dt = new DataTable();
DataTable dtInfo;
switch (ListType)
{
case PIKCV.COM.Enumerations.ListTypes.Message:
string JobID = "%";
if (CARETTA.COM.Util.IsNumeric(Request.QueryString["JobID"]))
{
JobID = Request.QueryString["JobID"].ToString();
}
dtInfo = new DataTable();
AddDataInfo(ref dtInfo, "", "ReadResult", false, -1);
AddDataInfo(ref dtInfo, "Konu", "MessageTitle", false, -1, true, "Employee-Messages-MessageDetail", "MessageID");
AddDataInfo(ref dtInfo, "Gönderen", "CompanyName", true, 0);
AddDataInfo(ref dtInfo, "Tarih", "CreateDate", false, -1);
AddDataInfo(ref dtInfo, "", "Delete", false, -1);
InitializeHtQuery(dtInfo);
dt = PIKCV.BUS.Messages.GetAllMessages(this.smUserID, false, PIKCV.COM.EnumDB.MemberTypes.Employee, this.HtQuery["CompanyName"].ToString(), JobID);
dt.Columns.Add("ReadResult");
dt.Columns.Add("Delete");
foreach (DataRow dr in dt.Rows)
{
dr["Delete"] = "<a href=\"" + this.OpenConfirm(PIKCV.COM.EnumDB.ErrorTypes.cDeleteMessage, Convert.ToInt32(dr["MessageID"])) + "\">Sil<a>";
if (Convert.ToBoolean(dr["IsRead"]))
{
dr["ReadResult"] = "<img src='images/misc/read.jpg' />";
}
else
{
dr["ReadResult"] = "<img src='images/misc/unread.jpg' />";
}
}
FilterCount(dtInfo);
AddListFilterTypes(dt, "CompanyID", "CompanyName");
DataBind(dtInfo, dt, "Employee-Messages-Messages");
lblNoRecord.Text = PIKCV.COM.Data.GetErrorMessageCache(this.cmbErrors, PIKCV.COM.EnumDB.ErrorTypes.NoMessage);
break;
case PIKCV.COM.Enumerations.ListTypes.UserJobApplicants:
dtInfo = new DataTable();
AddDataInfo(ref dtInfo, "Baþvuru Tarihi", "ApplicationDate", false, -1);
AddDataInfo(ref dtInfo, "Firma", "CompanyName", true, 0);
AddDataInfo(ref dtInfo, "Pozisyon", "PositionName", true, 1, true, "Employee-Jobs-JobDetail", "JobID");
AddDataInfo(ref dtInfo, "Durum", "JobApplicationStatusName", true, 2);
AddDataInfo(ref dtInfo, "Mesaj", "MessageCount", false, -1, true, "Employee-Messages-Messages", "JobID");
AddDataInfo(ref dtInfo, "Baþvuru Ýptal", "CancelApplicant", false, -1);
InitializeHtQuery(dtInfo);
dt = PIKCV.BUS.JobApplicants.GetUserJobApplicants(this.smUserID, this.smLanguageID, this.HtQuery["CompanyName"].ToString(), this.HtQuery["PositionName"].ToString(), this.HtQuery["JobApplicationStatusName"].ToString());
dt.Columns.Add("CancelApplicant");
foreach (DataRow dr in dt.Rows)
{
if ((PIKCV.COM.EnumDB.JobApplicationStates)dr["ApplicationStatusID"] == PIKCV.COM.EnumDB.JobApplicationStates.RecievedBack)
{
dr["CancelApplicant"] = "";
}
else
{
dr["CancelApplicant"] = "<a href=\"" + this.OpenConfirm(PIKCV.COM.EnumDB.ErrorTypes.cCancelApplicant, Convert.ToInt32(dr["JobApplicantID"]), "") + "\">Baþvuru Ýptal<a>";
}
}
FilterCount(dtInfo);
AddListFilterTypes(dt, "CompanyID", "CompanyName");
AddListFilterTypes(dt, "PositionID", "PositionName");
AddListFilterTypes(dt, "ApplicationStatusID", "JobApplicationStatusName");
DataBind(dtInfo, dt, "Employee-JobApplicants-JobApplicants");
lblNoRecord.Text = PIKCV.COM.Data.GetErrorMessageCache(this.cmbErrors, PIKCV.COM.EnumDB.ErrorTypes.NoApplicant);
break;
case PIKCV.COM.Enumerations.ListTypes.CompanyMessages:
dtInfo = new DataTable();
AddDataInfo(ref dtInfo, "Konu", "MessageTitle", false, -1, true, "Company-Messages-MessageDetail", "MessageID");
AddDataInfo(ref dtInfo, "Tarih", "CreateDate", false, -1);
InitializeHtQuery(dtInfo);
dt = PIKCV.BUS.Messages.GetCompanyMessages(this.smCompanyID, false, PIKCV.COM.EnumDB.MemberTypes.Company);
FilterCount(dtInfo);
DataBind(dtInfo, dt, "Company-Messages-Messages");
lblNoRecord.Text = PIKCV.COM.Data.GetErrorMessageCache(this.cmbErrors, PIKCV.COM.EnumDB.ErrorTypes.NoMessage);
break;
case PIKCV.COM.Enumerations.ListTypes.CompanySentMessages:
dtInfo = new DataTable();
AddDataInfo(ref dtInfo, "", "ReadResult", false, -1);
AddDataInfo(ref dtInfo, "Konu", "MessageTitle", false, -1, true, "Company-Messages-SendMessageDetail", "MessageID");
AddDataInfo(ref dtInfo, "Gönderilen", "FullName", true, 0, true, "Company-Messages-SentMessages", "UserID");
AddDataInfo(ref dtInfo, "Tarih", "CreateDate", false, -1);
InitializeHtQuery(dtInfo);
dt = PIKCV.BUS.Messages.GetCompanySentMessages(this.smCompanyID, false, this.HtQuery["FullName"].ToString());
dt.Columns.Add("ReadResult");
foreach (DataRow dr in dt.Rows)
{
if (Convert.ToBoolean(dr["IsRead"]))
{
dr["ReadResult"] = "";
}
else
{
dr["ReadResult"] = "<img src='images/misc/unread.jpg' />";
}
}
FilterCount(dtInfo);
AddListFilterTypes(dt, "UserID", "FullName");
DataBind(dtInfo, dt, "Company-Messages-SentMessages");
lblNoRecord.Text = PIKCV.COM.Data.GetErrorMessageCache(this.cmbErrors, PIKCV.COM.EnumDB.ErrorTypes.NoMessage);
break;
case PIKCV.COM.Enumerations.ListTypes.EnteredJobs:
int m_Status = 1;
PIKCV.COM.EnumDB.JobStatus JobStatus = PIKCV.COM.EnumDB.JobStatus.Active;
if (CARETTA.COM.Util.IsNumeric(Request.QueryString["JobStatus"]))
{
m_Status = Convert.ToInt32(Request.QueryString["JobStatus"]);
JobStatus = (PIKCV.COM.EnumDB.JobStatus)m_Status;
}
dtInfo = new DataTable();
AddDataInfo(ref dtInfo, "Referans Numarasý", "ReferenceNumber", false, -1);
AddDataInfo(ref dtInfo, "Pozisyon", "PositionName", true, 0);
AddDataInfo(ref dtInfo, "Baþvuru", "ApplicantCount", false, -1, true, "Company-Jobs-JobApplicants", "JobID");
AddDataInfo(ref dtInfo, "Bitiþ Tarihi", "EndDate", false, -1);
AddDataInfo(ref dtInfo, "Ýstatistik", "Statistics", false, -1);
switch (JobStatus)
{
case PIKCV.COM.EnumDB.JobStatus.Active:
AddDataInfo(ref dtInfo, "Durum", "Update", false, -1, true, "Company-Jobs-Jobs&JobFocus=2&JobSaveType=" + ((int)PIKCV.COM.Enumerations.JobSaveType.Update).ToString(), "JobID");
AddDataInfo(ref dtInfo, "", "Archive", false, -1, true, "Company-Jobs-PublicJobs&JobStatus=4", "JobID");
break;
case PIKCV.COM.EnumDB.JobStatus.Draft:
AddDataInfo(ref dtInfo, "Durum", "Update", false, -1, true, "Company-Jobs-Jobs&JobFocus=2&JobSaveType=" + ((int)PIKCV.COM.Enumerations.JobSaveType.ArchiveOrDraft).ToString(), "JobID");
AddDataInfo(ref dtInfo, "", "Archive", false, -1, true, "Company-Jobs-PublicJobs&JobStatus=1", "JobID");
break;
case PIKCV.COM.EnumDB.JobStatus.Archive:
AddDataInfo(ref dtInfo, "Durum", "Update", false, -1, true, "Company-Jobs-Jobs&JobFocus=2&JobSaveType=" + ((int)PIKCV.COM.Enumerations.JobSaveType.ArchiveOrDraft).ToString(), "JobID");
AddDataInfo(ref dtInfo, "", "Archive", false, -1, true, "Company-Jobs-PublicJobs&JobStatus=1", "JobID");
break;
}
AddDataInfo(ref dtInfo, "", "Delete", false, -1);
//AddDataInfo(ref dtInfo, "", "Delete", false, -1, true, "Company-Jobs-PublicJobs&JobStatus=" + ((int)PIKCV.COM.EnumDB.JobStatus.Draft).ToString(), "JobID");
InitializeHtQuery(dtInfo);
dt = PIKCV.BUS.Job.GetCompanyJobsAll(this.smCompanyID, JobStatus, this.smLanguageID, this.HtQuery["PositionName"].ToString());
dt.Columns.Add("Update");
dt.Columns.Add("Archive");
dt.Columns.Add("Delete");
dt.Columns.Add("Statistics");
foreach (DataRow dr in dt.Rows)
{
switch (JobStatus)
{
case PIKCV.COM.EnumDB.JobStatus.Active:
dr["Update"] = "Güncelle";
dr["Archive"] = "Arþivle";
dr["Delete"] = "";
break;
case PIKCV.COM.EnumDB.JobStatus.Draft:
dr["Update"] = "Güncelle";
dr["Archive"] = "Yayýnla";
//"<span onclick='DraftDeleteCtrl(3, 3)'>Delete</span>";
string Delete = "<u><b><span onclick='DraftDeleteCtrl(" +
((int)PIKCV.COM.EnumDB.JobStatus.Draft).ToString() +
", " + dr["JobID"].ToString() +
")'>Sil</span><b></u>";
dr["Delete"] = Delete;
break;
case PIKCV.COM.EnumDB.JobStatus.Archive:
dr["Update"] = "";
dr["Delete"] = "";
dr["Archive"] = "Yayýnla";
break;
}
string StatisticImage = "<img onclick='OpenJobStatistics(";
StatisticImage = StatisticImage + dr["JobID"].ToString() + ")'";
StatisticImage = StatisticImage + "style='cursor: pointer;' src='images/misc/statistic.png' width='16' height='14' />";
dr["Statistics"] = StatisticImage;
string PositionName = "<strong><a href='javascript:;' onclick='OpenJobPreview(" + dr["JobID"].ToString() + ")'>" + dr["PositionName"].ToString() + "</a></strong>";
dr["PositionName"] = PositionName;
}
FilterCount(dtInfo);
AddListFilterTypes(dt, "PositionID", "PositionName");
DataBind(dtInfo, dt, "Company-Jobs-PublicJobs");
string NoRecordMsg = String.Empty;
switch (JobStatus)
{
case PIKCV.COM.EnumDB.JobStatus.Active:
lblNoRecord.Text = PIKCV.COM.Data.GetErrorMessageCache(this.cmbErrors, PIKCV.COM.EnumDB.ErrorTypes.NoJob);
break;
case PIKCV.COM.EnumDB.JobStatus.Draft:
lblNoRecord.Text = PIKCV.COM.Data.GetErrorMessageCache(this.cmbErrors, PIKCV.COM.EnumDB.ErrorTypes.NoDraftJob);
break;
case PIKCV.COM.EnumDB.JobStatus.Archive:
lblNoRecord.Text = PIKCV.COM.Data.GetErrorMessageCache(this.cmbErrors, PIKCV.COM.EnumDB.ErrorTypes.NoArchiveJob);
break;
}
break;
case PIKCV.COM.Enumerations.ListTypes.JobSearchResults:
JobSearchQuery JobSearchQueries = this.smJobSearchQueries;
dtInfo = new DataTable();
AddDataInfo(ref dtInfo, "Pozisyon", "PositionName_JobTitle", true, 0, true, "Employee-Jobs-JobDetail", "JobID");
AddDataInfo(ref dtInfo, "Ref NO", "ReferenceNumber", false, -1);
AddDataInfo(ref dtInfo, "Firma", "CompanyName", true, 1);
AddDataInfo(ref dtInfo, "Son Baþvuru", "EndDate", false, -1);
AddDataInfo(ref dtInfo, "Tarih", "ModifyDate", false, -1);
AddDataInfo(ref dtInfo, "Baþvuru", "IsApply", true, 2);
string Keyword = JobSearchQueries.Keyword;
string Positions = XMLHelper.BuildXmlString("Positions", "PositionID", JobSearchQueries.Positions);
string Sectors = (JobSearchQueries.Sectors.Count > 0) ? XMLHelper.BuildXmlString("Sectors", "SectorID", JobSearchQueries.Sectors) : String.Empty;
string Cities = (JobSearchQueries.Cities.Count > 0) ? XMLHelper.BuildXmlString("Cities", "PlaceID", JobSearchQueries.Cities) : String.Empty;
string Companies = (JobSearchQueries.Companies.Count > 0) ? XMLHelper.BuildXmlString("Copmanies", "CompanyID", JobSearchQueries.Companies) : String.Empty;
string EducationLevels = (JobSearchQueries.EducationLevels.Count > 0) ? XMLHelper.BuildXmlString("EducationLevels", "EducationLevelID", JobSearchQueries.EducationLevels) : String.Empty;
PIKCV.COM.EnumDB.AgeRange AgeRange = JobSearchQueries.AgeRange;
string LabouringTypes = (JobSearchQueries.LabouringTypes.Count > 0) ? XMLHelper.BuildXmlString("LabouringTypes", "LabouringTypeID", JobSearchQueries.LabouringTypes) : String.Empty;
DateTime JobDate = (JobSearchQueries.JobDate != -1) ? DateTime.Now.AddDays(JobSearchQueries.JobDate) : DateTime.MinValue;
bool CustomJobs = JobSearchQueries.CustomJobs;
InitializeHtQuery(dtInfo);
int PositionID = (this.HtQuery["PositionName_JobTitle"].ToString() == "%") ? -1 : Convert.ToInt32(this.HtQuery["PositionName_JobTitle"]);
int CompanyID = (this.HtQuery["CompanyName"].ToString() == "%") ? -1 : Convert.ToInt32(this.HtQuery["CompanyName"]);
int Status = (this.HtQuery["IsApply"].ToString() == "%") ? -1 : Convert.ToInt32(this.HtQuery["IsApply"]);
PIKCV.BUS.Job objJob = new PIKCV.BUS.Job();
dt = objJob.GetJobs(this.smUserID, Keyword, Sectors, Cities, Positions, PIKCV.COM.EnumDB.JobStatus.Active, Companies, EducationLevels,
LabouringTypes, AgeRange, JobDate, CustomJobs, PositionID, CompanyID, Status);
FilterCount(dtInfo);
AddListFilterTypes(dt, "PositionID", "PositionName_JobTitle");
AddListFilterTypes(dt, "CompanyID", "CompanyName");
AddListFilterTypes(dt, "Status", "IsApply");
DataBind(dtInfo, dt, "Employee-Jobs-Jobs");
lblNoRecord.Text = PIKCV.COM.Data.GetErrorMessageCache(this.cmbErrors, PIKCV.COM.EnumDB.ErrorTypes.NoJobSearch);
break;
case PIKCV.COM.Enumerations.ListTypes.CompanyJobApplicants:
int ApplicantJobID = 0;
if (CARETTA.COM.Util.IsNumeric(Request.QueryString["JobID"]))
{
ApplicantJobID = Convert.ToInt32(Request.QueryString["JobID"]);
}
dtInfo = new DataTable();
//AddDataInfo(ref dtInfo, "Kiþi", "FullName", false, -1, true, "Company-Jobs-JobApplicants", "UserID");
AddDataInfo(ref dtInfo, "Kiþi", "FullName", false, -1);
AddDataInfo(ref dtInfo, "Baþvuru Tarihi", "ApplicationDate", false, -1);
AddDataInfo(ref dtInfo, "Puan", "Rate", false, -1);
AddDataInfo(ref dtInfo, "Durum", "JobApplicationStatusName", true, 0);
AddDataInfo(ref dtInfo, "", "Unsuitability", false, -1);
InitializeHtQuery(dtInfo);
dt = PIKCV.BUS.JobApplicants.GetCompanyJobApplicants(ApplicantJobID, this.smLanguageID, this.HtQuery["JobApplicationStatusName"].ToString());
dt.Columns.Add("Unsuitability");
foreach (DataRow dr in dt.Rows)
{
dr["FullName"] = "<a href='Pikcv.aspx?Pik=Company-Jobs-JobApplicants&UserID=" + dr["UserID"].ToString() + "&JobApplicantID=" + dr["JobApplicantID"].ToString() + "'>" + dr["FullName"].ToString() + "</a>";
if (!(Convert.ToInt32(dr["JobApplicationStatusID"]) == (int)PIKCV.COM.EnumDB.JobApplicationStates.Unsuitability))
{
dr["Unsuitability"] = dr["Unsuitability"] = "<a href=\"" + this.OpenConfirm(PIKCV.COM.EnumDB.ErrorTypes.cJobApplicantUnsuitabilitySet, Convert.ToInt32(dr["JobApplicantID"])) + "\">Reddet<a>";
}
}
FilterCount(dtInfo);
AddListFilterTypes(dt, "JobApplicationStatusID", "JobApplicationStatusName");
DataBind(dtInfo, dt, "Company-Jobs-JobApplicants");
lblNoRecord.Text = PIKCV.COM.Data.GetErrorMessageCache(this.cmbErrors, PIKCV.COM.EnumDB.ErrorTypes.NoApplicant);
break;
}
}