public IHttpActionResult PutAppliedJobs(int id, AppliedJobs appliedJobs) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != appliedJobs.id) { return(BadRequest()); } db.Entry(appliedJobs).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!AppliedJobsExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(int id) { AppliedJobs appliedJobs = db.AppliedJobs.Find(id); db.AppliedJobs.Remove(appliedJobs); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,studentid,companyid,jobid,applydate")] AppliedJobs appliedJobs) { if (ModelState.IsValid) { db.Entry(appliedJobs).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(appliedJobs)); }
public IHttpActionResult GetAppliedJobs(int id) { AppliedJobs appliedJobs = db.AppliedJobs.Find(id); if (appliedJobs == null) { return(NotFound()); } return(Ok(appliedJobs)); }
public ActionResult Create([Bind(Include = "id,studentid,companyid,jobid,applydate")] AppliedJobs appliedJobs) { if (ModelState.IsValid) { db.AppliedJobs.Add(appliedJobs); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(appliedJobs)); }
public IHttpActionResult GetApplied_StudId(string id1) { AppliedJobs appliedJobs = db.AppliedJobs.Where(x => x.jobid == id1).FirstOrDefault(); if (appliedJobs == null) { return(NotFound()); } return(Ok(appliedJobs)); }
public IHttpActionResult PostAppliedJobs(AppliedJobs appliedJobs) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.AppliedJobs.Add(appliedJobs); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = appliedJobs.id }, appliedJobs)); }
public static bool ApplyJob(AppliedJobs job) { bool isSuccessful = false; var connectionString = ConfigurationManager.ConnectionStrings["RozgaarConnectionString"].ConnectionString; var query = "INSERT INTO " + "[dbo].[AppliedJobs] (UserID_FK,PostedJobID_FK,ApplyDate) " + "VALUES (" + job.UserID_FK + "," + job.PostedJobID_FK + ",'" + DateTime.Now.Date + "')"; SqlConnection connection = new SqlConnection(connectionString); SqlCommand command = null; try { connection.Open(); command = new SqlCommand(query, connection); command.ExecuteNonQuery(); isSuccessful = true; } catch (Exception e) { isSuccessful = false; } finally { command.Dispose(); connection.Close(); } if (isSuccessful) { using (System.IO.StreamWriter file = new System.IO.StreamWriter(@"D:\RozgaarRecords\AppliedJobRecords.txt", true)) { file.WriteLine("UserID: " + job.UserID_FK + " applied to JobID: " + job.PostedJobID_FK + "\tAt :" + DateTime.Now + "."); } } return(isSuccessful); }
public IHttpActionResult DeleteAppliedJobs(int id) { AppliedJobs appliedJobs = db.AppliedJobs.Find(id); if (appliedJobs == null) { return(NotFound()); } db.AppliedJobs.Remove(appliedJobs); db.SaveChanges(); return(Ok(appliedJobs)); }
// GET: AppliedJobs/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AppliedJobs appliedJobs = db.AppliedJobs.Find(id); if (appliedJobs == null) { return(HttpNotFound()); } return(View(appliedJobs)); }
public bool IsApplied(int jobId) { return AppliedJobs.Any(j => j.JobId == jobId); }
public static bool ApplyForJob(AppliedJobs job) { return(UsersRepository.ApplyJob(job)); }
public bool ApplyForJob(AppliedJobs job) { return(UsersProcessor.ApplyForJob(job)); }