public wsSQLResult DeleteRouterSetup(string SetupID) { wsSQLResult result = new wsSQLResult(); try { HomeNetworkDataContext dc = new HomeNetworkDataContext(); RouterSetups_HNR rs = dc.RouterSetups_HNRs.Where(r => r.SetupID == SetupID).FirstOrDefault(); if (rs == null) { result.WasSuccessful = -3; result.Exception = "Could not find a [RouterSetups_HNR] record with ID: " + SetupID.ToString(); return(result); } dc.RouterSetups_HNRs.DeleteOnSubmit(rs); 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 InsertNewRouterSetup(Stream JSONdataStream) { wsSQLResult result = new wsSQLResult(); try { //Read JSON Stream into a String.. StreamReader reader = new StreamReader(JSONdataStream); string JSONdata = reader.ReadToEnd(); // Convert to New User record.. JavaScriptSerializer jss = new JavaScriptSerializer(); RouterSetups rs = jss.Deserialize <RouterSetups>(JSONdata); if (rs == null) { // Error: Couldn't deserialize JSON String result.WasSuccessful = 0; result.Exception = "Unable to deserialize the JSON data."; return(result); } HomeNetworkDataContext dc = new HomeNetworkDataContext(); //if (user.UserID == Convert.ToString(dc.Users_HNUs.Where(i => i.UserID == user.UserID).FirstOrDefault())) //{ // // User Already Exists // return -3; //} // Insert Record to SQL Server Table RouterSetups_HNR newRS = new RouterSetups_HNR() { SetupID = rs.SetupID, SetupName = rs.SetupName, Name = rs.Name, IPaddress = rs.IPaddress, UserID = rs.UserID, Password = rs.Passwd, SSID24 = rs.SS24, Password24 = rs.PW24, SSID50 = rs.SS50, Password50 = rs.PW50, EncryptionType = rs.EncryptionType, Mode = rs.Mode, Comments = rs.Comments }; dc.RouterSetups_HNRs.InsertOnSubmit(newRS); dc.SubmitChanges(); result.WasSuccessful = 1; result.Exception = ""; return(result); } catch (Exception ex) { result.WasSuccessful = 0; result.Exception = ex.Message; return(result); } }
public wsSQLResult UpdateRouterSetup(Stream JSONdataStream) { wsSQLResult result = new wsSQLResult(); try { //Read JSON Stream into a String.. StreamReader reader = new StreamReader(JSONdataStream); string JSONdata = reader.ReadToEnd(); // Convert to New User record.. JavaScriptSerializer jss = new JavaScriptSerializer(); RouterSetups rs = jss.Deserialize <RouterSetups>(JSONdata); if (rs == null) { // Error: Couldn't deserialize JSON String result.WasSuccessful = 0; result.Exception = "Unable to deserialize the JSON data."; return(result); } HomeNetworkDataContext dc = new HomeNetworkDataContext(); RouterSetups_HNR currentRS = dc.RouterSetups_HNRs.Where(r => r.SetupID == rs.SetupID).FirstOrDefault(); if (currentRS == null) { // Couldnt Find User to Update result.WasSuccessful = -3; result.Exception = "Could not find a [RouterSetups_HNR] record with ID: " + rs.SetupID.ToString(); return(result); } // Update Record to SQL Server Table currentRS.SetupID = rs.SetupID; currentRS.SetupName = rs.SetupName; currentRS.Name = rs.Name; currentRS.IPaddress = rs.IPaddress; currentRS.UserID = rs.UserID; currentRS.Password = rs.Passwd; currentRS.SSID24 = rs.SS24; currentRS.Password24 = rs.PW24; currentRS.SSID50 = rs.SS50; currentRS.Password50 = rs.PW50; currentRS.EncryptionType = rs.EncryptionType; currentRS.Mode = rs.Mode; currentRS.Comments = rs.Comments; 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 } }