/// <summary> /// Takes the specified b u commitment adjustment entity. /// </summary> /// <param name="bUCommitmentAdjustmentEntity">The b u commitment adjustment entity.</param> /// <returns>System.Object[].</returns> private static object[] Take(BUCommitmentAdjustmentEntity bUCommitmentAdjustmentEntity) { return(new object[] { "@RefID", bUCommitmentAdjustmentEntity.RefId, "@RefDate", bUCommitmentAdjustmentEntity.RefDate, "@PostedDate", bUCommitmentAdjustmentEntity.PostedDate, "@RefNo", bUCommitmentAdjustmentEntity.RefNo, "@BUCommitmentRequestID", bUCommitmentAdjustmentEntity.BUCommitmentRequestId, "@ContractNo", bUCommitmentAdjustmentEntity.ContractNo, "@ContractFrameNo", bUCommitmentAdjustmentEntity.ContractFrameNo, "@RealContractNo", bUCommitmentAdjustmentEntity.RealContractNo, "@RefType", bUCommitmentAdjustmentEntity.RefType, "@TotalAmount", bUCommitmentAdjustmentEntity.TotalAmount, "@TotalAmountOC", bUCommitmentAdjustmentEntity.TotalAmountOC, "@IsForeignCurrency", bUCommitmentAdjustmentEntity.IsForeignCurrency, "@Posted", bUCommitmentAdjustmentEntity.Posted, "@EditVersion", bUCommitmentAdjustmentEntity.EditVersion, "@PostVersion", bUCommitmentAdjustmentEntity.PostVersion, "@IsSuggestAdjustment", bUCommitmentAdjustmentEntity.IsSuggestAdjustment, "@IsSuggestSupplement", bUCommitmentAdjustmentEntity.IsSuggestSupplement, "@AdjustmentProviderBankAccount", bUCommitmentAdjustmentEntity.AdjustmentProviderBankAccount, "@AdjustmentProviderBankName", bUCommitmentAdjustmentEntity.AdjustmentProviderBankName, "@BankAccount", bUCommitmentAdjustmentEntity.BankAccount, "@BankName", bUCommitmentAdjustmentEntity.BankName, "@CurrencyCode", bUCommitmentAdjustmentEntity.CurrencyCode, "@ExchangeRate", bUCommitmentAdjustmentEntity.ExchangeRate, }); }
/// <summary> /// Deletes the bu plan receipt. /// </summary> /// <param name="bUCommitmentAdjustment">The b u commitment adjustment.</param> /// <returns>System.String.</returns> public string DeleteBUCommitmentAdjustment(BUCommitmentAdjustmentEntity bUCommitmentAdjustment) { const string procedures = @"uspDelete_BUCommitmentAdjustment"; object[] parms = { "@RefId", bUCommitmentAdjustment.RefId }; return(Db.Delete(procedures, true, parms)); }
public List <BUCommitmentAdjustmentEntity> GetBUCommitmentAdjustments(string connectionString) { List <BUCommitmentAdjustmentEntity> buentity = new List <BUCommitmentAdjustmentEntity>(); using (var context = new MISAEntity(connectionString)) { var querry = context.BUCommitmentAdjustmentDetails.ToList(); var projects = context.Projects.ToList(); var currencys = context.CCies.ToList(); var budgetsource = context.BudgetSources.ToList(); var listitems = context.ListItems.ToList(); var fundstructures = context.FundStructures.ToList(); var budgetproviders = context.BudgetProvidences.ToList(); var accountingobject = context.AccountingObjects.ToList(); var projectexpenses = context.ProjectExpenses.ToList(); var activity = context.Activities.ToList(); var tasks = context.Tasks.ToList(); banks = context.BankInfoes.ToList(); var resultcontext = context.BUCommitmentAdjustments.ToList(); foreach (var result in resultcontext) { var newresult = new BUCommitmentAdjustmentEntity(); newresult.RefId = result.RefID.ToString(); newresult.RefDate = result.RefDate; newresult.PostedDate = result.PostedDate; newresult.RefNo = result.RefNo; newresult.BUCommitmentRequestId = result.BUCommitmentRequestID.ToString(); newresult.ContractNo = result.ContractNo; newresult.ContractFrameNo = result.ContractFrameNo; newresult.RealContractNo = result.RealContractNo; newresult.RefType = ConvRefType.ConvRefType(result.RefType); newresult.TotalAmount = result.TotalAmount; newresult.TotalAmountOC = result.TotalAmountOC; newresult.IsForeignCurrency = result.IsForeignCurrency; newresult.Posted = result.Posted; newresult.EditVersion = result.EditVersion; newresult.PostVersion = result.PostVersion; newresult.IsSuggestAdjustment = result.IsSuggestAdjustment; newresult.IsSuggestSupplement = result.IsSuggestSupplement; newresult.AdjustmentProviderBankAccount = result.AdjustmentProviderBankAccount; newresult.AdjustmentProviderBankName = result.AdjustmentProviderBankName; newresult.BankAccount = result.BankAccount; newresult.BankName = result.BankName; newresult.BUCommitmentAdjustmentDetails = BUCommitmentAdjustmentDetails(result.BUCommitmentAdjustmentDetails.ToList(), result.RefID.ToString()); buentity.Add(newresult); } } return(buentity); }
/// <summary> /// Inserts the bu commitment request. /// </summary> /// <param name="bUCommitmentRequest">The b u commitment request.</param> /// <returns>BUCommitmentAdjustmentResponse.</returns> public BUCommitmentAdjustmentResponse InsertBUCommitmentAdjustment(BUCommitmentAdjustmentEntity bUCommitmentRequest) { var bUCommitmentRequestResponse = new BUCommitmentAdjustmentResponse { Acknowledge = AcknowledgeType.Success }; if (bUCommitmentRequest != null && !bUCommitmentRequest.Validate()) { foreach (var error in bUCommitmentRequest.ValidationErrors) { bUCommitmentRequestResponse.Message += error + Environment.NewLine; } bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure; return(bUCommitmentRequestResponse); } using (var scope = new TransactionScope()) { if (bUCommitmentRequest != null) { var bUCommitmentAdjust = BUCommitmentAdjustmentDao.GetBUCommitmentAdjustmentsByRefNo(bUCommitmentRequest.RefNo, bUCommitmentRequest.PostedDate); if (bUCommitmentAdjust != null && bUCommitmentAdjust.PostedDate.Year == bUCommitmentRequest.PostedDate.Year) { bUCommitmentRequestResponse.Message = string.Format("Số phiếu điều chỉnh \'{0}\' đã tồn tại!", bUCommitmentRequest.RefNo); bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure; return(bUCommitmentRequestResponse); } bUCommitmentRequest.RefId = Guid.NewGuid().ToString(); bUCommitmentRequestResponse.Message = BUCommitmentAdjustmentDao.InsertBUCommitmentAdjustment(bUCommitmentRequest); if (!string.IsNullOrEmpty(bUCommitmentRequestResponse.Message)) { bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure; return(bUCommitmentRequestResponse); } foreach (var bUCommitmentRequestDetail in bUCommitmentRequest.BUCommitmentAdjustmentDetails) { bUCommitmentRequestDetail.RefId = bUCommitmentRequest.RefId; bUCommitmentRequestDetail.RefDetailId = Guid.NewGuid().ToString(); if (!bUCommitmentRequestDetail.Validate()) { foreach (var error in bUCommitmentRequestDetail.ValidationErrors) { bUCommitmentRequestResponse.Message += error + Environment.NewLine; } bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure; return(bUCommitmentRequestResponse); } bUCommitmentRequestResponse.Message = BUCommitmentAdjustmentDetailDao.InsertBUCommitmentAdjustmenttDetail(bUCommitmentRequestDetail); if (!string.IsNullOrEmpty(bUCommitmentRequestResponse.Message)) { bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure; return(bUCommitmentRequestResponse); } #region Insert OriginalGeneralLedger var originalGeneralLedgerEntity = new OriginalGeneralLedgerEntity { OriginalGeneralLedgerId = Guid.NewGuid().ToString(), RefType = bUCommitmentRequest.RefType, RefId = bUCommitmentRequest.RefId, RefDetailId = bUCommitmentRequestDetail.RefDetailId, RefDate = bUCommitmentRequest.RefDate, RefNo = bUCommitmentRequest.RefNo, Amount = bUCommitmentRequestDetail.Amount, AmountOC = bUCommitmentRequestDetail.AmountOC, BudgetChapterCode = bUCommitmentRequestDetail.BudgetChapterCode, BudgetDetailItemCode = bUCommitmentRequestDetail.BudgetDetailItemCode, BudgetItemCode = bUCommitmentRequestDetail.BudgetItemCode, BudgetKindItemCode = bUCommitmentRequestDetail.BudgetKindItemCode, BudgetSourceId = bUCommitmentRequestDetail.BudgetSourceId, BudgetSubItemCode = bUCommitmentRequestDetail.BudgetSubItemCode, BudgetSubKindItemCode = bUCommitmentRequestDetail.BudgetSubKindItemCode, Description = bUCommitmentRequestDetail.Description, FundStructureId = bUCommitmentRequestDetail.FundStructureId, ProjectId = bUCommitmentRequestDetail.ProjectId, PostedDate = bUCommitmentRequest.PostedDate, CurrencyCode = bUCommitmentRequest.CurrencyCode, //ExchangeRate = bUCommitmentRequest.ExchangeRate, ContractId = bUCommitmentRequestDetail.ContractId, }; bUCommitmentRequestResponse.Message = OriginalGeneralLedgerDao.InsertOriginalGeneralLedger(originalGeneralLedgerEntity); if (!string.IsNullOrEmpty(bUCommitmentRequestResponse.Message)) { bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure; return(bUCommitmentRequestResponse); } #endregion } if (bUCommitmentRequestResponse.Message != null) { bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure; scope.Dispose(); return(bUCommitmentRequestResponse); } bUCommitmentRequestResponse.RefId = bUCommitmentRequest.RefId; scope.Complete(); } return(bUCommitmentRequestResponse); } }
/// <summary> /// Updates the bu plan receipt. /// </summary> /// <param name="bUCommitmentAdjustment">The b u commitment adjustment.</param> /// <returns>System.String.</returns> public string UpdateBUCommitmentAdjustment(BUCommitmentAdjustmentEntity bUCommitmentAdjustment) { const string procedures = @"uspUpdate_BUCommitmentAdjustment"; return(Db.Update(procedures, true, Take(bUCommitmentAdjustment))); }
/// <summary> /// Inserts the bu plan receipt. /// </summary> /// <param name="bUCommitmentAdjustment">The b u commitment adjustment.</param> /// <returns>System.String.</returns> public string InsertBUCommitmentAdjustment(BUCommitmentAdjustmentEntity bUCommitmentAdjustment) { const string procedures = @"uspInsert_BUCommitmentAdjustment"; return(Db.Insert(procedures, true, Take(bUCommitmentAdjustment))); }