public BusinessAggregateSteps() { _config = new ConfigurationFactory().CreateFromAzureSettings(); _connectionString = new ConnectionStringFactory(_config).CreateFromAzureSettings("Stack:Shared:SqlConnection"); _dbContext = new DbContextFactory(_connectionString).Create(); Aggregate = new AssociateAggregate(_dbContext); }
public static async Task <IActionResult> Run( [HttpTrigger(AuthorizationLevel.Function, "get", Route = null)] HttpRequest req, ILogger log) { log.LogInformation($"Subjects.BusinessesGet()"); var defaultConnection = Configuration["Stack:Shared:SqlConnection"]; var options = new DbContextOptionsBuilder <SubjectsDbContext>(); options.UseSqlServer(defaultConnection); var context = new SubjectsDbContext(options.Options); var entities = await context.Business.ToListAsync(); return(entities?.Count == 0 ? new NotFoundResult() : (IActionResult) new JsonResult(entities)); }
public static async Task <IActionResult> Run( [HttpTrigger(AuthorizationLevel.Function, "put", "post", Route = null)] HttpRequest req, ILogger log) { log.LogInformation($"Subjects.BusinessSave({req.Query["key"]})"); string defaultConnection = Configuration["Stack:Shared:SqlConnection"]; var options = new DbContextOptionsBuilder <SubjectsDbContext>(); options.UseSqlServer(defaultConnection); var context = new SubjectsDbContext(options.Options); string requestBody = await new StreamReader(req.Body).ReadToEndAsync(); var entity = JsonConvert.DeserializeObject <Business>(requestBody); var recordsAffected = await new AssociateAggregate(context).BusinessSaveAsync(entity); return(recordsAffected == 0 ? new NotFoundResult() : (IActionResult) new JsonResult(entity)); }
public static async Task <IActionResult> Run( [HttpTrigger(AuthorizationLevel.Function, "get", Route = null)] HttpRequest req, ILogger log) { log.LogInformation($"Subjects.BusinessGet({req.Query["key"]})"); var businessKey = req.Query["key"].ToString().ToGuid(); if (businessKey == Guid.Empty) { return(new BadRequestResult()); } var defaultConnection = Configuration["Stack:Shared:SqlConnection"]; var options = new DbContextOptionsBuilder <SubjectsDbContext>(); var dbContextOptionsBuilder = options.UseSqlServer(defaultConnection); var context = new SubjectsDbContext(options.Options); var entity = await context.Business.FirstAsync(x => x.BusinessKey == businessKey); return(entity == null ? new NotFoundResult() : (IActionResult) new JsonResult(entity)); }
public BusinessesController(SubjectsDbContext context, IMediator mediator) : base(mediator) { _dbContext = context; }
public AssociateOptionsController(SubjectsDbContext context) { _dbContext = context; }
public GendersController(SubjectsDbContext context) { _dbContext = context; }
public BusinessGetByKeySteps() { _config = new ConfigurationFactory().CreateFromAzureSettings(); _connectionString = new ConnectionStringFactory(_config).CreateFromAzureSettings("Stack:Shared:SqlConnection"); _dbContext = new DbContextFactory(_connectionString).Create(); }
public VentureOptionsController(SubjectsDbContext context) { _dbContext = context; }
public DetailsController(SubjectsDbContext context) { _dbContext = context; }
public BusinessGetHandler(SubjectsDbContext dbContext) { _dbContext = dbContext; _validator = new BusinessGetValidator(); _errors = new List <KeyValuePair <string, string> >(); }
public ActionResult InsertSubjects() { ViewBag.Message = "Insert Subjects"; string path = "c:/MACA/teachings.txt"; //string path = ""; // To prevent bad actions! StreamReader srTeachings = new StreamReader(path); List <TMPSubject> lstTMPSubjects = new List <TMPSubject>(); while (!srTeachings.EndOfStream) { string[] lineArr = srTeachings.ReadLine().Split(new char[] { '\t' }, StringSplitOptions.RemoveEmptyEntries); TMPSubject subject = new TMPSubject(); subject.TeacherCode = lineArr[0].Trim(); int sem = lineArr[1].Trim().ToLower() == "l" ? 2 : 1; subject.Semester = sem; subject.Year = lineArr[2].Trim(); subject.TeachingType = lineArr[3].Trim(); subject.HoursPerWeek = double.Parse(lineArr[4].Trim()); subject.SubjectCode = lineArr[5].Trim(); string depShort = lineArr[6].Trim(); string[] depShortSplit = depShort.Split('/'); subject.Department = depShortSplit[0].Trim(); subject.ShortName = depShortSplit[1].Trim(); subject.Name = lineArr[7].Trim(); if (lstTMPSubjects.Where(x => x.ShortName == subject.ShortName && x.Department == subject.Department && x.TeacherCode == subject.TeacherCode && x.TeachingType == subject.TeachingType && x.Year == subject.Year && x.Semester == subject.Semester && x.SubjectCode == subject.SubjectCode).Count() > 0) { lstTMPSubjects.Where(x => x.ShortName == subject.ShortName && x.Department == subject.Department && x.TeacherCode == subject.TeacherCode && x.TeachingType == subject.TeachingType && x.Year == subject.Year && x.Semester == subject.Semester && x.SubjectCode == subject.SubjectCode) .First().HoursPerWeek += subject.HoursPerWeek; } else { lstTMPSubjects.Add(subject); } } srTeachings.Close(); // Insert Persons PersonsDbContext dbPersons = new PersonsDbContext(); SubjectsDbContext dbSubjects = new SubjectsDbContext(); TeachingsDbContext dbTeachings = new TeachingsDbContext(); List <Subject> lstSubjects = new List <Subject>(); Dictionary <Guid, List <Teaching> > dicTeachings = new Dictionary <Guid, List <Teaching> >(); foreach (TMPSubject tmp in lstTMPSubjects) { if (lstSubjects.Where(x => x.ShortName == tmp.ShortName && x.Department == tmp.Department && x.Year == tmp.Year && x.Semester == tmp.Semester && x.AISCode == tmp.SubjectCode).Count() == 0) { Subject sub = new Subject(); sub.SubjectID = Guid.NewGuid(); sub.AISCode = tmp.SubjectCode; sub.Department = tmp.Department; sub.Name = tmp.Name; sub.Semester = tmp.Semester; sub.ShortName = tmp.ShortName; sub.AISCode = tmp.SubjectCode; sub.Year = tmp.Year; lstSubjects.Add(sub); Teaching t = new Teaching(); t.TeachingID = Guid.NewGuid(); t.Hours = tmp.HoursPerWeek; try { t.PersonID = dbPersons.Persons.Where(x => x.AISID == tmp.TeacherCode).First().PersonID; } catch { continue; } t.SubjectID = sub.SubjectID; t.TeachingTypeID = dbTeachings.TeachingTypes.Where(x => x.AISCode == tmp.TeachingType).First().TeachingTypeID; dicTeachings.Add(sub.SubjectID, new List <Teaching>()); dicTeachings[sub.SubjectID].Add(t); } else { Subject sub = lstSubjects.Where(x => x.ShortName == tmp.ShortName && x.Department == tmp.Department && x.Year == tmp.Year && x.Semester == tmp.Semester && x.AISCode == tmp.SubjectCode).First(); Teaching t = new Teaching(); t.TeachingID = Guid.NewGuid(); t.Hours = tmp.HoursPerWeek; try { t.PersonID = dbPersons.Persons.Where(x => x.AISID == tmp.TeacherCode).First().PersonID; } catch { continue; } t.SubjectID = sub.SubjectID; t.TeachingTypeID = dbTeachings.TeachingTypes.Where(x => x.AISCode == tmp.TeachingType).First().TeachingTypeID; dicTeachings[sub.SubjectID].Add(t); } } foreach (Subject sub in lstSubjects) { sub.DateCreated = DateTime.Now; sub.DateModified = DateTime.Now; sub.UserCreatedID = new Guid(User.Identity.GetUserId()); sub.UserModifiedID = sub.UserCreatedID; dbSubjects.Subjects.Add(sub); dbSubjects.SaveChanges(); if (dicTeachings.ContainsKey(sub.SubjectID)) { foreach (Teaching t in dicTeachings[sub.SubjectID]) { t.DateCreated = DateTime.Now; t.DateModified = DateTime.Now; t.UserCreatedID = new Guid(User.Identity.GetUserId()); t.UserModifiedID = t.UserCreatedID; dbTeachings.Teachings.Add(t); dbTeachings.SaveChanges(); } } } return(RedirectToAction("Administration")); }
public PeopleController(SubjectsDbContext context) { _dbContext = context; }
public OptionGroupsController(SubjectsDbContext context) { _dbContext = context; }
public ResourcesController(SubjectsDbContext context) { _dbContext = context; }
public BusinessesOriginalController(SubjectsDbContext context) { _dbContext = context; }
public ItemsController(SubjectsDbContext context) { _dbContext = context; }
public AssociateDetailsController(SubjectsDbContext context) { _dbContext = context; }
public GovernmentsController(SubjectsDbContext context) { _dbContext = context; }