/// <summary>
/// Deletes the budget expense.
/// </summary>
/// <param name="budgetExpense">The budget expense.</param>
/// <returns>System.String.</returns>
public string DeleteBudgetExpense(BudgetExpenseEntity budgetExpense)
{
const string sql = @"uspDelete_BudgetExpense";
object[] parms = { "@BudgetExpenseID", budgetExpense.BudgetExpenseId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified budget expense entity.
/// </summary>
/// <param name="budgetExpenseEntity">The budget expense entity.</param>
/// <returns>System.Object[].</returns>
private object[] Take(BudgetExpenseEntity budgetExpenseEntity)
{
return(new object[]
{
"@BudgetExpenseID", budgetExpenseEntity.BudgetExpenseId,
"@BudgetExpenseCode", budgetExpenseEntity.BudgetExpenseCode,
"@BudgetExpenseName", budgetExpenseEntity.BudgetExpenseName,
"@IsActive", budgetExpenseEntity.IsActive,
"@IsSystem", budgetExpenseEntity.IsSystem,
"@BudgetExpenseType", budgetExpenseEntity.BudgetExpenseType
});
}
/// <summary>
/// Inserts the account category.
/// </summary>
/// <param name="budgetExpense">The account category entity.</param>
/// <returns>BudgetExpenseResponse.</returns>
public BudgetExpenseResponse InsertBudgetExpense(BudgetExpenseEntity budgetExpense)
{
var response = new BudgetExpenseResponse {
Acknowledge = AcknowledgeType.Success
};
try
{
if (!budgetExpense.Validate())
{
foreach (string error in budgetExpense.ValidationErrors)
{
response.Message += error + Environment.NewLine;
}
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
var budgetExpenseExited = BudgetExpenseDao.GetBudgetExpenseByBudgetExpenseCode(budgetExpense.BudgetExpenseCode);
if (budgetExpenseExited != null)
{
response.Acknowledge = AcknowledgeType.Failure;
response.Message = string.Format("Mã phí, lệ phí {0}, đã tồn tại!", budgetExpenseExited.BudgetExpenseCode);
return(response);
}
budgetExpense.BudgetExpenseId = Guid.NewGuid().ToString();
response.Message = BudgetExpenseDao.InsertBudgetExpense(budgetExpense);
if (!string.IsNullOrEmpty(response.Message))
{
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.BudgetExpenseId = budgetExpense.BudgetExpenseId;
return(response);
}
catch (Exception ex)
{
response.Acknowledge = AcknowledgeType.Failure;
response.Message = ex.Message;
return(response);
}
}
public List <BudgetExpenseEntity> GetExpense(string connectionString)
{
List <BudgetExpenseEntity> listExpense = new List <BudgetExpenseEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.BudgetExpenses.ToList();
foreach (var result in categories)
{
var budgetExpense = new BudgetExpenseEntity();
budgetExpense.BudgetExpenseId = result.BudgetExpenseID.ToString();
budgetExpense.BudgetExpenseCode = result.BudgetExpenseCode;
budgetExpense.BudgetExpenseName = result.BudgetExpenseName;
budgetExpense.IsActive = result.Inactive == true?false:true;
budgetExpense.IsSystem = result.IsSystem;
budgetExpense.BudgetExpenseType = result.BudgetExpenseType;
listExpense.Add(budgetExpense);
}
}
return(listExpense);
}
/// <summary>
/// Inserts the budget expense.
/// </summary>
/// <param name="budgetExpense">The budget expense.</param>
/// <returns>System.String.</returns>
public string InsertBudgetExpense(BudgetExpenseEntity budgetExpense)
{
const string sql = "uspInsert_BudgetExpense";
return(Db.Insert(sql, true, Take(budgetExpense)));
}
/// <summary>
/// Updates the budget expense.
/// </summary>
/// <param name="budgetExpense">The budget expense.</param>
/// <returns>System.String.</returns>
public string UpdateBudgetExpense(BudgetExpenseEntity budgetExpense)
{
const string sql = "uspUpdate_BudgetExpense";
return(Db.Update(sql, true, Take(budgetExpense)));
}
