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