public async Task <DTO.ReturnResponse <DTO.Import> > Get(long id)
{
var response = new DTO.ReturnResponse <DTO.Import>();
var v = await _db.Import.Include(o => o.ImportErrors).FirstOrDefaultAsync(o => o.Id == id);
response.Result = _mapper.Map <DTO.Import>(v);
return(response);
}
public async Task <DTO.ReturnResponse <DTO.Company> > Get(long id)
{
var ret = new DTO.ReturnResponse <DTO.Company>();
var v = await _db.Company.FirstOrDefaultAsync(o => o.Id == id);
ret.Result = _mapper.Map <DTO.Company>(v);
return(ret);
}
public async Task <DTO.ReturnResponse <DTO.PersonMap> > GetMap(long id)
{
var ret = new DTO.ReturnResponse <DTO.PersonMap>();
var v = await _db.PersonMap.Include(o => o.Columns).FirstOrDefaultAsync(o => o.Id == id);
ret.Result = _mapper.Map <DTO.PersonMap>(v);
return(ret);
}
public async Task <DTO.ReturnResponse <DTO.Company> > Update(DTO.CompanyMod company)
{
var ret = new DTO.ReturnResponse <DTO.Company>();
var v = await _db.Company.FirstOrDefaultAsync(o => o.Id == company.Id);
v = _mapper.Map <Company>(company);
await _db.SaveChangesAsync();
ret.Result = _mapper.Map <DTO.Company>(v);
return(ret);
}
public async Task <DTO.ReturnResponse <DTO.MasterMap> > Add(DTO.MasterMap inMap, long personId)
{
var response = new DTO.ReturnResponse <DTO.MasterMap>();
if (inMap.Columns.Count == 0)
{
response.Errors.Add("Zero Columns? Really?");
}
var mmap = _mapper.Map <MasterMap>(inMap);
OrmHelper.SetAuditColumns(ref mmap, true, personId);
var Headers = new List <string>();
var SqlNames = new List <string>();
foreach (var col in mmap.Columns)
{
if (Headers.Contains(col.Header))
{
response.Errors.Add($"Header not unique {col.Header}");
}
if (SqlNames.Contains(col.ColumnName))
{
response.Errors.Add($"Header not unique {col.Header}");
}
if (response.Success)
{
var tcol = col;
OrmHelper.SetAuditColumns(ref tcol, true, personId);
}
}
if (response.Success)
{
try
{
_db.MasterMap.Add(mmap);
await _db.SaveChangesAsync();
response.Result = _mapper.Map <DTO.MasterMap>(mmap);
}
catch (Exception ex)
{
response.Errors.Add(ex.Message);
}
}
return(response);
}
public async Task <DTO.ReturnResponse <DTO.Person> > Update(DTO.Person Person)
{
var ret = new DTO.ReturnResponse <DTO.Person>();
var v = await _db.Person.FirstOrDefaultAsync(o => o.Id == Person.Id);
v = _mapper.Map <Person>(Person);
await _db.SaveChangesAsync();
ret.Result = _mapper.Map <DTO.Person>(v);
return(ret);
}
public async Task <DTO.ReturnResponse <DTO.Person> > Add(DTO.Person Person)
{
var ret = new DTO.ReturnResponse <DTO.Person>();
var val = _mapper.Map <Person>(Person);
OrmHelper.SetAuditColumns <Person>(ref val, true, 1);
_db.Person.Add(val);
await _db.SaveChangesAsync();
ret.Result = _mapper.Map <DTO.Person>(val);
return(ret);
}
public async Task <DTO.ReturnResponse <DTO.PersonMap> > AddMap(DTO.PersonMapAdd map, long personId)
{
var response = new DTO.ReturnResponse <DTO.PersonMap>();
if (map.Columns.Count == 0)
{
response.Errors.Add("Zero Columns? Really?");
}
var mmap = _db.MasterMap.Include(o => o.Columns).First(o => o.Id == map.MasterMapId);
if (mmap == null)
{
response.Errors.Add($"Invalid MasterMapID {map.MasterMapId}");
}
var pmap = _mapper.Map <PersonMap>(map);
OrmHelper.SetAuditColumns(ref pmap, true, personId);
foreach (var col in pmap.Columns)
{
if (mmap.Columns.First(o => o.Header == col.OurHeader) == null)
{
response.Errors.Add($"header does not exist {col.OurHeader}");
}
if (response.Success)
{
var tcol = col;
OrmHelper.SetAuditColumns(ref tcol, true, personId);
}
}
if (response.Success)
{
try
{
_db.PersonMap.Add(pmap);
await _db.SaveChangesAsync();
response.Result = _mapper.Map <DTO.PersonMap>(pmap);
}
catch (Exception ex)
{
response.Errors.Add(ex.Message);
}
}
return(response);
}
public async Task <DTO.ReturnResponse <DTO.Company> > Add(DTO.CompanyAdd inVal)
{
var ret = new DTO.ReturnResponse <DTO.Company>();
var dbVal = _mapper.Map <Company>(inVal);
OrmHelper.SetAuditColumns <Company>(ref dbVal, true, 1);
_db.Company.Add(dbVal);
await _db.SaveChangesAsync();
ret.Result = _mapper.Map <DTO.Company>(dbVal);
return(ret);
}
public async Task <DTO.ReturnResponse <DTO.PersonMap> > UpdateMap(DTO.PersonMapMod inMap, long personId)
{
var response = new DTO.ReturnResponse <DTO.PersonMap>();
var map = await _db.PersonMap.Include(o => o.Columns).FirstOrDefaultAsync(o => o.Id == inMap.Id);
if (map == null)
{
response.Errors.Add($"Person Map {inMap.Id} does not exist");
}
else if (map.Locked)
{
response.Errors.Add($"Person Map {inMap.Id} is locked, no changes allowed");
}
else
{
}
return(response);
}
public Task <DTO.ReturnResponse <DTO.MasterMap> > Update(DTO.MasterMap map, long personId)
{
var response = new DTO.ReturnResponse <DTO.MasterMap>();
return(Task.FromResult(response));
}
