/// <summary> /// Takes the specified b u commitment request entity. /// </summary> /// <param name="bUCommitmentRequestEntity">The b u commitment request entity.</param> /// <returns>System.Object[].</returns> private static object[] Take(BUCommitmentRequestEntity bUCommitmentRequestEntity) { return(new object[] { "@RefID", bUCommitmentRequestEntity.RefId, "@RefDate", bUCommitmentRequestEntity.RefDate, "@PostedDate", bUCommitmentRequestEntity.PostedDate, "@RefNo", bUCommitmentRequestEntity.RefNo, "@RefType", bUCommitmentRequestEntity.RefType, "@AccountingObjectID", bUCommitmentRequestEntity.AccountingObjectId, "@AccountingObjectName", bUCommitmentRequestEntity.AccountingObjectName, "@TABMISCode", bUCommitmentRequestEntity.TABMISCode, "@BankAccount", bUCommitmentRequestEntity.BankAccount, "@BankName", bUCommitmentRequestEntity.BankName, "@ContractNo", bUCommitmentRequestEntity.ContractNo, "@ContractFrameNo", bUCommitmentRequestEntity.ContractFrameNo, "@BudgetSourceKind", bUCommitmentRequestEntity.BudgetSourceKind, "@TotalAmount", bUCommitmentRequestEntity.TotalAmount, "@TotalAmountOC", bUCommitmentRequestEntity.TotalAmountOC, "@IsForeignCurrency", bUCommitmentRequestEntity.IsForeignCurrency, "@Posted", bUCommitmentRequestEntity.Posted, "@EditVersion", bUCommitmentRequestEntity.EditVersion, "@PostVersion", bUCommitmentRequestEntity.PostVersion, "@ProjectInvestmentCode", bUCommitmentRequestEntity.ProjectInvestmentCode, "@ProjectInvestmentName", bUCommitmentRequestEntity.ProjectInvestmentName, "@SignDate", bUCommitmentRequestEntity.SignDate, "@ContractAmount", bUCommitmentRequestEntity.ContractAmount, "@PrevYearCommitmentAmount", bUCommitmentRequestEntity.PrevYearCommitmentAmount }); }
/// <summary> /// Deletes the bu plan receipt. /// </summary> /// <param name="bUCommitmentRequest">The b u commitment request.</param> /// <returns>System.String.</returns> public string DeleteBUCommitmentRequest(BUCommitmentRequestEntity bUCommitmentRequest) { const string procedures = @"uspDelete_BUCommitmentRequest"; object[] parms = { "@RefId", bUCommitmentRequest.RefId }; return(Db.Delete(procedures, true, parms)); }
public List <BUCommitmentRequestEntity> GetBUCommitmentRequests(string connectionString) { List <BUCommitmentRequestEntity> buentity = new List <BUCommitmentRequestEntity>(); using (var context = new MISAEntity(connectionString)) { var querry = context.BUCommitmentRequestDetails.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.BUCommitmentRequests.ToList(); foreach (var result in resultcontext) { var newresult = new BUCommitmentRequestEntity(); newresult.RefId = result.RefID.ToString(); newresult.RefDate = result.RefDate; newresult.PostedDate = result.PostedDate; newresult.RefNo = result.RefNo; newresult.RefType = ConvRefType.ConvRefType(result.RefType); newresult.AccountingObjectId = result.AccountingObject == null ? null : result.AccountingObject.AccountingObjectID.ToString(); newresult.AccountingObjectName = result.AccountingObjectName; newresult.TABMISCode = result.TABMISCode; newresult.BankAccount = result.BankAccount; newresult.BankName = result.BankName; newresult.ContractNo = result.ContractNo; newresult.ContractFrameNo = result.ContractFrameNo; newresult.BudgetSourceKind = result.BudgetSourceKind; 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.ProjectInvestmentCode = result.ProjectInvestmentCode; newresult.ProjectInvestmentName = result.ProjectInvestmentName; newresult.SignDate = result.SignDate; newresult.ContractAmount = result.ContractAmount; newresult.PrevYearCommitmentAmount = result.PrevYearCommitmentAmount ?? 0; newresult.BUCommitmentRequestDetails = BUCommitmentRequestDetails(result.BUCommitmentRequestDetails.ToList(), result.RefID.ToString()); buentity.Add(newresult); } } return(buentity); }
/// <summary> /// Updates the bu commitment request. /// </summary> /// <param name="bUCommitmentRequest">The b u commitment request.</param> /// <returns>BUCommitmentRequestResponse.</returns> public BUCommitmentRequestResponse UpdateBUCommitmentRequest(BUCommitmentRequestEntity bUCommitmentRequest) { var bUCommitmentRequestResponse = new BUCommitmentRequestResponse { 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 bUCommitmentRequestEntityExited = BUCommitmentRequestDao.GetBUCommitmentRequestByRefNo(bUCommitmentRequest.RefNo.Trim(), bUCommitmentRequest.PostedDate); if (bUCommitmentRequestEntityExited != null && bUCommitmentRequest.RefId != bUCommitmentRequestEntityExited.RefId && bUCommitmentRequestEntityExited.PostedDate.Year == bUCommitmentRequest.PostedDate.Year) { bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure; bUCommitmentRequestResponse.Message = @"Số chứng từ '" + bUCommitmentRequest.RefNo + @"' đã tồn tại!"; return(bUCommitmentRequestResponse); } bUCommitmentRequestResponse.Message = BUCommitmentRequestDao.UpdateBUCommitmentRequest(bUCommitmentRequest); if (!string.IsNullOrEmpty(bUCommitmentRequestResponse.Message)) { bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure; return(bUCommitmentRequestResponse); } bUCommitmentRequestResponse.Message = BUCommitmentRequestDetailDao.DeleteBUCommitmentRequestDetail(bUCommitmentRequest.RefId); if (!string.IsNullOrEmpty(bUCommitmentRequestResponse.Message)) { bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure; return(bUCommitmentRequestResponse); } bUCommitmentRequestResponse.Message = OriginalGeneralLedgerDao.DeleteOriginalGeneralLedger(bUCommitmentRequest.RefId); if (!string.IsNullOrEmpty(bUCommitmentRequestResponse.Message)) { bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure; return(bUCommitmentRequestResponse); } foreach (var bUCommitmentRequestDetail in bUCommitmentRequest.BUCommitmentRequestDetails) { 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 = BUCommitmentRequestDetailDao.InsertBUPlanReceiptDetail(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="bUCommitmentRequest">The b u commitment request.</param> /// <returns>System.String.</returns> public string UpdateBUCommitmentRequest(BUCommitmentRequestEntity bUCommitmentRequest) { const string procedures = @"uspUpdate_BUCommitmentRequest"; return(Db.Update(procedures, true, Take(bUCommitmentRequest))); }
/// <summary> /// Inserts the bu plan receipt. /// </summary> /// <param name="bUCommitmentRequest">The b u commitment request.</param> /// <returns>System.String.</returns> public string InsertBUCommitmentRequest(BUCommitmentRequestEntity bUCommitmentRequest) { const string procedures = @"uspInsert_BUCommitmentRequest"; return(Db.Insert(procedures, true, Take(bUCommitmentRequest))); }