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