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);
}
