public void Application_Idle(object sender, EventArgs e)
{
if (_capture != null)
{
try
{
frame = _capture.QueryFrame();
Pic.Image = frame.ToBitmap();
//frame.ToBitmap(dst: (Bitmap)Pic.Image);
}
catch (NullReferenceException excpt)
{
MessageBox.Show(excpt.Message);// you can also show any suitable message
}
}
} iplImage.ToBitmap(dst: (Bitmap)pictureBox.Image);
<?xml version="1.0" encoding="UTF-8"?>
<cal1388>
<day>
<num>1/1</num>
<desc>عید نوروز، لحظه تحویل سال:ساعت 15 و 13 دقیقه و 39 ثانیه </desc>
</day>
</cal1388>
SELECT '1388' saal,
X.day.query('num').value('.', 'nVARCHAR(50)') rooz_maah,
X.day.query('desc').value('.', 'nVARCHAR(max)') tozih
FROM (
SELECT CAST(x AS XML)
FROM OPENROWSET(
BULK
'c:\1388.xml',
SINGLE_BLOB
) AS T(x)
) AS T(x)
CROSS APPLY x.nodes('cal1388/day') AS X(day);
DECLARE @MyXML XML
SELECT @MyXML = CAST(x AS XML)
FROM OPENROWSET(
BULK
'c:\1388.xml',
SINGLE_BLOB
) AS T(x)
SELECT 1388 saal,
nref.value('num[1]', 'nvarchar(50)') rooz_maah,
nref.value('desc[1]', 'nvarchar(max)') tozih
FROM @MyXML.nodes('//day') AS R(nref)
DECLARE @MyXML XML
DECLARE @handle INT
SELECT @MyXML = CAST(x AS XML)
FROM OPENROWSET(
BULK
'c:\1388.xml',
SINGLE_BLOB
) AS T(x)
EXEC sp_xml_preparedocument @handle OUTPUT,
@MyXML
SELECT 1388 saal,
*
FROM OPENXML(@handle, '/cal1388/day', 2) WITH
(num VARCHAR(20), [desc] NVARCHAR(MAX))
EXEC sp_xml_removedocument @handle
INSERT INTO tblMonasebat
(
saal,
rooz_mah,
tozih
)
SELECT '1388' saal,
nref.value('num[1]', 'nvarchar(50)') rooz_maah,
nref.value('desc[1]', 'nvarchar(max)') tozih
FROM @MyXML.nodes('//day') AS R(nref)
dotnet tool update -g Microsoft.Web.LibraryManager.Cli libman init libman install bootstrap --provider unpkg --destination wwwroot/lib/bootstrap libman install open-iconic --provider unpkg --destination wwwroot/lib/open-iconic
@import url('open-iconic/font/css/open-iconic-bootstrap.min.css'); <head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>BlazorServer.App</title>
<base href="~/" />
<link href="lib/open-iconic/font/css/open-iconic-bootstrap.min.css" rel="stylesheet" />
<link href="lib/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet" />
<link href="css/site.css" rel="stylesheet" />
<link href="BlazorServer.App.styles.css" rel="stylesheet" />
</head> <Project Sdk="Microsoft.NET.Sdk">
<PropertyGroup>
<TargetFramework>net5.0</TargetFramework>
</PropertyGroup>
</Project> using System;
using System.ComponentModel.DataAnnotations;
namespace BlazorServer.Entities
{
public class HotelRoom
{
[Key]
public int Id { get; set; }
[Required]
public string Name { get; set; }
[Required]
public int Occupancy { get; set; }
[Required]
public decimal RegularRate { get; set; }
public string Details { get; set; }
public string SqFt { get; set; }
public string CreatedBy { get; set; }
public DateTime CreatedDate { get; set; } = DateTime.Now;
public string UpdatedBy { get; set; }
public DateTime UpdatedDate { get; set; }
}
} <Project Sdk="Microsoft.NET.Sdk">
<PropertyGroup>
<TargetFramework>net5.0</TargetFramework>
</PropertyGroup>
<ItemGroup>
<ProjectReference Include="..\BlazorServer.Entities\BlazorServer.Entities.csproj" />
</ItemGroup>
<ItemGroup>
<PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="5.0.3" />
<PackageReference Include="Microsoft.EntityFrameworkCore.Tools" Version="5.0.3">
<PrivateAssets>all</PrivateAssets>
<IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
</PackageReference>
</ItemGroup>
</Project> using BlazorServer.Entities;
using Microsoft.EntityFrameworkCore;
namespace BlazorServer.DataAccess
{
public class ApplicationDbContext : DbContext
{
public DbSet<HotelRoom> HotelRooms { get; set; }
public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options)
{ }
}
} <Project Sdk="Microsoft.NET.Sdk.Web">
<PropertyGroup>
<TargetFramework>net5.0</TargetFramework>
</PropertyGroup>
<ItemGroup>
<ProjectReference Include="..\BlazorServer.DataAccess\BlazorServer.DataAccess.csproj" />
</ItemGroup>
<ItemGroup>
<PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="5.0.3" />
<PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="5.0.3">
<PrivateAssets>all</PrivateAssets>
<IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
</PackageReference>
</ItemGroup>
</Project> namespace BlazorServer.App
{
public class Startup
{
// ...
public void ConfigureServices(IServiceCollection services)
{
var connectionString = Configuration.GetConnectionString("DefaultConnection");
services.AddDbContext<ApplicationDbContext>(options => options.UseSqlServer(connectionString));
// ... {
"ConnectionStrings": {
"DefaultConnection": "Server=(localdb)\\mssqllocaldb;Database=HotelManagement;Trusted_Connection=True;MultipleActiveResultSets=true"
}
} dotnet tool update --global dotnet-ef --version 5.0.3 dotnet build dotnet ef migrations --startup-project ../BlazorServer.App/ add Init --context ApplicationDbContext dotnet ef --startup-project ../BlazorServer.App/ database update --context ApplicationDbContext
using System;
using System.ComponentModel.DataAnnotations;
namespace BlazorServer.Models
{
public record HotelRoomDTO
{
public int Id { get; init; }
[Required(ErrorMessage = "Please enter the room's name")]
public string Name { get; init; }
[Required(ErrorMessage = "Please enter the occupancy")]
public int Occupancy { get; init; }
[Range(1, 3000, ErrorMessage = "Regular rate must be between 1 and 3000")]
public decimal RegularRate { get; init; }
public string Details { get; init; }
public string SqFt { get; init; }
}
} <Project Sdk="Microsoft.NET.Sdk">
<PropertyGroup>
<TargetFramework>net5.0</TargetFramework>
</PropertyGroup>
<ItemGroup>
<ProjectReference Include="..\BlazorServer.Entities\BlazorServer.Entities.csproj" />
<ProjectReference Include="..\BlazorServer.Models\BlazorServer.Models.csproj" />
</ItemGroup>
<ItemGroup>
<PackageReference Include="AutoMapper.Extensions.Microsoft.DependencyInjection" Version="8.1.1" />
</ItemGroup>
</Project> using AutoMapper;
using BlazorServer.Entities;
namespace BlazorServer.Models.Mappings
{
public class MappingProfile : Profile
{
public MappingProfile()
{
CreateMap<HotelRoomDTO, HotelRoom>().ReverseMap(); // two-way mapping
}
}
} namespace BlazorServer.App
{
public class Startup
{
// ...
public void ConfigureServices(IServiceCollection services)
{
services.AddAutoMapper(AppDomain.CurrentDomain.GetAssemblies());
// ... using System.Collections.Generic;
using System.Threading.Tasks;
using BlazorServer.Models;
namespace BlazorServer.Services
{
public interface IHotelRoomService
{
Task<HotelRoomDTO> CreateHotelRoomAsync(HotelRoomDTO hotelRoomDTO);
Task<int> DeleteHotelRoomAsync(int roomId);
IAsyncEnumerable<HotelRoomDTO> GetAllHotelRoomsAsync();
Task<HotelRoomDTO> GetHotelRoomAsync(int roomId);
Task<HotelRoomDTO> IsRoomUniqueAsync(string name);
Task<HotelRoomDTO> UpdateHotelRoomAsync(int roomId, HotelRoomDTO hotelRoomDTO);
}
} using System;
using System.Collections.Generic;
using System.Threading.Tasks;
using AutoMapper;
using AutoMapper.QueryableExtensions;
using BlazorServer.DataAccess;
using BlazorServer.Entities;
using BlazorServer.Models;
using Microsoft.EntityFrameworkCore;
namespace BlazorServer.Services
{
public class HotelRoomService : IHotelRoomService
{
private readonly ApplicationDbContext _dbContext;
private readonly IMapper _mapper;
private readonly IConfigurationProvider _mapperConfiguration;
public HotelRoomService(ApplicationDbContext dbContext, IMapper mapper)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
_mapper = mapper ?? throw new ArgumentNullException(nameof(mapper));
_mapperConfiguration = mapper.ConfigurationProvider;
}
public async Task<HotelRoomDTO> CreateHotelRoomAsync(HotelRoomDTO hotelRoomDTO)
{
var hotelRoom = _mapper.Map<HotelRoom>(hotelRoomDTO);
hotelRoom.CreatedDate = DateTime.Now;
hotelRoom.CreatedBy = "";
var addedHotelRoom = await _dbContext.HotelRooms.AddAsync(hotelRoom);
await _dbContext.SaveChangesAsync();
return _mapper.Map<HotelRoomDTO>(addedHotelRoom.Entity);
}
public async Task<int> DeleteHotelRoomAsync(int roomId)
{
var roomDetails = await _dbContext.HotelRooms.FindAsync(roomId);
if (roomDetails == null)
{
return 0;
}
_dbContext.HotelRooms.Remove(roomDetails);
return await _dbContext.SaveChangesAsync();
}
public IAsyncEnumerable<HotelRoomDTO> GetAllHotelRoomsAsync()
{
return _dbContext.HotelRooms
.ProjectTo<HotelRoomDTO>(_mapperConfiguration)
.AsAsyncEnumerable();
}
public Task<HotelRoomDTO> GetHotelRoomAsync(int roomId)
{
return _dbContext.HotelRooms
.ProjectTo<HotelRoomDTO>(_mapperConfiguration)
.FirstOrDefaultAsync(x => x.Id == roomId);
}
public Task<HotelRoomDTO> IsRoomUniqueAsync(string name)
{
return _dbContext.HotelRooms
.ProjectTo<HotelRoomDTO>(_mapperConfiguration)
.FirstOrDefaultAsync(x => x.Name == name);
}
public async Task<HotelRoomDTO> UpdateHotelRoomAsync(int roomId, HotelRoomDTO hotelRoomDTO)
{
if (roomId != hotelRoomDTO.Id)
{
return null;
}
var roomDetails = await _dbContext.HotelRooms.FindAsync(roomId);
var room = _mapper.Map(hotelRoomDTO, roomDetails);
room.UpdatedBy = "";
room.UpdatedDate = DateTime.Now;
var updatedRoom = _dbContext.HotelRooms.Update(room);
await _dbContext.SaveChangesAsync();
return _mapper.Map<HotelRoomDTO>(updatedRoom.Entity);
}
}
} namespace BlazorServer.App
{
public class Startup
{
// ...
public void ConfigureServices(IServiceCollection services)
{
services.AddScoped<IHotelRoomService, HotelRoomService>();
// ... Rebuilding EF Providers for EF6 Updating Applications to use EF6 EF Tools: adding EF6 support & enabling out-of-band releases Async Query and Save Connection Resiliency Code-Based Configuration Dependency Resolution Interception/SQL logging Custom implementations of Equals or GetHashCode on entity classes Custom Code First Conventions Code First Mapping to Insert/Update/Delete Stored Procedures Configurable Migrations History Table Multiple Contexts per Database
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlCeConnectionFactory, EntityFramework">
<parameters>
<parameter value="System.Data.SqlServerCe.4.0" />
</parameters>
</defaultConnectionFactory>
<providers>
<provider invariantName="System.Data.SqlServerCe.4.0" type="System.Data.Entity.SqlServerCompact.SqlCeProviderServices, EntityFramework.SqlServerCompact" />
</providers>
</entityFramework> Update-Package EntityFramework
<!-- 1. Change in <configuration><configSections> -->
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=4.4.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
<!-- 2. Add in <entityFramework><providers> -->
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" /> PM> Install-Package EntityFramework.SqlServerCompact
<script src="/path/to/jquery.cookie.js"></script>
$.cookie('the_cookie', 'the_value');
$.cookie('the_cookie'); // => "the_value"
<script type="text/javascript">
$(function () {
$('#write').click(function () {
$.cookie('data', '{"iri":"Iran","usa":"United States"}', { expires: 365, json: true });
alert('Writed');
});
$('#show').click(function () {
var obj = jQuery.parseJSON($.cookie('data'));
alert(obj.iri);
});
$('#remove').click(function () {
$.removeCookie('data');
});
})
</script>
<body>
<a href="#" id="write">Write</a>
<br />
<a href="#" id="show">Show</a>
<br />
<a href="#" id="remove">Remove</a>
</body>
$('#write').click(function () {
$.cookie('data', '{"iri":"Iran","usa":"United States"}', { expires: 365, json: true });
alert('Writed');
});
$('#show').click(function () {
var obj = jQuery.parseJSON($.cookie('data'));
alert(obj.iri);
$('#remove').click(function () {
$.removeCookie('data');
});
$.cookie('data', JSON.stringify(jsonobject), { expires: 365, json: true });