public Student AddStudent(Student student)
{
_dbContext.Set <Student>().Add(student);
_dbContext.SaveChanges();
this.whenStudentCreated.OnNext(student);
return(student);
}
public void Run(IServiceProvider serviceProvider)
{
//configure console logging
DbContext = serviceProvider.GetService <SchoolDbContext>();
FiscalYears = DbContext.Set <FiscalYearEntity>().ToArray();
Districts = DbContext.Set <DistrictEntity>().ToArray();
Budgets = DbContext.Set <BudgetEntity>().ToArray();
var fileRecords = ReadRecordsFromFile();
CreateOrUpdateEntities(fileRecords);
Console.WriteLine("Enter 'y' to continue...");
if (Console.ReadLine().StartsWith("y"))
{
Console.WriteLine("Proceeding...");
DbContext.SaveChanges();
}
}
public async Task <SchoolDbContext> GetMockContextAsync(IEnumerable <T> entities)
{
var options = new DbContextOptionsBuilder <SchoolDbContext>()
.UseInMemoryDatabase(Guid.NewGuid().ToString())
.Options;
var context = new SchoolDbContext(options);
await context.Set <T>().AddRangeAsync(entities);
context.SaveChanges();
return(context);
}
public IActionResult Index()
{
var v = _schoolDbContext.Database.EnsureCreated();
if (v)
{
_schoolDbContext.CreateDatabasescri();
}
_schoolDbContext.Set <Course>().Add(new Course()
{
Coursename = "MCA"
});
_schoolDbContext.SaveChanges();
//_schoolDbContext.BaseEntities
//DbInitilizer.Initialize(_schoolDbContext);
//ViewBag.aa = _Student.Getsomestring();
//ViewBag.bb = _course.courses();
//var STU=_schoolDbContext.RegStudents.ToList();
return(View());
}
private DistrictEntity ChooseDistrict(SchoolDbContext dbContext)
{
var districts = dbContext.Set <DistrictEntity>().ToArray();
while (true)
{
Console.WriteLine("Choose District");
for (var index = 0; index < districts.Length; index++)
{
Console.WriteLine($"{index} {districts[index].Name}");
}
var choice = Console.ReadLine();
if (int.TryParse(choice, out var indexChosen) && indexChosen < districts.Length)
{
var chosenDistrict = districts[indexChosen];
Console.Write($"Enter 'Y' to confirm district '{chosenDistrict.Name}': ");
if (Console.ReadLine().Equals("y", StringComparison.InvariantCultureIgnoreCase))
{
return(districts[indexChosen]);
}
}
}
}
public DbOperation(SchoolDbContext context)
{
_db = context;
DbSet = context.Set <TEntity>();
}
private Dictionary <int, BudgetEntity> GetBudgetByFiscalYearMapping(SchoolDbContext dbContext, DistrictEntity district)
{
return(dbContext.Set <BudgetEntity>()
.Where(x => x.DistrictId == district.DistrictId)
.ToDictionary(x => x.FiscalYearId, x => x));
}
public Task <List <SchoolClass> > GetSchoolClasses()
{
try
{
return(SchoolDbContext.Set <SchoolClass>().ToListAsync());
}
catch (Exception ex)
{
throw new Exception($"Couldn't retrieve classes: {ex.Message}");
}
}
public Repository(SchoolDbContext context)
{
_context = context;
_dbSet = _context.Set <T>();
}
public Repository(SchoolDbContext _context)
{
this._context = _context;
table = _context.Set <T>();
}
public async virtual Task <IEnumerable <T> > AllAsync()
{
return(await dbContext.Set <T>().ToListAsync());
}
public TotalEnrollmentEntity[] GetAll()
{
All = All ?? DbContext.Set <TotalEnrollmentEntity>().ToArray();
return(All.ToArray());
}
public MembersRepo(SchoolDbContext context)
{
_context = context;
_dbset = _context.Set <Member>();
}
public void Add(Department department)
{
_schoolDb.Set <Department>().Add(department);
_schoolDb.SaveChanges();
}
public async Task DeleteAsync(TEntity entity)
{
_db.Set <TEntity>().Remove(entity);
//await _db.SaveChanges();
}
private void ConvertToTotalEnrollmentEntity(BudgetPropertiesFileRecord fileRecord, FiscalYearEntity fiscalYear)
{
var district = Districts.SingleOrDefault(x => x.Name.Equals(fileRecord.District, StringComparison.InvariantCultureIgnoreCase));
//skip record if we can't find district
if (district == null)
{
Console.WriteLine($"Skipping Record... Unable to find district '{fileRecord.District}'");
return;
}
var budget = Budgets.SingleOrDefault(x => x.DistrictId == district.DistrictId && x.FiscalYearId == fiscalYear.FiscalYearId);
var newBudget = false;
if (budget == null)
{
newBudget = true;
budget = new BudgetEntity {
DistrictId = district.DistrictId, FiscalYearId = fiscalYear.FiscalYearId
};
}
//get property value using reflection
var columnName = fiscalYear.Name.Replace("-", "");
var rawValueText = (string)fileRecord.GetType().GetProperty(columnName).GetMethod.Invoke(fileRecord, null);
if (string.IsNullOrWhiteSpace(rawValueText))
{
return;
}
if (fileRecord.Attribute.Contains("Assessed", StringComparison.InvariantCultureIgnoreCase))
{
if (long.TryParse(rawValueText, NumberStyles.Any, CultureInfo.CurrentCulture, out var assessed))
{
budget.Assessed = assessed;
}
else
{
Console.WriteLine($"Skipping Record... Unable to parse '{fileRecord.Attribute}' value '{rawValueText}'");
}
}
else if (fileRecord.Attribute.Contains("Homestead", StringComparison.InvariantCultureIgnoreCase))
{
if (int.TryParse(rawValueText, NumberStyles.Any, CultureInfo.CurrentCulture, out var homestead))
{
budget.Homestead = homestead;
}
else
{
Console.WriteLine($"Skipping Record... Unable to parse '{fileRecord.Attribute}' value '{rawValueText}'");
}
}
else if (fileRecord.Attribute.Contains("Tax Levy", StringComparison.InvariantCultureIgnoreCase))
{
if (int.TryParse(rawValueText, NumberStyles.Any, CultureInfo.CurrentCulture, out var taxLeavy))
{
budget.TaxLevy = taxLeavy;
}
else
{
Console.WriteLine($"Skipping Record... Unable to parse '{fileRecord.Attribute}' value '{rawValueText}'");
}
}
else if (fileRecord.Attribute.Contains("Collection", StringComparison.InvariantCultureIgnoreCase))
{
if (decimal.TryParse(rawValueText, NumberStyles.Any, CultureInfo.CurrentCulture, out var collectionRate))
{
budget.CollectionRate = collectionRate;
}
else
{
Console.WriteLine($"Skipping Record... Unable to parse '{fileRecord.Attribute}' value '{rawValueText}'");
}
}
else if (fileRecord.Attribute.Contains("Millage", StringComparison.InvariantCultureIgnoreCase))
{
if (decimal.TryParse(rawValueText, NumberStyles.Any, CultureInfo.CurrentCulture, out var millage))
{
budget.Millage = millage;
}
else
{
Console.WriteLine($"Skipping Record... Unable to parse '{fileRecord.Attribute}' value '{rawValueText}'");
}
}
if (newBudget)
{
Console.WriteLine("Adding New Budget");
DbContext.Set <BudgetEntity>().Add(budget);
}
}
public void AddCourse(Courses courses)
{
_schoolDb.Set <Courses>().Add(courses);
_schoolDb.SaveChanges();
}
public IQueryable <TEntity> Get()
{
var query = Db.Set <TEntity>().AsQueryable();
return(query);
}
public DistrictEntity[] GetAll()
{
All = All ?? DbContext.Set <DistrictEntity>().ToArray();
return(All);
}