public void AddDocument(DocumentModel doc) { doc.Tables.Add(doc.HeadTable); Document dbDoc = new Document(); using (var db = new practiceEntities()) { db.Configuration.AutoDetectChangesEnabled = false; dbDoc.Acts = ConvertActsToDbActs(doc.Acts); dbDoc.Tables = ConvertToDbTables(doc.Tables); db.Documents.Add(dbDoc); db.ChangeTracker.DetectChanges(); db.SaveChanges(); } }
public string ExportToExcel(DocumentModel document,string savePath) { savePath = savePath + Path.GetRandomFileName().Replace('.', 'a') + ".xlsx"; myApp = new Excel.Application(); myApp.Visible = false; myBook = myApp.Workbooks.Add(); mySheet = (Excel.Worksheet)myBook.Sheets[1]; var lastRow = mySheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell).Row; WriteHeadTable(document.HeadTable, ref lastRow); WriteActs(document.Acts, ref lastRow); WriteTables(document.Tables, ref lastRow); mySheet.Columns.AutoFit(); myBook.SaveAs(savePath, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); myBook.Close(false); myApp.Quit(); return savePath; }