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