public async Task <BidAndTenderRegRespObj> Handle(AddUpdateBidAndTenderByStaffCommand request, CancellationToken cancellationToken)
{
var response = new BidAndTenderRegRespObj {
Status = new APIResponseStatus {
IsSuccessful = false, Message = new APIResponseMessage()
}
};
try
{
var user = await _serverRequest.UserDataAsync();
if (user == null)
{
response.Status.Message.FriendlyMessage = "Unable To Process This User";
return(response);
}
cor_bid_and_tender bidAndTenderObj = new cor_bid_and_tender();
var supplierAdvert = _dataContext.cor_bid_and_tender.FirstOrDefault(q => q.SupplierId == request.SupplierId && q.LPOnumber.Trim().ToLower() == request.LPONumber.Trim().ToLower());
using (var trans = _dataContext.Database.BeginTransaction())
{
try
{
if (supplierAdvert != null)
{
request.SupplierId = supplierAdvert.SupplierId;
request.BidAndTenderId = supplierAdvert.BidAndTenderId;
bidAndTenderObj = BuildBidAndTenderObject(request);
await _repo.AddUpdateBidAndTender(bidAndTenderObj);
}
else
{
bidAndTenderObj = BuildBidAndTenderObject(request);
}
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw ex;
}
finally { trans.Dispose(); }
}
response.Status.IsSuccessful = true;
response.BidAndTenderId = request.BidAndTenderId;
response.Status.Message.FriendlyMessage = "Successful";
return(response);
}
catch (Exception ex)
{
#region Log error to file
var errorCode = ErrorID.Generate(4);
_logger.Error($"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}");
return(new BidAndTenderRegRespObj
{
Status = new APIResponseStatus
{
IsSuccessful = false,
Message = new APIResponseMessage
{
FriendlyMessage = "Error occured!! Unable to process item",
MessageId = errorCode,
TechnicalMessage = $"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}"
}
}
});
#endregion
}
}
public async Task <BidAndTenderRegRespObj> Handle(SendSupplierBidAndTenderToApprovalCommand request, CancellationToken cancellationToken)
{
var apiResponse = new BidAndTenderRegRespObj {
Status = new APIResponseStatus {
IsSuccessful = false, Message = new APIResponseMessage()
}
};
try
{
var bidAndTenderObj = await _repo.GetBidAndTender(request.BidAndTenderId);
// IEnumerable<cor_paymentterms> paymentTerms = await _repo.GetPaymenttermsAsync();
if (bidAndTenderObj == null)
{
apiResponse.Status.Message.FriendlyMessage = $"Bid Not found";
return(apiResponse);
}
var enumName = (ApprovalStatus)bidAndTenderObj.ApprovalStatusId;
if (bidAndTenderObj.ApprovalStatusId != (int)ApprovalStatus.Pending)
{
apiResponse.Status.Message.FriendlyMessage = $"Unable to push supplier bid with status '{enumName.ToString()}' for approval";
return(apiResponse);
}
var _ThisBidLPO = await _repo.GetLPOByNumberAsync(bidAndTenderObj.LPOnumber);
if (_ThisBidLPO.WinnerSupplierId > 0)
{
apiResponse.Status.Message.FriendlyMessage = $"Supplier already taken for the item associated to this bid";
return(apiResponse);
}
if (bidAndTenderObj.Paymentterms.Count() > 0 && bidAndTenderObj.Paymentterms.Count(q => q.ProposedBy == (int)Proposer.STAFF) == 0)
{
apiResponse.Status.Message.FriendlyMessage = $"No Payment Plan Found";
return(apiResponse);
}
var user = await _serverRequest.UserDataAsync();
IEnumerable <cor_paymentterms> paymentTerms = await _repo.GetPaymenttermsAsync();
using (var _transaction = await _dataContext.Database.BeginTransactionAsync())
{
try
{
var targetList = new List <int>();
targetList.Add(bidAndTenderObj.BidAndTenderId);
GoForApprovalRequest wfRequest = new GoForApprovalRequest
{
Comment = "Bid and tender",
OperationId = (int)OperationsEnum.BidAndTenders,
TargetId = targetList,
ApprovalStatus = (int)ApprovalStatus.Pending,
DeferredExecution = true,
StaffId = user.StaffId,
CompanyId = user.CompanyId,
EmailNotification = true,
ExternalInitialization = false,
StatusId = (int)ApprovalStatus.Processing,
};
var result = await _serverRequest.GotForApprovalAsync(wfRequest);
if (!result.IsSuccessStatusCode)
{
apiResponse.Status.Message.FriendlyMessage = $"{result.ReasonPhrase} {result.StatusCode}";
return(apiResponse);
}
var stringData = await result.Content.ReadAsStringAsync();
GoForApprovalRespObj res = JsonConvert.DeserializeObject <GoForApprovalRespObj>(stringData);
if (res.ApprovalProcessStarted)
{
bidAndTenderObj.ApprovalStatusId = (int)ApprovalStatus.Processing;
bidAndTenderObj.WorkflowToken = res.Status.CustomToken;
// var thisBidPaymentTerms = paymentTerms.Where(d => d.BidAndTenderId == bidAndTenderObj.BidAndTenderId).ToList();
///bidAndTenderObj.Paymentterms = thisBidPaymentTerms;
await _repo.AddUpdateBidAndTender(bidAndTenderObj);
await _transaction.CommitAsync();
apiResponse.BidAndTenderId = bidAndTenderObj.BidAndTenderId;
apiResponse.Status = res.Status;
return(apiResponse);
}
if (res.EnableWorkflow || !res.HasWorkflowAccess)
{
await _transaction.RollbackAsync();
apiResponse.Status.Message = res.Status.Message;
return(apiResponse);
}
if (!res.EnableWorkflow)
{
bidAndTenderObj.ApprovalStatusId = (int)ApprovalStatus.Approved;
bidAndTenderObj.DecisionResult = (int)DecisionResult.Win;
bidAndTenderObj.PLPOId = _ThisBidLPO.PLPOId;
var thisBidPaymentTerms = paymentTerms.Where(d => d.BidAndTenderId == bidAndTenderObj.BidAndTenderId).ToList();
bidAndTenderObj.Paymentterms = thisBidPaymentTerms;
await _repo.SendEmailToSuppliersSelectedAsync(bidAndTenderObj.SupplierId, bidAndTenderObj.DescriptionOfRequest, _ThisBidLPO.PLPOId);
await _repo.AddUpdateBidAndTender(bidAndTenderObj);
var terms = paymentTerms.Where(q => q.BidAndTenderId == bidAndTenderObj.BidAndTenderId).ToList();
foreach (var term in terms)
{
term.LPOId = bidAndTenderObj.PLPOId;
term.CompanyId = bidAndTenderObj.CompanyId;
await _repo.AddUpdatePaymentTermsAsync(term);
}
var otherBids = _dataContext.cor_bid_and_tender.Where(q => q.LPOnumber.Trim().ToLower() == bidAndTenderObj.LPOnumber.Trim().ToLower() && q.BidAndTenderId != bidAndTenderObj.BidAndTenderId).ToList();
if (otherBids.Count() > 0)
{
foreach (var otherbid in otherBids)
{
otherbid.ApprovalStatusId = (int)ApprovalStatus.Disapproved;
otherbid.DecisionResult = (int)DecisionResult.Lost;
otherbid.Paymentterms = _dataContext.cor_paymentterms.Where(q => q.BidAndTenderId == otherbid.BidAndTenderId).ToList();
await _repo.AddUpdateBidAndTender(otherbid);
}
}
var thisBidLpo = _repo.BuildThisBidLPO(_ThisBidLPO, bidAndTenderObj);
await _repo.AddUpdateLPOAsync(thisBidLpo);
await _transaction.CommitAsync();
}
apiResponse.Status.IsSuccessful = true;
apiResponse.Status.Message.FriendlyMessage = "LPO Generated";
return(apiResponse);
}
catch (Exception ex)
{
await _transaction.RollbackAsync();
#region Log error to file
var errorCode = ErrorID.Generate(4);
_logger.Error($"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}");
return(new BidAndTenderRegRespObj
{
Status = new APIResponseStatus
{
Message = new APIResponseMessage
{
FriendlyMessage = "Error occured!! Please try again later",
MessageId = errorCode,
TechnicalMessage = $"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}"
}
}
});
#endregion
}
finally { await _transaction.DisposeAsync(); }
}
}
catch (Exception ex)
{
#region Log error to file
var errorCode = ErrorID.Generate(4);
_logger.Error($"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}");
return(new BidAndTenderRegRespObj
{
Status = new APIResponseStatus
{
Message = new APIResponseMessage
{
FriendlyMessage = "Error occured!! Please try again later",
MessageId = errorCode,
TechnicalMessage = $"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}"
}
}
});
#endregion
}
}
public async Task <StaffApprovalRegRespObj> Handle(PRNStaffApprovalCommand request, CancellationToken cancellationToken)
{
try
{
if (request.ApprovalStatus == (int)ApprovalStatus.Revert && request.ReferredStaffId < 1)
{
return(new StaffApprovalRegRespObj
{
Status = new APIResponseStatus {
IsSuccessful = false, Message = new APIResponseMessage {
FriendlyMessage = "Please select staff to revert to"
}
}
});
}
var allSuppliers = await _dataContext.cor_supplier.ToListAsync();
var currentUserId = _accessor.HttpContext.User?.FindFirst(x => x.Type == "userId").Value;
var user = await _serverRequest.UserDataAsync();
var prn = await _repo.GetPurchaseRequisitionNoteAsync(request.TargetId);
var detail = BuildApprovalDetailObject(request, prn, user.StaffId);
var req = new IndentityServerApprovalCommand
{
ApprovalComment = request.ApprovalComment,
ApprovalStatus = request.ApprovalStatus,
TargetId = request.TargetId,
WorkflowToken = prn.WorkflowToken,
ReferredStaffId = request.ReferredStaffId
};
using (var _trans = await _dataContext.Database.BeginTransactionAsync())
{
try
{
var result = await _serverRequest.StaffApprovalRequestAsync(req);
if (!result.IsSuccessStatusCode)
{
var stringData2 = await result.Content.ReadAsStringAsync();
response = JsonConvert.DeserializeObject <StaffApprovalRegRespObj>(stringData2);
return(new StaffApprovalRegRespObj
{
Status = response.Status
});
}
var stringData = await result.Content.ReadAsStringAsync();
response = JsonConvert.DeserializeObject <StaffApprovalRegRespObj>(stringData);
if (!response.Status.IsSuccessful)
{
return(new StaffApprovalRegRespObj
{
Status = response.Status
});
}
if (response.ResponseId == (int)ApprovalStatus.Processing)
{
await _detailService.AddUpdateApprovalDetailsAsync(detail);
prn.ApprovalStatusId = (int)ApprovalStatus.Processing;
await _repo.AddUpdatePurchaseRequisitionNoteAsync(prn);
await _trans.CommitAsync();
return(new StaffApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Processing,
Status = new APIResponseStatus {
IsSuccessful = true, Message = response.Status.Message
}
});
}
if (response.ResponseId == (int)ApprovalStatus.Revert)
{
await _detailService.AddUpdateApprovalDetailsAsync(detail);
prn.ApprovalStatusId = (int)ApprovalStatus.Revert;
await _repo.AddUpdatePurchaseRequisitionNoteAsync(prn);
await _trans.CommitAsync();
return(new StaffApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Revert,
Status = new APIResponseStatus {
IsSuccessful = true, Message = response.Status.Message
}
});
}
if (response.ResponseId == (int)ApprovalStatus.Approved)
{
await _detailService.AddUpdateApprovalDetailsAsync(detail);
prn.ApprovalStatusId = (int)ApprovalStatus.Approved;
var prnDetails = await _repo.GetPrnDetailsByPrnId(prn.PurchaseReqNoteId);
EmailMessageObj email = new EmailMessageObj {
ToAddresses = new List <EmailAddressObj>()
};
foreach (var item in prnDetails)
{
item.LPONumber = _repo.LpoNubmer(prn.PurchaseReqNoteId + item.PRNDetailsId);
if (await _repo.AddUpdatePrnDetailsAsync(item))
{
var lpoObject = _repo.BuildLPODomianObject(item, prn.DeliveryLocation, prn.ExpectedDeliveryDate ?? DateTime.Today);
item.PurchaseReqNoteId = prn.PurchaseReqNoteId;
if (await _repo.AddUpdateLPOAsync(lpoObject))
{
var SuggestedSupplierList = lpoObject.SupplierIds.Split(',').Select(int.Parse);
foreach (var supplierId in SuggestedSupplierList)
{
var supplier = await _supRepo.GetSupplierAsync(supplierId);
if (supplier != null)
{
var bidAndTenderObject = _repo.BuildBidAndTenderDomianObject(supplier, lpoObject, prn.DepartmentId, item);
bidAndTenderObject.CompanyId = prn.CompanyId;
bidAndTenderObject.PurchaseReqNoteId = prn.PurchaseReqNoteId;
if (await _repo.AddUpdateBidAndTender(bidAndTenderObject))
{
email.ToAddresses.Add(new EmailAddressObj {
Address = supplier.Email, Name = supplier.Name
});
}
}
}
var otherSupplierbid = _repo.BuildBidAndTenderDomianObjectForNonSelectedSuppliers(lpoObject, prn.DepartmentId, item);
await _repo.AddUpdateBidAndTender(otherSupplierbid);
}
}
}
email.ToAddresses.Distinct();
await _repo.SendEmailToSuppliersAsync(email, prn.Description);
await _repo.AddUpdatePurchaseRequisitionNoteAsync(prn);
await _repo.SendEmailToInitiatingStaffAsync(prn);
await _trans.CommitAsync();
return(new StaffApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Approved,
Status = new APIResponseStatus {
IsSuccessful = true, Message = new APIResponseMessage {
FriendlyMessage = "Final Approval </br> Successfully created Supplier Bids"
}
}
});
}
if (response.ResponseId == (int)ApprovalStatus.Disapproved)
{
await _detailService.AddUpdateApprovalDetailsAsync(detail);
prn.ApprovalStatusId = (int)ApprovalStatus.Disapproved;
await _repo.AddUpdatePurchaseRequisitionNoteAsync(prn);
await _trans.CommitAsync();
return(new StaffApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Disapproved,
Status = new APIResponseStatus {
IsSuccessful = true, Message = response.Status.Message
}
});
}
}
catch (Exception ex)
{
await _trans.RollbackAsync();
throw ex;
}
finally { await _trans.DisposeAsync(); }
}
return(new StaffApprovalRegRespObj
{
ResponseId = detail.ApprovalDetailId,
Status = response.Status
});
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <BidAndTenderRegRespObj> Handle(UploadProposalCommand request, CancellationToken cancellationToken)
{
var response = new BidAndTenderRegRespObj {
Status = new APIResponseStatus {
IsSuccessful = false, Message = new APIResponseMessage()
}
};
try
{
var user = await _serverRequest.UserDataAsync();
if (user == null)
{
response.Status.Message.FriendlyMessage = "Unable To Process This User";
return(response);
}
if (string.IsNullOrEmpty(request.LPONumber) || request.SupplierId < 1)
{
response.Status.Message.FriendlyMessage = "Supplier Number and Identification is required to process this request";
return(response);
}
var bidAndTenderObj = _dataContext.cor_bid_and_tender.FirstOrDefault(w => w.SupplierId == request.SupplierId && w.LPOnumber.Trim().ToLower() == request.LPONumber.Trim().ToLower());
if (bidAndTenderObj == null)
{
bidAndTenderObj = new cor_bid_and_tender();
bidAndTenderObj.ApprovalStatusId = (int)ApprovalStatus.Authorised;
bidAndTenderObj.DecisionResult = (int)DecisionResult.Non_Applicable;
}
var file = _accessor.HttpContext.Request.Form.Files;
if (file.Count() > 0)
{
if (file[0].FileName.Split('.').Length > 2)
{
response.Status.Message.FriendlyMessage = "Invalid Character detected in file Name";
return(response);
}
var folderName = Path.Combine("Resources", "Images");
var pathToSave = Path.Combine(Directory.GetCurrentDirectory(), folderName);
var fileName = $"{request.LPONumber}-{request.SupplierId}-{DateTime.Now.ToString().Split(" ")[1].Replace(':','-')}";
var type = file[0].ContentType;
var fullPath = _env.WebRootPath + "/Resources/" + fileName;
var dbPath = _env.WebRootPath + "/Resources/" + fileName;
using (FileStream filestrem = System.IO.File.Create(fullPath))
{
await file[0].CopyToAsync(filestrem);
await filestrem.FlushAsync();
}
bidAndTenderObj.ProposalTenderUploadFullPath = fullPath;
bidAndTenderObj.ProposalTenderUploadName = "/Resources/" + fileName;
bidAndTenderObj.ProposalTenderUploadPath = dbPath;
bidAndTenderObj.ProposalTenderUploadType = type;
bidAndTenderObj.Extention = file[0].FileName.Split('.')[1];
bidAndTenderObj.SupplierId = request.SupplierId;
bidAndTenderObj.LPOnumber = request.LPONumber;
}
bidAndTenderObj.Paymentterms = _dataContext.cor_paymentterms.Where(w => w.BidAndTenderId == bidAndTenderObj.BidAndTenderId).ToList();
if (bidAndTenderObj.Paymentterms.Count() == 0)
{
bidAndTenderObj.Paymentterms = new List <cor_paymentterms>();
}
await _repo.AddUpdateBidAndTender(bidAndTenderObj);
response.Status.IsSuccessful = true;
response.Status.Message.FriendlyMessage = "Successful";
return(response);
}
catch (Exception ex)
{
#region Log error to file
var errorCode = ErrorID.Generate(4);
_logger.Error($"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}");
response.Status.IsSuccessful = true;
response.Status.Message.FriendlyMessage = $"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}";
response.Status.Message.TechnicalMessage = ex.ToString();
return(response);
#endregion
}
}
public async Task <BidAndTenderRegRespObj> Handle(AddUpdateBidAndTenderCommand request, CancellationToken cancellationToken)
{
var response = new BidAndTenderRegRespObj {
Status = new APIResponseStatus {
IsSuccessful = false, Message = new APIResponseMessage()
}
};
try
{
var user = await _serverRequest.UserDataAsync();
if (user == null)
{
response.Status.Message.FriendlyMessage = "Unable To Process This User";
return(response);
}
var bidAndTenderObj = BuildBidAndTenderObject(request);
if (user.StaffId < 1)
{
foreach (var item in bidAndTenderObj.Paymentterms)
{
item.ProposedBy = (int)Proposer.SUPPLIER;
//item.LPOId = bidAndTenderObj.PLPOId;
}
await _repo.AddUpdateBidAndTender(bidAndTenderObj);
response.Status.IsSuccessful = true;
response.BidAndTenderId = request.BidAndTenderId;
response.Status.Message.FriendlyMessage = "Successful";
return(response);
}
response.BidAndTenderId = bidAndTenderObj.BidAndTenderId;
response.Status.IsSuccessful = true;
return(response);
}
catch (Exception ex)
{
#region Log error to file
var errorCode = ErrorID.Generate(4);
_logger.Error($"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}");
return(new BidAndTenderRegRespObj
{
Status = new APIResponseStatus
{
IsSuccessful = false,
Message = new APIResponseMessage
{
FriendlyMessage = "Error occured!! Unable to process item",
MessageId = errorCode,
TechnicalMessage = $"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}"
}
}
});
#endregion
}
}
public async Task <RequisitionNoteRegRespObj> Handle(AddUpdateRequisitionNoteCommand request, CancellationToken cancellationToken)
{
try
{
var apiResponse = new RequisitionNoteRegRespObj {
Status = new APIResponseStatus {
IsSuccessful = false, Message = new APIResponseMessage()
}
};
var user = await _serverRequest.UserDataAsync();
if (user == null)
{
return(new RequisitionNoteRegRespObj
{
Status = new APIResponseStatus {
IsSuccessful = false, Message = new APIResponseMessage {
FriendlyMessage = " Unable To Process This User"
}
}
});
}
List <purch_prndetails> prnDetails = new List <purch_prndetails>();
using (var _trans = await _dataContext.Database.BeginTransactionAsync())
{
try
{
var prn = _repo.BuildPurchRequisionNoteObject(request, user.StaffId, user.CompanyId);
await _repo.AddUpdatePurchaseRequisitionNoteAsync(prn);
if (request.PRNDetails.Count() > 0)
{
prnDetails = _repo.BuildListOfPrnDetails(request.PRNDetails, prn.CompanyId);
}
var targetList = new List <int>();
targetList.Add(prn.PurchaseReqNoteId);
GoForApprovalRequest wfRequest = new GoForApprovalRequest
{
Comment = "Purchase PRN",
OperationId = (int)OperationsEnum.PurchasePRNApproval,
TargetId = targetList,
ApprovalStatus = (int)ApprovalStatus.Pending,
DeferredExecution = true,
StaffId = user.StaffId,
CompanyId = user.CompanyId,
EmailNotification = true,
ExternalInitialization = false,
StatusId = (int)ApprovalStatus.Processing,
};
var result = await _serverRequest.GotForApprovalAsync(wfRequest);
if (!result.IsSuccessStatusCode)
{
apiResponse.Status.Message.FriendlyMessage = $"{result.ReasonPhrase} {result.StatusCode}";
return(apiResponse);
}
var stringData = await result.Content.ReadAsStringAsync();
var res = JsonConvert.DeserializeObject <GoForApprovalRespObj>(stringData);
if (res.ApprovalProcessStarted)
{
prn.ApprovalStatusId = (int)ApprovalStatus.Processing;
prn.WorkflowToken = res.Status.CustomToken;
await _repo.AddUpdatePurchaseRequisitionNoteAsync(prn);
foreach (var item in prnDetails)
{
item.PurchaseReqNoteId = prn.PurchaseReqNoteId;
await _repo.AddUpdatePrnDetailsAsync(item);
}
await _trans.CommitAsync();
apiResponse.PurchaseReqNoteId = prn.PurchaseReqNoteId;
apiResponse.Status.IsSuccessful = res.Status.IsSuccessful;
apiResponse.Status.Message = res.Status.Message;
return(apiResponse);
}
if (res.EnableWorkflow || !res.HasWorkflowAccess)
{
await _trans.CommitAsync();
apiResponse.PurchaseReqNoteId = prn.PurchaseReqNoteId;
apiResponse.Status.IsSuccessful = true;
apiResponse.Status.Message.FriendlyMessage = "Successful";
return(apiResponse);
}
if (!res.EnableWorkflow)
{
prn.ApprovalStatusId = (int)ApprovalStatus.Approved;
EmailMessageObj email = new EmailMessageObj {
ToAddresses = new List <EmailAddressObj>()
};
var lponum = 0;
foreach (var item in prnDetails)
{
if (await _repo.AddUpdatePrnDetailsAsync(item))
{
item.LPONumber = _repo.LpoNubmer(prn.PurchaseReqNoteId + item.PRNDetailsId);
item.PurchaseReqNoteId = prn.PurchaseReqNoteId;
await _repo.AddUpdatePrnDetailsAsync(item);
var lpoObject = _repo.BuildLPODomianObject(item, prn.DeliveryLocation, prn.ExpectedDeliveryDate ?? DateTime.Today);
if (await _repo.AddUpdateLPOAsync(lpoObject))
{
var SuggestedSupplierList = lpoObject.SupplierIds.Split(',').Select(int.Parse);
foreach (var supplierId in SuggestedSupplierList)
{
var supplier = await _suprepo.GetSupplierAsync(supplierId);
if (supplier != null)
{
var bidAndTenderObject = _repo.BuildBidAndTenderDomianObject(supplier, lpoObject, prn.DepartmentId, item);
bidAndTenderObject.CompanyId = prn.CompanyId;
bidAndTenderObject.PurchaseReqNoteId = prn.PurchaseReqNoteId;
if (await _repo.AddUpdateBidAndTender(bidAndTenderObject))
{
email.ToAddresses.Add(new EmailAddressObj {
Address = supplier.Email, Name = supplier.Name
});
}
}
}
var otherSupplierbid = _repo.BuildBidAndTenderDomianObjectForNonSelectedSuppliers(lpoObject, prn.DepartmentId, item);
otherSupplierbid.PurchaseReqNoteId = prn.PurchaseReqNoteId;
otherSupplierbid.CompanyId = prn.CompanyId;
await _repo.AddUpdateBidAndTender(otherSupplierbid);
}
}
}
email.ToAddresses.Distinct();
await _repo.SendEmailToSuppliersAsync(email, prn.Description);
await _repo.AddUpdatePurchaseRequisitionNoteAsync(prn);
await _trans.CommitAsync();
apiResponse.Status.IsSuccessful = true;
apiResponse.Status.Message.FriendlyMessage = "Successful";
return(apiResponse);
}
}
catch (SqlException ex)
{
await _trans.RollbackAsync();
var errorCode = ErrorID.Generate(4);
_logger.Error($"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}");
throw ex;
}
finally { await _trans.DisposeAsync(); }
}
return(new RequisitionNoteRegRespObj
{
Status = new APIResponseStatus
{
IsSuccessful = true,
Message = new APIResponseMessage
{
FriendlyMessage = "Success"
}
}
});
}
catch (Exception ex)
{
#region Log error to file
var errorCode = ErrorID.Generate(4);
_logger.Error($"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}");
return(new RequisitionNoteRegRespObj
{
Status = new APIResponseStatus
{
IsSuccessful = false,
Message = new APIResponseMessage
{
FriendlyMessage = "Error occured!! Unable to process item",
MessageId = errorCode,
TechnicalMessage = $"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}"
}
}
});
#endregion
}
}
public async Task <PaymentTermsRegRespObj> Handle(SaveUpdatePaymentTermsCommand request, CancellationToken cancellationToken)
{
var response = new PaymentTermsRegRespObj {
Status = new APIResponseStatus {
IsSuccessful = false, Message = new APIResponseMessage()
}
};
try
{
var user = await _serverRequest.UserDataAsync();
if (user == null)
{
response.Status.Message.FriendlyMessage = "Unable To Process This User";
return(response);
}
var thisProposalBid = await _repo.GetBidAndTender(request.BidAndTenderId);
if (thisProposalBid == null)
{
response.Status.Message.FriendlyMessage = "Unable To Identify Bid associated to this payment proposal (s)";
return(response);
}
if (request.Terms.Count() > 0)
{
foreach (var item in request.Terms)
{
if (item.PaymentTermId > 0)
{
var existingTerm = await _repo.GetSinglePaymenttermAsync(item.PaymentTermId);
existingTerm.Phase = item.Phase;
existingTerm.BidAndTenderId = request.BidAndTenderId;
existingTerm.ProjectStatusDescription = item.ProjectStatusDescription;
existingTerm.ProposedBy = user.StaffId > 0 ? (int)Proposer.STAFF : (int)Proposer.SUPPLIER;
existingTerm.Comment = item.Comment;
existingTerm.GrossAmount = item.GrossAmount;
existingTerm.Completion = item.Completion;
existingTerm.CompanyId = thisProposalBid.CompanyId;
existingTerm.Payment = item.Payment;
existingTerm.LPOId = thisProposalBid.PLPOId;
existingTerm.Amount = item.Amount;
thisProposalBid.Paymentterms.Add(existingTerm);
}
else
{
var term = new cor_paymentterms
{
Phase = item.Phase,
BidAndTenderId = request.BidAndTenderId,
ProjectStatusDescription = item.ProjectStatusDescription,
ProposedBy = user.StaffId > 0 ? (int)Proposer.STAFF : (int)Proposer.SUPPLIER,
Comment = item.Comment,
GrossAmount = item.GrossAmount,
Completion = item.Completion,
CompanyId = thisProposalBid.CompanyId,
Payment = item.Payment,
Amount = item.Amount,
LPOId = thisProposalBid.PLPOId,
};
thisProposalBid.Paymentterms.Add(term);
}
thisProposalBid.Total = request.TotalAmount;
await _repo.AddUpdateBidAndTender(thisProposalBid);
}
}
response.Status.IsSuccessful = true;
response.Status.Message.FriendlyMessage = "Successful";
return(response);
}
catch (Exception ex)
{
#region Log error to file
var errorCode = ErrorID.Generate(4);
_logger.Error($"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}");
return(new PaymentTermsRegRespObj
{
Status = new APIResponseStatus
{
IsSuccessful = false,
Message = new APIResponseMessage
{
FriendlyMessage = "Error occured!! Unable to process item",
MessageId = errorCode,
TechnicalMessage = $"ErrorID : {errorCode} Ex : {ex?.Message ?? ex?.InnerException?.Message} ErrorStack : {ex?.StackTrace}"
}
}
});
#endregion
}
}
public async Task <StaffApprovalRegRespObj> Handle(BidandTenderStaffApprovalCommand request, CancellationToken cancellationToken)
{
try
{
if (request.ApprovalStatus == (int)ApprovalStatus.Revert && request.ReferredStaffId < 1)
{
return(new StaffApprovalRegRespObj
{
Status = new APIResponseStatus {
IsSuccessful = false, Message = new APIResponseMessage {
FriendlyMessage = "Please select staff to revert to"
}
}
});
}
var currentUserId = _accessor.HttpContext.User?.FindFirst(x => x.Type == "userId").Value;
var user = await _serverRequest.UserDataAsync();
var currentBid = await _repo.GetBidAndTender(request.TargetId);
if (!Validation(currentBid).Status.IsSuccessful)
{
return(Validation(currentBid));
}
var _ThisBidLPO = await _repo.GetLPOByNumberAsync(currentBid.LPOnumber);
if (_ThisBidLPO.WinnerSupplierId > 0 && request.ApprovalStatus != (int)ApprovalStatus.Approved)
{
return(new StaffApprovalRegRespObj
{
Status = new APIResponseStatus {
IsSuccessful = false, Message = new APIResponseMessage {
FriendlyMessage = $"Supplier already selected for this LPO {currentBid.LPOnumber}"
}
}
});
}
IEnumerable <cor_paymentterms> paymentTerms = await _repo.GetPaymenttermsAsync();
var detail = BuildApprovalDetailObject(request, currentBid, user.StaffId);
var req = new IndentityServerApprovalCommand
{
ApprovalComment = request.ApprovalComment,
ApprovalStatus = request.ApprovalStatus,
TargetId = request.TargetId,
WorkflowToken = currentBid.WorkflowToken,
ReferredStaffId = request.ReferredStaffId
};
using (var _trans = await _dataContext.Database.BeginTransactionAsync())
{
try
{
var result = await _serverRequest.StaffApprovalRequestAsync(req);
if (!result.IsSuccessStatusCode)
{
return(new StaffApprovalRegRespObj
{
Status = new APIResponseStatus
{
IsSuccessful = false,
Message = new APIResponseMessage {
FriendlyMessage = result.ReasonPhrase
}
}
});
}
var stringData = await result.Content.ReadAsStringAsync();
response = JsonConvert.DeserializeObject <StaffApprovalRegRespObj>(stringData);
if (!response.Status.IsSuccessful)
{
return(new StaffApprovalRegRespObj
{
Status = response.Status
});
}
if (response.ResponseId == (int)ApprovalStatus.Processing)
{
await _detailService.AddUpdateApprovalDetailsAsync(detail);
currentBid.ApprovalStatusId = (int)ApprovalStatus.Processing;
currentBid.DecisionResult = (int)DecisionResult.Non_Applicable;
var thisBidPaymentTerms = paymentTerms.Where(d => d.BidAndTenderId == currentBid.BidAndTenderId).ToList();
currentBid.Paymentterms = thisBidPaymentTerms;
await _repo.AddUpdateBidAndTender(currentBid);
await _trans.CommitAsync();
return(new StaffApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Processing,
Status = new APIResponseStatus {
IsSuccessful = true, Message = response.Status.Message
}
});
}
if (response.ResponseId == (int)ApprovalStatus.Revert)
{
await _detailService.AddUpdateApprovalDetailsAsync(detail);
currentBid.ApprovalStatusId = (int)ApprovalStatus.Revert;
currentBid.DecisionResult = (int)DecisionResult.Non_Applicable;
await _repo.AddUpdateBidAndTender(currentBid);
await _trans.CommitAsync();
return(new StaffApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Revert,
Status = new APIResponseStatus {
IsSuccessful = true, Message = response.Status.Message
}
});
}
if (response.ResponseId == (int)ApprovalStatus.Approved)
{
await _detailService.AddUpdateApprovalDetailsAsync(detail);
currentBid.ApprovalStatusId = (int)ApprovalStatus.Approved;
currentBid.DecisionResult = (int)DecisionResult.Win;
currentBid.PLPOId = _ThisBidLPO.PLPOId;
var thisBidPaymentTerms = paymentTerms.Where(d => d.BidAndTenderId == currentBid.BidAndTenderId).ToList();
currentBid.Paymentterms = thisBidPaymentTerms;
await _repo.SendEmailToSuppliersSelectedAsync(currentBid.SupplierId, currentBid.DescriptionOfRequest, _ThisBidLPO.PLPOId);
await _repo.AddUpdateBidAndTender(currentBid);
var terms = paymentTerms.Where(q => q.BidAndTenderId == currentBid.BidAndTenderId).ToList();
foreach (var term in terms)
{
term.LPOId = currentBid.PLPOId;
term.CompanyId = currentBid.CompanyId;
await _repo.AddUpdatePaymentTermsAsync(term);
}
var otherBids = _dataContext.cor_bid_and_tender.Where(q => q.LPOnumber.Trim().ToLower() == currentBid.LPOnumber.Trim().ToLower() && q.BidAndTenderId != currentBid.BidAndTenderId).ToList();
if (otherBids.Count() > 0)
{
foreach (var otherbid in otherBids)
{
otherbid.ApprovalStatusId = (int)ApprovalStatus.Disapproved;
otherbid.DecisionResult = (int)DecisionResult.Lost;
otherbid.Paymentterms = _dataContext.cor_paymentterms.Where(q => q.BidAndTenderId == otherbid.BidAndTenderId).ToList();
await _repo.AddUpdateBidAndTender(otherbid);
}
}
var thisBidLpo = _repo.BuildThisBidLPO(_ThisBidLPO, currentBid);
await _repo.AddUpdateLPOAsync(thisBidLpo);
await _trans.CommitAsync();
return(new StaffApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Approved,
Status = new APIResponseStatus {
IsSuccessful = true, Message = new APIResponseMessage {
FriendlyMessage = $"Final Approval </br> Successfully selected Supplier for {currentBid.LPOnumber}"
}
}
});
}
if (response.ResponseId == (int)ApprovalStatus.Disapproved)
{
await _detailService.AddUpdateApprovalDetailsAsync(detail);
_ThisBidLPO.JobStatus = _ThisBidLPO.JobStatus;
currentBid.ApprovalStatusId = (int)ApprovalStatus.Disapproved;
currentBid.DecisionResult = (int)DecisionResult.Lost;
await _repo.AddUpdateBidAndTender(currentBid);
await _trans.CommitAsync();
return(new StaffApprovalRegRespObj
{
ResponseId = (int)ApprovalStatus.Disapproved,
Status = new APIResponseStatus {
IsSuccessful = true, Message = response.Status.Message
}
});
}
}
catch (Exception ex)
{
await _trans.RollbackAsync();
throw new Exception("Error Occurerd", new Exception($"{ex.Message}"));
}
finally { await _trans.DisposeAsync(); }
}
return(new StaffApprovalRegRespObj
{
ResponseId = detail.ApprovalDetailId,
Status = response.Status
});
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <LPORegRespObj> Handle(RespondToLPOCommand request, CancellationToken cancellationToken)
{
var response = new LPORegRespObj {
Status = new APIResponseStatus {
IsSuccessful = false, Message = new APIResponseMessage()
}
};
try
{
var rejectedlpo = _dataContext.purch_plpo.Find(request.LPOId);
if (rejectedlpo == null)
{
response.Status.Message.FriendlyMessage = "Unable to identify this LPO";
return(response);
}
var rejectedLpoBid = await _purchaseService.GetBidAndTender(rejectedlpo.BidAndTenderId);
if (rejectedLpoBid == null)
{
response.Status.Message.FriendlyMessage = "Error Occurred";
return(response);
}
if (request.IsRejected)
{
using (var _trans = await _dataContext.Database.BeginTransactionAsync())
{
try
{
await _purchaseService.SendEmailToSuppliersWhenBidIsRejectedAsync(rejectedlpo.WinnerSupplierId, rejectedlpo.Description);
rejectedlpo.ApprovalStatusId = (int)ApprovalStatus.Disapproved;
rejectedlpo.WinnerSupplierId = 0;
rejectedlpo.Name = string.Empty;
rejectedlpo.BidAndTenderId = 0;
await _purchaseService.AddUpdateLPOAsync(rejectedlpo);
if (rejectedLpoBid.Paymentterms.Count() > 0)
{
foreach (var term in rejectedLpoBid.Paymentterms)
{
var item = await _dataContext.cor_paymentterms.FindAsync(term.PaymentTermId);
if (item != null)
{
item.LPOId = 0;
item.ApprovalStatusId = (int)ApprovalStatus.Disapproved;
}
await _purchaseService.AddUpdatePaymentTermsAsync(item);
}
}
rejectedLpoBid.IsRejected = true;
rejectedLpoBid.PLPOId = 0;
rejectedLpoBid.ApprovalStatusId = (int)ApprovalStatus.Disapproved;
await _purchaseService.AddUpdateBidAndTender(rejectedLpoBid);
var lostBids = await _dataContext.cor_bid_and_tender.Where(q => q.PLPOId == request.LPOId && q.BidAndTenderId != rejectedLpoBid.BidAndTenderId).ToListAsync();
if (lostBids.Count() > 0)
{
foreach (var otherbid in lostBids)
{
var item = await _purchaseService.GetBidAndTender(otherbid.BidAndTenderId);
if (item != null)
{
item.ApprovalStatusId = (int)ApprovalStatus.Pending;
item.DecisionResult = (int)DecisionResult.Non_Applicable;
var terms = await _dataContext.cor_paymentterms.Where(q => q.BidAndTenderId == item.BidAndTenderId).ToListAsync();
item.Paymentterms = terms;
}
await _purchaseService.AddUpdateBidAndTender(item);
}
}
await _trans.CommitAsync();
response.Status.IsSuccessful = true;
response.Status.Message.FriendlyMessage = "Successfully rejected LPO";
return(response);
}
catch (Exception ex)
{
await _trans.RollbackAsync();
}
finally { await _trans.DisposeAsync(); }
}
}
return(response);
}
catch (Exception ex)
{
response.Status.Message.FriendlyMessage = ex.Message;
return(response);
}
}