public bool deleteApp(Guid appID)
 {
     careersAppDataContext objApps = new careersAppDataContext();
     using (objApps)
     {
         var objDelApp = objApps.brdhc_JobApplications.Single(x => x.ApplicationId == appID);
         objApps.brdhc_JobApplications.DeleteOnSubmit(objDelApp);
         objApps.SubmitChanges();
         return true;
     }
 }
 public bool replyJob( Guid appID, string _reply)
 {
     careersAppDataContext objApps = new careersAppDataContext();
     using(objApps)
     {
         var objReply = objApps.brdhc_JobApplications.Single(x => x.ApplicationId == appID);
         objReply.Reply = _reply;
         objApps.SubmitChanges();
         return true;
     }
 }
 //insert
 public bool insertApp(Guid appID, Guid jobID, string _fname, string _lname, string _email, string _phone, string _resume, string _cover)
 {
     careersAppDataContext objApps = new careersAppDataContext();
     using (objApps)
     {
         brdhc_JobApplication objNewApp = new brdhc_JobApplication();
         objNewApp.ApplicationId = Guid.NewGuid();
         objNewApp.JobPostId = Guid.Parse(jobID.ToString());
         objNewApp.FirstName = _fname;
         objNewApp.LastName = _lname;
         objNewApp.Email = _email;
         objNewApp.Phone = _phone;
         objNewApp.ResumePath = _resume;
         objNewApp.CoverLetter = _cover;
         objApps.brdhc_JobApplications.InsertOnSubmit(objNewApp);
         objApps.SubmitChanges();
         return true;
     }
 }
 public IQueryable<brdhc_JobApplication> getAppByJobID(Guid jobID)
 {
     careersAppDataContext objApps = new careersAppDataContext();
     var singleApp = objApps.brdhc_JobApplications.Where(x => x.JobPostId == jobID).Select(x => x);
     return singleApp;
 }
	public IQueryable<brdhc_JobApplication> getApps()
	{
        careersAppDataContext objApps = new careersAppDataContext();
        var allApps = objApps.brdhc_JobApplications.Select(x => x);
        return allApps;
	}