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;
}
