public Boolean insertTask(Task obj) { using (NewElasticBankContext db = new NewElasticBankContext()) { try { db.Tasks.Add(obj); db.SaveChanges(); return true; } catch (Exception ex) { return false; } } }
public Boolean insertRecommendedJob(RecommendedJob obj) { using (NewElasticBankContext db = new NewElasticBankContext()) { try { db.RecommendedJobs.Add(obj); db.SaveChanges(); return true; } catch (Exception ex) { return false; } } }
public Boolean deleteTask(Task obj) { using (NewElasticBankContext db = new NewElasticBankContext()) { try { Task task = db.Tasks.SqlQuery("dbo.SelectTaskById @TaskId='" + obj.TaskId.ToString() + "'").Single(); if (task != null) { db.Tasks.Remove(task); #region Database Submission try { db.SaveChanges(); return true; } catch (Exception ex) { return false; } #endregion } else { return false; } } catch (Exception ex) { return false; } } }
public Boolean deleteRecommendedJob(RecommendedJob obj) { using (NewElasticBankContext db = new NewElasticBankContext()) { try { RecommendedJob rec_job = db.RecommendedJobs.SqlQuery("dbo.SelectRecommendedJobByJobIdAndRecruiteeId @JobId='" + obj.JobId.ToString() + "' @RecruiteeId='" + obj.RecruiteeId.ToString() + "'").Single(); if (rec_job != null) { db.RecommendedJobs.Remove(rec_job); #region Database Submission try { db.SaveChanges(); return true; } catch (Exception ex) { return false; } #endregion } else { return false; } } catch (Exception ex) { return false; } } }
public Boolean updateTask(Task obj) { using (NewElasticBankContext db = new NewElasticBankContext()) { try { Task task = db.Tasks.SqlQuery("dbo.SelectTaskById @TaskId='" + obj.TaskId.ToString() + "'").Single(); if (task != null) { task.JobId = obj.JobId; task.RecruiteeId = obj.RecruiteeId; task.TaskDescription = obj.TaskDescription; task.Rating = obj.Rating; #region Database Submission with Rollback try { db.SaveChanges(); return true; } catch (Exception ex) { return false; } #endregion } else { return false; } } catch (Exception ex) { return false; } } }