public override async Task <bool> process() { var _xconn = xmlMsgIn.Data.Element("connection"); //get the connection data string _dataBase = _xconn.Element("DataBase").Value.ToString(); //get the database var _server = new cServer(_xconn.Element("server")); //create the server object from the connection data string _sql = xmlMsgIn.Data.Element("sql").Value.ToString(); //get the sql using (var _conn = new cAccesoDatosNet(_server, _dataBase)) //create the normal connection using (var _rs = new DynamicRS(_sql, _conn)) // create the normal recordset { try { await _rs.OpenAsync(); //execute the recordset xmlMsgOut = _rs.XMLData; //create the msgout xml data xmlMsgOut.Root.Name = "result"; } catch (Exception ex) { xmlMsgOut = XDocument.Parse((new XElement("result", "ERROR: " + ex.Message)).ToString()); //returns error } } MsgOut = xmlMsgOut.ToString(); return(true); }
public override async void OnCreate(Bundle savedInstanceState) { base.OnCreate(savedInstanceState); //constructor stuff cImageFileList = new ListImageFile(); cUnitNumber = UnitRepair.cUnitNumber; cRepairCode = UnitRepair.cRepairCode; cCount = 0; using (var _rs = new DynamicRS("Select FileName,FilePath,Thumbnail,len=len(Thumbnail),IdPicture from PicturesRepairs where RepairCode='" + cRepairCode + "' and UnitNumber='" + cUnitNumber + "' order by xfec", Values.gDatos)) { await _rs.OpenAsync(); while (!_rs.EOF) { Bitmap _bm = BitmapFactory.DecodeByteArray((byte[])_rs["Thumbnail"], 0, Convert.ToInt32(_rs["len"])); ImageFile elFile = new ImageFile(_rs["FileName"].ToString(), _bm); elFile.IdPicture = _rs["IdPicture"].ToString(); await cImageFileList.Add(elFile); _rs.MoveNext(); } } //cRSOld.Open("Select FileName,FilePath,Thumbnail,len=len(Thumbnail),IdPicture from PicturesRepairs where RepairCode='" + cRepairCode + "' and UnitNumber='" + cUnitNumber + "' order by xfec", Values.gDatos); //while (!cRSOld.EOF) //{ // Bitmap _bm = BitmapFactory.DecodeByteArray((byte[])cRSOld["Thumbnail"], 0, Convert.ToInt32(cRSOld["len"])); // ImageFile elFile = new ImageFile(cRSOld["FileName"].ToString(), _bm); // elFile.IdPicture = cRSOld["IdPicture"].ToString(); // await cImageFileList.Add(elFile); // cRSOld.MoveNext(); //} //cRSOld.Close(); // }
private async void btnProcess_Click(object sender, EventArgs e) { if (MessageBox.Show("This will update the DHCP server assignments and will restart the service.\n Are you sure? ", "Info", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { foreach (var server in serverList1.ListServers.Where(s => s.CheckBox.Checked == true)) { string _configFile = ""; //create the temp File using (var _RSD = new DynamicRS("Select * from vDHCPConfig where COD3='" + server.Info.COD3 + "'", Values.gDatos)) { await _RSD.OpenAsync(); string _group = ""; while (!_RSD.EOF) { if (_RSD["Group"].ToString() != _group) { if (_group != "") { _configFile += "\t}\n"; } _group = _RSD["Group"].ToString(); _configFile += "# " + _group + '\n' + "group " + _group + "{" + '\n'; } _configFile += "\t# " + _RSD["Comment"].ToString() + '\n'; _configFile += "\thost " + _RSD["Host"].ToString() + " {" + '\n'; _configFile += "\t\thardware ethernet " + _RSD["MAC"].ToString() + ";" + '\n'; _configFile += "\t\tfixed-address " + _RSD["IP"].ToString() + ";" + '\n'; _configFile += "\t\t}\n"; _RSD.MoveNext(); } _configFile += "\t}\n"; _RSD.Close(); } server.Info.FileName = string.Format("/etc/dhcp/{0}_NET.conf", server.Info.COD3); server.Info.FileContent = _configFile; } //execute tasks await serverList1.ExecuteCommandInServers(); } }