public AddressAuditLogResponse Insert(AddressAuditLogRequest addressAuditLogRequest)
{
AddressAuditLogResponse addressAuditLogResponse = new AddressAuditLogResponse();
try
{
this.context.AddressAuditLogRequests.Add(addressAuditLogRequest);
this.context.Entry(addressAuditLogRequest).State = EntityState.Added;
this.context.SaveChanges();
addressAuditLogResponse.AddressAuditLogRequestList = this.context.AddressAuditLogRequests.Where(a => a.ID == addressAuditLogRequest.ID);
addressAuditLogResponse.Success = true;
return(addressAuditLogResponse);
}
catch (Exception exception)
{
addressAuditLogResponse.Success = false;
addressAuditLogResponse.OperatonExceptionMessage = exception.Message;
}
return(addressAuditLogResponse);
}
public List <AddressAuditLogRequest> GetAll()
{
List <AddressAuditLogRequest> addressAuditLogRequests = new List <AddressAuditLogRequest>();
var auditListByName = from a in context.AddressAuditLogRequests
join us in context.UserData on(int?) a.UPD_BY equals us.ID
orderby a.ID descending
select new
{
a.ID,
a.SMT_ID,
a.CSG_ADR,
a.BFR_ADR,
a.AFR_ADR,
a.UPD_BY,
a.UPD_FRM,
a.UPD_DT,
UPD_BY_TE = us.FirstName + " " + us.LastName,
a.WFL_ID
};
foreach (var aaloglist in auditListByName)
{
AddressAuditLogRequest addrauditlog = new AddressAuditLogRequest();
addrauditlog.ID = aaloglist.ID;
addrauditlog.SMT_ID = aaloglist.SMT_ID;
addrauditlog.CSG_ADR = aaloglist.CSG_ADR;
addrauditlog.BFR_ADR = aaloglist.BFR_ADR;
addrauditlog.AFR_ADR = aaloglist.AFR_ADR;
addrauditlog.UPD_BY = aaloglist.UPD_BY;
addrauditlog.UPD_FRM = aaloglist.UPD_FRM;
addrauditlog.UPD_DT = aaloglist.UPD_DT;
addrauditlog.UPD_BY_TE = aaloglist.UPD_BY_TE;
addrauditlog.WFL_ID = aaloglist.WFL_ID;
addressAuditLogRequests.Add(addrauditlog);
}
return(addressAuditLogRequests);
}
public IActionResult UpdateAddressBookById([FromBody] AddressBook addressBookData)
{
AddressBookResponse addressBookResponse = this.addressBookService.UpdateAddressBookById(addressBookData);
if (addressBookResponse.Success && !string.IsNullOrEmpty(addressBookResponse.BeforeAddress))
{
try
{
int userId = Convert.ToInt32(HttpContext.User.Claims.FirstOrDefault(x => x.Type == JwtConstant.UserId).Value);
//AddressAuditLog Update
AddressAuditLogRequest addressAuditLogRequest = new AddressAuditLogRequest();
addressAuditLogRequest.SMT_ID = addressBookResponse.AddressBookData.ShipmentId;
addressAuditLogRequest.CSG_ADR = addressBookResponse.AddressBookData.ConsigneeAddress;
addressAuditLogRequest.BFR_ADR = addressBookResponse.BeforeAddress;
addressAuditLogRequest.AFR_ADR = addressBookData.ConsigneeTranslatedAddress;
addressAuditLogRequest.UPD_BY = userId;
addressAuditLogRequest.UPD_FRM = "AddressBook";
addressAuditLogRequest.UPD_DT = DateTime.Now;
addressAuditLogRequest.WFL_ID = addressBookData.WFL_ID;
AddressAuditLogResponse addressAuditLogResponse = this.addressAuditLogService.Insert(addressAuditLogRequest);
if (addressAuditLogResponse.Success)
{
// TO DO
}
else
{
// Log the error here
}
}
catch (Exception ex)
{
AuditEventEntry.WriteEntry(ex);
}
}
return(Ok(addressBookResponse));
}
public async Task <ActionResult> UpdateShipmentAddressById([FromBody] ShipmentDataRequest shipmentDataRequest)
{
//shipmentService = new ShipmentService();
string id = HttpContext.User.Claims.FirstOrDefault(x => x.Type == JwtConstant.UserId)?.Value;
int userId = !string.IsNullOrEmpty(id) ? Convert.ToInt32(id) : 0;
ShipmentDataResponse shipmentDataResponse = _shipmentService.UpdateShipmentAddressById(shipmentDataRequest);
if (shipmentDataResponse.Success && !string.IsNullOrEmpty(shipmentDataResponse.BeforeAddress))
{
try
{
//AddressAuditLog Update
AddressAuditLogRequest addressAuditLogRequest = new AddressAuditLogRequest();
addressAuditLogRequest.SMT_ID = shipmentDataRequest.ID;
addressAuditLogRequest.CSG_ADR = shipmentDataRequest.RCV_ADR_TE;
addressAuditLogRequest.BFR_ADR = shipmentDataResponse.BeforeAddress;
addressAuditLogRequest.AFR_ADR = shipmentDataResponse.ShipmentDataRequest.SHP_ADR_TR_TE;
addressAuditLogRequest.UPD_BY = userId;
addressAuditLogRequest.UPD_FRM = "Shipment";
addressAuditLogRequest.UPD_DT = DateTime.Parse(DateTime.Now.ToString()).ToLocalTime();
addressAuditLogRequest.WFL_ID = shipmentDataResponse.ShipmentDataRequest.WFL_ID;
AddressAuditLogResponse addressAuditLogResponse = addressAuditLogService.Insert(addressAuditLogRequest);
if (addressAuditLogResponse.Success)
{
// TO DO
}
else
{
// Log the error here
}
}
catch (Exception ex)
{
}
}
//we need to update the workflow status
int?workflowstatus = _shipmentService.SelectShipmentTotalStatusByWorkflowId(shipmentDataRequest.WFL_ID);
WorkflowDataRequest workflowDataRequest = new WorkflowDataRequest();
workflowDataRequest.ID = shipmentDataRequest.WFL_ID;
workflowDataRequest.WFL_STA_TE = workflowstatus;
_workflowService.UpdateWorkflowStatusById(workflowDataRequest);
#pragma warning disable CS4014 // Because this call is not awaited, execution of the current method continues before the call is completed
Task.Run(() => iCustomLog.AddLogEntry(new UPS.DataObjects.LogData.LogDataModel()
{
apiTypes = UPS.DataObjects.LogData.APITypes.EFCoreContext,
apiType = Enum.GetName(typeof(UPS.DataObjects.LogData.APITypes), 6),
dateTime = System.DateTime.Now,
LogInformation = new UPS.DataObjects.LogData.LogInformation()
{
LogException = null,
LogRequest = JsonConvert.SerializeObject(shipmentDataRequest),
LogResponse = JsonConvert.SerializeObject(shipmentDataResponse)
}
}));
#pragma warning restore CS4014 // Because this call is not awaited, execution of the current method continues before the call is completed
return(Ok(shipmentDataResponse));
}
