public List <AppliedJobsViewModel> MonthlyAppliedJobs(int month, int year, string gender, string state)
{
DataTable dt = _userProcessor.MonthlyAppliedJobs(month, year, gender, state);
List <AppliedJobsViewModel> lstAppliedJobs = new List <AppliedJobsViewModel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
AppliedJobsViewModel aJob = new AppliedJobsViewModel
{
JobDetail = new JobPostViewModel(),
UserDetail = new UserViewModel(),
AppliedOn = Convert.ToDateTime(dt.Rows[i]["AppliedDate"]).Date
};
aJob.UserDetail.UserId = Convert.ToInt32(dt.Rows[i]["UserId"]);
aJob.UserDetail.FirstName = Convert.ToString(dt.Rows[i]["FirstName"]);
aJob.UserDetail.LastName = Convert.ToString(dt.Rows[i]["LastName"]);
aJob.UserDetail.Email = Convert.ToString(dt.Rows[i]["Email"]);
aJob.UserDetail.MobileNo = Convert.ToString(dt.Rows[i]["MobileNo"]);
aJob.JobDetail.JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]);
aJob.JobDetail.CTC = Convert.ToString(dt.Rows[i]["CTC"]);
aJob.JobDetail.JobTypeSummary = Convert.ToString(dt.Rows[i]["JobTypeDesc"]);
aJob.JobDetail.CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]);
aJob.JobDetail.City = Convert.ToString(dt.Rows[i]["City"]);
aJob.JobDetail.State = Convert.ToString(dt.Rows[i]["State"]);
lstAppliedJobs.Add(aJob);
}
return(lstAppliedJobs);
}
public List <AppliedJobsViewModel> GetAppliedJobsInRange(string startDate, string endDate)
{
DataTable dt = _userProcessor.GetAppliedJobsInRange(startDate, endDate);
List <AppliedJobsViewModel> lstAppliedJobs = new List <AppliedJobsViewModel>();
for (int i = 0; i < dt.Rows.Count; i++)
{
//var Skill = JsonConvert.DeserializeObject<Skills>(dt.Rows[i]["Skills"].ToString());
AppliedJobsViewModel aJob = new AppliedJobsViewModel
{
JobDetail = new JobPostViewModel(),
UserDetail = new UserViewModel(),
AppliedOn = Convert.ToDateTime(dt.Rows[i]["AppliedDate"]).Date
};
aJob.UserDetail.UserId = Convert.ToInt32(dt.Rows[i]["UserId"]);
aJob.UserDetail.FirstName = Convert.ToString(dt.Rows[i]["FirstName"]);
aJob.UserDetail.LastName = Convert.ToString(dt.Rows[i]["LastName"]);
aJob.UserDetail.Email = Convert.ToString(dt.Rows[i]["Email"]);
aJob.UserDetail.MobileNo = Convert.ToString(dt.Rows[i]["MobileNo"]);
aJob.JobDetail.JobTitleByEmployer = Convert.ToString(dt.Rows[i]["JobTitleByEmployer"]);
aJob.JobDetail.CTC = Convert.ToString(dt.Rows[i]["CTC"]);
aJob.JobDetail.JobTypeSummary = Convert.ToString(dt.Rows[i]["JobTypeDesc"]);
aJob.JobDetail.CompanyName = Convert.ToString(dt.Rows[i]["CompanyName"]);
aJob.JobDetail.City = Convert.ToString(dt.Rows[i]["City"]);
aJob.JobDetail.State = Convert.ToString(dt.Rows[i]["State"]);
lstAppliedJobs.Add(aJob);
}
return(lstAppliedJobs);
}
public ActionResult Applied_Jobs(employee employee1)
{
var jobs = (from j in db.job_applied
where j.id_employee == employee1.id_employee
select j).ToList();
//var job_circulars = (from jc in db.job_circular
// select jc).Last();
List <AppliedJobsViewModel> AppliedJobsViewModel1 = new List <AppliedJobsViewModel>();
foreach (var job in jobs)
{
var AppliedJobsViewModelTemp = new AppliedJobsViewModel();
var job_circular1 = new job_circular();
var job_circularTemp = (from jct in db.job_circular //
where jct.id_job_circular == job.id_job_circular //
select jct).ToList(); //
job_circular1 = job_circularTemp.First(); //
AppliedJobsViewModelTemp.EmployeeJobSeeker = employee1;
AppliedJobsViewModelTemp.job_applied1 = job;
AppliedJobsViewModelTemp.job_circular1 = job_circular1;
AppliedJobsViewModel1.Add(AppliedJobsViewModelTemp);
}
return(View(AppliedJobsViewModel1));
}
