public void UpdateVerified(VBRealizationPosition position, string reason, string username, string userAgent)
{
Position = position;
VerificationDate = DateTimeOffset.Now;
VerifiedBy = username;
IsVerified = true;
NotVerifiedReason = reason;
this.FlagForUpdate(username, userAgent);
}
private void UpdateVBRealizationPosition(int vbRealizationId, VBRealizationPosition position, string reason)
{
var model = _dbContext.VBRealizationDocuments.FirstOrDefault(entity => entity.Id == vbRealizationId);
model.UpdatePosition(position, _identityService.Username, UserAgent);
if (position == VBRealizationPosition.VerifiedToCashier || position == VBRealizationPosition.NotVerified || position == VBRealizationPosition.Cashier)
{
model.UpdateVerified(position, reason, _identityService.Username, UserAgent);
}
EntityExtension.FlagForUpdate(model, _identityService.Username, UserAgent);
_dbContext.VBRealizationDocuments.Update(model);
}
private void UpdateVBRealizationPosition(List <int> vbRealizationIds, VBRealizationPosition position, string reason)
{
var models = _dbContext.VBRealizationDocuments.Where(entity => vbRealizationIds.Contains(entity.Id)).ToList();
models.ForEach(model =>
{
model.UpdatePosition(position, _identityService.Username, UserAgent);
if (position == VBRealizationPosition.VerifiedToCashier || position == VBRealizationPosition.NotVerified)
{
model.UpdateVerified(position, reason, _identityService.Username, UserAgent);
}
EntityExtension.FlagForUpdate(model, _identityService.Username, UserAgent);
});
_dbContext.VBRealizationDocuments.UpdateRange(models);
}
public IActionResult Get([FromQuery] int vbId, [FromQuery] int vbRealizationId, [FromQuery] DateTimeOffset?realizationDate, [FromQuery] string vbRealizationRequestPerson, [FromQuery] int unitId, [FromQuery] VBRealizationPosition position = 0, [FromQuery] int page = 1, [FromQuery] int size = 25, [FromQuery] string order = "{}", [FromQuery] string keyword = "")
{
try
{
VerifyUser();
var data = _service.Read(page, size, order, keyword, position, vbId, vbRealizationId, realizationDate, vbRealizationRequestPerson, unitId);
return(Ok(new
{
apiVersion = ApiVersion,
data = data.Data,
info = new
{
data.Count
},
message = General.OK_MESSAGE,
statusCode = General.OK_STATUS_CODE
}));
}
catch (Exception e)
{
Dictionary <string, object> Result =
new ResultFormatter(ApiVersion, General.INTERNAL_ERROR_STATUS_CODE, e.Message)
.Fail();
return(StatusCode(General.INTERNAL_ERROR_STATUS_CODE, Result));
}
}
public void UpdatePosition(VBRealizationPosition position, string user, string userAgent)
{
Position = position;
this.FlagForUpdate(user, userAgent);
}
public ReadResponse <VBRealizationDocumentExpeditionModel> ReadVerification(int page, int size, string order, string keyword, VBRealizationPosition position, int vbId, int vbRealizationId, DateTimeOffset?realizationDate, string vbRealizationRequestPerson, int unitId)
{
throw new NotImplementedException();
}
public ReadResponse <VBRealizationDocumentExpeditionModel> ReadVerification(int page, int size, string order, string keyword, VBRealizationPosition position, int vbId, int vbRealizationId, DateTimeOffset?realizationDate, string vbRealizationRequestPerson, int unitId)
{
var query = _dbContext.Set <VBRealizationDocumentExpeditionModel>().AsQueryable();
var idQuery = query;
var selectData = idQuery.GroupBy(entity => entity.VBRealizationId)
.Select(e => e.OrderByDescending(x => x.Id)
.FirstOrDefault()).ToList();
var ids = selectData.Select(element => element.Id).ToList();
query = query.Where(entity => ids.Contains(entity.Id) && (entity.Position == VBRealizationPosition.VerifiedToCashier || entity.Position == VBRealizationPosition.NotVerified));
if (vbId > 0)
{
query = query.Where(entity => entity.VBId == vbId);
}
if (vbRealizationId > 0)
{
query = query.Where(entity => entity.VBRealizationId == vbRealizationId);
}
if (realizationDate.HasValue)
{
var date = realizationDate.GetValueOrDefault().AddHours(_identityService.TimezoneOffset * -1);
query = query.Where(entity => entity.VBRealizationDate.Date == date.Date);
}
if (!string.IsNullOrWhiteSpace(vbRealizationRequestPerson))
{
query = query.Where(entity => entity.VBRequestName == vbRealizationRequestPerson);
}
if (unitId > 0)
{
query = query.Where(entity => entity.UnitId == unitId);
}
//query = query
// .Select(entity => new VBRealizationDocumentExpeditionIndexDto
// {
// Id = entity.Id,
// LastModifiedUtc = entity.LastModifiedUtc,
// VBNo = entity.VBNo,
// VBRealizationNo = entity.VBRealizationNo,
// VBRealizationDate = entity.VBRealizationDate,
// VBName = entity.VBRequestName,
// UnitId = entity.UnitId,
// UnitName = entity.UnitName,
// DivisionId = entity.DivisionId,
// DivisionName = entity.DivisionName,
// Currency
// });
List <string> searchAttributes = new List <string>()
{
"VBRealizationNo", "VBRequestName", "UnitName"
};
query = QueryHelper <VBRealizationDocumentExpeditionModel> .Search(query, searchAttributes, keyword);
//var filterDictionary = JsonConvert.DeserializeObject<Dictionary<string, object>>(filter);
//Query = QueryHelper<JournalTransactionModel>.Filter(Query, FilterDictionary);
var orderDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(order);
query = QueryHelper <VBRealizationDocumentExpeditionModel> .Order(query, orderDictionary);
var pageable = new Pageable <VBRealizationDocumentExpeditionModel>(query, page - 1, size);
var data = pageable.Data.ToList();
var totalData = pageable.TotalCount;
return(new ReadResponse <VBRealizationDocumentExpeditionModel>(data, totalData, orderDictionary, new List <string>()));
}
