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 <RequisitionNoteRegRespObj> Handle(SendPRNToApprovalCommand request, CancellationToken cancellationToken) { try { var apiResponse = new RequisitionNoteRegRespObj { Status = new APIResponseStatus { IsSuccessful = false, Message = new APIResponseMessage() } }; var prn = await _repo.GetPurchaseRequisitionNoteAsync(request.PurchaseReqNoteId); if (prn == null) { apiResponse.Status.Message.FriendlyMessage = $"Bid Not found"; return(apiResponse); } if (prn.ApprovalStatusId != (int)ApprovalStatus.Pending) { apiResponse.Status.Message.FriendlyMessage = $"Unable to push supplier bid with status '{Convert.ToString((ApprovalStatus)prn.ApprovalStatusId)}' for approval"; return(apiResponse); } var user = await _serverRequest.UserDataAsync(); using (var _transaction = await _dataContext.Database.BeginTransactionAsync()) { try { var targetList = new List <int>(); targetList.Add(prn.PurchaseReqNoteId); GoForApprovalRequest wfRequest = new GoForApprovalRequest { Comment = "Bid and tender", OperationId = (int)OperationsEnum.PurchasePRNApproval, TargetId = targetList, ApprovalStatus = (int)ApprovalStatus.Pending, DeferredExecution = true, StaffId = user.StaffId, CompanyId = 1, 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) { prn.ApprovalStatusId = (int)ApprovalStatus.Processing; prn.WorkflowToken = res.Status.CustomToken; await _repo.AddUpdatePurchaseRequisitionNoteAsync(prn); await _transaction.CommitAsync(); apiResponse.PurchaseReqNoteId = prn.PurchaseReqNoteId; apiResponse.Status = res.Status; return(apiResponse); } if (res.EnableWorkflow || !res.HasWorkflowAccess) { await _transaction.RollbackAsync(); apiResponse.Status.IsSuccessful = false; apiResponse.Status.Message = res.Status.Message; return(apiResponse); } apiResponse.Status = res.Status; 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 RequisitionNoteRegRespObj { 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 RequisitionNoteRegRespObj { 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 <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 } }