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.
Project Request
2021 TestIdea of the project: if someone wants to order a project development, here you can send an application.
ASP.NET MVC
C#
SQL Server
Source code
using ProjectRequestTest.Core.Enums;
using System;
using System.Data;
using System.Data.SqlClient;
using ProjectRequestTest.Core.DbContext;
namespace ProjectRequestTest.Core
{
public class ProjectRequestService : IProjectRequestService
{
public int Create(ProjectRequestItem item)
{
using (var conn = DataAccessService.SqlConn())
{
var cmd = new SqlCommand(DbSpName.ProjectRequestSave.ToName()) { CommandType = CommandType.StoredProcedure };
cmd.Parameters.Add("@Identifier", SqlDbType.Int).Value = item.Identifier;
cmd.Parameters.Add("@ClientName", SqlDbType.NVarChar).Value = item.ClientName;
cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = item.Email;
cmd.Parameters.Add("@PhoneNumber", SqlDbType.VarChar).Value = item.PhoneNumber;
cmd.Parameters.Add("@ProjectType", SqlDbType.VarChar).Value = item.ProjectType.ToString();
cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = item.Description;
cmd.Parameters.Add("@UserIP", SqlDbType.VarChar).Value = Helpers.GetUserIP();
var resultParam = cmd.Parameters.Add("@NewItemID", SqlDbType.Int);
resultParam.Direction = ParameterDirection.Output;
DataAccessService.ExecuteSQL(cmd);
return Convert.ToInt32(resultParam.Value);
}
}
public ProjectRequestItem GetRequestByIdentifier(int identifier)
{
ProjectRequestItem result = null;
using (var conn = DataAccessService.SqlConn())
{
var cmd = new SqlCommand(DbSpName.ProjectRequestLoadByIdentifier.ToName(), conn) { CommandType = CommandType.StoredProcedure };
cmd.Parameters.Add("@Identifier", SqlDbType.Int).Value = identifier;
var sqlReader = cmd.ExecuteReader();
if (sqlReader.Read() && sqlReader[TableProjectRequest.ROWID.ToName()] != DBNull.Value)
{
result = new ProjectRequestItem();
result.Id = Convert.ToInt32(sqlReader[TableProjectRequest.ROWID.ToName()]);
result.Identifier = Convert.ToInt32(sqlReader[TableProjectRequest.ROWID.ToName()]);
if (sqlReader[TableProjectRequest.ClientName.ToName()] != DBNull.Value)
result.ClientName = sqlReader[TableProjectRequest.ClientName.ToName()].ToString();
if (sqlReader[TableProjectRequest.Email.ToName()] != DBNull.Value)
result.Email = sqlReader[TableProjectRequest.Email.ToName()].ToString();
if (sqlReader[TableProjectRequest.PhoneNumber.ToName()] != DBNull.Value)
result.PhoneNumber = sqlReader[TableProjectRequest.PhoneNumber.ToName()].ToString();
if (sqlReader[TableProjectRequest.ProjectType.ToName()] != DBNull.Value)
result.ProjectType = EnumHelper<ProjectType>.Parse(sqlReader[TableProjectRequest.ProjectType.ToName()].ToString());
if (sqlReader[TableProjectRequest.Description.ToName()] != DBNull.Value)
result.Description = sqlReader[TableProjectRequest.Description.ToName()].ToString();
if (sqlReader[TableProjectRequest.UserIP.ToName()] != DBNull.Value)
result.UserIP = sqlReader[TableProjectRequest.UserIP.ToName()].ToString();
if (sqlReader[TableProjectRequest.DateCreated.ToName()] != DBNull.Value)
result.DateCreated = Convert.ToDateTime(sqlReader[TableProjectRequest.DateCreated.ToName()]);
}
}
return result;
}
}
}