public void Update(DS_SafeQuestion SafeQuestion) { using (var ct = new DS_SafeQuestionDataContext(DbHelperSQL.Connection)) { ct.DS_SafeQuestion.Attach(SafeQuestion, true); ct.SubmitChanges(); } }
public void Add(DS_SafeQuestion SafeQuestion) { using (var ct = new DS_SafeQuestionDataContext(DbHelperSQL.Connection)) { ct.DS_SafeQuestion.InsertOnSubmit(SafeQuestion); ct.SubmitChanges(); } }
public void Delete(int ID) { using (var ct = new DS_SafeQuestionDataContext(DbHelperSQL.Connection)) { DS_SafeQuestion st = ct.DS_SafeQuestion.Single(a => a.ID == ID); ct.DS_SafeQuestion.DeleteOnSubmit(st); ct.SubmitChanges(); } }
public void InsertOrUpdate(DS_SafeQuestion SafeQuestion) { using (var ct = new DS_SafeQuestionDataContext(DbHelperSQL.Connection)) { var md = ct.DS_SafeQuestion.SingleOrDefault(a => a.MemberID.Equals(SafeQuestion.MemberID)); if (object.Equals(md, null)) { ct.DS_SafeQuestion.InsertOnSubmit(SafeQuestion); } else { md.Question1 = SafeQuestion.Question1; md.Answer1 = SafeQuestion.Answer1; } ct.SubmitChanges(); } }