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 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
}
}
