//THIS IS AN UPDATE public bool commitUpdate(Guid _QuestionID, string _THISname, string _THISimage, int _THIScalories, int _THISfat, string _THATname, string _THATimage, int _THATcalories, int _THATfat, string _Answer) { healthToolsDataContext objQuiz = new healthToolsDataContext(); try { //updating a single row at a time which row depends on the _id var objUpQuiz = objQuiz.brdhc_HealthTools_Quizs.Single(x => x.QuestionID == _QuestionID); objUpQuiz.THISname = _THISname; //Up for update objUpQuiz.THISimage = _THISimage; objUpQuiz.THIScalories = _THIScalories; objUpQuiz.THISfat = _THISfat; objUpQuiz.THATname = _THATname; objUpQuiz.THATimage = _THATimage; objUpQuiz.THATcalories = _THATcalories; objUpQuiz.THATfat = _THATfat; objUpQuiz.Answer = _Answer; objQuiz.SubmitChanges(); //on submit use objQuiz return true; } catch (Exception e) { clsCommon.saveError(e); return false; } }
//THIS IS AN INSERT public bool commitInsert(string _THISname, string _THISimage, int _THIScalories, int _THISfat, string _THATname, string _THATimage, int _THATcalories, int _THATfat, string _Answer) { healthToolsDataContext objQuiz = new healthToolsDataContext(); try { brdhc_HealthTools_Quiz objNewQuiz = new brdhc_HealthTools_Quiz(); objNewQuiz.THISname = _THISname; objNewQuiz.THISimage = _THISimage; objNewQuiz.THIScalories = _THIScalories; objNewQuiz.THISfat = _THISfat; objNewQuiz.THATname = _THATname; objNewQuiz.THATimage = _THATimage; objNewQuiz.THATcalories = _THATcalories; objNewQuiz.THATfat = _THATfat; objNewQuiz.Answer = _Answer; objQuiz.brdhc_HealthTools_Quizs.InsertOnSubmit(objNewQuiz); objQuiz.SubmitChanges(); //this will commit the changes return true; //boolean } catch (Exception e) { clsCommon.saveError(e); return false; } }
//THIS IS A DELETE public bool commitDelete(Guid _QuestionID) { healthToolsDataContext objQuiz = new healthToolsDataContext(); try { var objDelCan = objQuiz.brdhc_HealthTools_Quizs.Single(x => x.QuestionID == _QuestionID); objQuiz.brdhc_HealthTools_Quizs.DeleteOnSubmit(objDelCan); //if you want to delete all best to drop the table objQuiz.SubmitChanges(); return true; } catch (Exception e) { clsCommon.saveError(e); return false; } }