sannlynnhtun-coding

ATM Console Application

1. Application Requirements

• User Management (UserID, Password, Balance).
• Login System with 5 attempts.
• Console alerts like "Login Success".
• A main menu with 5 options:
  1. Withdraw
  2. Deposit
  3. Check Balance

sannlynnhtun-coding

dotnet publish -c Release -r browser-wasm --self-contained true

sannlynnhtun-coding

public static void DetachAllEntries(this DbContext context)
{
    foreach (var entry in context.ChangeTracker.Entries().ToList())
    {
         context.Entry(entry.Entity).State = EntityState.Detached;
    }
}

sannlynnhtun-coding

git shortlog --summary --numbered --all --no-merges

sannlynnhtun-coding

public static class DevCode
{
  public static string? ToJson<T>(this T? obj, bool format = false)
    {
        if (obj == null) return string.Empty;
        string? result;
        if (obj is string)
 {

sannlynnhtun-coding

builder.Services.AddDbContext<DatabaseContext>(options =>
{
    options.UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking);
    options.UseSqlServer(builder.Configuration.GetConnectionString("DbConnection"));
});

sannlynnhtun-coding

Microsoft SQL Server

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=sasa@123" -p 1433:1433 --name mssql2022 --hostname mssql2022 -d mcr.microsoft.com/mssql/server:2022-latest

MySQL

docker run --name=mysql-container -e MYSQL_ROOT_PASSWORD=acesa123 -d -p 3306:3306 mysql:latest

sannlynnhtun-coding

dotnet ef dbcontext scaffold "Server=.;Database=DbName;User Id=userId;Password=password;TrustServerCertificate=True;" Microsoft.EntityFrameworkCore.SqlServer -o Models -c AppDbContext -t Tbl_Name -f

sannlynnhtun-coding

EF Core Installation For Command

dotnet tool install --global dotnet-ef

dotnet tool install --global dotnet-ef --version 7

sannlynnhtun-coding

DECLARE @command nvarchar(max)
SET @command = ''
Declare @FileName varchar(500) = 'D:\Backup\LocalDbBackup\' + '@name' +'.bak'''
SELECT @command = @command + 'BACKUP DATABASE ['+name+'] TO DISK = ''' + REPLACE(@FileName, '@name', name) + ';'
FROM sys.databases
where [name] not in ( 'master', 'model', 'msdb', 'tempdb');

SELECT @command
EXECUTE sp_executesql @command