public SaleTransaction Update(SaleTransaction modifiedSale)
{
var entity = dbContext.SaleTransactions.AsNoTracking().FirstOrDefault(a => a.SaleId == modifiedSale.SaleId);
if (entity == null)
{
throw new Exception("Selected Record does not exists.");
}
var auditLog = initAuditLogUpdate(entity, modifiedSale);
updateRelatedTableColumns(ref modifiedSale);
var correctedMC = mcRepository.GetCorrectedMC(modifiedSale.MC, entity.NetWt);
entity.BaleCount = modifiedSale.BaleCount;
entity.BaleTypeDesc = modifiedSale.BaleTypeDesc;
entity.BaleTypeId = modifiedSale.BaleTypeId;
entity.CategoryDesc = modifiedSale.CategoryDesc;
entity.CategoryId = modifiedSale.CategoryId;
entity.Corrected10 = correctedMC.Corrected10;
entity.Corrected12 = correctedMC.Corrected12;
entity.Corrected14 = correctedMC.Corrected14;
entity.Corrected15 = correctedMC.Corrected15;
entity.CustomerId = modifiedSale.CustomerId;
entity.CustomerName = modifiedSale.CustomerName;
entity.DriverName = modifiedSale.DriverName;
entity.HaulerId = modifiedSale.HaulerId;
entity.HaulerName = modifiedSale.HaulerName;
entity.MC = modifiedSale.MC;
//entity.MCStatus = modifiedSale.MCStatus;
entity.MoistureReaderId = modifiedSale.MoistureReaderId;
entity.MoistureReaderDesc = modifiedSale.MoistureReaderDesc;
entity.OT = modifiedSale.OT;
entity.PM = modifiedSale.PM;
entity.PaperMillId = modifiedSale.PaperMillId;
entity.PaperMillCode = modifiedSale.PaperMillCode;
entity.ProductId = modifiedSale.ProductId;
entity.ProductDesc = modifiedSale.ProductDesc;
entity.Remarks = modifiedSale.Remarks;
entity.SealNum = modifiedSale.SealNum;
entity.Trip = modifiedSale.Trip;
entity.VehicleNum = modifiedSale.VehicleNum;
entity.VehicleTypeId = modifiedSale.VehicleTypeId;
entity.VehicleTypeCode = modifiedSale.VehicleTypeCode;
entity.WeigherOutId = modifiedSale.WeigherOutId;
entity.WeigherOutName = modifiedSale.WeigherOutName;
dbContext.SaleTransactions.Update(entity);
dbContext.SaveChanges();
if (auditLog != null)
{
auditLogRepository.Create(auditLog);
}
return(entity);
}
public async Task SaveAuditLog(string description, AuditActionEnum action)
{
var userId = _contextAccessor.HttpContext.GetUserId();
var auditLog = new AuditLog
{
Action = action.GetDisplayName(),
Description = description,
IpAddress = _contextAccessor.HttpContext.Connection.RemoteIpAddress.ToString(),
Created = DateTime.Now,
CreatedBy = userId
};
await _repository.Create(auditLog);
}
public void Handle(object sender, BasicDeliverEventArgs basicDeliverEventArgs)
{
var logEntry = new LogEntry
{
EventType = basicDeliverEventArgs.BasicProperties.Type,
Timestamp = basicDeliverEventArgs.BasicProperties.Timestamp.UnixTime,
RoutingKey = basicDeliverEventArgs.RoutingKey,
EventJson = Encoding.Unicode.GetString(basicDeliverEventArgs.Body)
};
_logger.LogTrace(
$"Log entry for event: {logEntry.EventType} with routing key: {logEntry.RoutingKey} deserialized.");
_repository.Create(logEntry);
_logger.LogTrace(
$"Log entry for event: {logEntry.EventType} with routing key: {logEntry.RoutingKey} saved.");
}
public IActionResult Post([FromBody] AuditLog model)
{
try
{
if (!ModelState.IsValid)
{
return(InvalidModelStateResult());
}
var modelStateErrors = repository.Validate(model);
if (modelStateErrors.Count() > 0)
{
ModelState.AddModelErrors(modelStateErrors);
}
var result = RedirectToAction("ValidateCode", model);
return(Accepted(repository.Create(model)));
}
catch (Exception ex)
{
logger.LogError(ex.GetExceptionMessages());
return(StatusCode(StatusCodes.Status500InternalServerError, Constants.ErrorMessages.CreateError));
}
}
public PurchaseTransaction Update(PurchaseTransaction modifiedPurchase)
{
var entity = dbContext.PurchaseTransactions.AsNoTracking().FirstOrDefault(a => a.PurchaseId == modifiedPurchase.PurchaseId);
if (entity == null)
{
throw new Exception("Selected Record does not exists.");
}
var auditLog = initAuditLogUpdate(entity, modifiedPurchase);
updateRelatedTableColumns(ref modifiedPurchase);
var correctedMC = mcRepository.GetCorrectedMC(modifiedPurchase.MC, entity.NetWt);
entity.BaleCount = modifiedPurchase.BaleCount;
entity.BaleTypeDesc = modifiedPurchase.BaleTypeDesc;
entity.BaleTypeId = modifiedPurchase.BaleTypeId;
entity.CategoryDesc = modifiedPurchase.CategoryDesc;
entity.CategoryId = modifiedPurchase.CategoryId;
entity.Corrected10 = correctedMC.Corrected10;
entity.Corrected12 = correctedMC.Corrected12;
entity.Corrected14 = correctedMC.Corrected14;
entity.Corrected15 = correctedMC.Corrected15;
entity.DriverName = modifiedPurchase.DriverName;
entity.MC = modifiedPurchase.MC;
entity.MCStatus = modifiedPurchase.MCStatus;
entity.MoistureReaderId = modifiedPurchase.MoistureReaderId;
entity.MoistureReaderDesc = modifiedPurchase.MoistureReaderDesc;
entity.OT = modifiedPurchase.OT;
entity.PM = modifiedPurchase.PM;
entity.PurchaseOrderId = modifiedPurchase.PurchaseOrderId;
entity.PONum = modifiedPurchase.PONum;
entity.POType = modifiedPurchase.POType;
entity.Price = modifiedPurchase.Price;
entity.RawMaterialId = modifiedPurchase.RawMaterialId;
entity.RawMaterialDesc = modifiedPurchase.RawMaterialDesc;
entity.Remarks = modifiedPurchase.Remarks;
entity.SourceId = modifiedPurchase.SourceId;
entity.SourceName = modifiedPurchase.SourceName;
entity.SourceCategoryId = modifiedPurchase.SourceCategoryId;
entity.SourceCategoryDesc = modifiedPurchase.SourceCategoryDesc;
entity.SubSupplierName = modifiedPurchase.SubSupplierName;
entity.SupplierId = modifiedPurchase.SupplierId;
entity.SupplierName = modifiedPurchase.SupplierName;
entity.Trip = modifiedPurchase.Trip;
entity.VehicleNum = modifiedPurchase.VehicleNum;
entity.VehicleTypeId = modifiedPurchase.VehicleTypeId;
entity.VehicleTypeCode = modifiedPurchase.VehicleTypeCode;
entity.WeigherOutId = modifiedPurchase.WeigherOutId;
entity.WeigherOutName = modifiedPurchase.WeigherOutName;
entity.MoistureReaderLogsModified = modifiedPurchase.MoistureReaderLogsModified;
dbContext.PurchaseTransactions.Update(entity);
if (modifiedPurchase.MoistureReaderLogsModified)
{
dbContext.RemoveRange(dbContext.moistureReaderLogs.Where(a => a.TransactionId == modifiedPurchase.PurchaseId));
}
dbContext.SaveChanges();
if (auditLog != null)
{
auditLogRepository.Create(auditLog);
}
balingStationRepository.CheckAndCreateStockStatusReminder();
return(entity);
}
public Inyard WeighIn(Inyard model)
{
var refNum = refNumRepository.Get().FirstOrDefault();
model.InyardNum = refNum?.InyardNum;
updateRelatedTableColumns(ref model);
var newInyard = new Inyard()
{
BaleCount = model.BaleCount,
BaleTypeDesc = baleTypeRepository.Get().Where(a => a.BaleTypeId == model.BaleTypeId).Take(1).Select(a => a.BaleTypeDesc).FirstOrDefault(),
BaleTypeId = model.BaleTypeId,
BalingStationNum = model.BalingStationNum,
BalingStationCode = model.BalingStationCode,
BalingStationName = model.BalingStationName,
CategoryDesc = model.CategoryDesc,
CategoryId = model.CategoryId,
ClientId = model.ClientId,
ClientName = model.ClientName,
CommodityDesc = model.CommodityDesc,
CommodityId = model.CommodityId,
DateTimeIn = model.DateTimeIn,
DateTimeOut = null,
DriverName = model.DriverName?.ToUpper(),
DRNum = model.DRNum?.ToUpper(),
GrossWt = model.GrossWt,
HaulerId = model.HaulerId,
HaulerName = model.HaulerName,
InyardNum = model.InyardNum,
IsOfflineIn = model.IsOfflineIn,
IsOfflineOut = model.IsOfflineOut,
MC = model.MC,
MCStatus = model.MCStatus,
MoistureReaderProcess = model.MoistureReaderProcess,
MoistureReaderDesc = model.MoistureReaderDesc,
MoistureReaderId = model.MoistureReaderId,
MoistureSettingsId = 1,
NetWt = model.NetWt,
OT = model.OT,
PlantMC = model.PlantMC,
PlantNetWt = model.PlantNetWt,
PlantTruckOrigin = model.PlantTruckOrigin?.ToUpper(),
PM = model.PM,
PaperMillId = model.PaperMillId,
PaperMillCode = model.PaperMillCode,
PurchaseOrderId = model.PurchaseOrderId,
PONum = model.PONum,
POType = model.POType,
Price = model.Price,
Remarks = model.Remarks?.ToUpper(),
SealNum = model.SealNum?.ToUpper(),
SignatoryId = 1,
SourceCategoryDesc = model.SourceCategoryDesc,
SourceCategoryId = model.SourceCategoryId,
SourceId = model.SourceId,
SourceName = model.SourceName,
SubSupplierName = model.SubSupplierName?.ToUpper(),
TareWt = model.TareWt,
TimeZoneIn = model.DateTimeIn.GetTimeZone(),
TimeZoneOut = null,
TransactionProcess = model.TransactionProcess,
TransactionTypeCode = model.TransactionTypeCode,
Trip = model.Trip?.ToUpper(),
VehicleNum = model.VehicleNum?.ToUpper(),
VehicleTypeCode = model.VehicleTypeCode,
VehicleTypeId = model.VehicleTypeId,
WeigherInId = model.WeigherInId,
WeigherInName = model.WeigherInName,
WeigherOutId = null,
WeigherOutName = null
};
dbContext.Inyards.Add(newInyard);
refNum.InyardNum = String.Format(StringFormats.REFNO_FORMAT, Convert.ToInt32(refNum.InyardNum) + 1);
dbContext.ReferenceNumbers.Update(refNum);
dbContext.SaveChanges();
if (model.TransactionTypeCode == "I" && model.IsOfflineIn == false)
{
var vd = new VehicleDeliveryRestriction()
{
VehicleNum = model.VehicleNum,
CommodityId = model.CommodityId,
DateTimeIn = model.DateTimeIn
};
vehicleDeliveryRestrictionRepository.Create(vd);
var pg = new PurchaseGrossWtRestriction()
{
VehicleNum = model.VehicleNum,
Weight = model.InitialWt,
DateTimeIn = model.DateTimeIn
};
purchaseGrossWtRestrictionRepository.Create(pg);
}
if (model.IsOfflineIn)
{
var auditLog = new AuditLog()
{
AuditLogEventId = auditLogEventRepository.GetOfflineInEventId(),
UserAccountId = model.WeigherInId,
AuditLogEventDesc = String.Empty,
Notes = formatOfflineInEvent(model)
};
auditLogRepository.Create(auditLog);
}
return(newInyard);
}
