/// <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)); }
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); }
/// <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 }); }
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); }
/// <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))); }
/// <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))); }