public wsSQLResult DeleteTestDbItem(string TestDbItemID)
{
wsSQLResult result = new wsSQLResult();
try
{
narfdaddy2DataContext dc = new narfdaddy2DataContext();
ListBuilder1 item = dc.ListBuilder1s.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.ListBuilder1s.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 DeleteCustomer(string customerID)
{
wsSQLResult result = new wsSQLResult();
try
{
NorthwindDataContext dc = new NorthwindDataContext();
Customer cust = dc.Customers.Where(s => s.CustomerID == customerID).FirstOrDefault();
if (cust == null)
{
// We couldn't find a [Customer] record with this ID.
result.WasSuccessful = -3;
result.Exception = "Could not find a [Customer] record with ID: " + customerID.ToString();
return(result);
}
dc.Customers.DeleteOnSubmit(cust);
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 CreateCustomer(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();
wsCustomer cust = jss.Deserialize <wsCustomer>(JSONdata);
if (cust == 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);
}
NorthwindDataContext dc = new NorthwindDataContext();
Customer newCustomer = new Customer()
{
CustomerID = cust.CustomerID,
CompanyName = cust.CompanyName,
City = cust.City
};
dc.Customers.InsertOnSubmit(newCustomer);
dc.SubmitChanges();
result.WasSuccessful = 1;
result.Exception = "";
return(result);
}
catch (Exception ex)
{
result.WasSuccessful = 0;
result.Exception = ex.Message;
return(result);
}
}
public wsSQLResult CreateTestDbItem(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();
wsTestDbItem item = jss.Deserialize <wsTestDbItem>(JSONdata);
if (item == 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();
ListBuilder1 newCustomer = new ListBuilder1()
{
sCat = item.sCat,
sSubcat = item.sSubcat,
sDialog = item.sDialog
};
dc.ListBuilder1s.InsertOnSubmit(newCustomer);
dc.SubmitChanges();
result.WasSuccessful = 1;
result.Exception = "";
return(result);
}
catch (Exception ex)
{
result.WasSuccessful = 0;
result.Exception = ex.Message;
return(result);
}
}
