public async Task <SaveResult> UpdateAsync(ProductDto entity) { SaveResult result = SaveResult.FAILURE; try { using (OrderAppEntities context = new OrderAppEntities()) { var product = context.Products.Single(x => x.Id == entity.ID && x.IsDeleted == false); product.UnitPrice = entity.UnitPrice; product.ProductName = entity.ProductName; context.Entry <Product>(product).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return(result); }
/// <summary> /// Sets the role asynchronous. /// </summary> /// <param name="id">The identifier.</param> /// <param name="roleType">Type of the role.</param> /// <returns></returns> public async Task <SaveResult> SetRoleAsync(int id, RoleType roleType) { SaveResult result = SaveResult.FAILURE; try { using (OrderAppEntities context = new OrderAppEntities()) { var user = context.Users.Single(x => x.Id == id && x.IsDeleted == false); user.RoleId = (int)roleType; user.LastUpdate = DateTime.Now; context.Entry <User>(user).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return(result); }
/// <summary> /// Adds the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task <SaveResult> AddAsync(UserDto entity) { SaveResult result = SaveResult.FAILURE; try { using (OrderAppEntities context = new OrderAppEntities()) { User add = context.Users.Create(); add.Email = entity.Email; add.PasswordHash = AppCipher.EncryptCipher(entity.PasswordHash); add.RoleId = entity.RoleId; add.RegistedDate = entity.RegistedDate; add.Phone = entity.Phone; add.IsLocked = entity.IsLocked; add.Firstname = entity.Firstname; add.Lastname = entity.Lastname; add.LastLoginDate = entity.LastLoginDate; add.IsDeleted = entity.IsDeleted; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry <User>(add).State = System.Data.Entity.EntityState.Added; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return(result); }
/// <summary> /// Lockeds the asynchronous. /// </summary> /// <param name="id">The identifier.</param> /// <returns></returns> public async Task <SaveResult> LockedAsync(int id) { SaveResult result = SaveResult.FAILURE; try { using (OrderAppEntities context = new OrderAppEntities()) { var assembly = context.Users.Single(x => x.Id == id && x.IsDeleted == false); assembly.IsLocked = true; assembly.LastUpdate = DateTime.Now; context.Entry <User>(assembly).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return(result); }
/// <summary> /// Updates the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task <SaveResult> UpdateAsync(UserDto entity) { SaveResult result = SaveResult.FAILURE; try { using (OrderAppEntities context = new OrderAppEntities()) { var update = context.Users.Single(x => x.Id == entity.ID && x.IsDeleted == false); update.RoleId = entity.RoleId; update.Phone = entity.Phone; update.IsLocked = entity.IsLocked; update.Firstname = entity.Firstname; update.Lastname = entity.Lastname; update.IsDeleted = entity.IsDeleted; update.LastUpdatedBy = entity.LastUpdatedBy; update.LastUpdate = DateTime.Now; context.Entry <User>(update).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return(result); }
public async Task <SaveResult> UpdateAsync(CountryDto entity) { SaveResult result = SaveResult.FAILURE; try { using (OrderAppEntities context = new OrderAppEntities()) { var Country = context.Countries.Single(x => x.Id == entity.ID && x.IsDeleted == false); Country.Name = entity.Name; Country.Description = entity.Description; context.Entry <Country>(Country).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return(result); }
/// <summary> /// Deletes the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task <SaveResult> DeleteAsync(RoleDto entity) { SaveResult result = SaveResult.FAILURE; try { using (OrderAppEntities context = new OrderAppEntities()) { var role = context.Roles.Single(x => x.Id == entity.ID && x.IsDeleted == false); role.IsDeleted = true; role.LastUpdate = DateTime.Now; role.LastUpdatedBy = entity.LastUpdatedBy; context.Entry <Role>(role).State = System.Data.Entity.EntityState.Modified; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return(result); }
/// <summary> /// Adds the asynchronous. /// </summary> /// <param name="entity">The entity.</param> /// <returns></returns> public async Task <SaveResult> AddAsync(RoleDto entity) { SaveResult result = SaveResult.FAILURE; try { using (OrderAppEntities context = new OrderAppEntities()) { Role add = context.Roles.Create(); add.Description = entity.Description; add.Name = entity.Name; add.IsDeleted = false; add.LastUpdatedBy = entity.LastUpdatedBy; add.LastUpdate = DateTime.Now; context.Entry <Role>(add).State = System.Data.Entity.EntityState.Added; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return(result); }
public async Task <SaveResult> AddAsync(ProductDto entity) { SaveResult result = SaveResult.FAILURE; try { using (OrderAppEntities context = new OrderAppEntities()) { Product add = context.Products.Create(); add.ProductName = entity.ProductName; add.UnitPrice = entity.UnitPrice; context.Entry <Product>(add).State = System.Data.Entity.EntityState.Added; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return(result); }
public async Task <SaveResult> AddAsync(CountryDto entity) { SaveResult result = SaveResult.FAILURE; try { using (OrderAppEntities context = new OrderAppEntities()) { Country add = context.Countries.Create(); add.Description = entity.Description; add.Name = entity.Name; context.Entry <Country>(add).State = System.Data.Entity.EntityState.Added; result = await context.SaveChangesAsync() > 0 ? SaveResult.SUCCESS : SaveResult.FAILURE; } } catch (Exception ex) { _logService.Error(ex.Message, ex); result = SaveResult.FAILURE; } return(result); }