public IQueryable<job> getJobByID(int _id)
{
jobsDataContext objJobDC = new jobsDataContext();
var allJobs = objJobDC.jobs.Where(x => x.Id == _id).Select(x => x);
return allJobs;
}
public bool commitDelete(int _id)
{
jobsDataContext objJobDC = new jobsDataContext();
using (objJobDC)
{
var objDelJob = objJobDC.jobs.Single(x => x.Id == _id);
objJobDC.jobs.DeleteOnSubmit(objDelJob);
objJobDC.SubmitChanges();
return true;
}
}
public bool commitUpdate(int _id, string _title, string _desc, DateTime _date)
{
jobsDataContext objJobDC = new jobsDataContext();
using (objJobDC)
{
var objUpJob = objJobDC.jobs.Single(x => x.Id == _id);
objUpJob.title = _title;
objUpJob.description = _desc;
objUpJob.last_date_apply = _date;
objJobDC.SubmitChanges();
return true;
}
}
public bool commitInsert(string _title, string _desc, DateTime _date)
{
jobsDataContext objJobDC = new jobsDataContext();
using (objJobDC)
{
job objNewJob = new job();
objNewJob.title = _title;
objNewJob.description = _desc;
objNewJob.last_date_apply = _date;
objJobDC.jobs.InsertOnSubmit(objNewJob);
objJobDC.SubmitChanges();
return true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
jobsDataContext dataContext =
new jobsDataContext();
var query = from job in dataContext.jobs
select job;
rpt_allJobs.DataSource = query;
rpt_allJobs.DataBind();
_subRefresh();
}
string urlPost = HttpContext.Current.Request.Url.AbsoluteUri;
string[] indexNum = urlPost.Split('=');
if (indexNum.Length > 1)
{
mv_tabs.ActiveViewIndex = Convert.ToInt32(indexNum[1]);
career_nav_menu.FindItem(indexNum[1]).Selected = true;
}
}
public IQueryable<job> getJobs()
{
jobsDataContext objJobDC = new jobsDataContext();
var allJobs = objJobDC.jobs.Select(x => x);
return allJobs;
}
