/// <summary>
/// Deletes the autoBusiness.
/// </summary>
/// <param name="autoBusiness">The autoBusiness.</param>
/// <returns></returns>
public string DeleteAutoBusiness(AutoBusinessEntity autoBusiness)
{
const string sql = @"uspDelete_AutoBusiness";
object[] parms = { "@AutoBusinessId", autoBusiness.AutoBusinessId };
return(Db.Delete(sql, true, parms));
}
/// <summary>
/// Takes the specified autoBusiness.
/// </summary>
/// <param name="autoBusiness">The autoBusiness.</param>
/// <returns></returns>
private static object[] Take(AutoBusinessEntity autoBusiness)
{
return(new object[]
{
"@AutoBusinessID", autoBusiness.AutoBusinessId,
"@AutoBusinessCode", autoBusiness.AutoBusinessCode,
"@AutoBusinessName", autoBusiness.AutoBusinessName,
"@RefTypeID", autoBusiness.RefTypeId,
"@VoucherTypeID", autoBusiness.VoucherTypeId,
"@DebitAccountNumber", autoBusiness.DebitAccountNumber,
"@CreditAccountNumber", autoBusiness.CreditAccountNumber,
"@BudgetSourceCode", autoBusiness.BudgetSourceCode,
"@BudgetItemCode", autoBusiness.BudgetItemCode,
"@Description", autoBusiness.Description,
"@CurrencyCode", autoBusiness.CurrencyCode,
"@IsActive", autoBusiness.IsActive
});
}
/// <summary>
/// Updates the account category.
/// </summary>
/// <param name="autoBusinessEntity">The automatic business entity.</param>
/// <returns>
/// AccountCategoryResponse.
/// </returns>
public AutoBusinessResponse UpdateAutoBusiness(AutoBusinessEntity autoBusinessEntity)
{
var response = new AutoBusinessResponse {
Acknowledge = AcknowledgeType.Success
};
try
{
if (!autoBusinessEntity.Validate())
{
foreach (string error in autoBusinessEntity.ValidationErrors)
{
response.Message += error + Environment.NewLine;
}
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
var autoBusiness = AutoBusinessDao.GetAutoBusinessesByAutoBusinessCode(autoBusinessEntity.AutoBusinessCode.Trim());
if (autoBusiness != null)
{
if (autoBusiness.AutoBusinessId != autoBusinessEntity.AutoBusinessId)
{
response.Acknowledge = AcknowledgeType.Failure;
response.Message = @"Mã định khoản tự động " + autoBusinessEntity.AutoBusinessCode.Trim() + @" đã tồn tại !";
return(response);
}
}
response.Message = AutoBusinessDao.UpdateAutoBusiness(autoBusinessEntity);
if (!string.IsNullOrEmpty(response.Message))
{
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.AutoBusinessId = autoBusinessEntity.AutoBusinessId;
return(response);
}
catch (Exception ex)
{
response.Message = ex.Message;
return(response);
}
}
/// <summary>
/// Takes the specified autoBusiness.
/// </summary>
/// <param name="autoBusiness">The autoBusiness.</param>
/// <returns></returns>
private static object[] Take(AutoBusinessEntity autoBusiness)
{
return(new object[]
{
"@AutoBusinessID", autoBusiness.AutoBusinessId,
"@AutoBusinessCode", autoBusiness.AutoBusinessCode,
"@AutoBusinessName", autoBusiness.AutoBusinessName,
"@RefTypeID", autoBusiness.RefTypeId,
"@DebitAccount", autoBusiness.DebitAccount,
"@CreditAccount", autoBusiness.CreditAccount,
"@BudgetSourceID", autoBusiness.BudgetSourceId,
"@BudgetChapterCode", autoBusiness.BudgetChapterCode,
"@BudgetKindItemCode", autoBusiness.BudgetKindItemCode,
"@BudgetSubKindItemCode", autoBusiness.BudgetSubKindItemCode,
"@BudgetItemCode", autoBusiness.BudgetItemCode,
"@BudgetSubItemCode", autoBusiness.BudgetSubItemCode,
"@MethodDistributeID", autoBusiness.MethodDistributeId,
"@CashWithDrawTypeID", autoBusiness.CashWithDrawTypeId,
"@Description", autoBusiness.Description,
"@IsActive", autoBusiness.IsActive
});
}
public List <AutoBusinessEntity> GetAutoBusiness(string connectionString)
{
List <AutoBusinessEntity> listAutoBusiness = new List <AutoBusinessEntity>();
using (var context = new MISAEntity(connectionString))
{
var lstAutoBusinessDetail = context.AutoBusinessDetails.ToList();
var lstAutoBusiness = context.AutoBusinesses.ToList().OrderBy(o => o.AutoBusinessID);
int i = 0;
foreach (var autoBusiness in lstAutoBusiness)
{
foreach (var result in autoBusiness.AutoBusinessDetails)
{
i = i + 1;
var autoBusinessDetail = new AutoBusinessEntity();
autoBusinessDetail.AutoBusinessId = result.AutoBusinessDetailID.ToString();
autoBusinessDetail.AutoBusinessCode = i.ToString();
autoBusinessDetail.AutoBusinessName = autoBusiness.AutoBusinessName;
autoBusinessDetail.RefTypeId = autoBusiness.RefTypeID;
autoBusinessDetail.DebitAccount = result.DebitAccount;
autoBusinessDetail.CreditAccount = result.CreditAccount;
autoBusinessDetail.BudgetSourceId = result.BudgetSourceID.ToString();
autoBusinessDetail.BudgetChapterCode = result.BudgetChapterCode;
autoBusinessDetail.BudgetKindItemCode = result.BudgetKindItemCode;
autoBusinessDetail.BudgetSubKindItemCode = result.BudgetSubKindItemCode;
autoBusinessDetail.BudgetItemCode = result.BudgetItemCode;
autoBusinessDetail.BudgetSubItemCode = result.BudgetSubItemCode;
autoBusinessDetail.MethodDistributeId = result.MethodDistributeID;
autoBusinessDetail.CashWithDrawTypeId = result.CashWithDrawTypeID;
autoBusinessDetail.Description = result.Description;
autoBusinessDetail.IsActive = autoBusiness.Inactive == true ? false : true;
listAutoBusiness.Add(autoBusinessDetail);
}
}
}
return(listAutoBusiness);
}
internal static AutoBusinessModel FromDataTransferObject(AutoBusinessEntity entity)
{
return(entity == null ? null : AutoMapper.Mapper.Map <AutoBusinessEntity, AutoBusinessModel>(entity));
}
/// <summary>
/// Updates the autoBusiness.
/// </summary>
/// <param name="autoBusiness">The autoBusiness.</param>
/// <returns></returns>
public string UpdateAutoBusiness(AutoBusinessEntity autoBusiness)
{
const string sql = @"uspUpdate_AutoBusiness";
return(Db.Update(sql, true, Take(autoBusiness)));
}
/// <summary>
/// Inserts the autoBusiness.
/// </summary>
/// <param name="autoBusiness">The autoBusiness.</param>
/// <returns></returns>
public int InsertAutoBusiness(AutoBusinessEntity autoBusiness)
{
const string sql = @"uspInsert_AutoBusiness";
return(Db.Insert(sql, true, Take(autoBusiness)));
}
