/// <summary>
/// The BulkInsert.
/// </summary>
/// <param name="table">The table<see cref="IFigures"/>.</param>
/// <param name="keysFromDeckis">The keysFromDeckis<see cref="bool"/>.</param>
/// <param name="buildMapping">The buildMapping<see cref="bool"/>.</param>
/// <param name="updateKeys">The updateKeys<see cref="bool"/>.</param>
/// <param name="updateExcept">The updateExcept<see cref="string[]"/>.</param>
/// <param name="tempType">The tempType<see cref="BulkPrepareType"/>.</param>
/// <returns>The <see cref="IDeck{IDeck{IFigure}}"/>.</returns>
public IDeck <IDeck <IFigure> > BulkInsert(IFigures table, bool keysFromDeckis = false, bool buildMapping = false, bool updateKeys = false, string[] updateExcept = null, BulkPrepareType tempType = BulkPrepareType.Trunc)
{
try
{
IFigures tab = table;
if (tab.Any())
{
IList <FieldMapping> nMaps = new List <FieldMapping>();
if (buildMapping)
{
SqlMapper imapper = new SqlMapper(tab, keysFromDeckis);
}
nMaps = tab.Rubrics.Mappings;
string dbName = _cn.Database;
SqlAdapter afad = new SqlAdapter(_cn);
afad.DataBulk(tab, tab.FigureType.Name, tempType, BulkDbType.TempDB);
_cn.ChangeDatabase(dbName);
IDeck <IDeck <IFigure> > nSet = new Album <IDeck <IFigure> >();
StringBuilder sb = new StringBuilder();
sb.AppendLine(@" /* ---- SQL BANK START CMD ------ */ ");
foreach (FieldMapping nMap in nMaps)
{
sb.AppendLine(@" /* ---- TABLE BULK START CMD ------ */ ");
MemberRubric[] ic = tab.Rubrics.AsValues().Where(c => nMap.ColumnOrdinal.Contains(c.FieldId)).ToArray();
MemberRubric[] ik = tab.Rubrics.AsValues().Where(c => nMap.KeyOrdinal.Contains(c.FieldId)).ToArray();
if (updateExcept != null)
{
ic = ic.Where(c => !updateExcept.Contains(c.RubricName)).ToArray();
ik = ik.Where(c => !updateExcept.Contains(c.RubricName)).ToArray();
}
string qry = BulkInsertQuery(dbName, tab.FigureType.Name, nMap.DbTableName, ic, ik, updateKeys).ToString();
sb.Append(qry);
sb.AppendLine(@" /* ---- TABLE BULK END CMD ------ */ ");
}
sb.AppendLine(@" /* ---- SQL BANK END CMD ------ */ ");
IDeck <IDeck <IFigure> > bIFigures = afad.ExecuteInsert(sb.ToString(), tab, true);
if (nSet.Count == 0)
{
nSet = bIFigures;
}
else
{
foreach (IDeck <IFigure> its in bIFigures.AsValues())
{
if (nSet.Contains(its))
{
nSet[its].Put(its.AsValues());
}
else
{
nSet.Add(its);
}
}
}
sb.Clear();
return(nSet);
}
else
{
return(null);
}
}
catch (SqlException ex)
{
_cn.Close();
throw new SqlInsertException(ex.ToString());
}
}
/// <summary>
/// The BulkDelete.
/// </summary>
/// <param name="table">The table<see cref="IFigures"/>.</param>
/// <param name="keysFromDeckis">The keysFromDeckis<see cref="bool"/>.</param>
/// <param name="buildMapping">The buildMapping<see cref="bool"/>.</param>
/// <param name="tempType">The tempType<see cref="BulkPrepareType"/>.</param>
/// <returns>The <see cref="IDeck{IDeck{IFigure}}"/>.</returns>
public IDeck <IDeck <IFigure> > BulkDelete(IFigures table, bool keysFromDeckis = false, bool buildMapping = false, BulkPrepareType tempType = BulkPrepareType.Trunc)
{
try
{
IFigures tab = table;
if (tab.Any())
{
IList <FieldMapping> nMaps = new List <FieldMapping>();
if (buildMapping)
{
SqlMapper imapper = new SqlMapper(tab, keysFromDeckis);
}
nMaps = tab.Rubrics.Mappings;
string dbName = _cn.Database;
SqlAdapter adapter = new SqlAdapter(_cn);
adapter.DataBulk(tab, tab.FigureType.Name, tempType, BulkDbType.TempDB);
_cn.ChangeDatabase(dbName);
IDeck <IDeck <IFigure> > nSet = new Album <IDeck <IFigure> >();
StringBuilder sb = new StringBuilder();
sb.AppendLine(@" /* ---- SQL BANK START CMD ------ */ ");
foreach (FieldMapping nMap in nMaps)
{
sb.AppendLine(@" /* ---- TABLE BULK START CMD ------ */ ");
string qry = BulkDeleteQuery(dbName, tab.FigureType.Name, nMap.DbTableName).ToString();
sb.Append(qry);
sb.AppendLine(@" /* ---- TABLE BULK END CMD ------ */ ");
}
sb.AppendLine(@" /* ---- SQL BANK END CMD ------ */ ");
IDeck <IDeck <IFigure> > bIFigures = adapter.ExecuteDelete(sb.ToString(), tab, true);
if (nSet.Count == 0)
{
nSet = bIFigures;
}
else
{
foreach (IDeck <IFigure> its in bIFigures.AsValues())
{
if (nSet.Contains(its))
{
nSet[its].Put(its.AsValues());
}
else
{
nSet.Add(its);
}
}
}
sb.Clear();
return(nSet);
}
else
{
return(null);
}
}
catch (SqlException ex)
{
_cn.Close();
throw new SqlDeleteException(ex.ToString());
}
}