public IHttpActionResult GetBusinessPartnerFull(long id) { DataTable general = new DataTable(); DataTable bankInfo = new DataTable(); DataTable contactNumbers = new DataTable(); DataTable contactPerson = new DataTable(); DataTable emails = new DataTable(); DataTable products = new DataTable(); using (var context = new DhoniEnterprisesEntities()) { general = DataTableSerializer.LINQToDataTable(context.uspGetBPGeneral(id)); bankInfo = DataTableSerializer.LINQToDataTable(context.uspGetBPBank(id)); contactNumbers = DataTableSerializer.LINQToDataTable(context.uspGetBPContactNumber(id)); contactPerson = DataTableSerializer.LINQToDataTable(context.uspGetBPContact(id)); emails = DataTableSerializer.LINQToDataTable(context.uspGetBPEmails(id)); products = DataTableSerializer.LINQToDataTable(context.uspGetBPProducts(id)); return(Ok(new { success = true, gen = general, bank = bankInfo, contNum = contactNumbers, contPers = contactPerson, emails = emails, products = products })); } }
public List <DimSumBondSummary> GetDimSumBondSummary(DateTime start, DateTime end, string category, string unit, string columnType, string TypeValue) { var table = GetDimSumBondSummaryTable(start, end, category, unit, columnType, TypeValue); var pResult = DataTableSerializer.ToList <DimSumBondSummary>(table); //For sovr item if (category == ConstValues.Option_Asset_Type && (TypeValue == "all" || TypeValue == "Sovr")) { var govItem = pResult.Where(b => b.Type == "Gov").Select(b => b).FirstOrDefault(); var agenItem = pResult.Where(b => b.Type == "Agen").Select(b => b).FirstOrDefault(); var sovrItem = AddTwoDimSumBondSummary(govItem, agenItem); var re = pResult.ToList(); re.Add(sovrItem); return(re.OrderBy(b => b.Order).ToList()); } if (category == ConstValues.Option_Indu) { return(pResult.Where(b => b.Issues != 0 || b.MaturityBonds != 0).Select(b => b).OrderBy(b => b.Order).ToList()); } return(pResult.OrderBy(b => b.Order).ToList()); }
public ViewDTO GetCachedView(string sessionId, long layoutId, string lang) { try { m_ViewSemaphore.Wait(); Console.WriteLine(" Waited {0} tics for the semaphore", (DateTime.Now.Ticks - m_Ticks) / 100000 * 100000); Thread.Sleep(100); byte[] viewBytes = BinarySerializer.SerializeFromString(SerializedViewStub.ViewXml); byte[] viewZippedBytes = BinaryCompressor.Zip(viewBytes); DataTable sourceData = DataTableSerializer.Deserialize(SerializedViewStub.DataXml); BaseTableDTO serializedDTO = BinarySerializer.SerializeFromTable(sourceData); BaseTableDTO zippedDTO = BinaryCompressor.Zip(serializedDTO); var result = new ViewDTO(zippedDTO, viewZippedBytes); return(result); } finally { m_ViewSemaphore.Release(); } }
public static List <CoalTrafficPortChartEntity> GetCoalTrafficPortData(string key) { const string proName = "CoalTrafficPort_ChartData"; var paras = new[] { new OracleParameter("P_key", key), new OracleParameter("P_CUR", OracleDbType.RefCursor) { Direction = ParameterDirection.Output } }; var chartTable = new DataTable(); using (var cnE = new CNE_ZCXNewEntities()) { using (var spCmd = new OracleCommand()) { cnE.Database.Connection.Open(); spCmd.Connection = (OracleConnection)(cnE.Database.Connection); spCmd.CommandText = proName; spCmd.CommandType = CommandType.StoredProcedure; spCmd.CommandTimeout = 0; spCmd.Parameters.AddRange(paras); var da = new OracleDataAdapter(spCmd); da.Fill(chartTable); } } return(DataTableSerializer.ToList <CoalTrafficPortChartEntity>(chartTable)); }
/// <summary> /// get bond issue amount statistical data /// </summary> /// <param name="param"></param> /// <returns></returns> public IEnumerable <BondIssueAmount> GetBondIssueAmountNew(BondIssueAmountParams param) { var table = GetBondIssueAmountDtNew(param.Type, param.StartDate, param.EndDate, param.Unit, string.Join(",", param.TypeList.ToArray()), param.UseSubType ? 1 : 0, param.SubType); var pResult = DataTableSerializer.ToList <BondIssueAmount>(table); return(pResult); }
public Dictionary <int, List <TabNode> > GetGDTTabNodes() { var dicTabs = new Dictionary <int, List <TabNode> >(); var paramArray = new[] { new OracleParameter("O_CUR", OracleDbType.RefCursor) { Direction = ParameterDirection.Output } }; DataSet dataSet = GetDataSetBySpFromCma("GetGDTTabNodes", paramArray); List <TabNode> tabNodes = DataTableSerializer.ToList <TabNode>(dataSet.Tables[0]); foreach (var item in tabNodes) { if (dicTabs.ContainsKey(item.ReportId)) { dicTabs[item.ReportId].Add(item); } else { var itemList = new List <TabNode> { item }; dicTabs.Add(item.ReportId, itemList); } } return(dicTabs); }
/// <summary> /// Get bond detail data /// </summary> /// <param name="param"></param> /// <returns></returns> public IEnumerable <BondDetail> GetBondDetailByTypeAndSubType(BondDetailParams param) { var table = GetIssueAmountBondDetailByTypeAndSubType(param); var pResult = DataTableSerializer.ToList <BondDetail>(table); return(pResult); }
public List <BallanceFilter> GetAreaFilters(int reportId, string productCode) { var ds = new DataTable(); var paras = new[] { new OracleParameter("P_reportID", reportId), new OracleParameter("P_ProductCode", productCode), new OracleParameter("P_CUR", OracleDbType.RefCursor) { Direction = ParameterDirection.Output } }; using (var zcxDb = new CNE_ZCXNewEntities()) { using (var spCmd = new OracleCommand()) { zcxDb.Database.Connection.Open(); spCmd.Connection = (OracleConnection)zcxDb.Database.Connection; spCmd.CommandText = "GetAreaFiltes"; spCmd.CommandType = CommandType.StoredProcedure; spCmd.CommandTimeout = 0; spCmd.Parameters.AddRange(paras); var da = new OracleDataAdapter(spCmd); da.Fill(ds); } } return(DataTableSerializer.ToList <BallanceFilter>(ds)); }
public List <PartitionBallanceTableData> GetPartitionBallenceData(string areaCode, string productCode, List <string> years) { var ds = new DataTable(); var paras = new[] { new OracleParameter("P_AreaCode", areaCode), new OracleParameter("P_productCode", productCode), new OracleParameter("P_myear1", years[2]), new OracleParameter("P_myear2", years[1]), new OracleParameter("P_myear3", years[0]), new OracleParameter("P_CUR", OracleDbType.RefCursor) { Direction = ParameterDirection.Output } }; using (var zcxDb = new CNE_ZCXNewEntities()) { using (var spCmd = new OracleCommand()) { zcxDb.Database.Connection.Open(); spCmd.Connection = (OracleConnection)zcxDb.Database.Connection; spCmd.CommandText = "GetPartitionBallenceData"; spCmd.CommandType = CommandType.StoredProcedure; spCmd.CommandTimeout = 0; spCmd.Parameters.AddRange(paras); var da = new OracleDataAdapter(spCmd); da.Fill(ds); } } return(DataTableSerializer.ToList <PartitionBallanceTableData>(ds)); }
public List <SelectListItem> GetQueryConditionContent(string columnName, string tableName, string queryFilter, string relationColumn = null, string relationValue = null) { var condition = new List <SelectListItem>(); var paras = new List <OracleParameter> { new OracleParameter("tableName", tableName), new OracleParameter("queryFilter", queryFilter), new OracleParameter("relationcolumn", columnName), new OracleParameter("O_CUR", OracleDbType.RefCursor) { Direction = ParameterDirection.Output } }; DataSet set; set = GetDataSetBySp("GetQueryConditionContent", paras.ToArray()); var strList = DataTableSerializer.ToList <QueryItem>(set.Tables[0]); foreach (QueryItem str in strList) { var exists = condition.Any(it => it.Text == str.DisplayName); if (!exists) { var item = new SelectListItem { Text = str.DisplayName, Value = str.ItemText_EN }; condition.Add(item); } } return(condition); }
public IHttpActionResult getSingleTransaction(long id) { DataTable transaction = new DataTable(); using (var context = new DhoniEnterprisesEntities()) { //transaction = DataTableSerializer.LINQToDataTable(context.uspGetTransaction(id)); var basic = context.uspGetTransaction(id); var comm = basic.GetNextResult <DataTable>(); var contract = basic.GetNextResult <DataTable>(); var sec = basic.GetNextResult <DataTable>(); var ship = basic.GetNextResult <DataTable>(); var status = basic.GetNextResult <DataTable>(); var notes = basic.GetNextResult <DataTable>(); return(Ok(new { success = true, basic = DataTableSerializer.LINQToDataTable(basic), comm = DataTableSerializer.LINQToDataTable(comm), contract = DataTableSerializer.LINQToDataTable(contract), sec = DataTableSerializer.LINQToDataTable(sec), ship = DataTableSerializer.LINQToDataTable(ship), status = DataTableSerializer.LINQToDataTable(status), notes = DataTableSerializer.LINQToDataTable(notes) })); } }
/// <summary> /// 成功改变一行的值 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Row_ChangedEvent(object sender, DataRowChangeEventArgs e) { if (isLoadingData) { return; } DataTable dt = (DataTable)sender; if (VocationTableRowCountSet.ContainsKey(dt)) { if (VocationTableRowCountSet[dt] != dt.Rows.Count) { m_IDIDAllocator.AcceptAlloc(); } DataRow row = e.Row; DeleteTableEvent(dt); DataTableSerializer.FillDefaultRow(ref row, dt); AddTableEvent(dt); ChangedRowWithVocation(row, dt); UpdateVocationTableRowCountSet(); } }
public IHttpActionResult getBPDropDown([FromBody] JObject bpType) { var BPType = Convert.ToString(bpType["type"]); DataTable data = new DataTable(); using (var context = new DhoniEnterprisesEntities()) { if (BPType == "Buyer") { data = DataTableSerializer.LINQToDataTable(context.uspGetDropDownBuyer()); } else if (BPType == "Seller") { data = DataTableSerializer.LINQToDataTable(context.uspGetDropDownSeller()); } else if (BPType == "Shipper") { data = DataTableSerializer.LINQToDataTable(context.uspGetDropDownShipper()); } else if (BPType == "Broker") { data = DataTableSerializer.LINQToDataTable(context.uspGetDropDownBroker()); } return(Ok(new { success = true, data = data, type = BPType })); } }
/// <summary> /// 导出spelllogic脚本到csv /// </summary> /// <param name="fullPatch"></param> /// <returns></returns> public DataTableSerializer.FileExportReslut ExportSpellLogicToCsv(string fullPatch) { if (null == mConditionEditor) { mConditionEditor = SpellEditorForm.Instance.mConditionEditor; mEffectEditor = SpellEditorForm.Instance.mEffectEditor; } DataTable t = new DataTable(); if (!EncodeSpellLogicDataTable(ref t, mLogicTree)) { return(DataTableSerializer.FileExportReslut.RESLUT_ERROR); } string[] headerText = new string[2]; headerText[0] = "技能ID,事件ID,客户端条件列表,客户端效果列表,服务器条件列表,服务器效果列表"; headerText[1] = "int,int,string,string,string,string"; if (t.Rows.Count <= 0) { Trace.Warring("文件为空:" + fullPatch); return(DataTableSerializer.FileExportReslut.RESLUT_EMPTYFILE); } if (!DataTableSerializer.SaveToCSV(t, fullPatch, headerText)) { Trace.Error("文件导出失败:" + fullPatch); return(DataTableSerializer.FileExportReslut.RESLUT_ERROR); } Trace.Normal("文件导出成功:" + fullPatch); return(DataTableSerializer.FileExportReslut.RESLUT_OK); }
public void Setup() { _saveFilter = new SaveFilter(); _dataTableSerializer = new DataTableSerializer( _saveFilter, new LegacyRijndaelCryptographyProvider(), new SecureString()); }
public IHttpActionResult getUserDetails(string email) { using (var context = new DhoniEnterprisesEntities()) { var curUser = DataTableSerializer.LINQToDataTable(context.uspGetAppUserByEmail(email)); return(Ok(new { success = true, user = curUser })); } }
public IHttpActionResult GetAppUsers() { using (var context = new DhoniEnterprisesEntities()) { var allUsers = DataTableSerializer.LINQToDataTable(context.getAllUsers()); return(Ok(new { success = true, user = allUsers })); } }
public IHttpActionResult GetProductsPricesByDate([FromBody] JObject date) { using (var context = new DhoniEnterprisesEntities()) { var productPrices = context.uspGetProductPriceByDate(Convert.ToDateTime(date["date"])); return(Ok(new { success = true, productPrices = DataTableSerializer.LINQToDataTable(productPrices) })); } }
/// <summary> /// 单元格数据验证 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private static void grid_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { DataGridView dv = (DataGridView)sender; DataGridViewCell dc = dv[e.ColumnIndex, e.RowIndex]; DataTable dt = (DataTable)dv.DataSource; string s = e.FormattedValue.ToString(); if (e.ColumnIndex > dt.Columns.Count || e.RowIndex > dt.Rows.Count) { return; } if (string.IsNullOrEmpty(s)) { dv.Rows[e.RowIndex].ErrorText = null; return; } //是按钮,跳过 if (DataTableSerializer.IsDataGridViewButton(dv.Columns[e.ColumnIndex].GetType())) { return; } try { //特殊处理枚举 if (DataTableSerializer.IsEnum(dt.Columns[e.ColumnIndex].DataType)) { Type enumType = dt.Columns[e.ColumnIndex].DataType; string[] enumNames = Enum.GetNames(enumType); // 载入事件类型中文描述 FieldInfo[] enumfields = enumType.GetFields(); for (int i = 1; i < enumfields.Length; i++) { FieldInfo f = enumfields[i]; enumNames[enumfields.Length - i - 1] = WrapperReflection.getFieldDesc(f); } if (!enumNames.Contains(s) && enumType != typeof(VOCATION)) //职业类型不做改检测,因为DESC的中文跟配置的已经不同了。。 { Trace.Error("枚举值无效!"); e.Cancel = true; } } else { Convert.ChangeType(s, dt.Columns[e.ColumnIndex].DataType); } dv.Rows[e.RowIndex].ErrorText = null; } catch (Exception) { Trace.Error("输入不合法!当前单元格类型需要:" + dc.ValueType.ToString() + ",输入值:" + e.FormattedValue.ToString() + ",请重新输入!"); dv.Rows[e.RowIndex].ErrorText = "第" + e.ColumnIndex.ToString() + "个输入不合法,类型为:" + dc.ValueType.ToString(); e.Cancel = true; } }
public IHttpActionResult GetProductsPricesByDateForDashboard([FromBody] JObject date) { using (var context = new DhoniEnterprisesEntities()) { int userId = BasicAuthHttpModule.getCurrentUserId(); var productPrices = context.uspGetProductPriceByDateForDashBoard(Convert.ToDateTime(date["date"]), userId); return(Ok(new { success = true, productPrices = DataTableSerializer.LINQToDataTable(productPrices) })); } }
public IEnumerable <DimBondInfo> GetDimSumBondList(DateTime start, DateTime end, string category, bool isEnglishCulture) { _log.Error("GetDimSumBondList Start: " + DateTime.Now); var table = GetDimSumBond(start, end, category); var bondList = DataTableSerializer.ToList <DimBondInfo>(table); _log.Error("GetDimSumBondList finish: " + DateTime.Now); return(bondList ?? new List <DimBondInfo>()); }
public void LoadTableWithConstraintsTest() { ResetTestTables(); using (var datSer = new DataTableSerializer(DataSerTestHelper.DataToolsConnectionString)) { var result = datSer.ImportTable(@"Resources\person.xml"); DataSerTestHelper.AssertResult(result); DataSerTestHelper.AssertConstraintsAreEnabledAndTrusted(); } }
public List <v_bondClass> GetAssetClass() { var paramArray = new[] { new OracleParameter("cur", OracleDbType.RefCursor, ParameterDirection.Output) }; var table = GetDataSetBySpFromBondDB("GetBondClass", paramArray).Tables[0]; return(DataTableSerializer.ToList <v_bondClass>(table)); }
public void SerializeZipViewTableTest() { DataTable sourceData = DataTableSerializer.Deserialize(SerializedViewStub.DataXml); BaseTableDTO serializedDTO = BinarySerializer.SerializeFromTable(sourceData, 10000); BaseTableDTO zippedDTO = BinaryCompressor.Zip(serializedDTO); BaseTableDTO unzippedDTO = BinaryCompressor.Unzip(zippedDTO); DataTable resultData = BinarySerializer.DeserializeToTable(unzippedDTO); AssertTablesAreEqual(sourceData, resultData); }
private void UpdateConnectionsTable(ContainerInfo rootTreeNode, SqlDatabaseConnector sqlDatabaseConnector) { var sqlQuery = new SqlCommand("DELETE FROM tblCons", sqlDatabaseConnector.SqlConnection); sqlQuery.ExecuteNonQuery(); var serializer = new DataTableSerializer(_saveFilter); var dataTable = serializer.Serialize(rootTreeNode); var dataProvider = new SqlDataProvider(sqlDatabaseConnector); dataProvider.Save(dataTable); }
public IHttpActionResult GetTransactionStatus(long transactionId) { using (var context = new DhoniEnterprisesEntities()) { var status = DataTableSerializer.LINQToDataTable(context.uspGetTransactionStatus(transactionId)); return(Ok(new { success = true, status = status })); } }
public IHttpActionResult GetTransactionByParameter(string parameter, string textInput, DateTime?dateInput) { using (var context = new DhoniEnterprisesEntities()) { var transactions = DataTableSerializer.LINQToDataTable(context.uspGetTransactionByParameter(parameter, textInput, (DateTime?)(dateInput))); return(Ok(new { success = true, transactions = transactions })); } }
public void GenerateTestTables() { var datSer = new DataTableSerializer(DataSerTestHelper.DataToolsConnectionString); var folder = Directory.CreateDirectory("Export"); var result = datSer.ExportTable("Job", string.Format(@"{0}\{1}", folder.FullName, "Job.xml")); DataSerTestHelper.AssertResult(result); result = datSer.ExportTable("Person", string.Format(@"{0}\{1}", folder.FullName, "Person.xml")); DataSerTestHelper.AssertResult(result); result = datSer.ExportTable("Tools", string.Format(@"{0}\{1}", folder.FullName, "Tools.xml")); DataSerTestHelper.AssertResult(result); Console.Write(string.Format("tables written to: {0}", folder.FullName)); }
public IHttpActionResult getTransactionNotesList(long transactionId) { using (var context = new DhoniEnterprisesEntities()) { var Notes = DataTableSerializer.LINQToDataTable(context.uspGetTransactionNotes(transactionId)); return(Ok(new { success = true, notes = Notes })); } }
private void ConditionSerachIDButton_Click(object sender, EventArgs e) { //Table索引 DataTable FoundTable = null; //Table的行索引 int Rowindex = 0; bool bFound = false; foreach (DataTable ta in mConditionSet.Values) { FoundTable = ta; foreach (DataRow dr in FoundTable.Rows) { if (dr[0].Equals(SerachID)) { bFound = true; break; } Rowindex++; } if (bFound) { break; } Rowindex = 0; } if (bFound) { string tableName = mConditionReSet[FoundTable]; Type t = WrapperReflection.gAssembly.GetType(ServerWapperConditionNameSpace + tableName); if (t == null) { t = WrapperReflection.gAssembly.GetType(ClientWapperConditionNameSpace + tableName); if (t == null) { return; } } this.ConditionDesc.Text = WrapperReflection.getDesc(t); ConditionSerachBox.Text = WrapperReflection.getDesc(t); DataTableSerializer.BuildDataGridViewFromDataTable(ref conditionList, mConditionSet[tableName], t); DataTableSerializer.FillDataGridViewFromDataTable(ref conditionList, mConditionSet[tableName]); DataTableSerializer.AddButtonToDataGridView(ref conditionList, InsetButtonHeaderText, InsetButtonHeaderText, ConditionInsetButtonCallBack); conditionList.Rows[Rowindex].Selected = true; } else { Trace.Error("找不到条件ID"); } }
/// <summary> /// Csv确认框 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void CsvFilecheckBox_CheckedChanged(object sender, EventArgs e) { if (CsvFilecheckBox.Checked) { BinFileCheckBox.Checked = false; DataTableSerializer.SetFileType(DataTableSerializer.FileType.FILETYPE_CSV); } else { BinFileCheckBox.Checked = true; } }
public IHttpActionResult getTransactionFiles(long transactionId) { using (var context = new DhoniEnterprisesEntities()) { var files = context.uspTransactionFileGetAll(transactionId); return(Ok(new { success = true, files = DataTableSerializer.LINQToDataTable(files) })); } }
public void ImportEntireDatabase() { var datSer = new DataTableSerializer(DataSerTestHelper.DataDiffConnectionString); var paths = Directory.GetFiles("FolderDTC").Except( new[] {@"FolderDTC\Production.Document.xml" , @"FolderDTC\Production.ProductDocument.xml" }); var sw = new Stopwatch(); sw.Start(); var result = datSer.ImportTables(paths); DataSerTestHelper.AssertResult(result); sw.Stop(); Debug.WriteLine(sw.Elapsed); }
public void SpecialSchemaTest() { using (var conn = new SqlConnection(DataSerTestHelper.DataToolsConnectionString)) { const string tableName = "BulkLoadTestTableSpecial"; conn.ExecSql(string.Format("DELETE FROM {0}", tableName)); var datSer = new DataTableSerializer(DataSerTestHelper.DataToolsConnectionString); var result = datSer.ImportTable(string.Format(@"resources\dbo.{0}.xml", tableName)); DataSerTestHelper.AssertResult(result); var tableData = conn.ExecQuery(string.Format("SELECT * FROM {0}", tableName)); Assert.AreEqual(3, tableData.Rows.Count); } }
public void LoadStandaloneTableTest() { using (var conn = new SqlConnection(DataSerTestHelper.DataToolsConnectionString)) { var sql = File.ReadAllText(@"SQL\reset_tools_table.sql"); conn.ExecSql(sql); } using (var datSer = new DataTableSerializer(DataSerTestHelper.DataToolsConnectionString)) { var result = datSer.ImportTableWithoutBulkCopy(@"Resources\Tools.xml"); DataSerTestHelper.AssertResult(result); } }
public void DifferentSchemaTest() { using (var conn = new SqlConnection(DataSerTestHelper.DataToolsConnectionString)) { conn.ExecSql(File.ReadAllText(@"SQL\reset_BulkLoadTestTable1.sql")); var datSer = new DataTableSerializer(DataSerTestHelper.DataToolsConnectionString); var result = datSer.ImportTable(@"resources\dbo.BulkLoadTestTable1.xml"); DataSerTestHelper.AssertResult(result); var tableData = conn.ExecQuery("SELECT * FROM BulkLoadTestTable1"); Assert.AreEqual(3, tableData.Rows.Count); var firstRowData = tableData.Rows[0].ItemArray; CollectionAssert.AreEqual(new object[] {1, "Alpha", 11, DBNull.Value}, firstRowData); } }
public void LoadTableWithConstraintsWithBadDataTest() { ResetTestTables(); using (var datSer = new DataTableSerializer(DataSerTestHelper.DataToolsConnectionString)) { var result = datSer.ImportTable(@"Resources\person-missing-bob.xml"); Assert.IsFalse(result.Success); } DataSerTestHelper.AssertConstraintsAreEnabledAndTrusted(); // make sure all the rows are still there. CollectionAssert.AreEquivalent(new[] { "Bob", "Alice", "Ted" }, new SqlConnection(DataSerTestHelper.DataToolsConnectionString).ExecQuery("SELECT person from person").Rows.Cast<DataRow>().Select(r => r.Field<string>("person"))); }
public override ReturnValue ExportTables(string exportFolder) { if (!Directory.Exists(exportFolder)) { return ReturnValue.FailResult(string.Format("Exporting tables"), new DirectoryNotFoundException( string.Format("The export folder '{0}' does not exist.", exportFolder))); } return ReturnValue.Wrap(() => { var dataSer = new DataTableSerializer(ConnStr); foreach (string tableName in TableList) { var path = Path.Combine(exportFolder, string.Format("{0}.xml", tableName)); dataSer.ExportTable(tableName, path).AbortOnFail(); } }, string.Format("Exporting to folder '{0}'.", exportFolder)); }
public override ReturnValue<string[]> ImportTables(string connStr) { return ReturnValue<string[]>.Wrap(() => { var dataSer = new DataTableSerializer(connStr); dataSer.ImportTables(AvailableFiles).AbortOnFail(); return AvailableFiles; }, "Importing tables"); }
public void Setup() { _saveFilter = new SaveFilter(); _dataTableSerializer = new DataTableSerializer(_saveFilter); }
public void Teardown() { _saveFilter = null; _dataTableSerializer = null; }
private void UpdateConnectionsTable(ContainerInfo rootTreeNode, SqlDatabaseConnector sqlDatabaseConnector) { var sqlQuery = new SqlCommand("DELETE FROM tblCons", sqlDatabaseConnector.SqlConnection); sqlQuery.ExecuteNonQuery(); var serializer = new DataTableSerializer(SaveFilter); var dataTable = serializer.Serialize(rootTreeNode); var dataProvider = new SqlDataProvider(sqlDatabaseConnector); dataProvider.Save(dataTable); }