public void SaveSettingsData(string SettingsXML)
{
var query = (from S in DB.dtSettingLookups
where S.Code == "APP"
select S).FirstOrDefault();
if (query.Code == "APP")
{
query.Value = SettingsXML;
DB.SubmitChanges();
}
else
{
dtSettingLookup APP = new dtSettingLookup
{
Code = "APP",
Value = SettingsXML
};
DB.dtSettingLookups.InsertOnSubmit(APP);
DB.SubmitChanges();
}
}
public string LoadSettingsData()
{
var query = (from S in DB.dtSettingLookups
where S.Code == "APP"
select new
{
Value = S.Value
}).FirstOrDefault().Value;
if (string.IsNullOrEmpty(query))
{
dtSettingLookup APP = new dtSettingLookup
{
Code = "APP",
Value = "<>"
};
DB.dtSettingLookups.InsertOnSubmit(APP);
DB.SubmitChanges();
return("<>");
}
return(query);
}
