private void btnImport_Click(object sender, RoutedEventArgs e)
{
OpenFileDialog open = new OpenFileDialog();
open.Filter = "excel files|*.xls;*.xlsx;*.xlsm";
open.ShowDialog();
FileStream stream = new FileStream(open.FileName, FileMode.Open);
IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(stream);
DataSet result = excelReader.AsDataSet();
DataClasses1DataContext conn = new DataClasses1DataContext();
foreach (DataTable table in result.Tables)
{
foreach (DataRow dr in table.Rows)
{
invoceSecond addtable = new invoceSecond()
{
Id = Convert.ToString(dr[0]),
DeliveryDate = Convert.ToString(dr[1]),
DealDate = Convert.ToString(dr[2]),
DealNumber = Convert.ToString(dr[3]),
TIN = Convert.ToString(dr[4]),
BuyerBankName = Convert.ToString(dr[5]),
BuyerBankAccountNumber = Convert.ToString(dr[6]),
GoodDescription = Convert.ToString(dr[7]),
GoodAmount = Convert.ToInt32(dr[8]),
PricePerUnit = Convert.ToInt32(dr[9]),
Price = Convert.ToInt32(dr[10]),
};
conn.invoceSeconds.InsertOnSubmit(addtable);
}
}
conn.SubmitChanges();
excelReader.Close();
stream.Close();
MessageBox.Show("lyox lyava");
}
partial void DeleteinvoceSecond(invoceSecond instance);
partial void UpdateinvoceSecond(invoceSecond instance);
partial void InsertinvoceSecond(invoceSecond instance);
