/// <summary> /// Deletes the budget chapter. /// </summary> /// <param name="budgetChapter">The budget chapter.</param> /// <returns>System.String.</returns> public string DeleteBudgetChapter(BudgetChapterEntity budgetChapter) { const string sql = @"uspDelete_BudgetChapter"; object[] parms = { "@BudgetChapterID", budgetChapter.BudgetChapterId }; return(Db.Delete(sql, true, parms)); }
/// <summary> /// Takes the specified budget chapter. /// </summary> /// <param name="budgetChapter">The budget chapter.</param> /// <returns>System.Object[][].</returns> private object[] Take(BudgetChapterEntity budgetChapter) { return(new object[] { "@BudgetChapterID", budgetChapter.BudgetChapterId, "@BudgetChapterCode", budgetChapter.BudgetChapterCode, "@BudgetChapterName", budgetChapter.BudgetChapterName, "@IsActive", budgetChapter.IsActive, }); }
/// <summary> /// Takes the specified budget chapter. /// </summary> /// <param name="budgetChapter">The budget chapter.</param> /// <returns>System.Object[][].</returns> private object[] Take(BudgetChapterEntity budgetChapter) { return(new object[] { "@BudgetChapterID", budgetChapter.BudgetChapterId, "@BudgetChapterCode", budgetChapter.BudgetChapterCode, "@BudgetChapterName", budgetChapter.BudgetChapterName, "@Description", budgetChapter.Description, "@IsSystem", budgetChapter.IsSystem, "@IsActive", budgetChapter.IsActive, "@ForeignName", budgetChapter.ForeignName }); }
/// <summary> /// Inserts the account category. /// </summary> /// <param name="budgetChapterEntity">The account category entity.</param> /// <returns>BudgetChapterResponse.</returns> public BudgetChapterResponse InsertBudgetChapter(BudgetChapterEntity budgetChapterEntity) { var response = new BudgetChapterResponse { Acknowledge = AcknowledgeType.Success }; try { if (!budgetChapterEntity.Validate()) { foreach (string error in budgetChapterEntity.ValidationErrors) { response.Message += error + Environment.NewLine; } response.Acknowledge = AcknowledgeType.Failure; return(response); } budgetChapterEntity.BudgetChapterId = Guid.NewGuid().ToString(); //check ma trung var budgetChapterEntityExited = BudgetChapterDao.GetBudgetChaptersByBudgetChapterCode(budgetChapterEntity.BudgetChapterCode); if (budgetChapterEntityExited != null) { response.Acknowledge = AcknowledgeType.Failure; response.Message = string.Format(@"Mã chương {0} đã tồn tại trong hệ thống. Vui lòng nhập mã khác", budgetChapterEntityExited.BudgetChapterCode); return(response); } response.Message = BudgetChapterDao.InsertBudgetChapter(budgetChapterEntity); if (!string.IsNullOrEmpty(response.Message)) { response.Acknowledge = AcknowledgeType.Failure; return(response); } response.BudgetChapterId = budgetChapterEntity.BudgetChapterId; return(response); } catch (Exception ex) { response.Acknowledge = AcknowledgeType.Failure; response.Message = ex.Message; return(response); } }
public List <BudgetChapterEntity> GetBudgetChapters(string connectionString) { List <BudgetChapterEntity> listBudgetChapter = new List <BudgetChapterEntity>(); using (var context = new MISAEntity(connectionString)) { var lstBudgetChapter = context.BudgetChapters.ToList(); foreach (var result in lstBudgetChapter) { var budgetChapter = new BudgetChapterEntity(); budgetChapter.BudgetChapterId = result.BudgetChapterID.ToString(); budgetChapter.BudgetChapterCode = result.BudgetChapterCode; budgetChapter.BudgetChapterName = result.BudgetChapterName; budgetChapter.IsActive = result.Active; listBudgetChapter.Add(budgetChapter); } } return(listBudgetChapter); }
/// <summary> /// Updates the budget chapter. /// </summary> /// <param name="budgetChapter">The budget chapter.</param> /// <returns>System.String.</returns> public string UpdateBudgetChapter(BudgetChapterEntity budgetChapter) { const string sql = "uspUpdate_BudgetChapter"; return(Db.Update(sql, true, Take(budgetChapter))); }
/// <summary> /// Inserts the budget chapter. /// </summary> /// <param name="budgetChapter">The budget chapter.</param> /// <returns>System.Int32.</returns> public int InsertBudgetChapter(BudgetChapterEntity budgetChapter) { const string sql = "uspInsert_BudgetChapter"; return(Db.Insert(sql, true, Take(budgetChapter))); }
/// <summary> /// Updates the account category. /// </summary> /// <param name="budgetChapterEntity">The account category entity.</param> /// <returns>BudgetChapterResponse.</returns> public BudgetChapterResponse UpdateBudgetChapter(BudgetChapterEntity budgetChapterEntity) { var response = new BudgetChapterResponse { Acknowledge = AcknowledgeType.Success }; try { if (!budgetChapterEntity.Validate()) { foreach (string error in budgetChapterEntity.ValidationErrors) { response.Message += error + Environment.NewLine; } response.Acknowledge = AcknowledgeType.Failure; return(response); } //check ma trung var budgetChapterEntityExited = BudgetChapterDao.GetBudgetChaptersByBudgetChapterCode(budgetChapterEntity.BudgetChapterCode); if (budgetChapterEntityExited != null && budgetChapterEntity.BudgetChapterCode != budgetChapterEntityExited.BudgetChapterCode) { response.Acknowledge = AcknowledgeType.Failure; response.Message = string.Format(@"Mã chương {0} đã tồn tại trong hệ thống. Vui lòng nhập mã khác", budgetChapterEntityExited.BudgetChapterCode); return(response); } response.Message = BudgetChapterDao.UpdateBudgetChapter(budgetChapterEntity); if (!string.IsNullOrEmpty(response.Message)) { if (response.Message.Contains("FK_AccountingObject_BudgetChapter") || response.Message.Contains("FK_BABankTransferDetailParallel_BudgetChapter") || response.Message.Contains("FK_BADepositDetail_BudgetChapter") || response.Message.Contains("FK_BADepositDetailFixedAsset_BudgetChapter") || response.Message.Contains("FK_BADepositDetailParallel_BudgetChapter") || response.Message.Contains("FK_BADepositDetailSale_BudgetChapter") || response.Message.Contains("FK_BAWithDrawDetail_BudgetChapter") || response.Message.Contains("FK_BAWithDrawDetailFixedAsset_BudgetChapter") || response.Message.Contains("FK_BAWithDrawDetailParallel_BudgetChapter") || response.Message.Contains("FK_BAWithDrawDetailPurchase_BudgetChapter") || response.Message.Contains("FK_BUBudgetReserve_BudgetChapter") || response.Message.Contains("FK_BUCommitmentAdjustmentDetail_BudgetChapter") || response.Message.Contains("FK_BUCommitmentRequestDetail_BudgetChapter") || response.Message.Contains("FK_BUPlanAdjustmentDetail_BudgetChapter") || response.Message.Contains("FK_BUPlanWithdrawDetail_BudgetChapter") || response.Message.Contains("FK_BUTransferDetail_BudgetChapter") || response.Message.Contains("FK_BUTransferDetailFixedAsset_BudgetChapter") || response.Message.Contains("FK_BUTransferDetailParallel_BudgetChapter") || response.Message.Contains("FK_BUTransferDetailPurchase_BudgetChapter") || response.Message.Contains("FK_BUVoucherListDetailParallel_BudgetChapter") || response.Message.Contains("FK_BUVoucherListDetailTransfer_BudgetChapter") || response.Message.Contains("FK_CAPaymentDetail_BudgetChapter") || response.Message.Contains("FK_CAPaymentDetailFixedAsset_BudgetChapter") || response.Message.Contains("FK_CAPaymentDetailParallel_BudgetChapter") || response.Message.Contains("FK_CAPaymentDetailPurchase_BudgetChapter") || response.Message.Contains("FK_CAReceiptDetail_BudgetChapter") || response.Message.Contains("FK_CAReceiptDetailFixedAsset_BudgetChapter") || response.Message.Contains("FK_CAReceiptDetailParallel_BudgetChapter") || response.Message.Contains("FK_FAAdjustmentDetail_BudgetChapter") || response.Message.Contains("FK_FAIncrementDecrementDetail_BudgetChapter") || response.Message.Contains("FK_FixedAsset_BudgetChapter_BudgetChapterCode") || response.Message.Contains("FK_GLVoucherDetail_BudgetChapter") || response.Message.Contains("FK_GLVoucherDetailParallel_BudgetChapter") || response.Message.Contains("FK_INInwardOutwardDetail_BudgetChapter") || response.Message.Contains("FK_OpeningAccountEntry_BudgetChapter") || response.Message.Contains("FK_OpeningFixedAssetEntry_BudgetChapter") || response.Message.Contains("FK_OpeningInventoryEntry_BudgetChapter") || response.Message.Contains("FK_PUInvoiceDetailFixedAsset_BudgetChapter")) { response.Message = @"Chương " + budgetChapterEntity.BudgetChapterCode + " đã phát sinh tại các nghiệp vụ liên quan không thể sửa mã!"; } response.Acknowledge = AcknowledgeType.Failure; return(response); } if (!string.IsNullOrEmpty(response.Message)) { response.Acknowledge = AcknowledgeType.Failure; return(response); } response.BudgetChapterId = budgetChapterEntity.BudgetChapterId; return(response); } catch (Exception ex) { response.Acknowledge = AcknowledgeType.Failure; response.Message = ex.Message; return(response); } }