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