private Device GetContacts(string id) { var device= new Device { DeviceId = id, Contacts = GetContactList (id) }; return device; }
private void Push(Device device) { _conn = new MySqlConnection (_db); try { _conn.Open (); if (device.Apps != null) foreach (var app in device.Apps) { var query = String.Format ("INSERT INTO apps (ID,AppID,PackageName,Name,Visible) VALUES(\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\") ON DUPLICATE KEY UPDATE Visible=\"{3}\";", device.DeviceId, app.AppId, app.PackageName, app.Title, app.Visible); var cmd = new MySqlCommand (query, _conn); cmd.ExecuteScalar (); } if (device.Contacts != null) foreach (var contact in device.Contacts) { var query = String.Format ("INSERT INTO contacts (ID,Contact_ID,LastName,FirstName,Number,TxtAmount,TxtMax,CallAmount,CallMax) VALUES(\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\",\"{8}\") ON DUPLICATE KEY UPDATE SurName=\"{2}\",Name=\"{3}\",Number=\"{4}\",TxtAmount=\"{5}\",TxtMax=\"{6}\",CallAmount=\"{7}\",CallMax=\"{8}\";", device.DeviceId, contact.ContactId, contact.LastName, contact.FirstName, contact.Number, contact.TxtAmount, contact.TxtMax, contact.CallAmount, contact.CallMax); var cmd = new MySqlCommand (query, _conn); cmd.ExecuteScalar (); } if (device.Locations != null) foreach (var coordinate in device.Locations) { var query = String.Format ("INSERT INTO coordinates (ID,Pos_ID,Latitude,Longitude) VALUES(\"{0}\",\"{1}\",\"{2}\",\"{3}\") ON DUPLICATE KEY UPDATE Latitude=\"{2}\",Longitude=\"{3}\";", device.DeviceId, coordinate.PosId, coordinate.Latitude, coordinate.Longitude); var cmd = new MySqlCommand (query, _conn); cmd.ExecuteScalar (); } } catch (Exception e) { Program.WriteInfo (String.Format ("{0} | Error | SQL Error: {1}", DateTime.Now.ToString ("yyyy-MM-d HH:mm:ss"), e.Message)); } _conn.Close (); }
private Device GetApps(string id) { var device= new Device { DeviceId = id, Apps = GetAppList (id) }; return device; }