public async Task <IncrementsModel> CreateNewIncrement(string tableName) { var increment = new IncrementsModel() { Next = 1, TableName = tableName }; await AddIncrement(increment).ConfigureAwait(false); return(increment); }
public object ValidateIncrementsData(IncrementsModel incrementsModel) { ResponseList = new List <object>(); foreach (IncrementsDetails incrementsDetails in incrementsModel.IncrementsDetails) { if (incrementsDetails.IncrementAmount <= 0) { Success = "Failed"; ResponseList.Add(_incrementsResponseMessages.InvalidAmount()); } if (string.IsNullOrEmpty(incrementsDetails.Description.Trim())) { Success = "Failed"; ResponseList.Add(_incrementsResponseMessages.DescNotProvided()); } else { if (incrementsDetails.Description.Length > 100) { Success = "Failed"; ResponseList.Add(_incrementsResponseMessages.DescExceedsLimit()); } } if (string.IsNullOrEmpty(incrementsDetails.IncrementDate.Trim())) { Success = "Failed"; ResponseList.Add(_incrementsResponseMessages.DateNotProvided()); } else { if (!IsValidDateFormat(incrementsDetails.IncrementDate)) { Success = "Failed"; ResponseList.Add(_incrementsResponseMessages.InvalidDateFormat()); } } } if (Success != null) { return(this); } return(null); }
public async Task <Guid[]> AddIncrements(Guid businessID, IncrementsModel incrementsModel) { var businessId = new Npgsql.NpgsqlParameter("@thebusinessid", businessID); var incrementsDetails = new Npgsql.NpgsqlParameter("@theincrementsdetails", NpgsqlDbType.Json) { Direction = ParameterDirection.InputOutput, Value = incrementsModel.IncrementsDetails ?? (object)DBNull.Value }; IncrementsAddingButEmployeeIDsNotPresent incrementsAddingButEmployeeIDsNotPresent = await Task.Run(() => _projectContextDB.IncrementsAddingButEmployeeIDsNotPresent. FromSqlRaw("select * from addincrements(@thebusinessid,@theincrementsdetails)", businessId, incrementsDetails) .Select(e => new IncrementsAddingButEmployeeIDsNotPresent() { NotFoundEmployeesIds = e.NotFoundEmployeesIds }).FirstOrDefault()); if (incrementsAddingButEmployeeIDsNotPresent.NotFoundEmployeesIds.Length == 0) { return(null); } return(incrementsAddingButEmployeeIDsNotPresent.NotFoundEmployeesIds); }
public async Task <object> AddIncrements(Guid businessID, [FromBody] IncrementsModel incrementsModel) { var checkBusinessId = await _commonLogic.CheckBusinessID(businessID); if (checkBusinessId) { var errors = _incrementsValidation.ValidateIncrementsData(incrementsModel); if (errors != null) { return(errors); } var response = await _incrementsLogic.AddIncrements(businessID, incrementsModel); if (response == null) { return(_incrementsValidation.IncrementsAddedSuccess()); } return(_commonValidation.TheseEmployeesIdsNotFound(response)); } return(_commonValidation.BusinessIdNotExists(businessID)); }
//public async Task<int> IncrementTable(string tableName) //{ // var increment = await GetIncrement(tableName).ConfigureAwait(false) ?? // await CreateNewIncrement(tableName).ConfigureAwait(false); //} public async Task AddIncrement(IncrementsModel increment) { await DynamoDbContextProvider.CurrentContext.SaveAsync(increment).ConfigureAwait(false); }
public Task <Guid[]> AddIncrements(Guid businessID, IncrementsModel incrementsModel) { return(_incrementsDAL.AddIncrements(businessID, incrementsModel)); }