public Computer CreateComputer(string token, Computer item)
{
if (item.UserId == 0)
throw new ArgumentException("Computer must have a user Id");
var request = new RestRequest(ApiPath + ComputerPath, Method.POST);
request.AddParameter(Auth, token);
var json = item.ToJSON();
request.AddParameter("computer", json);
var response = Client.Execute(request);
if (response.StatusCode != HttpStatusCode.OK)
Console.WriteLine("Status Code Error: {0}", response.StatusCode);
var compjson = JObject.Parse(response.Content);
Computer comp = null;
try
{
comp = JsonConvert.DeserializeObject<Computer>(compjson[ComputerKey].ToString());
}
catch (Exception e)
{
Console.WriteLine(response.Content);
Console.WriteLine(e);
}
return comp;
}
public Computer ForceUpdate()
{
var dbcomputer = DbManager.GetComputer();
IPAddress[] localIPs = Dns.GetHostAddresses(Dns.GetHostName());
String MyIp = localIPs[0].ToString();
if (dbcomputer == null)
{
var computer = new Computer
{
CreatedAt = DateTime.Now,
Name = Environment.MachineName,
Enviroment = OS.StringName,
IpAddress = MyIp,
UpdatedAt = DateTime.Now
};
return DbManager.SaveComputer(computer);
}
return null;
}
public Computer UpdateComputer(Computer computer)
{
using (SQLiteConnection conn = new SQLiteConnection(UrlBuilder.ToString()))
{
conn.Open();
if (computer == null)
throw new NullReferenceException("Computer cant be null");
computer.Id = 1;
StringBuilder sb = new StringBuilder();
sb.Append(Update);
sb.Append(ComputersTable);
sb.Append(Set);
sb.Append("WebId=@webId, UserId=@userId, Name=@name, Enviroment=@enviroment, IpAddress=@ipAddress, UpdatedAt=@updatedAt");
sb.Append(Where);
sb.Append("Id = " + computer.Id);
sb.Append(End);
var command = new SQLiteCommand(sb.ToString(), conn);
command.Parameters.Add(new SQLiteParameter("@webId", computer.WebId));
command.Parameters.Add(new SQLiteParameter("@userId", computer.UserId));
command.Parameters.Add(new SQLiteParameter("@name", computer.Name));
command.Parameters.Add(new SQLiteParameter("@enviroment", computer.Enviroment));
command.Parameters.Add(new SQLiteParameter("@ipAddress", computer.IpAddress));
command.Parameters.Add(new SQLiteParameter("@updatedAt", DateTime.Now));
Console.WriteLine(sb.ToString());
command.ExecuteNonQuery();
}
return GetComputer();
}
public Computer SaveComputer(Computer comp)
{
using (SQLiteConnection conn = new SQLiteConnection(UrlBuilder.ToString()))
{
conn.Open();
if (comp == null)
throw new NoNullAllowedException("Computer can't be null");
StringBuilder sb = new StringBuilder();
Console.WriteLine("Saving a Computer");
sb.Append(InsertInto);
sb.Append(ComputersTable);
sb.Append("(UserId, Name, Enviroment, IpAddress, CreatedAt, UpdatedAt)");
sb.Append(Values);
sb.Append("(@userid, @name, @enviroment, @ipaddress, @createdAt, @updatedAt)");
sb.Append(End);
var command = new SQLiteCommand(sb.ToString(), conn);
command.Parameters.Add(new SQLiteParameter("@userid", comp.UserId));
command.Parameters.Add(new SQLiteParameter("@name", comp.Name));
command.Parameters.Add(new SQLiteParameter("@enviroment", comp.Enviroment));
command.Parameters.Add(new SQLiteParameter("@ipaddress", comp.IpAddress));
command.Parameters.Add(new SQLiteParameter("@createdAt", DateTime.Now));
command.Parameters.Add(new SQLiteParameter("@updatedAt", DateTime.Now));
Console.WriteLine(sb.ToString());
command.ExecuteNonQuery();
Console.WriteLine("Done Saving a computer");
}
return GetComputer();
}
public Computer GetComputer()
{
Computer comp = null;
using (SQLiteConnection conn = new SQLiteConnection(UrlBuilder.ToString()))
{
conn.Open();
StringBuilder sb = new StringBuilder();
sb.Append(SelectAll);
sb.Append(ComputersTable);
sb.Append(End);
var reader = new SQLiteCommand(sb.ToString(), conn).ExecuteReader(CommandBehavior.SingleResult);
while (reader.Read())
{
comp = new Computer
{
Id = Convert.ToInt32(reader["Id"]),
UserId = Convert.ToInt32(reader["UserId"]),
WebId = Convert.ToInt32(reader["WebId"]),
Enviroment = Convert.ToString(reader["Enviroment"]),
Name = Convert.ToString(reader["Name"]),
IpAddress = Convert.ToString(reader["IpAddress"]),
CreatedAt = Convert.ToDateTime(reader["CreatedAt"]),
UpdatedAt = Convert.ToDateTime(reader["UpdatedAt"])
};
}
}
return comp;
}
