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 DeleteMachine(string MachineID)
{
wsSQLResult result = new wsSQLResult();
try
{
HomeNetworkDataContext dc = new HomeNetworkDataContext();
Machines_HNM machine = dc.Machines_HNMs.Where(m => m.MachineID == MachineID).FirstOrDefault();
if (machine == null)
{
result.WasSuccessful = -3;
result.Exception = "Could not find a [Machines_HNM] record with ID: " + MachineID.ToString();
return(result);
}
dc.Machines_HNMs.DeleteOnSubmit(machine);
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 DeleteNetDevice(string NetDeviceID)
{
wsSQLResult result = new wsSQLResult();
try
{
HomeNetworkDataContext dc = new HomeNetworkDataContext();
NetworkDevices_HNND netDevice = dc.NetworkDevices_HNNDs.Where(n => n.NetworkDeviceID == NetDeviceID).FirstOrDefault();
if (netDevice == null)
{
result.WasSuccessful = -3;
result.Exception = "Could not find a [NetworkDevices_HNND] record with ID: " + NetDeviceID.ToString();
return(result);
}
dc.NetworkDevices_HNNDs.DeleteOnSubmit(netDevice);
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 DeleteUser(string UserID)
{
wsSQLResult result = new wsSQLResult();
try
{
HomeNetworkDataContext dc = new HomeNetworkDataContext();
Users_HNU user = dc.Users_HNUs.Where(u => u.UserID == UserID).FirstOrDefault();
if (user == null)
{
result.WasSuccessful = -3;
result.Exception = "Could not find a [Users_HNU] record with ID: " + UserID.ToString();
return(result);
}
dc.Users_HNUs.DeleteOnSubmit(user);
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
}
}
public wsSQLResult InsertNewMachine(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();
Machines machine = jss.Deserialize <Machines>(JSONdata);
if (machine == 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
Machines_HNM newMachine = new Machines_HNM()
{
MachineID = machine.MachineID,
MachineName = machine.MachineName,
MacAddress = machine.MacAddress,
IPaddress = machine.IPaddress,
Static = Convert.ToBoolean(machine.Static),
MachineTypeID = machine.MachineTypeID,
NetworkDeviceID = machine.NetworkDeviceID,
LocationID = machine.LocationID,
HostName = machine.HostName
};
dc.Machines_HNMs.InsertOnSubmit(newMachine);
dc.SubmitChanges();
result.WasSuccessful = 1;
result.Exception = "";
return(result);
}
catch (Exception ex)
{
result.WasSuccessful = 0;
result.Exception = ex.Message;
return(result);
}
}
public wsSQLResult UpdateMachine(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();
Machines machine = jss.Deserialize <Machines>(JSONdata);
if (machine == null)
{
// Error: Couldn't deserialize JSON String
result.WasSuccessful = 0;
result.Exception = "Unable to deserialize the JSON data.";
return(result);
}
HomeNetworkDataContext dc = new HomeNetworkDataContext();
Machines_HNM currentMach = dc.Machines_HNMs.Where(m => m.MachineID == machine.MachineID).FirstOrDefault();
if (currentMach == null)
{
// Couldnt Find User to Update
result.WasSuccessful = -3;
result.Exception = "Could not find a [Machines_HNU] record with ID: " + machine.MachineID.ToString();
return(result);
}
// Update Record to SQL Server Table
currentMach.MachineID = machine.MachineID;
currentMach.MachineName = machine.MachineName;
currentMach.MacAddress = machine.MacAddress;
currentMach.IPaddress = machine.IPaddress;
currentMach.Static = Convert.ToBoolean(machine.Static);
currentMach.MachineTypeID = machine.MachineTypeID;
currentMach.NetworkDeviceID = machine.NetworkDeviceID;
currentMach.LocationID = machine.LocationID;
currentMach.HostName = machine.HostName;
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 UpdateNetDevice(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();
NetworkDevices netDevice = jss.Deserialize <NetworkDevices>(JSONdata);
if (netDevice == null)
{
// Error: Couldn't deserialize JSON String
result.WasSuccessful = 0;
result.Exception = "Unable to deserialize the JSON data.";
return(result);
}
HomeNetworkDataContext dc = new HomeNetworkDataContext();
NetworkDevices_HNND currentDevice = dc.NetworkDevices_HNNDs.Where(n => n.NetworkDeviceID == netDevice.NetworkDeviceID).FirstOrDefault();
if (currentDevice == null)
{
// Couldnt Find User to Update
result.WasSuccessful = -3;
result.Exception = "Could not find a [NetworkDevices_HNND] record with ID: " + netDevice.NetworkDeviceID.ToString();
return(result);
}
// Update Record to SQL Server Table
currentDevice.NetworkDeviceID = netDevice.NetworkDeviceID;
currentDevice.NetworkDeviceName = netDevice.NetworkDeviceName;
currentDevice.MacAddress = netDevice.MacAddress;
currentDevice.IPaddress = netDevice.IPaddress;
currentDevice.NetworkDeviceTypeID = netDevice.NetworkDeviceTypeID;
currentDevice.NetworkPorts = netDevice.NetworkPorts;
currentDevice.LocationID = netDevice.LocationID;
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 InsertNewUser(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();
Users user = jss.Deserialize <Users>(JSONdata);
if (user == 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
Users_HNU newUser = new Users_HNU()
{
UserID = user.UserID,
FirstName = user.FirstName,
LastName = user.LastName,
Password = user.Password,
MachineID = user.MachineID
};
dc.Users_HNUs.InsertOnSubmit(newUser);
dc.SubmitChanges();
result.WasSuccessful = 1;
result.Exception = "";
return(result);
}
catch (Exception ex)
{
result.WasSuccessful = 0;
result.Exception = ex.Message;
return(result);
}
}
public wsSQLResult UpdateUser(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();
Users user = jss.Deserialize <Users>(JSONdata);
if (user == null)
{
// Error: Couldn't deserialize JSON String
result.WasSuccessful = 0;
result.Exception = "Unable to deserialize the JSON data.";
return(result);
}
HomeNetworkDataContext dc = new HomeNetworkDataContext();
Users_HNU currentUser = dc.Users_HNUs.Where(u => u.UserID == user.UserID).FirstOrDefault();
if (currentUser == null)
{
// Couldnt Find User to Update
result.WasSuccessful = -3;
result.Exception = "Could not find a [Users_HNU] record with ID: " + user.UserID.ToString();
return(result);
}
// Update Record to SQL Server Table
currentUser.UserID = user.UserID;
currentUser.FirstName = user.FirstName;
currentUser.LastName = user.LastName;
currentUser.Password = user.Password;
currentUser.MachineID = user.MachineID;
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
}
}
