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