Есть просто номер, который соответствует id в таблице Скана.
var detailsViewModel = db.employees.Include(ep => ep.Position)
.Where(j => j.Id == id)
.Select(emp => new EmploeeViewModel
{
Name = emp.Name,
Position = emp.Position,
Сontract = db.Contract.FirstOrDefault(c => c.Id == emp.ContractId)
}.FirstOrDefault();
return View(detailsViewModel);
var timeout = 600;
var optionsBuilder = new DbContextOptionsBuilder<InstituteContext>()
.UseSqlServer(new SqlConnection(connectionString), opt =>
{
opt.CommandTimeout(timeout);
});
using (var context = new InstituteContext (optionsBuilder.Options))
{
// your code
}
var orders = db.Orders
.Where(x => x.Kod == kod)
.GroupBy(x => x.Nomenklatura)
.ToDictionary(x => x.FirstOrDefault().Nomenklatura, x => x.ToList() )
orders["anyNomenklatura"]
var word = db.Words.Include(x => x.LearnDay).Where(p => p.Id == testId).FirstOrDefault();
public void ConfigureServices(IServiceCollection services)
{
services.AddAuthorization(x =>
{
x.AddPolicy("RoleStartWith", policy => {
policy.RequireRole(roles.Where(r => r.StartsWith("ad")));
});
});
}
[Authorize(Policy = "RoleStartWith")]
public IActionResult Index()
{
return View();
}
public class CustomAutorizeAttribute : AuthorizeAttribute
{
private string _prefix;
private string[] _roles;
public CustomAutorizeAttribute(string prefix)
{
_prefix = prefix;
_roles = base.Roles.Split(',').Select(x => x.Trim()).ToArray();
}
protected override bool AuthorizeCore(HttpContextBase httpContext)
{
return _roles.Where(x => x.StartsWith(_prefix)).Any(x => httpContext.User.IsInRole(x));
}
}
[CustomAutorize(prefix = "ad")]
public IActionResult Index()
{
return View();
}
public class VmWord
{
public int Id { get; set; }
public string Name { get; set; }
public string Localization { get; set; }
[NotMapped]
public Dictionary<string, string> Localizations
{
get { return JsonConvert.DeseriazeObject<Dictionary<string, string>>(Localization.ToList()); }
set { Localization = JsonConvert.SerializeObject(value); }
}
}
public class VmWord
{
public int Id { get; set; }
public string Name { get; set; }
public virtual List<string> Localizations { get; set; }
}
public class Localization
{
public int Id { get; set; }
public string Key { get; set; }
public string Value { get; set; }
public virtual VmWord VmWord { get; set; }
}
bd.User.OrderBy(x => x.Id).ElementAt(5);
bd.User.OrderBy(x => x.Id).ToList().FindIndex(x => x.Name == "Vasya");
return JsonConvert.SerializeObject(results, Formatting.Indented,
new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
});