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