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