/// <summary> /// Deletes the budgetSource. /// </summary> /// <param name="budgetSource">The budgetSource.</param> /// <returns>System.String.</returns> public string DeleteBudgetSource(BudgetSourceEntity budgetSource) { const string sql = @"uspDelete_BudgetSource"; object[] parms = { "@BudgetSourceID", budgetSource.BudgetSourceId }; return(Db.Delete(sql, true, parms)); }
public List <BudgetSourceEntity> GetBudgetSource(string connectionString) { List <BudgetSourceEntity> listBudgetSource = new List <BudgetSourceEntity>(); using (var context = new MISAEntity(connectionString)) { var lstBudgetProperties = context.BudgetSourceProperties.ToList(); var lstBudgetSource = context.BudgetSources.ToList().OrderBy(x => x.Grade); foreach (var result in lstBudgetSource) { var budgetSource = new BudgetSourceEntity(); budgetSource.BudgetSourceId = result.BudgetSourceID.ToString(); budgetSource.BudgetSourceCode = result.BudgetSourceCode; budgetSource.BudgetSourceName = result.BudgetSourceName; budgetSource.ParentId = result.ParentID.ToString(); budgetSource.IsParent = result.IsParent; budgetSource.BudgetSourceCategoryId = "ea7f3053-ed52-4048-9659-027481d03d25"; budgetSource.BudgetSourceProperty = 0; budgetSource.IsSelfControl = true; budgetSource.IsActive = result.Inactive == true ? false : true; budgetSource.Grade = result.Grade; budgetSource.BudgetCode = result.BudgetDistributionCode; if (result.BudgetSourceProperty == null) { budgetSource.BudgetSourceType = 0; } else { switch (result.BudgetSourceProperty.GroupPropertyID) { case 0: budgetSource.BudgetSourceType = 2; break; case 1: budgetSource.BudgetSourceType = 0; break; case 2: budgetSource.BudgetSourceType = 1; break; } } listBudgetSource.Add(budgetSource); } } return(listBudgetSource); }
/// <summary> /// Updates the account category. /// </summary> /// <param name="budgetSourceEntity">The budget source entity.</param> /// <returns> /// AccountCategoryResponse. /// </returns> public BudgetSourceResponse UpdateBudgetSource(BudgetSourceEntity budgetSourceEntity) { var response = new BudgetSourceResponse { Acknowledge = AcknowledgeType.Success }; try { if (!budgetSourceEntity.Validate()) { foreach (string error in budgetSourceEntity.ValidationErrors) { response.Message += error + Environment.NewLine; } response.Acknowledge = AcknowledgeType.Failure; return(response); } var budgetSource = BudgetSourceDao.GetBudgetSourcesByCode(budgetSourceEntity.BudgetSourceCode.Trim()); if (budgetSource != null) { if (budgetSource.BudgetSourceId != budgetSourceEntity.BudgetSourceId) { response.Acknowledge = AcknowledgeType.Failure; response.Message = @"Mã nguồn vốn " + budgetSourceEntity.BudgetSourceCode.Trim() + @" đã tồn tại !"; return(response); } } response.Message = BudgetSourceDao.UpdateBudgetSource(budgetSourceEntity); if (!string.IsNullOrEmpty(response.Message)) { response.Acknowledge = AcknowledgeType.Failure; return(response); } response.BudgetSourceId = budgetSourceEntity.BudgetSourceId; return(response); } catch (Exception ex) { response.Message = ex.Message; return(response); } }
/// <summary> /// Takes the specified budget source. /// </summary> /// <param name="budgetSource">The budget source.</param> /// <returns>System.Object[][].</returns> private object[] Take(BudgetSourceEntity budgetSource) { return(new object[] { "@BudgetSourceID", budgetSource.BudgetSourceId, "@BudgetSourceCode", budgetSource.BudgetSourceCode, "@BudgetSourceName", budgetSource.BudgetSourceName, "@ParentID", budgetSource.ParentId, "@IsParent", budgetSource.IsParent, "@IsSavingExpenses", budgetSource.IsSavingExpenses, "@BudgetSourceCategoryID", budgetSource.BudgetSourceCategoryId, "@BudgetSourceProperty", budgetSource.BudgetSourceProperty, "@BankAccountID", budgetSource.BankAccountId, "@PayableBankAccountID", budgetSource.PayableBankAccountId, "@ProjectID", budgetSource.ProjectId, "@IsSelfControl", budgetSource.IsSelfControl, "@IsActive", budgetSource.IsActive, "@BudgetCode", budgetSource.BudgetCode, "@BudgetSourceType", budgetSource.BudgetSourceType }); }
/// <summary> /// Takes the specified budget source. /// </summary> /// <param name="budgetSource">The budget source.</param> /// <returns>System.Object[][].</returns> private object[] Take(BudgetSourceEntity budgetSource) { return(new object[] { "@BudgetSourceID", budgetSource.BudgetSourceId, "@BudgetSourceCode", budgetSource.BudgetSourceCode, "@BudgetSourceName", budgetSource.BudgetSourceName, "@ForeignName", budgetSource.ForeignName, "@ParentID", budgetSource.ParentId, "@Description", budgetSource.Description, "@Grade", budgetSource.Grade, "@IsParent", budgetSource.IsParent, "@Type", budgetSource.Type, "@IsSystem", budgetSource.IsSystem, "@IsActive", budgetSource.IsActive, "@Allocation", budgetSource.Allocation, "@BudgetItemCode", budgetSource.BudgetItemCode, "@IsFund", budgetSource.IsFund, "@IsExpense", budgetSource.IsExpense, "@AccountCode", budgetSource.AccountCode, "@AutonomyBudgetType", budgetSource.AutonomyBudgetType, "BudgetCode", budgetSource.BudgetCode, }); }
internal static BudgetSourceModel FromDataTransferObject(BudgetSourceEntity entity) { return(entity == null ? null : AutoMapper.Mapper.Map <BudgetSourceEntity, BudgetSourceModel>(entity)); }
/// <summary> /// Updates the budgetSource. /// </summary> /// <param name="budgetSource">The budgetSource.</param> /// <returns>System.String.</returns> public string UpdateBudgetSource(BudgetSourceEntity budgetSource) { const string sql = "uspUpdate_BudgetSource"; return(Db.Update(sql, true, Take(budgetSource))); }
/// <summary> /// Inserts the budgetSource. /// </summary> /// <param name="budgetSource">The budgetSource.</param> /// <returns>System.Int32.</returns> public int InsertBudgetSource(BudgetSourceEntity budgetSource) { const string sql = "uspInsert_BudgetSource"; return(Db.Insert(sql, true, Take(budgetSource))); }