Total: 22
.NET Framework
Test
2021
Project Request
ASP.NET MVC • C# • SQL Server
Idea of the project: if someone wants to order a project development, here you can send an application.
Test
2020
ProjectC
ASP.NET MVC • C# • JSON • jQuery
JSON data processing.
Test
2020
Vehicle Maintenance
ASP.NET MVC • VB.NET • JSON
Idea of the project: if someone wants to order a project development, here you can send an application.
Test
2019
Movie Navigator
ASP.NET MVC • VB.NET
Request information about movie from IMDB.
Test
2018
Customers Exchange
ASP.NET MVC • C# • SQL Server
Automated teller machine emulation.
Test
2016
ATM
ASP.NET MVC • C#
Automated teller machine emulation.
.NET Core
Pet project
2022
Mail Daemon
.NET 8 • Console • JSON
Utility to send mails with customizable settings.
Custom
Code
2024
Buns of code
.NET Framework • C# • JavaScript
Code snippets from my projects, ready to use; tiny tests; code examples.
PHP
Test
2024
Mediabox
PHP 8 • Laravel 11 • Vue.js • Composer • SQLite
Test project for media files management.
Test
2020
Loan Castle
PHP • MariaDB
Jums jāizstrādā kāda lielāk projekta prototips. Izstrādājot prototipu, paturiet prātā, ka projektam attīstoties, šo prototipu varētu vajadzēt pilnveidot.
Test
2020
Content Management
PHP • MySQL • AJAX
Создать простой сайт, где будет страница с формой для авторизации и страница для авторизованного пользователя.
Test
2019
Laravel
PHP • Laravel • Vue.js • Composer • SQLite
Izveidot aplikāciju, kura ik pēc noteikta intervāla (60 sekundes) veic ierakstu datubāzē izmantojot Laravel freimworka iebūvēto funkcionalitāti.
Test
2019
Phone Check
PHP • JavaScript • JSON • Docker
Implement application to detect country by phone number.
Frontend
Test
2021
Forex Wall
npm • React
For this exercise, what we need is a simple live wall for tracking currencies.
Business projects
Commercial
2008
Certification Center
.NET Framework 4.8 • ASP.NET Web Forms • C# • LINQ • SQL Server • ADO.NET • Dapper • JavaScript • jQuery • Git
Transport registration and certification services in Latvia, Customer Relationship Management.
Commercial
2000
Amerikas Auto
.NET Framework 4.8 • ASP.NET Web Forms • C# • LINQ • SQL Server • ADO.NET • Entity Framework • JavaScript • jQuery • Git
Car service and spare parts for all USA and European car models, Customer Relationship Management.
Pet projects
Pet project
2023
Geolocation Assistant
.NET 8 • ASP.NET Core • C# • Web API • JSON • Git
Website for determining geolocation by IP or geotagged photo.
Pet project
2008
Web Dynamics
.NET Framework 4.8 • ASP.NET Web Forms • C# • LINQ • Web API • JSON • SQL Server • Dapper • JavaScript • jQuery • SVG • Git
Software development blog. Articles, books, videos, content management.
Pet project
2000
Blackball
.NET Framework 4.8 • ASP.NET Web Forms • C# • LINQ • Web API • JSON • XML • SQL Server • Dapper • JavaScript • jQuery • SVG • Git
My entertainment portal created from scratch.
Good old times
Legacy
2000
DOS Clock
Turbo Pascal • Assembler
Digital clock.
Legacy
2000
BrainOut
Turbo Pascal • Assembler
Tank battle game.
Legacy
1999
Airport Administrator
Turbo Pascal
Курсовая работа в институте.
Legacy
1998
Atomizer
Turbo Pascal • Assembler
Atomizer, aka «Studio2D». Graphic raster editor. AGI is my own «Atomizer Generated Image» file format.
ATM
2016 TestAutomated teller machine emulation.
ASP.NET MVC
C#
Source code
Root
/
SergeyDrozdovATM.Data
/
SergeyDrozdovATMModel.edmx
<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
<!-- EF Runtime content -->
<edmx:Runtime>
<!-- SSDL content -->
<edmx:StorageModels>
<Schema Namespace="SergeyDrozdovATMDbModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
<EntityType Name="Accounts">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
<Property Name="UserId" Type="int" Nullable="false" />
<Property Name="CurrencyId" Type="int" Nullable="false" />
<Property Name="CashAmount" Type="decimal" Precision="18" Scale="2" Nullable="false" />
</EntityType>
<EntityType Name="Currencies">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
<Property Name="Name" Type="varchar" MaxLength="3" Nullable="false" />
</EntityType>
<EntityType Name="CurrencyRates">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
<Property Name="SourceCurrencyId" Type="int" Nullable="false" />
<Property Name="DestinationCurrencyId" Type="int" Nullable="false" />
<Property Name="Rate" Type="decimal" Precision="18" Scale="10" Nullable="false" />
</EntityType>
<EntityType Name="Users">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
<Property Name="Login" Type="smallint" Nullable="false" />
<Property Name="PIN" Type="smallint" Nullable="false" />
</EntityType>
<Association Name="FK_Accounts_Currencies">
<End Role="Currencies" Type="Self.Currencies" Multiplicity="1" />
<End Role="Accounts" Type="Self.Accounts" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Currencies">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Accounts">
<PropertyRef Name="CurrencyId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_Accounts_Users">
<End Role="Users" Type="Self.Users" Multiplicity="1" />
<End Role="Accounts" Type="Self.Accounts" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Users">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Accounts">
<PropertyRef Name="UserId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_CurrencyRates_DestinationCurrency">
<End Role="Currencies" Type="Self.Currencies" Multiplicity="1" />
<End Role="CurrencyRates" Type="Self.CurrencyRates" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Currencies">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="CurrencyRates">
<PropertyRef Name="DestinationCurrencyId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_CurrencyRates_SourceCurrency">
<End Role="Currencies" Type="Self.Currencies" Multiplicity="1" />
<End Role="CurrencyRates" Type="Self.CurrencyRates" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Currencies">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="CurrencyRates">
<PropertyRef Name="SourceCurrencyId" />
</Dependent>
</ReferentialConstraint>
</Association>
<EntityContainer Name="SergeyDrozdovATMDbModelStoreContainer">
<EntitySet Name="Accounts" EntityType="Self.Accounts" Schema="dbo" store:Type="Tables" />
<EntitySet Name="Currencies" EntityType="Self.Currencies" Schema="dbo" store:Type="Tables" />
<EntitySet Name="CurrencyRates" EntityType="Self.CurrencyRates" Schema="dbo" store:Type="Tables" />
<EntitySet Name="Users" EntityType="Self.Users" Schema="dbo" store:Type="Tables" />
<AssociationSet Name="FK_Accounts_Currencies" Association="Self.FK_Accounts_Currencies">
<End Role="Currencies" EntitySet="Currencies" />
<End Role="Accounts" EntitySet="Accounts" />
</AssociationSet>
<AssociationSet Name="FK_Accounts_Users" Association="Self.FK_Accounts_Users">
<End Role="Users" EntitySet="Users" />
<End Role="Accounts" EntitySet="Accounts" />
</AssociationSet>
<AssociationSet Name="FK_CurrencyRates_DestinationCurrency" Association="Self.FK_CurrencyRates_DestinationCurrency">
<End Role="Currencies" EntitySet="Currencies" />
<End Role="CurrencyRates" EntitySet="CurrencyRates" />
</AssociationSet>
<AssociationSet Name="FK_CurrencyRates_SourceCurrency" Association="Self.FK_CurrencyRates_SourceCurrency">
<End Role="Currencies" EntitySet="Currencies" />
<End Role="CurrencyRates" EntitySet="CurrencyRates" />
</AssociationSet>
</EntityContainer>
</Schema></edmx:StorageModels>
<!-- CSDL content -->
<edmx:ConceptualModels>
<Schema Namespace="SergeyDrozdovATMDbModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
<EntityType Name="Accounts">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
<Property Name="UserId" Type="Int32" Nullable="false" />
<Property Name="CashAmount" Type="Decimal" Precision="18" Scale="2" Nullable="false" />
<NavigationProperty Name="Users" Relationship="SergeyDrozdovATMDbModel.FK_Accounts_Users" FromRole="Accounts" ToRole="Users" />
<Property Name="CurrencyId" Type="Int32" Nullable="false" />
<NavigationProperty Name="Currencies" Relationship="SergeyDrozdovATMDbModel.FK_Accounts_Currencies" FromRole="Accounts" ToRole="Currencies" />
</EntityType>
<EntityType Name="CurrencyRates">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
<Property Name="Rate" Type="Decimal" Precision="18" Scale="10" Nullable="false" />
<Property Name="SourceCurrencyId" Type="Int32" Nullable="false" />
<Property Name="DestinationCurrencyId" Nullable="false" Type="Int32" />
<NavigationProperty Name="Currencies_DestinationCurrency" Relationship="SergeyDrozdovATMDbModel.FK_CurrencyRates_DestinationCurrency" FromRole="CurrencyRates" ToRole="Currencies" />
<NavigationProperty Name="Currencies_SourceCurrency" Relationship="SergeyDrozdovATMDbModel.FK_CurrencyRates_SourceCurrency" FromRole="CurrencyRates" ToRole="Currencies" />
</EntityType>
<EntityType Name="Users">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
<Property Name="Login" Type="Int16" Nullable="false" />
<Property Name="PIN" Type="Int16" Nullable="false" />
<NavigationProperty Name="Accounts" Relationship="SergeyDrozdovATMDbModel.FK_Accounts_Users" FromRole="Users" ToRole="Accounts" />
</EntityType>
<EntityContainer Name="SergeyDrozdovATMDbContext" annotation:LazyLoadingEnabled="true">
<EntitySet Name="Accounts" EntityType="SergeyDrozdovATMDbModel.Accounts" />
<EntitySet Name="CurrencyRates" EntityType="Self.CurrencyRates" />
<EntitySet Name="Users" EntityType="SergeyDrozdovATMDbModel.Users" />
<AssociationSet Name="FK_Accounts_Users" Association="SergeyDrozdovATMDbModel.FK_Accounts_Users">
<End Role="Users" EntitySet="Users" />
<End Role="Accounts" EntitySet="Accounts" />
</AssociationSet>
<EntitySet Name="Currencies" EntityType="SergeyDrozdovATMDbModel.Currencies" />
<AssociationSet Name="FK_Accounts_Currencies" Association="SergeyDrozdovATMDbModel.FK_Accounts_Currencies">
<End Role="Currencies" EntitySet="Currencies" />
<End Role="Accounts" EntitySet="Accounts" />
</AssociationSet>
<AssociationSet Name="FK_CurrencyRates_DestinationCurrency" Association="SergeyDrozdovATMDbModel.FK_CurrencyRates_DestinationCurrency">
<End Role="Currencies" EntitySet="Currencies" />
<End Role="CurrencyRates" EntitySet="CurrencyRates" />
</AssociationSet>
<AssociationSet Name="FK_CurrencyRates_SourceCurrency" Association="SergeyDrozdovATMDbModel.FK_CurrencyRates_SourceCurrency">
<End Role="Currencies" EntitySet="Currencies" />
<End Role="CurrencyRates" EntitySet="CurrencyRates" />
</AssociationSet>
</EntityContainer>
<Association Name="FK_Accounts_Users">
<End Type="SergeyDrozdovATMDbModel.Users" Role="Users" Multiplicity="1" />
<End Type="SergeyDrozdovATMDbModel.Accounts" Role="Accounts" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Users">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Accounts">
<PropertyRef Name="UserId" />
</Dependent>
</ReferentialConstraint>
</Association>
<EntityType Name="Currencies">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
<Property Name="Name" Type="String" Nullable="false" MaxLength="3" FixedLength="false" Unicode="false" />
<NavigationProperty Name="Accounts" Relationship="SergeyDrozdovATMDbModel.FK_Accounts_Currencies" FromRole="Currencies" ToRole="Accounts" />
<NavigationProperty Name="CurrencyRates_DestinationCurrency" Relationship="SergeyDrozdovATMDbModel.FK_CurrencyRates_DestinationCurrency" FromRole="Currencies" ToRole="CurrencyRates" />
<NavigationProperty Name="CurrencyRates_SourceCurrency" Relationship="SergeyDrozdovATMDbModel.FK_CurrencyRates_SourceCurrency" FromRole="Currencies" ToRole="CurrencyRates" />
</EntityType>
<Association Name="FK_Accounts_Currencies">
<End Type="SergeyDrozdovATMDbModel.Currencies" Role="Currencies" Multiplicity="1" />
<End Type="SergeyDrozdovATMDbModel.Accounts" Role="Accounts" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Currencies">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="Accounts">
<PropertyRef Name="CurrencyId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_CurrencyRates_DestinationCurrency">
<End Type="SergeyDrozdovATMDbModel.Currencies" Role="Currencies" Multiplicity="1" />
<End Type="SergeyDrozdovATMDbModel.CurrencyRates" Role="CurrencyRates" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Currencies">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="CurrencyRates">
<PropertyRef Name="DestinationCurrencyId" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="FK_CurrencyRates_SourceCurrency">
<End Type="SergeyDrozdovATMDbModel.Currencies" Role="Currencies" Multiplicity="1" />
<End Type="SergeyDrozdovATMDbModel.CurrencyRates" Role="CurrencyRates" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="Currencies">
<PropertyRef Name="Id" />
</Principal>
<Dependent Role="CurrencyRates">
<PropertyRef Name="SourceCurrencyId" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema>
</edmx:ConceptualModels>
<!-- C-S mapping content -->
<edmx:Mappings>
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
<EntityContainerMapping StorageEntityContainer="SergeyDrozdovATMDbModelStoreContainer" CdmEntityContainer="SergeyDrozdovATMDbContext">
<EntitySetMapping Name="Accounts">
<EntityTypeMapping TypeName="SergeyDrozdovATMDbModel.Accounts">
<MappingFragment StoreEntitySet="Accounts">
<ScalarProperty Name="CurrencyId" ColumnName="CurrencyId" />
<ScalarProperty Name="Id" ColumnName="Id" />
<ScalarProperty Name="UserId" ColumnName="UserId" />
<ScalarProperty Name="CashAmount" ColumnName="CashAmount" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="CurrencyRates">
<EntityTypeMapping TypeName="SergeyDrozdovATMDbModel.CurrencyRates">
<MappingFragment StoreEntitySet="CurrencyRates">
<ScalarProperty Name="DestinationCurrencyId" ColumnName="DestinationCurrencyId" />
<ScalarProperty Name="SourceCurrencyId" ColumnName="SourceCurrencyId" />
<ScalarProperty Name="Id" ColumnName="Id" />
<ScalarProperty Name="Rate" ColumnName="Rate" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="Users">
<EntityTypeMapping TypeName="SergeyDrozdovATMDbModel.Users">
<MappingFragment StoreEntitySet="Users">
<ScalarProperty Name="Id" ColumnName="Id" />
<ScalarProperty Name="Login" ColumnName="Login" />
<ScalarProperty Name="PIN" ColumnName="PIN" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="Currencies">
<EntityTypeMapping TypeName="SergeyDrozdovATMDbModel.Currencies">
<MappingFragment StoreEntitySet="Currencies">
<ScalarProperty Name="Name" ColumnName="Name" />
<ScalarProperty Name="Id" ColumnName="Id" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
</EntityContainerMapping>
</Mapping>
</edmx:Mappings>
</edmx:Runtime>
<!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
<Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
<Connection>
<DesignerInfoPropertySet>
<DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
</DesignerInfoPropertySet>
</Connection>
<Options>
<DesignerInfoPropertySet>
<DesignerProperty Name="ValidateOnBuild" Value="true" />
<DesignerProperty Name="EnablePluralization" Value="false" />
<DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
<DesignerProperty Name="UseLegacyProvider" Value="false" />
<DesignerProperty Name="CodeGenerationStrategy" Value="None" />
</DesignerInfoPropertySet>
</Options>
<!-- Diagram content (shape and connector positions) -->
<Diagrams></Diagrams>
</Designer>
</edmx:Edmx>