async void SaverInterface.SaveToExcel(EntityCords entity)
{
await Task.Run(() =>
{
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
Workbook excelWorkBook = excelApp.Workbooks.Add();
Worksheet excelWorkSheet = excelWorkBook.Worksheets.Add();
List <double> CordsY = entity.GetListY();
List <double> CordsT = entity.GetListT();
int length = CordsT.Count();
excelWorkSheet.Columns[1].Rows[1] = "Step";
excelWorkSheet.Columns[2].Rows[1] = "T";
excelWorkSheet.Columns[3].Rows[1] = "Y (T)";
AddT(CordsT, excelWorkSheet);
AddY(CordsY, excelWorkSheet);
AddStep(length, excelWorkSheet);
CreateChart(length, excelWorkSheet);
excelWorkSheet.SaveAs(@"E:\courseWork\CourseProject\CourseWork\CourseWork\exports\excel.xlsx");
excelApp.Quit();
PlayDoneSound();
});
}
private String CreateInfo(EntityCords entity)
{
String info = " R0 = " + entity.GetR() + "\n P = " + entity.GetP() + "\n b = " + entity.GetB() + "\n h = " + entity.GetH() +
"\n l = " + entity.GetL() + "\n E = " + entity.GetE() + "\n t0 = " + entity.GetT0() + "\n th = " + entity.GetTH() + "\n tk = " +
entity.GetTK();
return(info);
}
//////////////////////////BUTTON CALCULATE/////////////////////////
private void button1_Click(object sender, EventArgs e)
{
PlayClickSound();
try
{
toolStripButton1.Enabled = true;
contextMenuStrip1.Enabled = true;
contextMenuStrip1.Items[0].Enabled = true;
button2.Enabled = true;
double r0 = ReadInfoFromTextBox(textBox1);
double P = ReadInfoFromTextBox(textBox2);
double b = ReadInfoFromTextBox(textBox3);
double h = ReadInfoFromTextBox(textBox4);
double l = ReadInfoFromTextBox(textBox5);
double E = ReadInfoFromTextBox(textBox6) * 10e10;
double t0 = ReadInfoFromTextBox(textBox7);
double tk = ReadInfoFromTextBox(textBox8);
double th = ReadInfoFromTextBox(textBox9);
entity = new EntityCords(r0, P, b, h, l, E, t0, tk, th);
chart1.Series[0].Points.Clear();
dataGridView1.Rows.Clear();
entity.Clear();
Calculate();
button5.Enabled = true;
toolStrip1.Items[2].Enabled = true;
contextMenuStrip1.Items[1].Enabled = true;
}
catch (Exception exception)
{
PlayExceptionSound();
MessageBox.Show("Something wrong with \nyour input data.");
}
}
async void SaverInterface.SaveToWord(EntityCords entity, System.Windows.Forms.DataVisualization.Charting.Chart chart)
{
SaveImage(chart);
await Task.Run(() =>
{
Microsoft.Office.Interop.Word.Application oneWord = new Microsoft.Office.Interop.Word.Application();
var oneDoc = oneWord.Documents.Add();
var paragraphone = oneDoc.Content.Paragraphs.Add();
String info = CreateInfo(entity);
paragraphone.Range.Text = info;
oneWord.ActiveDocument.Sections[1].Headers[Microsoft.Office.Interop.Word.WdHeaderFooterIndex.wdHeaderFooterPrimary].Range.InlineShapes.AddPicture(@"E:\courseWork\CourseProject\CourseWork\CourseWork\pictures\graphic.png");
oneDoc.SaveAs2(@"E:\courseWork\CourseProject\CourseWork\CourseWork\exports\word.docx");
oneWord.Quit();
PlayDoneSound();
});
}
