/// <summary> /// The Set. /// </summary> /// <param name="SqlConnectString">The SqlConnectString<see cref="string"/>.</param> /// <param name="cards">The cards<see cref="IFigures"/>.</param> /// <param name="Renew">The Renew<see cref="bool"/>.</param> /// <returns>The <see cref="IDeck{IDeck{IFigure}}"/>.</returns> public IDeck <IDeck <IFigure> > Set(string SqlConnectString, IFigures cards, bool Renew) { try { if (sqaf == null) { sqaf = new Sqlbase(SqlConnectString); } try { bool buildmap = true; if (cards.Count > 0) { BulkPrepareType prepareType = BulkPrepareType.Drop; if (Renew) { prepareType = BulkPrepareType.Trunc; } var ds = sqaf.Update(cards, true, buildmap, true, null, prepareType); if (ds != null) { IFigures im = (IFigures)Summon.New(cards.GetType()); im.Rubrics = cards.Rubrics; im.FigureType = cards.FigureType; im.FigureSize = cards.FigureSize; im.Add(ds["Failed"].AsValues()); return(sqaf.Insert(im, true, false, prepareType)); } else { return(null); } } return(null); } catch (SqlException ex) { throw ex; } } catch (Exception ex) { throw ex; } }
/// <summary> /// The UpdateSummation. /// </summary> /// <returns>The <see cref="MemberRubrics"/>.</returns> public MemberRubrics UpdateSummation() { AggregateOperand parsed = new AggregateOperand(); summaryRubrics = new MemberRubrics(); Figure summaryFigure = new Figure(figures.Rubrics.AsValues().Where(c => (c.RubricName.Split('=').Length > 1 || (c.SummaryOperand != AggregateOperand.None))).Select(c => (new MemberRubric(c) { SummaryRubric = (c.SummaryRubric != null) ? c.SummaryRubric : (c.RubricName.Split('=').Length > 1) ? new MemberRubric(c) { RubricName = c.RubricName.Split('=')[1] } : null, SummaryOperand = (Enum.TryParse(c.RubricName.Split('=')[0], true, out parsed)) ? parsed : c.SummaryOperand })).ToArray(), "Summary_" + figures.GetType().Name); figures.Summary = summaryFigure.Combine(); summaryRubrics = (MemberRubrics)summaryFigure.Rubrics; return(summaryRubrics); }