public MainWindow()
{
InitializeComponent();
objSQL = new DB_MySQL("sql7.freesqldatabase.com", 3306, "sql7338923", "sql7338923", "bc9vSYmu5u");
objSQL.openSessionMySQL();
}
/*
* Метод для публикации данных в бд
*/
public void pushDB()
{
string strCellData = "";
double douCellData;
DB_MySQL objSQL = new DB_MySQL("sql7.freesqldatabase.com", 3306, "sql7338923", "sql7338923", "bc9vSYmu5u");
objSQL.openSessionMySQL();
int rowCnt = 0; //строка
int colCnt = 0; //столбец
int[] mass = new int[10];
DataTable dt = new DataTable();
string FlightDate = ""; // new DateTime();
string ScheduledTime = "", FlightNumber = ""; //= new TimeSpan();
int AirlineCode = 0;
string CodeA = "", FlagArrivalDeparture = "", TypeAircraft = "", AParking = "", ParkingSector = "", NameAirline = "";
for (rowCnt = 1; rowCnt <= excelRange.Rows.Count; rowCnt++)
{
string strData = "";
for (colCnt = 1; colCnt <= excelRange.Columns.Count; colCnt++)
{
switch (colCnt)
{
case 1:
douCellData = (excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2;
FlightDate = DateTime.FromOADate(douCellData).ToString("yyyy-MM-dd");
break;
case 2:
douCellData = (excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2;
ScheduledTime = DateTime.FromOADate(douCellData).ToLongTimeString().ToString();
break;
case 3:
CodeA = (string)(excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2;
break;
case 4:
AirlineCode = (int)(excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2;
break;
case 5:
FlightNumber = (string)(excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2;
break;
case 6:
FlagArrivalDeparture = Convert.ToString((excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2);
break;
case 7:
TypeAircraft = Convert.ToString((excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2);
break;
case 8:
AParking = Convert.ToString((excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2);
break;
case 9:
ParkingSector = Convert.ToString((excelRange.Cells[rowCnt, colCnt] as Microsoft.Office.Interop.Excel.Range).Value2);
break;
}
}
objSQL.CreatingNewRowTimetable(FlightDate, ScheduledTime, CodeA, AirlineCode, FlightNumber, FlagArrivalDeparture, TypeAircraft, AParking, ParkingSector, NameAirline);
}
objSQL.closeSessionMySQL();
excelBook.Close(true, null, null);
excelApp.Quit();
}
