private void AssignTaskType(string participantName, string plannerName, IList <DataGridCellInfo> selectedCells, string taskTypeName) { try { string day, time; DataTable task = new DataTable(); task.Columns.Add("tvp_Task_Day"); task.Columns.Add("tvp_Task_Time"); task.Columns.Add("tvp_Task_TaskType_Name"); foreach (DataGridCellInfo selectedCell in selectedCells) { day = selectedCell.Column.Header.ToString(); DataGridRow dataGridRow = (DataGridRow)PlannerDataGrid.ItemContainerGenerator.ContainerFromItem(selectedCell.Item); time = dataGridRow.Header.ToString(); DataGridCell dataGridCell = DataGridExtension.GetCell(PlannerDataGrid, dataGridRow.GetIndex(), selectedCell.Column.DisplayIndex); TextBlock textBlock = dataGridCell.Content as TextBlock; textBlock.Text = taskTypeName; task.Rows.Add(day, time, taskTypeName); } DbAdapter.EditTasks(participantName, plannerName, task); } catch (Exception) { throw; } }
public static void RecordPermissions(this SPWeb web, SPWeb caseWeb, DbAdapter dbConnection) { foreach (SPList list in web.Lists) { list.RecordPermissions(caseWeb, dbConnection); } foreach (SPWeb childWeb in web.Webs) { try { if (childWeb.HasUniqueRoleAssignments) { if (dbConnection.IsConnected) { ((SPSecurableObject)childWeb).RecordPermissions(dbConnection, web.Site.ID, caseWeb.ID, childWeb.ID, null, null); } } childWeb.RecordPermissions(caseWeb, dbConnection); } catch (Exception x) { Logger.Instance.Error(string.Format("Failed to record SPWeb permissions at {0}", childWeb.Url), x, DiagnosticsCategories.eCaseExtensions); } finally { childWeb.Dispose(); } } }
private string GetDetails(string participantName, string plannerName) { try { string details = ""; List <string> TasksTypes = ExtractTasksTypes(DbAdapter.GetTasksTypes(participantName, plannerName)); foreach (var taskType in TasksTypes) { DataTable dataTable = DbAdapter.GetOccurrencesNumber(participantName, plannerName, taskType); int occurrencesNumber = Convert.ToInt32(dataTable.Rows[0]["OccurrencesNumber"].ToString()); details += $"{taskType}: {this.Planner.Interval * occurrencesNumber}\n"; } if (!String.IsNullOrEmpty(details)) { return(details.Substring(0, details.Length - 1)); } else { return(null); } } catch (Exception) { throw; } }
static void Main() { string Query = "SELECT * FROM [MyTable]"; //db connection config DbConfigInfo Config = new DbConfigInfo() { ServerAddress = "MyServer", DbName = "MyDb", TrustedConnection = true }; //db adapter for communication DbAdapter Adapter = new DbAdapter() { DbConfig = Config }; //output with data DataTable MyDataTable; if (!Adapter.ExecuteSqlCommandAsTable(Query, out MyDataTable)) { Console.WriteLine("Error Occured!"); Console.ReadLine(); return; } //do actions with your DataTable }
public void LogIn(string participantName, string participantPassword) { if (participantName.Length != 0 && participantPassword.Length != 0) { try { DataTable dataTable = DbAdapter.ParticipantCheck(participantName, participantPassword); if (Convert.ToBoolean(dataTable.Rows[0]["CheckSentence"])) { Participant participant = new Participant(participantName, participantPassword); PanelWindow panelWindow = new PanelWindow(participant); panelWindow.Show(); this.Close(); } else { MessageBox.Show("Bad user name or password"); } } catch (Exception exception) { MessageBox.Show(exception.Message); } } else { MessageBox.Show("All fields must be filled"); } }
private void LockCaseSite(SPListItem caseItem, SPWeb caseWeb, DbAdapter dbAdapter) { CreateSPObjPermSProc sProc; if (caseItem != null) { // Record permissions of the Case list item sProc = new CreateSPObjPermSProc(caseWeb.Site.ID, caseWeb.ID, caseItem.ParentList.ParentWeb.ID, caseItem.ParentList.ID, caseItem.UniqueId, caseItem.RoleAssignments.Xml); dbAdapter.ExecuteNonQueryStoredProcedure(sProc); // Reset permissions of case list item and reconfigure SPUser assignedTo, supervisor; GetAssignedToAndSupervisor(caseItem, out assignedTo, out supervisor); caseItem.ResetRoleInheritance(); LockItemPermissions(caseItem, caseWeb, assignedTo, supervisor); } // Record the permissions of the case web sProc = new CreateSPObjPermSProc(caseWeb.Site.ID, caseWeb.ID, null, null, null, caseWeb.RoleAssignments.Xml); dbAdapter.ExecuteNonQueryStoredProcedure(sProc); caseWeb.RecordPermissions(caseWeb, dbAdapter); // Reset permissions of case web and reconfigure caseWeb.ResetRoleInheritance(); // Recursively redefine all object permissions and force them to inherit parent caseWeb.BreakRoleInheritance(false); // Break at web level and redefine permissions from top->down caseWeb.TryGrantPermission(caseWeb.AssociatedOwnerGroup, SPRoleType.Administrator); caseWeb.TryGrantPermission(caseWeb.AssociatedMemberGroup, SPRoleType.Reader); caseWeb.TryGrantPermission(caseWeb.AssociatedVisitorGroup, SPRoleType.Reader); caseWeb.Update(); }
public DataSet ExecuteSelect(string sql, IEnumerable <DbParameter> parameters) { DbConnection conn = DbAdapter.CreateConnection(ConnectionString); conn.Open(); DbCommand cmd = conn.CreateCommand(); cmd.CommandText = sql; foreach (DbParameter dbParam in parameters) { cmd.Parameters.Add(dbParam); } DataSet ds = new DataSet(); DbDataAdapter adapter = DbAdapter.CreateAdapter(); adapter.SelectCommand = cmd; adapter.Fill(ds); conn.Close(); return(ds); }
public override void Execute(Guid targetInstanceId) { using (SPSite site = new SPSite(new Guid(SiteCollectionGuid))) { string _connectionString = site.RootWeb.Properties[eCaseConstants.PropertyBagKeys.ECASE_DB_CONNECTION_STRING]; using (DbAdapter dbAdapter = new DbAdapter()) { dbAdapter.Connect(_connectionString); try { GetCaseWebsSProc sProc = new GetCaseWebsSProc(new Guid(SiteCollectionGuid)); dbAdapter.ExecuteReaderStoredProcedure(sProc); while (dbAdapter.DataReader.Read()) { string caseWebGuid = dbAdapter.DataReader["CaseWebGuid"].ToString(); try { using (SPWeb caseWeb = site.OpenWeb(new Guid(caseWebGuid))) { CasesNextDueDate.UpdateNextDueDate(caseWeb); /* This method logs errors and consumes them */ } } catch (Exception x) { Logger.Instance.Error(string.Format("UpdateNextDueDate Timer Job Failed to Locate Case Web {0}", caseWebGuid), x, DiagnosticsCategories.eCaseCommon); } } } catch (Exception x) { Logger.Instance.Error(string.Format("UpdateNextDueDate Timer Job Failed for Site Collection {0}", site.Url), x, DiagnosticsCategories.eCaseCommon); } } } }
/// <summary> /// Update specified by identifier entity with new column values /// </summary> /// <param name="entityId">Identifier value</param> /// <param name="newValues">Entity new column values</param> /// <exception cref="ArgumentNullException">Parameter entityId is default</exception> /// <exception cref="ArgumentNullException">Parameter newValues is null or empty</exception> /// <exception cref="Exception">Update command doesn't applied to any record</exception> public void Update(Guid entityId, IDictionary <string, object> newValues) { if (entityId == default) { throw new ArgumentNullException(nameof(entityId)); } if (newValues == null || !newValues.Any()) { throw new ArgumentNullException(nameof(newValues)); } var setStatements = new List <string>(); var arguments = new ExpandoObject(); var argumentsCount = 0; foreach (var pair in newValues.Where(x => !string.IsNullOrEmpty(x.Key) && x.Value != null)) { var isDefaultValue = IsDefaultValue(pair.Value, pair.Value.GetType()); if (!isDefaultValue && EntityFields.Contains(pair.Key) && !DefaultEntityFields.Contains(pair.Key)) { var parameterName = $"@P{argumentsCount + 1}"; if (arguments.TryAdd(parameterName, pair.Value)) { setStatements.Add($"[{pair.Key}] = {parameterName}"); argumentsCount++; } } } if (setStatements.Any()) { var parameterName = $"@P{argumentsCount + 1}"; if (arguments.TryAdd(parameterName, DateTime.UtcNow)) { setStatements.Add($"[ModifiedOn] = {parameterName}"); argumentsCount++; } var setStatement = string.Join(", ", setStatements); if (arguments.TryAdd($"@P{++argumentsCount}", entityId)) { var sqlQuery = $"UPDATE [{TableName}] SET {setStatement} WHERE [Id] = @P{argumentsCount}"; int affectedRows = 0; using (var connection = DbConnectionFactory.CreateDbConnection()) { affectedRows = DbAdapter.Execute(connection, sqlQuery, arguments); } if (affectedRows == 0) { throw new Exception("Update command performed with empty result, no record was updated."); } } } }
private void RenamePlanner(string participantName, string plannerName, string plannerNewName) { if (plannerNewName.Length != 0) { if (plannerName != plannerNewName) { if (!PanelWindow.ExtractPlanners(DbAdapter.GetPlanners(participantName)).Contains(plannerNewName)) { try { DbAdapter.RenamePlanner(participantName, plannerName, plannerNewName); this.Planner.Name = plannerNewName; AdjustControls(); MessageBox.Show("Planner has been renamed"); } catch (Exception exception) { MessageBox.Show(exception.Message); } } else { MessageBox.Show($"Planner {plannerNewName} already exists"); } } else { MessageBox.Show("The planner new name must be different from the current one"); } } else { MessageBox.Show("Planner new name field must be filled"); } }
private void DeleteAccount(string password) { if (password.Length != 0) { if (this.Participant.Password == password) { MessageBoxResult messageBoxResult = MessageBox.Show("Are you sure?", "Delete confirmation", MessageBoxButton.YesNo); if (messageBoxResult == MessageBoxResult.Yes) { try { DbAdapter.DeleteAccount(this.Participant.Name); MessageBox.Show($"Account {this.Participant.Name} has been deleted"); LogInWindow logInWindow = new LogInWindow(); logInWindow.Show(); CloseWindows(); } catch (Exception exception) { MessageBox.Show(exception.Message); } } } else { MessageBox.Show("Bad password"); } } else { MessageBox.Show("Password field must be filled"); } }
public async Task <ActionResult <WorkerJobDto> > addWorkerJob(WorkerJobDto worker) { // 1. Create DbAdapter object for execute user to database. var adapter = new DbAdapter(_config.GetConnectionString("DefaultConnection")); // 2. Create SqlParameter output object. SqlParameter paramTrxNo = new SqlParameter("@TrxNo", SqlDbType.Int); paramTrxNo.Direction = ParameterDirection.Output; SqlParameter paramCreateDateTime = new SqlParameter("@CreateDateTime", SqlDbType.DateTime); paramCreateDateTime.Direction = ParameterDirection.Output; // 3. Execute new worker job to database. await adapter.executedAsync("SP_WorkerJob_Add", CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@WorkerID", worker.WorkerID), new SqlParameter("@FromPath", worker.FromPath), new SqlParameter("@ToPath", worker.ToPath), paramTrxNo, paramCreateDateTime }); // Final return workerjob object. return(new WorkerJobDto { TrxNo = Convert.ToInt32(paramTrxNo.Value), WorkerID = worker.WorkerID, FromPath = worker.FromPath, ToPath = worker.ToPath, CreateDateTime = Convert.ToDateTime(paramCreateDateTime.Value) }); }
// Видимо временное решение //public string DaraSrc { get { return requester?.DataSrc; } } public CassetteIntegration(XElement xconfig) { if (xconfig.Element("Net") == null) { localstorage = new DStorage1(); } else { localstorage = new DStorage2(); } localstorage.Init(xconfig); string connectionstring = xconfig.Element("database")?.Attribute("connectionstring")?.Value; if (connectionstring == null) { _adapter = new NextEraAdapter(); } else if (connectionstring.StartsWith("trs:")) { _adapter = new TripleRecordStoreAdapter(); } else if (connectionstring.StartsWith("ts:")) { _adapter = new TripleStoreAdapter();// XmlDbAdapter(); } else if (connectionstring.StartsWith("xml:")) { _adapter = new XmlDbAdapter(); } else if (connectionstring.StartsWith("sxml:")) { _adapter = new SimpleDbAdapter(); } localstorage.InitAdapter(_adapter); XElement net = xconfig.Element("Net"); if (net != null) { try { requester = new CassetteDataRequester(net.Attribute("src")?.Value); var res = requester.Ping(); if (res != "Pong") { requester = null; } } catch (Exception) { requester = null; } } else { //if (_adapter.firsttime) //TODO: закомментарено пока не устранена ошибка localstorage.LoadFromCassettesExpress(); } }
public static void FillGroups() { var adapter = new DbAdapter(); adapter.ActionByContext(context => { IEnumerable <Group> entities = context.Group.AsEnumerable(); foreach (Group entity in entities) { string fullFileName = @"C:\Projects\StudyLanguages\Источники для групп\Источники картинок\" + entity.Name + ".jpg"; byte[] image = null; if (File.Exists(fullFileName)) { image = File.ReadAllBytes(fullFileName); } else { Console.WriteLine("Не найдена картинка для группы {0}! Нажмите Enter для продолжения...", entity.Name); Console.ReadLine(); } entity.Image = image; context.SaveChanges(); } }); }
public static void FillRepresentation() { var adapter = new DbAdapter(); adapter.ActionByContext(context => { IEnumerable <Representation> entities = context.Representation.AsEnumerable(); foreach (Representation entity in entities) { string fullFileName = @"C:\Projects\StudyLanguages\Источники визуального словаря\Картинки\" + entity.Title + ".jpg"; if (File.Exists(fullFileName)) { byte[] image = File.ReadAllBytes(fullFileName); //обновить возможно изменившийся рейтинг и изображение entity.Image = image; context.SaveChanges(); } else { Console.WriteLine( "Не найдена картинка для визуального словаря {0}! Нажмите Enter для продолжения...", entity.Title); Console.ReadLine(); } } }); }
public static void RecordPermissions(this SPSecurableObject secObj, DbAdapter dbConnection, Guid siteGuid, Guid caseWebGuid, Guid?childWebGuid, Guid?listGuid, Guid?listItemGuid) { string roleAssignmentsXml = secObj.RoleAssignments.Xml; CreateSPObjPermSProc sProc = new CreateSPObjPermSProc(siteGuid, caseWebGuid, childWebGuid, listGuid, listItemGuid, roleAssignmentsXml); dbConnection.ExecuteNonQueryStoredProcedure(sProc); }
private void AddTaskType(string participantName, string plannerName, string taskTypeName, string foregroundSample, string backgroundSample) { if (taskTypeName.Length != 0) { if (!ExtractTasksTypes(DbAdapter.GetTasksTypes(this.Participant.Name, this.Planner.Name)).Contains(taskTypeName)) { try { DbAdapter.TaskTypeAdd(participantName, plannerName, taskTypeName, foregroundSample, backgroundSample); AdjustTaskTypeListBox(); } catch (Exception exception) { MessageBox.Show(exception.Message); } } else { MessageBox.Show($"Task type {taskTypeName} already exists"); } } else { MessageBox.Show("Task type name field must be filled"); } }
private void SignUp(string login, string password, string passwordRetype) { if (login.Length != 0 && password.Length != 0 && passwordRetype.Length != 0) { if (password == passwordRetype) { try { DbAdapter.ParticipantAdd(login, password); MessageBox.Show($"Account {login} has been created"); LogInWindow logInWindow = new LogInWindow(); logInWindow.LogIn(login, password); this.Close(); } catch (SqlException sqlException) when(sqlException.Number == 2627) { MessageBox.Show($"Account {login} already exists"); LoginTextBox.Clear(); } catch (Exception exception) { MessageBox.Show(exception.Message); } } else { MessageBox.Show("Given passwords are non-identical"); } } else { MessageBox.Show("All fields must be filled"); } }
private IEnumerable <KeyValuePair <Bytes, byte[]> > All(bool forward) { var enumerator = DbAdapter.All(forward); var wrapped = new WrappedRocksRbKeyValueEnumerator(enumerator, openIterators.Remove); openIterators.Add(wrapped); return(new RocksDbEnumerable(Name, wrapped)); }
private static void OnDynamicBoneInit(MonoBehaviour __instance) { // Prevent having multiple copies, maybe use a dictionary and check for key? if (_DBs.All(x => x.BoneMb != __instance)) { _DBs.Add(DbAdapter.Create(__instance)); } }
public void Init() { schemaBuilder = new Mock <IDbSchemaBuilder>(); schema = new Mock <DbSchema>(); schema.Setup(c => c.GetHashCode()).Returns(123456); classBuilder = new Mock <DynamicClassBuilder>(schema.Object); dbAdapter = new DbAdapter(schemaBuilder.Object, classBuilder.Object, schema.Object); }
public async Task <ActionResult <bool> > deleteEventQueue(int id) { // 1. Create DbAdapter object for execute user to database. var adapter = new DbAdapter(_config.GetConnectionString("DefaultConnection")); await adapter.executedAsync("SP_EventQueue_Delete", CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("", id) }); return(Ok()); }
public StaffController() { Staff = DbAdapter.LoadAllStaff(); ViewableStaff = new ObservableCollection <Staff>(Staff); foreach (Staff e in Staff) { e.Consultations = DbAdapter.LoadConsultationItems(e.ID); e.Class = DbAdapter.LoadStaffClasses(e.ID); } }
/// <summary> /// Get the value corresponding to this key. /// </summary> /// <param name="key">the key to fetch</param> /// <returns>The value or null if no value is found.</returns> public byte[] Get(Bytes key) { CheckStateStoreOpen(); try { return(DbAdapter.Get(key.Get)); } catch (RocksDbSharp.RocksDbException e) { throw new ProcessorStateException($"Error while getting value for key from store {Name}", e); } }
public UnitController() { Unit = DbAdapter.LoadAllUnit(); ViewableUnit = new ObservableCollection <Unit>(Unit); //this list we will modify later //Part of step 2.3.2 from Week 9 tutorial foreach (Unit e in Unit) { e.ClassList = DbAdapter.LoadClasses(e.Code); } }
public async Task <ActionResult <IEnumerable <WorkerJobDto> > > getWorkerJobs() { // 1. Create DbAdapter object for execute user to database. var adapter = new DbAdapter(_config.GetConnectionString("DefaultConnection")); // 2. Read streamdata from database to DataSet. DataSet dsSet = await adapter.getDataSetAsync("SP_WorkerJob_Select", CommandType.StoredProcedure); // Final result is workers. return(WorkerJobHelper.convertDataSetToWorkerJobs(dsSet)); }
private void button1_Click(object sender, EventArgs e) { if (менеджерIDComboBox.SelectedIndex < 0 || spisok.Count == 0) { MessageBox.Show("Заполните все поля!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } foreach (var t in spisok) { if (t.TovarId == -1) { MessageBox.Show("Какой-то из товаров отсутствует на складе", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (t.Count == 0) { MessageBox.Show("Укажите количество!", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } } счетаTableAdapter.Insert(датаDateTimePicker.Value.Date, (int)менеджерIDComboBox.SelectedValue); счетаTableAdapter.Fill(dataSet.Счета); расходTableAdapter.Insert(датаDateTimePicker.Value.Date, (int)менеджерIDComboBox.SelectedValue); расходTableAdapter.Fill(dataSet.асход); int id = dataSet.Счета.Last().Шифр; foreach (var t in spisok) { составСчетаTableAdapter.Insert((int)t.TovarId, id, (int)t.Count, t.Cena * t.Count); } составСчетаTableAdapter.Fill(dataSet.СоставСчета); int id1 = dataSet.асход.Last().Шифр; using (var dbAdapter = new DbAdapter()) { foreach (var t in spisok) { составРасходаTableAdapter.Insert(id1, t.TovarId, t.Count, t.Cena * t.Count); dbAdapter.UpdateTovar(t.TovarId, -t.Count); } составРасходаTableAdapter.Fill(dataSet.СоставРасхода); } MessageBox.Show("Счет успешно оформлен!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
/// <summary> /// Get entity by it identifier /// </summary> /// <param name="entityId">Identifier value</param> /// <returns>Entity by identifier if it found; otherwise null</returns> public TEntity Get(Guid entityId) { TEntity entity = null; var sqlQuery = $"SELECT * FROM [{TableName}] WHERE Id = @P1"; using (var connection = DbConnectionFactory.CreateDbConnection()) { entity = DbAdapter.Query <TEntity>(connection, sqlQuery, new { P1 = entityId }).FirstOrDefault(); } return(entity); }
private string GetDocumentIdForPrefix(SPListItem listItem, string prefix, bool forceUpdate) { string connectionString = GetConnectionString(listItem); GetCreateDocIdSProc sProc = new GetCreateDocIdSProc(listItem.ParentList.ParentWeb.Site.ID, listItem.ParentList.ParentWeb.ID, listItem.UniqueId, forceUpdate, prefix, 0, listItem.ID); using (DbAdapter dbAdapter = new DbAdapter()) { dbAdapter.Connect(connectionString); dbAdapter.ExecuteNonQueryStoredProcedure(sProc); } return(string.Format("{0}-{1}", sProc.Parameters[4].Value, sProc.Parameters[5].Value.ToString().PadLeft(9, '0'))); }
/// <summary> /// Get all entities /// </summary> /// <returns>All entities</returns> public IEnumerable <TEntity> Get() { IEnumerable <TEntity> entities = Enumerable.Empty <TEntity>(); var sqlQuery = $"SELECT * FROM [{TableName}]"; using (var connection = DbConnectionFactory.CreateDbConnection()) { entities = DbAdapter.Query <TEntity>(connection, sqlQuery).ToList(); } return(entities); }
public void Data_is_inserted_into_database_table() { using (var connection = new SqlConnection("Data Source=(local);Initial Catalog=tests;Integrated Security=SSPI;")) { connection.Open(); connection.ExecuteIgnoringErrors("DROP TABLE TestDaten"); connection.Execute("CREATE TABLE TestDaten (Bezeichnung NVARCHAR (80), Menge INT, Verfuegbar BIT)"); var sut = new DbAdapter(connection); sut.Save("TestDaten", new[] { new Column("Bezeichnung", typeof(string)), new Column("Menge", typeof(int)), new Column("Verfuegbar", typeof(bool)) }, new[] { new Line(new object[] {"Äpfel", 42, true}), new Line(new object[] {"Birnen", 37, false}), new Line(new object[] {"Pflaumen", 56, true}) }); } }
public void BeregnAkkumuleretReserveTil67AarMedInterpolationShouldMatchDataFromSpreadsheet() { var dbAdapter = new DbAdapter(Program.DbConnectionString); dbAdapter.ReadFromDb(); var e = new RenteReserveBeregner(dbAdapter); var foedselsDato = new DateTime(1980, 6, 30); var udloebsDato = new DateTime(2013, 1, 1); /* Ydelse pr maaned er hentet fra kolonne E benævnt fakturasum * i regnearket "beregning af rentereserver" i panelet "dataark" * */ const int ydelsePrMaaned = 6554; var renteReserve = e.BeregnReserve(foedselsDato, udloebsDato, Koen.Kvinde, ydelsePrMaaned, 0); /* rentereserven er hentet fra kolonne O som Olsen benævnt fakturasum * i regnearket "beregning af rentereserver" i panelet "dataark" * */ const decimal expectedRenteReserve = (decimal) 1997696.35904207; Expect(renteReserve, Is.EqualTo(expectedRenteReserve).Within(10)); }
public void ReadFromDb() { var e = new DbAdapter(Program.DbConnectionString); e.ReadFromDb(); }
private void AssertSkade(ErhvervsSkade skade, DbAdapter dbAdapter) { var e = new RenteReserveBeregner(dbAdapter); var reserve = e.BeregnReserve(skade.BuildFictionalDate(), EndOf2012,Koen.Kvinde, skade.Fakturasum, 0); Expect(reserve, Is.EqualTo(skade.Reserve).Within(26)); var message = string.Format("Udbetalinger (år): {0}\t Fakturasum: {1}\t og forskel {2}", Math.Round(67 - skade.Alder, 2), skade.Fakturasum, Math.Round(reserve - skade.Reserve, 2)); Debug.Print(message); }
private static Decimal BeregnSkade(DbAdapter dbAdapter, ErhvervsSkade skade) { var e = new RenteReserveBeregner(dbAdapter); return e.BeregnReserve(skade.BuildFictionalDate(), EndOf2012, Koen.Kvinde, skade.Fakturasum, 0); }
public void CanCalulateOrderedDataFromSpreadsheet() { var dbAdapter = new DbAdapter(Program.DbConnectionString); dbAdapter.ReadFromDb(); foreach (var e in ReadErhvervsSkaderFromFile(). Select(skade => new {AkkumuleretReserve = BeregnSkade(dbAdapter, skade), Skade = skade}).OrderBy( x => (x.AkkumuleretReserve - x.Skade.Reserve))) { Expect(e.AkkumuleretReserve, Is.EqualTo(e.Skade.Reserve).Within(26)); var message = string.Format("Udbetalinger (år): {0}\t Fakturasum: {1}\t og forskel {2}", Math.Round(67 - e.Skade.Alder, 2), e.Skade.Fakturasum, Math.Round(e.AkkumuleretReserve - e.Skade.Reserve, 2)); Debug.Print(message); } }
public void CanCalulateDataFromSpreadsheet() { var dbAdapter = new DbAdapter(Program.DbConnectionString); dbAdapter.ReadFromDb(); foreach ( var erhvervsSkade in ReadErhvervsSkaderFromFile().OrderBy(x => 67 - x.Alder).ThenBy(x => x.Fakturasum)) { AssertSkade(erhvervsSkade, dbAdapter); } }
public void BeregnReserveWithDiskontoFrom10Oktober2012Other() { //150182-xxx6 var db = new DbAdapter(Program.DbConnectionString); db.ReadFromDb(); db.SetDiskontoSatser(TestConstants.DiskonteringsRente10Oktober2012); var e = new RenteReserveBeregner(db); var foedselsDato = new DateTime(1982, 1, 15); var beregningsDato = new DateTime(2012, 12, 31); var age = new InsuranceAgeCalculator().CalculateAge(foedselsDato, beregningsDato); Expect(age, Is.EqualTo(30.9166666666667).Within(0.001)); const int comsumerPriceIndexInPercent = 1; var reserve = e.BeregnReserve(foedselsDato, beregningsDato, Koen.Kvinde, 10034, comsumerPriceIndexInPercent); const double expectedReserveFromSpreadsheet = 3719302.94806157; Expect(reserve, Is.EqualTo(expectedReserveFromSpreadsheet).Within(10)); }
public void BeregnReserveWithDiskontoFrom10Oktober2012() { //cpr: 160680-xxx6 var db = new DbAdapter(Program.DbConnectionString); db.ReadFromDb(); db.SetDiskontoSatser(TestConstants.DiskonteringsRente10Oktober2012); var e = new RenteReserveBeregner(db); var foedselsDato = new DateTime(1980,6,16); var beregningsDato = new DateTime(2012,12,31); var age = new InsuranceAgeCalculator().CalculateAge(foedselsDato, beregningsDato); Expect(age, Is.EqualTo(32.5).Within(0.001)); const int comsumerPriceIndexInPercent = 1; var reserve = e.BeregnReserve(foedselsDato, beregningsDato, Koen.Kvinde, 6554, comsumerPriceIndexInPercent); Expect(reserve, Is.EqualTo(2347852.93480205).Within(10)); }