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