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