public ActionResult JobDetailsApplied(Guid?id)
{
ApplicantJobApplicationPoco applicantJobApplicationPoco = null;
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (TempData["ListJobsAppliedModel"] != null)
{
IEnumerable <ApplicantJobApplicationPoco> appliedJobList = (IEnumerable <ApplicantJobApplicationPoco>)TempData["ListJobsAppliedModel"];
applicantJobApplicationPoco = appliedJobList.Where(c => c.Id == id).FirstOrDefault();
if (applicantJobApplicationPoco == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TempData.Keep("ListJobsAppliedModel");
}
else
{
IDataRepository <ApplicantJobApplicationPoco> repoAppliedJob = new MvcLogic <ApplicantJobApplicationPoco>().Repo;
applicantJobApplicationPoco = repoAppliedJob.GetSingle(c => c.Id == id);
if (applicantJobApplicationPoco == null)
{
return(HttpNotFound());
}
}
return(View(applicantJobApplicationPoco));
}
public ActionResult DeleteConfirmed(Guid id)
{
ApplicantJobApplicationPoco applicantJobApplicationPoco = logic.Get(id);
logic.Delete(new[] { applicantJobApplicationPoco });
return(RedirectToAction("Index"));
}
public void Init()
{
// create an instance of a POCO to load the Pocos assembly
ApplicantJobApplicationPoco poco = new ApplicantJobApplicationPoco();
_types = Assembly.LoadFrom(_assemblyUnderTest).GetTypes();
}
public override Task <Empty> DeleteApplicantJobApplication(ApplicantJobApplicationPayload request, ServerCallContext context)
{
ApplicantJobApplicationPoco poco = _logic.Get(Guid.Parse(request.Id));
_logic.Delete(new ApplicantJobApplicationPoco[] { poco });
return(new Task <Empty>(() => new Empty()));
}
public override Task <ApplicantJobApplicationReply> GetApplicantJobApplication(IdRequest1 request,
ServerCallContext context)
{
ApplicantJobApplicationPoco poco = _logic.Get(Guid.Parse(request.Id));
return(Task.FromResult <ApplicantJobApplicationReply>(FromPoco(poco)));
}
public async Task <IActionResult> Edit(Guid id, [Bind("Id,Applicant,Job,ApplicationDate,TimeStamp")] ApplicantJobApplicationPoco applicantJobApplicationPoco)
{
if (id != applicantJobApplicationPoco.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(applicantJobApplicationPoco);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ApplicantJobApplicationPocoExists(applicantJobApplicationPoco.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["Applicant"] = new SelectList(_context.ApplicantProfiles, "Id", "Id", applicantJobApplicationPoco.Applicant);
ViewData["Job"] = new SelectList(_context.CompanyJobs, "Id", "Id", applicantJobApplicationPoco.Job);
return(View(applicantJobApplicationPoco));
}
public ActionResult JobSearchResult()
{
List <JobSearchResult> result = new List <JobSearchResult>();
string connectionString = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
using (conn)
{
SqlCommand cmd = new SqlCommand {
Connection = conn
};
conn.Open();
cmd.CommandText = @"SELECT CJ.Id, CP.Id, CJD.Job_Name, CJD.Job_Descriptions, CL.City_Town, CL.State_Province_Code, CD.Company_Name, CP.Company_Website FROM Company_Profiles AS CP INNER JOIN Company_Descriptions AS CD ON CP.Id = CD.Company INNER JOIN Company_Locations AS CL ON CL.Company = CP.Id INNER JOIN Company_Jobs AS CJ ON CJ.Company = CP.Id INNER JOIN Company_Jobs_Descriptions AS CJD ON CJD.Job = CJ.Id WHERE CD.LanguageID = 'EN' AND CJD.Job_Name LIKE '%'+@JobTitle+'%' AND CL.City_Town LIKE '%'+@Location+'%'";
cmd.Parameters.AddWithValue("@JobTitle", (TempData["JobTitle"] != null)? TempData["JobTitle"].ToString().Trim():"");
TempData.Keep();
cmd.Parameters.AddWithValue("@Location", (TempData["Location"] != null)? TempData["Location"].ToString().Trim():"");
TempData.Keep();
try
{
SqlDataReader IDreader = cmd.ExecuteReader();
while (IDreader.Read())
{
IDataRecord myreader = (IDataRecord)IDreader;
JobSearchResult x = new JobSearchResult
{
JobID = (Guid)myreader[0],
CompID = (Guid)myreader[1],
JobName = myreader[2].ToString(),
JobDescription = myreader[3].ToString(),
City = myreader[4].ToString(),
State = myreader[5].ToString(),
CompanyName = myreader[6].ToString(),
Website = myreader[7].ToString(),
Applied = false
};
try
{
ApplicantJobApplicationPoco poco = _appliedLogic.GetAll().Where <ApplicantJobApplicationPoco>(T => (T.Applicant == (Guid)TempData["Applicant"] && T.Job == x.JobID) ? true : false).FirstOrDefault();
TempData.Keep();
x.Applied = (poco != null) ? true : false;
result.Add(x);
}
catch { }
finally {
TempData.Keep();
}
}
IDreader.Close();
conn.Close();
}
catch { }
finally { conn.Close(); }
}
conn.Close();
return(View(result));
}
public ActionResult DeleteConfirmed(Guid id)
{
ApplicantJobApplicationPoco applicantJobApplicationPoco = db.ApplicantJobApplications.Find(id);
db.ApplicantJobApplications.Remove(applicantJobApplicationPoco);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ApplicantJobApplicationPoco GetSingleApplicantJobApplication(string Id)
{
var logic = new ApplicantJobApplicationLogic(new EFGenericRepository <ApplicantJobApplicationPoco>(false));
ApplicantJobApplicationPoco applicantJobApplicationPoco = new ApplicantJobApplicationPoco();
applicantJobApplicationPoco = logic.Get(Guid.Parse(Id));
return(applicantJobApplicationPoco);
}
public ActionResult Edit([Bind(Include = "Id,Applicant,Job,ApplicationDate,TimeStamp")] ApplicantJobApplicationPoco applicantJobApplicationPoco)
{
if (ModelState.IsValid)
{
logic.Update(new[] { applicantJobApplicationPoco });
return(RedirectToAction("Index"));
}
return(View(applicantJobApplicationPoco));
}
public ActionResult DeleteConfirmed(Guid id)
{
ApplicantJobApplicationPoco applicantJobApplicationPoco = applicantJobApplicationLogic.Get(id); //db.ApplicantJobApplications.Find(id);
appJobAppPoco[0] = applicantJobApplicationPoco;
applicantJobApplicationLogic.Delete(appJobAppPoco);
return(RedirectToAction("Index"));
}
private void ApplicantJobApplication_Init()
{
_applicantJobApplication = new ApplicantJobApplicationPoco()
{
Id = Guid.NewGuid(),
ApplicationDate = Faker.Date.Recent(),
Applicant = _applicantProfile.Id,
Job = _companyJob.Id
};
}
private ApplicantJobApplicationReply FromPoco(ApplicantJobApplicationPoco poco)
{
return(new ApplicantJobApplicationReply()
{
Id = poco.Id.ToString(),
Applicant = poco.Applicant.ToString(),
Job = poco.Job.ToString(),
ApplicationDate = Timestamp.FromDateTime(DateTime.SpecifyKind(poco.ApplicationDate, DateTimeKind.Utc)),
});
}
public ActionResult GetApplicantJobApplication(Guid applicantJobApplicationId)
{
ApplicantJobApplicationPoco poco = _logic.Get(applicantJobApplicationId);
if (poco is null)
{
return(NotFound());
}
return(Ok(poco));
}
private ApplicantJobApplication TranslateFromPoco(ApplicantJobApplicationPoco poco)
{
return(new ApplicantJobApplication()
{
Id = poco.Id.ToString(),
Applicant = poco.Applicant.ToString(),
Job = poco.Job.ToString(),
ApplicationDate = poco.ApplicationDate == null ? null : Timestamp.FromDateTime((DateTime)poco.ApplicationDate)
});
}
public IHttpActionResult GetApplicantJobApplication(Guid ApplicantJobApplicationId)
{
ApplicantJobApplicationPoco applicantJobApplication = _logic.Get(ApplicantJobApplicationId);
if (applicantJobApplication == null)
{
return(NotFound());
}
return(Ok(applicantJobApplication));
}
private Task <ApplicantJobApplicationObj> TranslateFromPoco(ApplicantJobApplicationPoco poco)
{
return(Task.FromResult(new ApplicantJobApplicationObj
{
Id = poco.Id.ToString(),
Applicant = poco.Applicant.ToString(),
Job = poco.Job.ToString(),
ApplicationDate = Timestamp.FromDateTime(DateTime.SpecifyKind(poco.ApplicationDate, DateTimeKind.Utc)),
}));
}
public IHttpActionResult GetApplicantJobApplication(Guid id)
{
ApplicantJobApplicationPoco poco = logic.Get(id);
if (poco == null)
{
return(NotFound());
}
return(Ok(poco));
}
public override Task <Empty> UpdateApplicantJobApplication(ApplicantJobApplicationPayload request, ServerCallContext context)
{
ApplicantJobApplicationPoco[] pocos = new ApplicantJobApplicationPoco[1];
pocos[0].Id = Guid.Parse(request.Id);
pocos[0].Applicant = Guid.Parse(request.Applicant);
pocos[0].Job = Guid.Parse(request.Job);
pocos[0].ApplicationDate = request.ApplicationDate.ToDateTime();
_logic.Update(pocos);
return(new Task <Empty>(null));
}
public override Task <ApplicantJobApplicationObj> GetApplicantJobApplication(IdRequestApplicantJobApplication request, ServerCallContext context)
{
var _logic = new ApplicantJobApplicationLogic(new EFGenericRepository <ApplicantJobApplicationPoco>());
ApplicantJobApplicationPoco poco = _logic.Get(Guid.Parse(request.Id));
if (poco == null)
{
throw new ArgumentOutOfRangeException();
}
return(TranslateFromPoco(poco));
}
public ActionResult Create([Bind(Include = "Id,Applicant,Job,ApplicationDate,TimeStamp")] ApplicantJobApplicationPoco applicantJobApplicationPoco)
{
if (ModelState.IsValid)
{
applicantJobApplicationPoco.Id = Guid.NewGuid();
logic.Add(new[] { applicantJobApplicationPoco });
return(RedirectToAction("Index"));
}
return(View(applicantJobApplicationPoco));
}
public ActionResult Edit([Bind(Include = "Id,Applicant,Job,ApplicationDate,TimeStamp")] ApplicantJobApplicationPoco applicantJobApplicationPoco)
{
if (ModelState.IsValid)
{
db.Entry(applicantJobApplicationPoco).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Applicant = new SelectList(db.ApplicantProfiles, "Id", "Currency", applicantJobApplicationPoco.Applicant);
ViewBag.Job = new SelectList(db.CompanyJobs, "Id", "Id", applicantJobApplicationPoco.Job);
return(View(applicantJobApplicationPoco));
}
private ApplicantJobApplicationReply FromPOCO(ApplicantJobApplicationPoco poco)
{
return(new ApplicantJobApplicationReply()
{
Id = poco.Id.ToString(),
Applicant = poco.Applicant.ToString(),
Job = poco.Job.ToString(),
ApplicationDate = poco.ApplicationDate == null ? null :
Timestamp.FromDateTime((DateTime)poco.ApplicationDate),
TimeStamp = ByteString.CopyFrom(poco.TimeStamp)
});
}
public override Task <ApplicantJobApplicationPayload> ReadApplicantJobApplication(IdRequest request, ServerCallContext context)
{
ApplicantJobApplicationPoco poco = _logic.Get(Guid.Parse(request.Id));
return(new Task <ApplicantJobApplicationPayload>(() => new ApplicantJobApplicationPayload()
{
Id = poco.Id.ToString(),
Applicant = poco.Applicant.ToString(),
Job = poco.Job.ToString(),
ApplicationDate = Timestamp.FromDateTime((DateTime)poco.ApplicationDate)
}));
}
public async Task <IActionResult> JobSave(Guid id)
{
var applicantJobPoco = new ApplicantJobApplicationPoco();
applicantJobPoco.Id = Guid.NewGuid();
applicantJobPoco.Job = id;
applicantJobPoco.Applicant = Guid.Parse(TempData["Applicant"].ToString());
applicantJobPoco.ApplicationDate = DateTime.Today;
_context.Add(applicantJobPoco);
await _context.SaveChangesAsync();
return(RedirectToAction("Details", new { id = applicantJobPoco.Applicant }));
}
public override Task <Empty> DeleteApplicantJobApplication(ApplicantJobApplicationPayload request, ServerCallContext context)
{
var poco = new ApplicantJobApplicationPoco()
{
Id = Guid.Parse(request.Id),
Applicant = Guid.Parse(request.Applicant),
Job = Guid.Parse(request.Job),
ApplicationDate = request.ApplicationDate.ToDateTime(),
};
_logic.Delete(new ApplicantJobApplicationPoco[] { poco });
return(null);
}
public override Task <Empty> DeleteApplicantJobApplication(ApplicantJobApplicationPayLoad request, ServerCallContext context)
{
ApplicantJobApplicationPoco[] pocos = new ApplicantJobApplicationPoco[] { new ApplicantJobApplicationPoco()
{
Id = Guid.Parse(request.Id),
Applicant = Guid.Parse(request.Applicant),
Job = Guid.Parse(request.Job),
ApplicationDate = request.ApplicationDate.ToDateTime()
} };
_logic.Delete(pocos);
return(new Task <Empty>(() => new Empty()));
}
public ActionResult GetApplicantJobApplication(Guid id)
{
ApplicantJobApplicationPoco poco = _logic.Get(id);
if (poco != null)
{
return(Ok(poco));
}
else
{
return(NotFound());
}
}
public ActionResult Edit([Bind(Include = "Id,Applicant,Job,ApplicationDate,TimeStamp")] ApplicantJobApplicationPoco applicantJobApplicationPoco)
{
if (ModelState.IsValid)
{
appJobAppPoco[0] = applicantJobApplicationPoco;
applicantJobApplicationLogic.Update(appJobAppPoco);
return(RedirectToAction("Index"));
}
ViewBag.Applicant = new SelectList(applicantJobApplicationLogic.GetAll(), "Applicant", "Applicant");
ViewBag.Job = new SelectList(applicantJobApplicationLogic.GetAll(), "Job", "Job");
return(View(applicantJobApplicationPoco));
}
public ActionResult Create([Bind(Include = "Id,Applicant,Job,ApplicationDate,TimeStamp")] ApplicantJobApplicationPoco applicantJobApplicationPoco)
{
if (ModelState.IsValid)
{
applicantJobApplicationPoco.Id = Guid.NewGuid();
db.ApplicantJobApplications.Add(applicantJobApplicationPoco);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Applicant = new SelectList(db.ApplicantProfiles, "Id", "Currency", applicantJobApplicationPoco.Applicant);
ViewBag.Job = new SelectList(db.CompanyJobs, "Id", "Id", applicantJobApplicationPoco.Job);
return(View(applicantJobApplicationPoco));
}
