Example #1
0
        /// <summary>
        /// Deletes the Budget item.
        /// </summary>
        /// <param name="budgetItem">The Budget item.</param>
        /// <returns>System.String.</returns>
        public string DeleteBudgetItem(BudgetItemEntity budgetItem)
        {
            const string sql = @"uspDelete_BudgetItem";

            object[] parms = { "@BudgetItemID", budgetItem.BudgetItemId };
            return(Db.Delete(sql, true, parms));
        }
Example #2
0
        public List <BudgetItemEntity> GetBudgetItem(string connectionString)
        {
            List <BudgetItemEntity> listBudgetItem = new List <BudgetItemEntity>();

            using (var context = new MISAEntity(connectionString))
            {
                var lstBudgetItem = context.BudgetItems.ToList().OrderBy(x => x.Grade);

                foreach (var result in lstBudgetItem)
                {
                    var budgetItem = new BudgetItemEntity();

                    budgetItem.BudgetItemId        = result.BudgetItemID.ToString();
                    budgetItem.ParentId            = result.ParentID.ToString();
                    budgetItem.BudgetItemType      = result.BudgetItemType;
                    budgetItem.BudgetItemCode      = result.BudgetItemCode;
                    budgetItem.BudgetItemName      = result.BudgetItemName;
                    budgetItem.BudgetGroupItemCode = result.BudgetGroupItemCode;
                    budgetItem.Grade    = result.Grade;
                    budgetItem.IsParent = result.IsParent;
                    budgetItem.IsActive = result.Inactive == true ?false:true;

                    listBudgetItem.Add(budgetItem);
                }
            }

            return(listBudgetItem);
        }
Example #3
0
 /// <summary>
 /// Takes the specified Budget item.
 /// </summary>
 /// <param name="budgetItemEntity">The budget item entity.</param>
 /// <returns>
 /// System.Object[][].
 /// </returns>
 private object[] Take(BudgetItemEntity budgetItemEntity)
 {
     return(new object[]
     {
         "@BudgetItemID", budgetItemEntity.BudgetItemId,
         "@ParentID", budgetItemEntity.ParentId,
         "@BudgetItemType", budgetItemEntity.BudgetItemType,
         "@BudgetItemCode", budgetItemEntity.BudgetItemCode,
         "@BudgetItemName", budgetItemEntity.BudgetItemName,
         "@BudgetGroupItemCode", budgetItemEntity.BudgetGroupItemCode,
         "@Grade", budgetItemEntity.Grade,
         "@IsParent", budgetItemEntity.IsParent,
         "@IsActive", budgetItemEntity.IsActive
     });
 }
        /// <summary>
        /// Updates the account category.
        /// </summary>
        /// <param name="budgetItemEntity">The budget item entity.</param>
        /// <returns>
        /// AccountCategoryResponse.
        /// </returns>
        public BudgetItemResponse UpdateBudgetItem(BudgetItemEntity budgetItemEntity)
        {
            var response = new BudgetItemResponse {
                Acknowledge = AcknowledgeType.Success
            };

            try
            {
                if (!budgetItemEntity.Validate())
                {
                    foreach (string error in budgetItemEntity.ValidationErrors)
                    {
                        response.Message += error + Environment.NewLine;
                    }
                    response.Acknowledge = AcknowledgeType.Failure;
                    return(response);
                }

                var budgetItem = BudgetItemDao.GetBudgetItemsByCode(budgetItemEntity.BudgetItemCode.Trim());
                if (budgetItem != null)
                {
                    if (budgetItem.BudgetItemId != budgetItemEntity.BudgetItemId)
                    {
                        response.Acknowledge = AcknowledgeType.Failure;
                        response.Message     = @"Mã Mục/Tiểu mục " + budgetItemEntity.BudgetItemCode.Trim() + @" đã tồn tại !";
                        return(response);
                    }
                }

                response.Message = BudgetItemDao.UpdateBudgetItem(budgetItemEntity);
                if (!string.IsNullOrEmpty(response.Message))
                {
                    response.Acknowledge = AcknowledgeType.Failure;
                    return(response);
                }
                response.BudgetItemId = budgetItemEntity.BudgetItemId;
                return(response);
            }
            catch (Exception ex)
            {
                response.Message = ex.Message;
                return(response);
            }
        }
 /// <summary>
 /// Takes the specified Budget item.
 /// </summary>
 /// <param name="budgetItem">The Budget item.</param>
 /// <returns>System.Object[][].</returns>
 private object[] Take(BudgetItemEntity budgetItem)
 {
     return(new object[]
     {
         "@BudgetItemID", budgetItem.BudgetItemId,
         "@BudgetGroupID", budgetItem.BudgetGroupId,
         "@BudgetItemCode", budgetItem.BudgetItemCode,
         "@BudgetItemName", budgetItem.BudgetItemName,
         "@ParentID", budgetItem.ParentId,
         "@ForeignName", budgetItem.ForeignName,
         "@IsFixedItem", budgetItem.IsFixedItem,
         "@IsExpandItem", budgetItem.IsExpandItem,
         "@IsNoAllocate", budgetItem.IsNoAllocate,
         "@IsOrganItem", budgetItem.IsOrganItem,
         "@IsActive", budgetItem.IsActive,
         "@IsReceipt", budgetItem.IsReceipt,
         "@IsSystem", budgetItem.IsSystem,
         "@BudgetItemType", budgetItem.BudgetItemType,
         "@Grade", budgetItem.Grade,
         "@IsParent", budgetItem.IsParent,
         "@Rate", budgetItem.Rate,
         "@IsShowOnVoucher", budgetItem.IsShowOnVoucher
     });
 }
Example #6
0
 internal static BudgetItemModel FromDataTransferObject(BudgetItemEntity entity)
 {
     return(entity == null ? null : AutoMapper.Mapper.Map <BudgetItemEntity, BudgetItemModel>(entity));
 }
 public static BudgetItemEntity CreateBudgetItemEntity(int budgetItemId, string name, double amount, bool recur)
 {
     BudgetItemEntity budgetItemEntity = new BudgetItemEntity();
     budgetItemEntity.BudgetItemId = budgetItemId;
     budgetItemEntity.Name = name;
     budgetItemEntity.Amount = amount;
     budgetItemEntity.Recur = recur;
     return budgetItemEntity;
 }
 public void AddToBudgetItemEntitySet(BudgetItemEntity budgetItemEntity)
 {
     base.AddObject("BudgetItemEntitySet", budgetItemEntity);
 }
Example #9
0
        /// <summary>
        /// Updates the Budget item.
        /// </summary>
        /// <param name="budgetItem">The Budget item.</param>
        /// <returns>System.String.</returns>
        public string UpdateBudgetItem(BudgetItemEntity budgetItem)
        {
            const string sql = "uspUpdate_BudgetItem";

            return(Db.Update(sql, true, Take(budgetItem)));
        }
Example #10
0
        /// <summary>
        /// Inserts the Budget item.
        /// </summary>
        /// <param name="budgetItem">The Budget item.</param>
        /// <returns>System.Int32.</returns>
        public string InsertBudgetItem(BudgetItemEntity budgetItem)
        {
            const string sql = "uspInsert_BudgetItem";

            return(Db.Insert(sql, true, Take(budgetItem)));
        }