public RequestWaterHub(WaterDbContext dbContext, ILogger <RequestWaterHub> logger, UserManager <ApplicationUser> userManager)
{
_dbContext = dbContext;
_logger = logger;
_userManager = userManager;
requestorConnections = RequestorConnectionSingleton.Instance;
}
internal static async Task <List <Notes> > RetrievePrompts(string regNumber)
{
Console.WriteLine($"Retrieving Prompts for {regNumber}");
Trace.WriteLine($"{regNumber}, , Retrieving Prompts for {regNumber}");
try
{
using (var context = new WaterDbContext())
{
var notes = await context.Notes.AsNoTracking()
.Where(n => n.TABLE_ID == regNumber &&
!string.IsNullOrEmpty(n.TABLE_NAME) &&
n.TABLE_NAME.Equals("PROMPTS") &&
n.DATE_COMPLETED == null).ToListAsync();
var result = notes.Where(n => !string.IsNullOrEmpty(n.NOTE)).ToList();
return(result);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
Trace.WriteLine(ex);
}
return(null);
}
public static async Task <Move> RetrieveWaterRecords(string regNumber)
{
Trace.WriteLine($"{regNumber}, , StartTime: {DateTime.Now}");
Console.WriteLine($"Retrieving GMMS move {regNumber}");
Trace.WriteLine($"{regNumber}, , Retrieving GMMS move");
try
{
using (var context = new WaterDbContext())
{
var moves = await context.Moves
.Include(v => v.Account)
.Include(v => v.Names)
.Include(v => v.MoveItems)
.Include(v => v.MoveAgents)
.ThenInclude(v => v.Name)
.AsNoTracking()
.Where(m => m.RegNumber == regNumber).SingleAsync();
return(moves);
}
}
catch (Exception ex)
{
Console.WriteLine($"No moves retrieved for {regNumber}", ex);
Trace.WriteLine($"{regNumber}, , No moves retrieved");
}
return(null);
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, WaterDbContext dbContext, RoleManager <ApplicationRole> roleManager, UserManager <ApplicationUser> userManager)
{
dbContext.Database.Migrate();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseSwagger();
// app.UseSwaggerUI(c =>
// {
// c.SwaggerEndpoint("/swagger/v1.0/swagger.json", "API V1.0");
// });
}
else
{
app.UseExceptionHandler("/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
// ASP.NET Identity Authentication
app.UseAuthentication();
app.UseCookiePolicy();
app.UseCors("CorsPolicy");
app.UseSignalR(routes =>
{
routes.MapHub <RequestWaterHub>("/requestWaterHub");
routes.MapHub <DonateWaterHub>("/donateWaterHub");
});
var roleCreator = new RoleCreator(dbContext, userManager, roleManager, Configuration);
roleCreator.Initialize().Wait();
app.UseMvc();
}
public RegisteredUsersController(ILogger <RegisteredUsersController> logger,
IHubContext <RequestWaterHub> requestorsHubContext, WaterDbContext dbContext)
{
_logger = logger;
_requestorsHubContext = requestorsHubContext;
_requestorConnections = RequestorConnectionSingleton.Instance;
_dbContext = dbContext;
}
public RoleCreator(WaterDbContext dbContext, UserManager <ApplicationUser> userManager,
RoleManager <ApplicationRole> roleManager, IConfiguration configuration)
{
_dbContext = dbContext;
_userManager = userManager;
_roleManager = roleManager;
_configuration = configuration;
}
public WaterService(
ILogger <WaterService> logger,
WaterDbContext dbContext
)
{
_logger = logger;
_dbContext = dbContext;
_waterRequest.BaseAddress = new Uri(@"https://water.jaydeveloper.com/");
_waterRequest.DefaultRequestHeaders.Accept.Clear();
}
public UsersController(ITokenManagerService tokenManagerService,
WaterDbContext dbContext,
SignInManager <ApplicationUser> signInManager,
UserManager <ApplicationUser> userManager,
RoleManager <ApplicationRole> roleManager,
IEmailSender emailSender,
ILogger <UsersController> logger)
{
_tokenManagerService = tokenManagerService;
_dbContext = dbContext;
_signInManager = signInManager;
_userManager = userManager;
_roleManager = roleManager;
_emailSender = emailSender;
_logger = logger;
}
internal static async Task <Name> GetNames(string names_id)
{
try
{
using (var context = new WaterDbContext())
{
var name = await context.Names.AsNoTracking()
.SingleOrDefaultAsync(n => n.Id == names_id);
return(name);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
Trace.WriteLine(ex);
}
return(null);
}
internal static async Task <List <PaymentSent> > RetrieveJobCostExpense(string regNumber)
{
Console.WriteLine($"Retrieving Payment_send for {regNumber}");
Trace.WriteLine($"{regNumber}, , Retrieving Payment_send for {regNumber}");
try
{
using (var context = new WaterDbContext())
{
// open accrual records
var openAccrualRecords = await context.PaymentSent.AsNoTracking()
.Where(n => n.MOVES_ID == regNumber &&
(
(n.DATE_BILLED == null && n.ESTIMATED_AMOUNT != null) ||
(n.DATE_BILLED == null && n.ADJ_EST_AMOUNT != null)
))
.ToListAsync();
var regularRecords = await context.PaymentSent.AsNoTracking()
.Where(n => n.MOVES_ID == regNumber && n.DATE_BILLED != null)
.OrderByDescending(n => n.DATE_BILLED)
.Take(4)
.ToListAsync();
var paymentSends = openAccrualRecords.Union(regularRecords).ToList();
return(paymentSends);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
Trace.WriteLine(ex);
}
return(null);
}
internal static async Task <List <InsuranceClaims> > RetrieveInsuranceClaims(string regNumber)
{
Console.WriteLine($"Retrieving Insurance & Claims for {regNumber}");
Trace.WriteLine($"{regNumber}, , Retrieving Insurance & Claims for {regNumber}");
try
{
using (var context = new WaterDbContext())
{
var insurance = await context.InsuranceClaims.AsNoTracking()
.Where(n => n.MOVES_ID == regNumber)
.ToListAsync();
return(insurance);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
Trace.WriteLine(ex);
}
return(null);
}
public WaterService(WaterDbContext dbContext)
{
_dbContext = dbContext ?? throw new ArgumentNullException("dbContext");
}
