public async Task <IHttpActionResult> PostAPIIntegrationMaster(APIIntegrationDTO data) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } Guid id = data.Id; int EntityStateId = 0; if (id == Guid.Empty) { id = Guid.NewGuid(); //user.Id = id; EntityStateId = (int)EntityState.Added; } else { EntityStateId = (int)EntityState.Modified; } Guid result = await _APIIntegrationService.Save(data, id, EntityStateId); data.Id = id; if (result == Guid.Empty) { return(NotFound()); } return(CreatedAtRoute("DefaultApi", new { id = id }, data)); }
public IQueryable <APIIntegrationDTO> GetAll() { db = new DatabaseEntities(); var data = db.APIIntegrations.Select(o => new APIIntegrationDTO { Id = o.Id, Name = o.Name, URL = o.URL, UserName = o.UserName, Password = o.Password, //o.Password, StatusCode = o.StatusCode }).DefaultIfEmpty(); List <APIIntegrationDTO> APIIntegrationDTOs = new List <APIIntegrationDTO>(); foreach (APIIntegrationDTO API in data) { APIIntegrationDTO APIInteg = new APIIntegrationDTO(); APIInteg.Id = API.Id; APIInteg.Id = API.Id; APIInteg.Name = API.Name; APIInteg.URL = API.URL; APIInteg.UserName = API.UserName; APIInteg.Password = PasswordManager.DecryptText(API.Password); //o.Password, APIInteg.StatusCode = API.StatusCode; APIIntegrationDTOs.Add(APIInteg); } return(APIIntegrationDTOs.AsQueryable()); }
public async Task <Guid> Save(APIIntegrationDTO _Dto, Guid Id, int EntityState) { APIIntegration _APIIntegration = new APIIntegration(); if (_Dto != null) { _APIIntegration.Id = Id; _APIIntegration.Name = _Dto.Name; _APIIntegration.URL = _Dto.URL; _APIIntegration.UserName = _Dto.UserName; _APIIntegration.Password = PasswordManager.DecryptText(_Dto.Password); _APIIntegration.StatusCode = EMPConstants.Active; } if (_Dto.Id != null) { _APIIntegration.CreatedBy = _Dto.UserId; _APIIntegration.CreatedDate = DateTime.Now; _APIIntegration.LastUpdatedBy = _Dto.UserId; _APIIntegration.LastUpdatedDate = DateTime.Now; } else { _APIIntegration.LastUpdatedBy = _Dto.UserId; _APIIntegration.LastUpdatedDate = DateTime.Now; } if (EntityState == (int)System.Data.Entity.EntityState.Modified) { db.Entry(_APIIntegration).State = System.Data.Entity.EntityState.Modified; } else { db.APIIntegrations.Add(_APIIntegration); } try { await db.SaveChangesAsync(); return(_APIIntegration.Id); } catch (DbUpdateConcurrencyException) { if (!IsExists(_APIIntegration.Id)) { return(_APIIntegration.Id); } else { throw; } } }