private void button3_Click(object sender, EventArgs e)
{
textBox2.Clear();
nt tracer = new nt();
textBox2.Text = tracer.tracert(textBox3.Text);
}
static void Main(string[] args)
{
nt number = int.Parse(Console.ReadLine());
if (number % 10 == 0)
{
Console.WriteLine($"The number is divisible by 10");
}
else if (number % 7 == 0)
{
int sum = 7 % number;
Console.WriteLine($"The number is divisible by 7");
}
else if (number % 6 == 0)
{
int sum = 6 % number;
Console.WriteLine($"The number is divisible by 6");
}
else if (number % 3 == 0)
{
int sum = 3 % number;
Console.WriteLine($"The number is divisible by 3");
}
else if (number % 2 == 0)
{
int sum = 2 % number;
Console.WriteLine($"The number is divisible by 2");
}
else
{
Console.WriteLine("Not divisible");
}
}
public static int GetVowelCount(string str)
{
nt vowelCount = 0;
char[] charInString = str.ToCharArray();
foreach (var item in charInString)
{
if (item == 'a' || item == 'e' || item == 'i' || item == 'o' || item == 'u')
{
vowelCount++;
}
}
return(vowelCount);
}
/// <summary>
///
/// </summary>
/// <param name="pdbId"></param>
/// <param name="entityId"></param>
public void UpdateEntryEntityDbRefData(string pdbId, nt entityId, ref int refId, ref int alignId)
{
string srcType = "";
bool dbAccValid = true;
string[] dbAccessions = GetUnpAccessions(pdbId, entityId, out srcType, true);
try
{
dbAccValid = DoesEntityHaveValidDbAccessions(dbAccessions);
}
catch (Exception ex)
{
string stop = "";
}
if (dbAccValid && srcType != "")
{
updateLogWriter.WriteLine("Update " + pdbId + entityId.ToString () + " from " + srcType);
// delete related data to this entity
DeleteDbRefData(pdbId, entityId);
totalNumOfEntitiesUpdated++;
DataTable residueMapTable = GetEntityResidueMapTable(pdbId, entityId, srcType);
UpdatePdbDbRefInfoFromDifSrc(residueMapTable, ref refId, ref alignId, srcType);
/* if (srcType == "ssmap")
{
UpdatePdbDbRefFromSSmap(residueMapTable, ref refId, ref alignId);
}
else if (srcType == "sws")
{
UpdatePdbDbRefFromSws(residueMapTable, ref refId, ref alignId);
}
*/
dbInsert.InsertDataIntoDBtables(dbRefTable);
dbInsert.InsertDataIntoDBtables(dbRefSeqTable);
dbRefTable.Clear();
dbRefSeqTable.Clear();
}
}
private void timer1_Tick(object sender, EventArgs e)
{
nt first = new nt();
long Result = first.ping(textBox1.Text);
if (period != 0)
{
if (chart1.Series[0].Points.Count > period / numericUpDown1.Value)
{
chart1.Series[0].Points.RemoveAt(0);
}
}
chart1.Series[0].Points.AddXY(DateTime.Now.ToString("HH:mm:ss"), Result);
if (Result > maximum)
{
maximum = Result;
}
if (Result < minimum)
{
minimum = Result;
}
//average = moving_avg(average,Result,count);
count++;
average_ping1 += Result;
average = average_ping1 / count;
label3.Text = count.ToString();
chart1.Series[0].LegendText = textBox1.Text;
label1.Text = $"Текущее:{Result} Min:{minimum} Среднее:{average} Макс:{maximum}";
long Result_eff = first.ping(textBox3.Text);
if (period != 0)
{
if (chart1.Series[1].Points.Count > period / numericUpDown1.Value)
{
chart1.Series[1].Points.RemoveAt(0);
}
}
chart1.Series[1].Points.AddXY(DateTime.Now.ToString("HH:mm:ss"), Result_eff);
if (Result_eff > maximum_eff)
{
maximum_eff = Result_eff;
}
if (Result_eff < minimum_eff)
{
minimum_eff = Result_eff;
}
count_eff++;
average_ping2 += Result_eff;
average_eff = average_ping2 / count_eff;
label4.Text = count_eff.ToString();
//label2.Text = "Всего пакетов " + textBox3.Text;
chart1.Series[1].LegendText = textBox3.Text;
label6.Text = $"Текущее:{Result_eff} Min:{minimum_eff} Среднее:{average_eff} Макс:{maximum_eff}";
if (checkBox1.Checked)
{
LogWrite($"{Application.StartupPath}/{DateTime.Now:yyyyMMdd}-{textBox1.Text}.log", $"{count};{textBox1.Text};{Result};{minimum};{maximum}");
LogWrite($"{Application.StartupPath}/{DateTime.Now:yyyyMMdd}-{textBox3.Text}.log", $"{count_eff};{textBox3.Text};{Result_eff};{minimum_eff};{maximum_eff}");
}
}
static private void executeDAX(Model model)
{
Console.Clear();
showConsoleHeader(model);
myConsoleWriteLine($"Enter or Pick a Query");
string query = getData("Query.dat");
AdomdConnection adomdConnection = new AdomdConnection($"Data Source={model.Database.Parent.ConnectionString};Initial catalog={model.Database.Name}");
AdomdCommand adomdCommand = new AdomdCommand(query, adomdConnection);
adomdConnection.Open();
String queryResultFileName = $"{appFolder}QueryResult-{Guid.NewGuid()}.tsv";
List <string> list = new List <string>();
bool hasHeader = false;
try {
AdomdDataReader reader = adomdCommand.ExecuteReader();
while (reader.Read())
{
String rowResults = "";
/*****************************************************************************
* Add Header (if needed)
****************************************************************************/
if (!hasHeader)
{
for (nt columnNumber = 0; columnNumber < reader.FieldCount; columnNumber++)
{
if (columnNumber > 0)
{
rowResults += $"\t";
}
rowResults += $"{reader.GetName(columnNumber)}";
}
Console.WriteLine(rowResults);
list.Add(rowResults);
hasHeader = true;
}
/*****************************************************************************
* Add normal line
****************************************************************************/
rowResults = "";
// Create a loop for every column in the current row
for (int columnNumber = 0; columnNumber < reader.FieldCount; columnNumber++)
{
if (columnNumber > 0)
{
rowResults += $"\t";
}
rowResults += $"{reader.GetValue(columnNumber)}";
}
Console.WriteLine(rowResults);
list.Add(rowResults);
}
System.IO.File.WriteAllLines(queryResultFileName, list);
ProcessStartInfo startInfo = new ProcessStartInfo();
bool excelFound = false;
if (File.Exists("C:\\Program Files\\Microsoft Office\\root\\Office16\\EXCEL.EXE"))
{
startInfo.FileName = "C:\\Program Files\\Microsoft Office\\root\\Office16\\EXCEL.EXE";
excelFound = true;
}
else
{
if (File.Exists("C:\\Program Files (x86)\\Microsoft Office\\root\\Office16\\EXCEL.EXE"))
{
startInfo.FileName = "C:\\Program Files (x86)\\Microsoft Office\\root\\Office16\\EXCEL.EXE";
excelFound = true;
}
}
if (excelFound)
{
startInfo.Arguments = queryResultFileName;
Process.Start(startInfo);
}
}
catch (Exception ex) {
Console.WriteLine(ex.Message);
Console.ReadKey();
}
adomdConnection.Close();
}
