public ListRepairs2LoadAdapter(Context context) { this.context = context; using (var recordset = new DynamicRS(query, Values.gDatos)) { recordset.Open(); ListElements = recordset.ToList().Select(r => new Repair() { UnitNumber = r["UnitNumber"].ToString().Trim(), RepairCode = r["RepairCode"].ToString().Trim(), Flags = r["Flags"].ToString().Trim() }).ToList(); //(from r in _RS.ToList() select r["RepairCode"] + "|" + r["UnitNumber"]).ToList<string>(); recordset.Close(); } }
public override void NotifyDataSetChanged() { base.NotifyDataSetChanged(); LoadLabel.Text = Loads.Label; using (var recordset = new DynamicRS(query, Values.gDatos)) { recordset.Open(); ListElements = recordset.ToList().Select(r => new Repair() { UnitNumber = r["UnitNumber"].ToString().Trim(), RepairCode = r["RepairCode"].ToString().Trim(), Flags = r["Flags"].ToString().Trim() }).ToList(); //(from r in _RS.ToList() select r["RepairCode"] + "|" + r["UnitNumber"]).ToList<string>(); recordset.Close(); } }
public fDNS() { InitializeComponent(); var _RS = new DynamicRS("Select server=cmp_varchar from datosEmpresa where codigo='BIND_SERVER'", Values.gDatos); try { _RS.Open(); } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } txtServerName.Value = _RS["server"]; _RS.Close(); _RS = null; txtUser.Focus(); }
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(); } }
private void btnProcess_Click(object sender, EventArgs e) { try { if (MessageBox.Show("This will update the DNS server assignments and will restart the service.\n Are you sure? ", "Info", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { string _serverDNS = txtServerName.Text; var _SP = new SP(Values.gDatos, "pGetContador"); _SP.AddParameterValue("@Contador", 0); _SP.AddParameterValue("@Serv", ""); _SP.AddParameterValue("@Codigo", "BIND_SERIAL"); _SP.Execute(); var _serial = _SP.Parameters["@Contador"].Value.ToString(); _SP = null; string _tmpFile = System.IO.Path.GetTempPath() + "local.hosts"; string _configFile = "$ttl 38400\n"; _configFile += "local. IN SOA valsrv02. informatica.espackeuro.com. (\n"; _configFile += " "+ _serial + "\n"; _configFile += " 10800\n"; _configFile += " 3600\n"; _configFile += " 604800\n"; _configFile += " 38400 )\n"; _configFile += "local. IN NS valsrv02.\n"; //create the temp File var _RSD = new DynamicRS("Select entry from vDNSFile order by entry", Values.gDatos); _RSD.Open(); while (!_RSD.EOF) { _configFile += _RSD["entry"] + "\n"; _RSD.MoveNext(); } //_configFile += "\t}\n"; _RSD.Close(); File.WriteAllText(_tmpFile, _configFile); lblMsg.Text = "File created OK."; //move the file to the server using (var client = new SftpClient(_serverDNS, txtUser.Text, txtPassword.Text)) { lblMsg.Text = "Connecting the server."; client.Connect(); lblMsg.Text = "Server Connected!"; client.ChangeDirectory("/var/lib/bind/"); using (var fileStream = new FileStream(_tmpFile, FileMode.Open)) { client.BufferSize = 4 * 1024; // bypass Payload error large files client.UploadFile(fileStream, Path.GetFileName(_tmpFile)); } lblMsg.Text = "File updated!"; client.Disconnect(); } //restart the dhcp service using (var client = new SshClient(_serverDNS, txtUser.Text, txtPassword.Text)) { client.Connect(); client.RunCommand("service bind9 reload"); lblMsg.Text = "DNS Service reloaded!"; client.Disconnect(); } MessageBox.Show("The process has finished correctly.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnProcess_Click(object sender, EventArgs e) { try { 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) { string _serverDHCP = txtServerName.Text; string _tmpFile = System.IO.Path.GetTempPath() + cboCOD3.Text + "_NET.conf"; string _configFile = ""; //create the temp File var _RSD = new DynamicRS("Select * from vDHCPConfig where COD3='" + cboCOD3.Text + "'", Values.gDatos); _RSD.Open(); 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(); File.WriteAllText(_tmpFile, _configFile); lblMsg.Text = "File created OK."; //move the file to the server using (var client = new SftpClient(_serverDHCP, txtUser.Text, txtPassword.Text)) { lblMsg.Text = "Connecting the server."; client.Connect(); lblMsg.Text = "Server Connected!"; client.ChangeDirectory("/etc/dhcp/"); using (var fileStream = new FileStream(_tmpFile, FileMode.Open)) { client.BufferSize = 4 * 1024; // bypass Payload error large files client.UploadFile(fileStream, Path.GetFileName(_tmpFile)); } lblMsg.Text = "File updated!"; client.Disconnect(); } //restart the dhcp service using (var client = new SshClient(_serverDHCP, txtUser.Text, txtPassword.Text)) { client.Connect(); client.RunCommand("service isc-dhcp-server restart"); lblMsg.Text = "DHCP Service restarted!"; client.Disconnect(); } MessageBox.Show("The process has finished correctly.", "Info", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }