//public async Task<bool> DeleteLocationByID(int id)
//{
// using (ContactDBContext db = new ContactDBContext())
// {
// Contacts contact = db.Contacts.Where(x => x.ContactId == id).FirstOrDefault();
// if (contact != null)
// {
// db.Locations.Remove(contact);
// }
// return await db.SaveChangesAsync() >= 1;
// }
//}
public async Task <List <SelfInfo> > GetSelfInfoLocations()
{
using (LocationDBContext db = new LocationDBContext())
{
return(await(from si in db.SelfInfo
select new SelfInfo
{
LocationID = si.LocationID.Trim()
}).Distinct().ToListAsync());
}
}
public async Task <List <Employer> > GetAllEmployers()
{
using (LocationDBContext db = new LocationDBContext())
{
return(await(from e in db.Employers
select new Employer
{
ERPEmployerID = e.ERPEmployerID.Trim(),
EmployerName = e.EmployerName,
Active = e.Active
}).Distinct().ToListAsync());
}
}
public async Task <bool> SaveLocation(Location model)
{
using (LocationDBContext db = new LocationDBContext())
{
Locations location = db.Locations.Where(x => x.LocationID == model.LocationID).FirstOrDefault();
if (location == null)
{
location = new Locations()
{
LocationID = model.LocationID.Trim(),
ERPEmployerID = model.ERPEmployerID.Trim(),
Name = model.Name.Trim(),
Address1 = model.Address1,
Address2 = model.Address2,
City = model.City,
State = model.State,
ZIP = model.ZIP,
Country = model.Country,
Active = model.Active ?? null,
ADCountryAbrv = model.ADCountryAbrv,
ADCountryCode = model.ADCountryCode ?? null
};
db.Locations.Add(location);
}
else
{
location.LocationID = model.LocationID.Trim();
location.ERPEmployerID = model.ERPEmployerID.Trim();
location.Name = model.Name.Trim();
location.Address1 = model.Address1;
location.Address2 = model.Address2;
location.City = model.City;
location.State = model.State;
location.ZIP = model.ZIP;
location.Country = model.Country;
location.Active = model.Active;
location.ADCountryAbrv = model.ADCountryAbrv;
location.ADCountryCode = Convert.ToInt32(model.ADCountryCode);
}
return(await db.SaveChangesAsync() >= 1);
}
}
public async Task <List <Location> > GetAllLocations()
{
using (LocationDBContext db = new LocationDBContext())
{
return(await(from l in db.Locations
select new Location
{
LocationID = l.LocationID.Trim(),
ERPEmployerID = l.ERPEmployerID.Trim(),
Name = l.Name.Trim(),
Address1 = l.Address1,
Address2 = l.Address2,
City = l.City,
State = l.State,
ZIP = l.ZIP,
Country = l.Country,
Active = l.Active,
ADCountryCode = l.ADCountryCode,
ADCountryAbrv = l.ADCountryAbrv
}).ToListAsync());
}
}
public BaseRepository(LocationDBContext context)
{
this.context = context;
}
public UnitOfWork(LocationDBContext context)
{
this.context = context;
}
public LoginController(IAuthenticationService authenticationService, LocationDBContext _db)
{
this.authenticationService = authenticationService;
db = _db;
}
public UserRepository(LocationDBContext context, IOptions <TokenOptions> tokenOptions) : base(context)
{
this.tokenOptions = tokenOptions.Value;
}
public AddressController(LocationDBContext _dbContext, IHttpContextAccessor httpContextAccessor, IAwsS3HelperService awsS3Service)
{
dbContext = _dbContext;
_httpContextAccessor = httpContextAccessor;
_awsS3Service = awsS3Service;
}
