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