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