public List <BudgetKindItemEntity> GetBudgetKindItem(string connectionString) { List <BudgetKindItemEntity> listBudgetKindItem = new List <BudgetKindItemEntity>(); using (var context = new MISAEntity(connectionString)) { var lstBudgetKindItem = context.BudgetKindItems.ToList(); foreach (var result in lstBudgetKindItem) { var budgetKindItem = new BudgetKindItemEntity(); budgetKindItem.BudgetKindItemId = result.BudgetKinditemID.ToString(); budgetKindItem.ParentId = result.ParentID.ToString(); budgetKindItem.BudgetKindItemCode = result.BudgetKindItemCode; budgetKindItem.BudgetKindItemName = result.BudgetKindItemName; budgetKindItem.Grade = result.Grade; budgetKindItem.IsParent = result.IsParent; budgetKindItem.IsActive = result.Active; listBudgetKindItem.Add(budgetKindItem); } } return(listBudgetKindItem); }
/// <summary> /// Deletes the Budget item. /// </summary> /// <param name="budgetKindItem">The budget kind item.</param> /// <returns></returns> public string DeleteBudgetKindItem(BudgetKindItemEntity budgetKindItem) { const string sql = @"uspDelete_BudgetKindItem"; object[] parms = { "@BudgetKindItemID", budgetKindItem.BudgetKindItemId }; return(Db.Delete(sql, true, parms)); }
/// <summary> /// Takes the specified budget kind item entity. /// </summary> /// <param name="budgetKindItemEntity">The budget kind item entity.</param> /// <returns></returns> private static object[] Take(BudgetKindItemEntity budgetKindItemEntity) { return(new object[] { "@BudgetKindItemID", budgetKindItemEntity.BudgetKindItemId, "@ParentID", budgetKindItemEntity.ParentId, "@BudgetKindItemCode", budgetKindItemEntity.BudgetKindItemCode, "@BudgetKindItemName", budgetKindItemEntity.BudgetKindItemName, "@Grade", budgetKindItemEntity.Grade, "@IsParent", budgetKindItemEntity.IsParent, "@IsActive", budgetKindItemEntity.IsActive }); }
/// <summary> /// Updates the account category. /// </summary> /// <param name="budgetKindItemEntity">The budget kind item entity.</param> /// <returns> /// AccountCategoryResponse. /// </returns> public BudgetKindItemResponse UpdateBudgetKindItem(BudgetKindItemEntity budgetKindItemEntity) { var response = new BudgetKindItemResponse { Acknowledge = AcknowledgeType.Success }; try { if (!budgetKindItemEntity.Validate()) { foreach (string error in budgetKindItemEntity.ValidationErrors) { response.Message += error + Environment.NewLine; } response.Acknowledge = AcknowledgeType.Failure; return(response); } var budgetKindItem = BudgetKindItemDao.GetBudgetKindItemsByCode(budgetKindItemEntity.BudgetKindItemCode.Trim()); if (budgetKindItem != null) { if (budgetKindItem.BudgetKindItemId != budgetKindItemEntity.BudgetKindItemId) { response.Acknowledge = AcknowledgeType.Failure; response.Message = @"Mã Loại/ Khoản " + budgetKindItemEntity.BudgetKindItemCode.Trim() + @" đã tồn tại !"; return(response); } } response.Message = BudgetKindItemDao.UpdateBudgetKindItem(budgetKindItemEntity); if (!string.IsNullOrEmpty(response.Message)) { response.Acknowledge = AcknowledgeType.Failure; return(response); } response.BudgetKindItemId = budgetKindItemEntity.BudgetKindItemId; return(response); } catch (Exception ex) { response.Message = ex.Message; return(response); } }
/// <summary> /// Updates the Budget item. /// </summary> /// <param name="budgetKindItem">The budget kind item.</param> /// <returns></returns> public string UpdateBudgetKindItem(BudgetKindItemEntity budgetKindItem) { const string sql = "uspUpdate_BudgetKindItem"; return(Db.Insert(sql, true, Take(budgetKindItem))); }