public wsSQLResult deleteTestDbItem(string TestDbItemID)
{
wsSQLResult result = new wsSQLResult();
try
{
narfdaddy2DataContext dc = new narfdaddy2DataContext();
NoteWriterItem item = dc.NoteWriterItems.Where(s => s.numRow == Int32.Parse(TestDbItemID)).FirstOrDefault();
if (item == null)
{
// We couldn't find a [Customer] record with this ID.
result.WasSuccessful = -3;
result.Exception = "Could not find a [ListBuilder1] record with ID: " + TestDbItemID.ToString();
return(result);
}
dc.NoteWriterItems.DeleteOnSubmit(item);
dc.SubmitChanges();
result.WasSuccessful = 1;
result.Exception = "";
return(result); // Success !
}
catch (Exception ex)
{
result.WasSuccessful = -1;
result.Exception = "An exception occurred: " + ex.Message;
return(result); // Failed.
}
}
public wsSQLResult addUserItems(Stream JSONdataStream)
{
wsSQLResult result = new wsSQLResult();
try
{
// Read in our Stream into a string...
StreamReader reader = new StreamReader(JSONdataStream);
string JSONdata = reader.ReadToEnd();
// ..then convert the string into a single "wsCustomer" record.
JavaScriptSerializer jss = new JavaScriptSerializer();
var root = jss.Deserialize <List <wsNoteWriterItem> >(JSONdata);
if (root == null)
{
// Error: Couldn't deserialize our JSON string into a "wsCustomer" object.
result.WasSuccessful = 0;
result.Exception = "Unable to deserialize the JSON data.";
return(result);
}
narfdaddy2DataContext dc = new narfdaddy2DataContext();
foreach (var item in root)
{
NoteWriterItem newCustomer = new NoteWriterItem()
{
usr = item.usr,
cat = item.cat,
subcat = item.subcat,
item = item.item,
dialog = item.dialog
};
dc.NoteWriterItems.InsertOnSubmit(newCustomer);
dc.SubmitChanges();
}
result.WasSuccessful = 1;
result.Exception = "";
return(result);
}
catch (Exception ex)
{
result.WasSuccessful = 0;
result.Exception = ex.Message;
return(result);
}
}
partial void UpdateNoteWriterItem(NoteWriterItem instance);
partial void DeleteNoteWriterItem(NoteWriterItem instance);
partial void InsertNoteWriterItem(NoteWriterItem instance);