public Place GetRecord(string cnic)
{
using (var context = new UniDbContext())
{
return(context.Places.Where(c => c.CNIC == cnic).Include(c => c.Status).Include(c => c.ScaleNo).Include(c => c.Department).Include(c => c.Domicile).Single());
}
}
public List <Scale> GetScale()
{
using (var context = new UniDbContext())
{
return(context.Scales.ToList());
}
}
public List <ApplyFor> GetApplyFor()
{
using (var context = new UniDbContext())
{
return(context.ApplyFors.ToList());
}
}
public List <Place> GetRecord()
{
using (var context = new UniDbContext())
{
return(context.Places.Include(c => c.Status).Include(c => c.ScaleNo).Include(c => c.Department).Include(c => c.Domicile).ToList());
}
}
public List <Domicile> GetDomicile()
{
using (var context = new UniDbContext())
{
return(context.Domiciles.ToList());
}
}
public List <Designation> GetDesignation()
{
using (var context = new UniDbContext())
{
return(context.Designations.ToList());
}
}
public List <Department> GetDepartment()
{
using (var context = new UniDbContext())
{
return(context.Departments.ToList());
}
}
public List <Status> GetStatus()
{
using (var context = new UniDbContext())
{
return(context.Statuses.ToList());
}
}
public List <Scale> GetJobTitle(int id)
{
using (var context = new UniDbContext())
{
return(context.Scales.Where(c => c.Scales == id).ToList());
}
}
public UpdateTeacherCommandHandler(
[NotNull] UniDbContext dbContext,
[NotNull] IBlobStorageUploader blobStorageUploader
)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
_blobStorageUploader = blobStorageUploader ?? throw new ArgumentNullException(nameof(blobStorageUploader));
}
public void SaveApply(Place model)
{
using (var context = new UniDbContext())
{
context.Places.Add(model);
context.SaveChanges();
}
}
public FindUserByLoginAndPasswordQueryHandler(
[NotNull] UniDbContext dbContext,
[NotNull] IPasswordValidator passwordValidator
)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
_passwordValidator = passwordValidator ?? throw new ArgumentNullException(nameof(passwordValidator));
}
public ApplicationInitializationService(
[NotNull] IHostingEnvironment environment,
[NotNull] UniDbContext uniDbContext,
[NotNull] ILogger <ApplicationInitializationService> logger
)
{
_environment = environment ?? throw new ArgumentNullException(nameof(environment));
_uniDbContext = uniDbContext ?? throw new ArgumentNullException(nameof(uniDbContext));
_logger = logger ?? throw new ArgumentNullException(nameof(logger));
}
public List <ScaleNo> GetScaleNo(int id)
{
using (var context = new UniDbContext())
{
if (id == 1)
{
var scale = context.ScaleNos.OrderBy(c => c.ScaleNum).Take(20).ToList();
return(scale);
}
else
{
var scale = context.ScaleNos.OrderBy(c => c.ScaleNum).Skip(16).Take(21).ToList();
return(scale);
}
}
}
private App()
{
using (UniDbContext db = new UniDbContext())
{
Group group = new Group()
{
Name = "Best Group"
};
Student student = new Student()
{
Name = "Elvin",
Surname = "Camalzade",
GroupId = 1
};
db.Groups.Add(group);
db.Students.Add(student);
db.SaveChanges();
}
}
public CreateScheduleCommandHandler([NotNull] UniDbContext dbContext)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public RemoveGroupCommandHandler([NotNull] UniDbContext dbContext)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public CreateUserCommandHandler([NotNull] UniDbContext dbContext, [NotNull] IPasswordHasher passwordHasher)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
_passwordHasher = passwordHasher ?? throw new ArgumentNullException(nameof(passwordHasher));
}
public FindFacultiesQueryHandler([NotNull] UniDbContext dbContext)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public SalesService(UniDbContext dbContext) =>
public CompanyService(UniDbContext dbContext) =>
public FindTeacherByIdQueryHandler([NotNull] UniDbContext dbContext)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public UpdateFacultyCommandHandler([NotNull] UniDbContext dbContext)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
}
public UpdateStudentCommandHandler([NotNull] UniDbContext dbContext, IBlobStorageUploader blobStorageUploader)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(dbContext));
_blobStorageUploader = blobStorageUploader;
}
