public void gvJobApplyBind()
{
try
{
SearchDetails objSearch = new SearchDetails();
objSearch.lstSkill = ddlSkillSetSel.Items.Cast<ListItem>().Where(l => l.Selected).Select(l => l.Value).ToList().Select(int.Parse).ToList();
objSearch.lstCountry = ddlCountrySel.Items.Cast<ListItem>().Where(l => l.Selected).Select(l => l.Value).ToList().Select(int.Parse).ToList();
objSearch.lstState = ddlStateSel.Items.Cast<ListItem>().Where(l => l.Selected).Select(l => l.Value).ToList().Select(int.Parse).ToList();
objSearch.lstCity = ddlCitySel.Items.Cast<ListItem>().Where(l => l.Selected).Select(l => l.Value).ToList().Select(int.Parse).ToList();
gvJobApply.DataSource = new AddJobBO().ListVacancy(objSearch);
gvJobApply.DataBind();
if (gvJobApply.PageCount > 0)
{
}
else
{
lblNoJob.Text = "No Records Found for your Search Query";
}
}
catch (Exception)
{
lblErr.Text = "Something Went Wrong";
}
}
public void bind()
{
try
{
SearchDetails objS = new SearchDetails();
objS.EmpID = Convert.ToInt32(Session["ID"].ToString());
// gvJobList.DataSource = new AddJobBO().ListVacancy(objS);
// gvJobList.DataBind();
gvSeekersList.DataSource = new JobAppliedBO().ListOfSeekersApplied(objS.EmpID);
gvSeekersList.DataBind();
if (gvSeekersList.PageCount > 0)
{
lblProError.Text = "";
}
#region Using
//using (JobASPContext context = new JobASPContext())
//{
// int Empid = Convert.ToInt32(Session["ID"].ToString());
// gvJobList.DataSource = context.Vacancies.Where(c => c.EmpId == Empid).ToList();
// gvJobList.DataBind();
//}
#endregion
}
catch (Exception)
{
lblProError.Text = "Something Went Wrong";
}
}
public void bind()
{
SearchDetails objS = new SearchDetails();
objS.JobID = Request.QueryString["JobID"] != null ? Convert.ToInt32(Request.QueryString["JobID"]) : 1;
rptJobDetails.DataSource = new AddJobBO().ListrptVacancy(objS);
rptJobDetails.DataBind();
}
public void ProcessRequest(HttpContext context)
{
System.Collections.Specialized.NameValueCollection forms = context.Request.Form;
string strOperation = forms.Get("oper");
SearchDetails objS = new SearchDetails();
objS.EmpID =ProfileEmployer.Id;
var collectionEmployee = new AddJobBO().ListVacancy(objS);
var collectionCompanies = new DDLDataBO().getCompanies(ProfileEmployer.Id);
string strResponse = string.Empty;
var filter = context.Request.QueryString["id"];
if (strOperation == null)
{
if (filter == "1")
{
//oper = null which means its first load.
var jsonSerializer = new JavaScriptSerializer();
context.Response.Write(jsonSerializer.Serialize(collectionEmployee.AsQueryable<Vacancy>().ToList<Vacancy>()));
}
else
{
var jsonSerializer = new JavaScriptSerializer();
context.Response.Write(jsonSerializer.Serialize(collectionCompanies.AsQueryable<CompanyProfile>().ToList<CompanyProfile>()));
}
}
else if (strOperation == "del")
{
if (filter == "1")
{
// var query = Query.EQ("JobID", forms.Get("JobId").ToString());
int jobid = Convert.ToInt32(forms.Get("JobId"));
new AddJobBO().RemoveJob(jobid);
//collectionEmployee.Remove(query);
}
strResponse = "Employee record successfully removed";
context.Response.Write(strResponse);
}
else
{
string strOut = string.Empty;
if (filter == "1")
{
AddEdit(forms, collectionEmployee, out strOut);
}
else
{
AddEditCompany(forms, collectionCompanies, out strOut);
}
context.Response.Write(strOut);
}
}
public void AppliedBind()
{
try
{
SearchDetails objDetails = new SearchDetails();
objDetails.ID = Convert.ToInt32(Session["ID"].ToString());
gvAppliedJobs.DataSource = new JobAppliedBO().ListApplied(objDetails);
gvAppliedJobs.DataBind();
}
catch (Exception)
{
lblProSeeker.Text = "Something Went Wrong";
}
}
public void GridBind()
{
try
{
SearchDetails objSearch = new SearchDetails();
// string[] arg = ddlSkillSet.SelectedItem.Text.Split(new string[] { }, StringSplitOptions.RemoveEmptyEntries).ToArray();
objSearch.lstSkill = ddlSkillSetSel.Items.Cast<ListItem>().Where(l => l.Selected).Select(l => l.Value).ToList().Select(int.Parse).ToList();
objSearch.lstCountry = ddlCountrySel.Items.Cast<ListItem>().Where(l => l.Selected).Select(l => l.Value).ToList().Select(int.Parse).ToList();
objSearch.lstState = ddlStateSel.Items.Cast<ListItem>().Where(l => l.Selected).Select(l => l.Value).ToList().Select(int.Parse).ToList();
objSearch.lstCity = ddlCitySel.Items.Cast<ListItem>().Where(l => l.Selected).Select(l => l.Value).ToList().Select(int.Parse).ToList();
gvListSeeker.DataSource = new AddJobBO().ListData(objSearch);
#region Search
// Search objS = new Search();
// objS.Skill = ddlSkillSet.SelectedItem.Text;
// if (ddlState.SelectedItem.Text != "Select")
// {
// if (ddlCity.SelectedItem.Text != "Select")
// {
// objS.Place = ddlCity.SelectedItem.Text;
// gvListSeeker.DataSource = new AddJobBO().ListAllSeekersByCity(objS);
// }
// else
// {
// objS.Place = ddlState.SelectedItem.Text;
// gvListSeeker.DataSource = new AddJobBO().ListAllSeekersByState(objS);
// }
// }
// else
// {
// gvListSeeker.DataSource = new AddJobBO().ListAllSeekersBySkill(objS);
// }
#endregion
gvListSeeker.DataBind();
if (gvListSeeker.PageCount > 0)
{
lblGrid.Text = "";
}
else
{
lblGrid.Text = "No data Found for your Search";
}
}
catch (Exception)
{
lblGrid.Text = "No data Found for your Search";
}
}
public List<JobApplied> ListApplied(SearchDetails objDetails)
{
var objList = _unitOfWork.Repository<JobApplied>().GetAll();
if (objDetails.ID != 0)
{
objList = objList.Where(c => c.SeekerID == objDetails.ID);
}
if (objDetails.Country!=0)
{
objList = objList.Where(c => c.Country == objDetails.Country);
}
if (objDetails.State!=0)
{
objList = objList.Where(c => c.State == objDetails.State);
}
if (objDetails.City!=0)
{
objList = objList.Where(c => c.City == objDetails.City);
}
return objList.ToList();
}
//public void BindCountry()
//{
// ddlProSCountry.DataSource = new DDLDataBO().GetCountries();
// ddlProSCountry.DataTextField = "CountryName";
// ddlProSCountry.DataValueField = "CountryID";
// ddlProSCountry.DataBind();
// ddlProSCountry.Items.Insert(0, "Select");
// #region Using
// //using (DataLayer.JobASPContext context = new DataLayer.JobASPContext())
// //{
// // ddlCountry.DataSource = context.Countries.ToList();
// // ddlCountry.DataTextField = "CountryName";
// // ddlCountry.DataValueField = "CountryID";
// // ddlCountry.DataBind();
// // ddlCountry.Items.Insert(0,"Select");
// //}
// #endregion
//}
//public void BindState()
//{
// try
// {
// if (ddlProSCountry.SelectedItem.Text != "Select")
// {
// int Val = Convert.ToInt32(ddlProSCountry.SelectedValue);
// ddlProSState.DataSource = new DDLDataBO().GetStates(Val);
// ddlProSState.DataTextField = "StateName";
// ddlProSState.DataValueField = "StateID";
// ddlProSState.DataBind();
// ddlProSState.Items.Insert(0, "Select");
// }
// else
// {
// ddlProSState.Items.Clear();
// ddlProSCity.Items.Clear();
// }
// }
// catch (Exception)
// {
// lblProSeeker.Text = "Something went wrong";
// }
// #region Using
// //using (DataLayer.JobASPContext context = new DataLayer.JobASPContext())
// //{
// // if (ddlCountry.SelectedItem.Text != "Select")
// // {
// // int Val = Convert.ToInt32(ddlCountry.SelectedValue);
// // ddlState.DataSource = context.States.Where(c => c.CountryID == Val).ToList();
// // ddlState.DataTextField = "StateName";
// // ddlState.DataValueField = "StateID";
// // ddlState.DataBind();
// // ddlState.Items.Insert(0, "Select");
// // }
// // else
// // {
// // ddlState.Items.Clear();
// // ddlCity.Items.Clear();
// // }
// //}
// #endregion
//}
//public void BindCity()
//{
// try
// {
// if (ddlProSState.SelectedItem.Text != "Select")
// {
// int Val = Convert.ToInt32(ddlProSState.SelectedValue);
// ddlProSCity.DataSource = new DDLDataBO().GetCities(Val);
// ddlProSCity.DataTextField = "CityName";
// ddlProSCity.DataValueField = "CityID";
// ddlProSCity.DataBind();
// ddlProSCity.Items.Insert(0, "Select");
// }
// else
// {
// ddlProSCity.Items.Clear();
// }
// }
// catch (Exception)
// {
// lblProSeeker.Text = "Something went wrong";
// }
// #region Using
// //using (DataLayer.JobASPContext context = new DataLayer.JobASPContext())
// //{
// // if (ddlState.SelectedItem.Text!="Select")
// // {
// // int Val = Convert.ToInt32(ddlState.SelectedValue);
// // ddlCity.DataSource = context.Cities.Where(c => c.StateID == Val).ToList();
// // ddlCity.DataTextField = "CityName";
// // ddlCity.DataValueField = "CityID";
// // ddlCity.DataBind();
// // ddlCity.Items.Insert(0, "Select");
// // }
// // else
// // {
// // ddlCity.Items.Clear();
// // }
// //}
// #endregion
//}
public void bind()
{
try
{
int ID = Convert.ToInt32(Session["ID"].ToString());
SearchDetails objSearch = new SearchDetails();
objSearch.ID = ID;
objSearch.lstSkill = ddlSkillSetSel.Items.Cast<ListItem>().Where(l => l.Selected).Select(l => l.Value).ToList().Select(int.Parse).ToList();
objSearch.lstCountry = ddlCountrySel.Items.Cast<ListItem>().Where(l => l.Selected).Select(l => l.Value).ToList().Select(int.Parse).ToList();
objSearch.lstState = ddlStateSel.Items.Cast<ListItem>().Where(l => l.Selected).Select(l => l.Value).ToList().Select(int.Parse).ToList();
objSearch.lstCity = ddlCitySel.Items.Cast<ListItem>().Where(l => l.Selected).Select(l => l.Value).ToList().Select(int.Parse).ToList();
gvJobApply.DataSource = new AddJobBO().ListVacancy(objSearch);
#region Code
//Search objs = new Search();
//objs.ID = ID;
//objs.Skill = ddlProSSkill.SelectedItem.Text;
//if (ddlState.SelectedItem.Text != "Select")
//{
// if (ddlCity.SelectedItem.Text != "Select")
// {
// objs.Place = ddlCity.SelectedItem.Text;
// gvJobApply.DataSource = new AddJobBO().ListOfJobsbyCitySkill(objs);
// }
// else
// {
// objs.Place = ddlState.SelectedItem.Text;
// gvJobApply.DataSource = new AddJobBO().ListOfJobsbyStateSkill(objs);
// }
//}
//else
//{
// gvJobApply.DataSource = new AddJobBO().ListAllJobsSkill(objs);
//}
#endregion
gvJobApply.DataBind();
if (gvJobApply.PageCount > 0)
{
lblNoJob.Text = "Jobs For your Search";
btngvApply.Visible = true;
}
else
{
lblNoJob.Text = "No jobs Found for your Search";
btngvApply.Visible = false;
}
#region Using
//using (JobASPContext context = new JobASPContext())
//{
//int SeekerID = Convert.ToInt32(Session["ID"].ToString());
//List<Vacancy> ObjList = context.Vacancies.ToList();
//var objList2 = context.JobApplies.Where(c => c.SeekerID == SeekerID).ToList();
//gvJobApply.DataSource = context.Vacancies.ToList();
//gvJobApply.DataBind();
//gvAppliedJobs.DataSource = context.JobApplies.Where(c => c.SeekerID == SeekerID).ToList();
//gvAppliedJobs.DataBind();
#region Prac
// gvJobApply.DataSource = context.Vacancies.Join(objList2, b => b.JobID, c => c.JobID, (b, c) => b.JobID != c.JobID).Skip(3);
// gvJobApply.DataSource = context.Vacancies.Join(context.JobApplies.Where(c => c.SeekerID == SeekerID), b => b.JobID, c => c.JobID, (b, c) => b).ToList();
//gvJobApply.DataSource=from j in context.Vacancies
// join aj in aj.JobID !=j.JobID
// on where aj.SeekerID == SeekerID;
//var exceptionList = context.JobApplies.Where(c=>c.SeekerID == SeekerID)
// .Select(e=>e);
//var query = context.Vacancies
// .Select(e => e)
// .Where(e => !exceptionList.Contains(e.JobID));
//var query = from w in context.Vacancies
// join c in context.JobApplies
// on w.JobID equals c.JobID
// where
// select w;
//gvJobApply.DataSource = query1.ToList();
#endregion
//}
#endregion
}
catch (Exception)
{
lblProSeeker.Text = "Something Went Wrong";
}
}