/// <summary>
/// Updates the ca planWithdraw.
/// </summary>
/// <param name="planWithdrawEntity">The planWithdraw entity.</param>
/// <returns>BUPlanWithdrawResponse.</returns>
public BUPlanWithdrawResponse UpdateBUPlanWithdraw(BUPlanWithdrawEntity planWithdrawEntity)
{
var planWithdrawResponse = new BUPlanWithdrawResponse {
Acknowledge = AcknowledgeType.Success
};
try
{
if (planWithdrawEntity != null && !planWithdrawEntity.Validate())
{
foreach (var error in planWithdrawEntity.ValidationErrors)
{
planWithdrawResponse.Message += error + Environment.NewLine;
}
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
return(planWithdrawResponse);
}
using (var scope = new TransactionScope())
{
// Trừ số tiền khi mà update xử lý Bảng cân đối tài khoản////////////////////////////////////
//accountBalances.Clear();
if (planWithdrawEntity != null)
{
//accountBalances = GetListAccountBalanceOlder(planWithdrawEntity.RefId);
//foreach (var accountBalanceEntity in accountBalances)
//{
// var obAccoutBalanceExit = AccountBalanceDao.GetExitsAccountBalance(accountBalanceEntity);
// if (obAccoutBalanceExit != null)
// {
// obAccoutBalanceExit.CurrencyCode = accountBalanceEntity.CurrencyCode;
// // cập nhật bên TK nợ
// if (accountBalanceEntity.MovementCreditAmountOC == 0)
// {
// obAccoutBalanceExit.ExchangeRate = accountBalanceEntity.ExchangeRate;
// obAccoutBalanceExit.MovementDebitAmountExchange =
// obAccoutBalanceExit.MovementDebitAmountExchange - accountBalanceEntity.MovementDebitAmountExchange;
// obAccoutBalanceExit.MovementDebitAmountOC =
// obAccoutBalanceExit.MovementDebitAmountOC - accountBalanceEntity.MovementDebitAmountOC;
// AccountBalanceDao.UpdateAccountBalance(obAccoutBalanceExit);
// }
// else
// {
// obAccoutBalanceExit.ExchangeRate = accountBalanceEntity.ExchangeRate;
// obAccoutBalanceExit.MovementCreditAmountExchange =
// obAccoutBalanceExit.MovementCreditAmountExchange - accountBalanceEntity.MovementCreditAmountExchange;
// obAccoutBalanceExit.MovementCreditAmountOC =
// obAccoutBalanceExit.MovementCreditAmountOC - accountBalanceEntity.MovementCreditAmountOC;
// AccountBalanceDao.UpdateAccountBalance(obAccoutBalanceExit);
// }
// }
//}
// Cập nhật lại dữ liệu vào bảng cân đối tài khoản
//accountBalances.Clear();
//accountBalances = GetListAccountBalance(planWithdrawEntity);
//foreach (var accountBalanceEntity in accountBalances)
//{
// var obAccoutBalanceExit = AccountBalanceDao.GetExitsAccountBalance(accountBalanceEntity);
// if (obAccoutBalanceExit != null)
// {
// obAccoutBalanceExit.CurrencyCode = accountBalanceEntity.CurrencyCode;
// // cập nhật bên TK nợ
// if (accountBalanceEntity.MovementCreditAmountOC == 0)
// {
// obAccoutBalanceExit.ExchangeRate = accountBalanceEntity.ExchangeRate;
// obAccoutBalanceExit.MovementDebitAmountExchange =
// obAccoutBalanceExit.MovementDebitAmountExchange + accountBalanceEntity.MovementDebitAmountExchange;
// obAccoutBalanceExit.MovementDebitAmountOC =
// obAccoutBalanceExit.MovementDebitAmountOC + accountBalanceEntity.MovementDebitAmountOC;
// AccountBalanceDao.UpdateAccountBalance(obAccoutBalanceExit);
// }
// else
// {
// obAccoutBalanceExit.ExchangeRate = accountBalanceEntity.ExchangeRate;
// obAccoutBalanceExit.MovementCreditAmountExchange =
// obAccoutBalanceExit.MovementCreditAmountExchange + accountBalanceEntity.MovementCreditAmountExchange;
// obAccoutBalanceExit.MovementCreditAmountOC =
// obAccoutBalanceExit.MovementCreditAmountOC + accountBalanceEntity.MovementCreditAmountOC;
// AccountBalanceDao.UpdateAccountBalance(obAccoutBalanceExit);
// }
// }
// else
// {
// AccountBalanceDao.InsertAccountBalance(accountBalanceEntity);
// }
//}
// Xóa dữ liệu trống trong bảng Cân đối tài khoản
//AccountBalanceDao.DeleteAccountBalance();
//check ma trung
var planWithdrawEntityExisted = BUPlanWithdrawDao.GetBUPlanWithdrawByRefNoRefType(planWithdrawEntity.RefNo.Trim(), planWithdrawEntity.RefType, planWithdrawEntity.PostedDate);
if (planWithdrawEntityExisted != null && planWithdrawEntityExisted.RefId != planWithdrawEntity.RefId && planWithdrawEntityExisted.PostedDate.Year == planWithdrawEntity.PostedDate.Year)
{
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
planWithdrawResponse.Message = @"Số chứng từ '" + planWithdrawEntity.RefNo + @"' đã tồn tại!";
return(planWithdrawResponse);
}
planWithdrawResponse.Message = BUPlanWithdrawDetailDao.DeleteBUPlanWithdrawDetailByRefId(planWithdrawEntity.RefId);
if (planWithdrawResponse.Message != null)
{
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
scope.Dispose();
return(planWithdrawResponse);
}
#region Delete OriginalGeneralLedger
if (!string.IsNullOrEmpty(planWithdrawResponse.Message))
{
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
return(planWithdrawResponse);
}
planWithdrawResponse.Message = OriginalGeneralLedgerDao.DeleteOriginalGeneralLedger(planWithdrawEntity.RefId);
#endregion
//if (planWithdrawEntity.RefTypeId == 600)
//{
// //Update Lại các mục Khoản lương
// //Lấy lại số chứng từ cũ thay the số chứng từ mới
// var objBUPlanWithdraw = BUPlanWithdrawDao.GetBUPlanWithdraw(planWithdrawEntity.RefId);
// planWithdrawResponse.Message = BUPlanWithdrawDao.UpdateEmployeePayroll(objBUPlanWithdraw.RefNo, planWithdrawEntity.RefNo, planWithdrawEntity.PostedDate.Month + "/" + planWithdrawEntity.PostedDate.Day + "/" + planWithdrawEntity.PostedDate.Year);
//}
planWithdrawResponse.Message = BUPlanWithdrawDao.UpdateBUPlanWithdraw(planWithdrawEntity);
if (planWithdrawResponse.Message != null)
{
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
scope.Dispose();
return(planWithdrawResponse);
}
//var jourentryAccount = journalEntryAccounts[0];
//planWithdrawResponse.Message = JournalEntryAccountDao.DeleteJournalEntryAccount(jourentryAccount);
//if (planWithdrawResponse.Message != null)
//{
// planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
// scope.Dispose();
// return planWithdrawResponse;
//}
foreach (var planWithdrawDetail in planWithdrawEntity.BUPlanWithdrawDetails)
{
planWithdrawDetail.RefId = planWithdrawEntity.RefId;
planWithdrawDetail.RefDetailId = Guid.NewGuid().ToString();
if (!planWithdrawDetail.Validate())
{
foreach (string error in planWithdrawDetail.ValidationErrors)
{
planWithdrawResponse.Message += error + Environment.NewLine;
}
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
return(planWithdrawResponse);
}
planWithdrawResponse.Message = BUPlanWithdrawDetailDao.InsertBUPlanWithdrawDetail(planWithdrawDetail);
if (!string.IsNullOrEmpty(planWithdrawResponse.Message))
{
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
return(planWithdrawResponse);
}
#region Insert OriginalGeneralLedger
var originalGeneralLedgerEntity = new OriginalGeneralLedgerEntity
{
OriginalGeneralLedgerId = Guid.NewGuid().ToString(),
RefType = planWithdrawEntity.RefType,
RefId = planWithdrawEntity.RefId,
RefDetailId = planWithdrawDetail.RefDetailId,
OrgRefDate = planWithdrawDetail.OrgRefDate,
OrgRefNo = planWithdrawDetail.OrgRefNo,
RefDate = planWithdrawEntity.RefDate,
RefNo = planWithdrawEntity.RefNo,
Amount = planWithdrawDetail.Amount,
AmountOC = planWithdrawDetail.AmountOC,
BudgetChapterCode = planWithdrawDetail.BudgetChapterCode,
BudgetDetailItemCode = planWithdrawDetail.BudgetDetailItemCode,
BudgetItemCode = planWithdrawDetail.BudgetItemCode,
BudgetKindItemCode = planWithdrawDetail.BudgetKindItemCode,
BudgetSourceId = planWithdrawDetail.BudgetSourceId,
BudgetSubItemCode = planWithdrawDetail.BudgetSubItemCode,
BudgetSubKindItemCode = planWithdrawDetail.BudgetSubKindItemCode,
CreditAccount = planWithdrawDetail.CreditAccount,
Description = planWithdrawDetail.Description,
FundStructureId = planWithdrawDetail.FundStructureId,
// TaxAmount = planWithdrawDetail.TaxAmount,
JournalMemo = planWithdrawEntity.JournalMemo,
ProjectId = planWithdrawDetail.ProjectId,
PostedDate = planWithdrawEntity.PostedDate,
CurrencyCode = planWithdrawEntity.CurrencyCode,
ExchangeRate = planWithdrawEntity.ExchangeRate,
};
planWithdrawResponse.Message = OriginalGeneralLedgerDao.InsertOriginalGeneralLedger(originalGeneralLedgerEntity);
if (!string.IsNullOrEmpty(planWithdrawResponse.Message))
{
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
return(planWithdrawResponse);
}
#endregion
//// Insert into JourentryAcocunt
//jourentryAccount = journalEntryAccounts[i];
//jourentryAccount.RefId = planWithdrawDetail.RefId;
//jourentryAccount.RefDetailId = planWithdrawDetail.RefDetailId;
//#region " jourentryAccount: thay đổi thông tin theo đối tượng Master"
//int accountingObjectType = planWithdrawEntity.AccountingObjectType == null ? 0 : int.Parse(planWithdrawEntity.AccountingObjectType.ToString());
//switch (accountingObjectType)
//{
// case 0:
// jourentryAccount.VendorId = planWithdrawEntity.VendorId;
// break;
// case 1:
// jourentryAccount.EmployeeId = planWithdrawEntity.EmployeeId;
// break;
// case 2:
// jourentryAccount.AccountingObjectId = planWithdrawEntity.AccountingObjectId;
// break;
// case 3:
// jourentryAccount.CustomerId = planWithdrawEntity.CustomerId;
// break;
//}
//#endregion
//if (!jourentryAccount.Validate())
//{
// foreach (string error in jourentryAccount.ValidationErrors)
// planWithdrawResponse.Message += error + Environment.NewLine;
// planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
// return planWithdrawResponse;
//}
//JournalEntryAccountDao.InsertDoubleJournalEntryAccount(jourentryAccount);
//i = i + 1;
}
//foreach (var buPlanDrawDetail in planWithdrawEntity.BUPlanWithdrawDetails)
//{
// var generalLedgerEntity = new GeneralLedgerEntity
// {
// RefType = planWithdrawEntity.RefType,
// RefNo = planWithdrawEntity.RefNo,
// // AccountingObjectId = buPlanReceiptEntity.AccountingObjectId,
// //BankId = buPlanReceiptEntity.BankId,
// // BudgetChapterCode = buPlanReceiptDetail.BudgetChapterCode,
// ProjectId = buPlanDrawDetail.ProjectId,
// BudgetSourceId = buPlanDrawDetail.BudgetSourceId,
// Description = buPlanDrawDetail.Description,
// RefDetailId = buPlanDrawDetail.RefDetailId,
// ExchangeRate = planWithdrawEntity.ExchangeRate,
// // ActivityId = buPlanReceiptDetail.ActivityId,
// BudgetSubKindItemCode = buPlanDrawDetail.BudgetSubKindItemCode,
// CurrencyCode = planWithdrawEntity.CurrencyCode,
// BudgetKindItemCode = buPlanDrawDetail.BudgetKindItemCode,
// RefId = planWithdrawEntity.RefId,
// PostedDate = planWithdrawEntity.PostedDate,
// //MethodDistributeId = buPlanReceiptDetail.MethodDistributeId,
// //OrgRefNo = buPlanReceiptDetail.OrgRefNo,
// // OrgRefDate = buPlanReceiptDetail.OrgRefDate,
// BudgetItemCode = buPlanDrawDetail.BudgetItemCode,
// ListItemId = buPlanDrawDetail.ListItemId,
// BudgetSubItemCode = buPlanDrawDetail.BudgetSubItemCode,
// BudgetDetailItemCode = buPlanDrawDetail.BudgetDetailItemCode,
// //CashWithDrawTypeId = buPlanReceiptDetail.CashWithDrawTypeId,
// //AccountNumber = buPlanDrawDetail.DebitAccount,
// CorrespondingAccountNumber = buPlanDrawDetail.CreditAccount,
// DebitAmount = buPlanDrawDetail.Amount,
// DebitAmountOC = buPlanDrawDetail.AmountOC,
// CreditAmount = 0,
// CreditAmountOC = 0,
// FundStructureId = buPlanDrawDetail.FundStructureId,
// GeneralLedgerId = Guid.NewGuid().ToString(),
// JournalMemo = planWithdrawEntity.JournalMemo,
// RefDate = planWithdrawEntity.RefDate
// };
// planWithdrawResponse.Message = GeneralLedgerDao.InsertGeneralLedger(generalLedgerEntity);
// if (!string.IsNullOrEmpty(planWithdrawResponse.Message))
// {
// planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
// return planWithdrawResponse;
// }
////insert lan 2
//generalLedgerEntity.GeneralLedgerId = Guid.NewGuid().ToString();
//generalLedgerEntity.AccountNumber = buPlanDrawDetail.CreditAccount;
////generalLedgerEntity.CorrespondingAccountNumber = buPlanDrawDetail.DebitAccount;
//generalLedgerEntity.DebitAmount = 0;
//generalLedgerEntity.DebitAmountOC = 0;
//generalLedgerEntity.CreditAmount = buPlanDrawDetail.Amount;
//generalLedgerEntity.CreditAmountOC = buPlanDrawDetail.AmountOC;
//planWithdrawResponse.Message = GeneralLedgerDao.InsertGeneralLedger(generalLedgerEntity);
if (!string.IsNullOrEmpty(planWithdrawResponse.Message))
{
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
return(planWithdrawResponse);
}
//}
planWithdrawResponse.RefId = planWithdrawEntity.RefId;
}
if (planWithdrawResponse.Message != null)
{
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
scope.Dispose();
return(planWithdrawResponse);
}
scope.Complete();
}
return(planWithdrawResponse);
}
catch (Exception ex)
{
planWithdrawResponse.Message = ex.Message;
return(planWithdrawResponse);
}
}
/// <summary>
/// Inserts the ca planWithdraw.
/// </summary>
/// <param name="planWithdrawEntity">The planWithdraw entity.</param>
/// <returns>BUPlanWithdrawResponse.</returns>
public BUPlanWithdrawResponse InsertBUPlanWithdraw(BUPlanWithdrawEntity planWithdrawEntity)
{
var planWithdrawResponse = new BUPlanWithdrawResponse {
Acknowledge = AcknowledgeType.Success
};
try
{
if (planWithdrawEntity != null && !planWithdrawEntity.Validate())
{
foreach (var error in planWithdrawEntity.ValidationErrors)
{
planWithdrawResponse.Message += error + Environment.NewLine;
}
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
return(planWithdrawResponse);
}
using (var scope = new TransactionScope())
{
if (planWithdrawEntity != null)
{
//check ma trung
var planWithdrawEntityExisted = BUPlanWithdrawDao.GetBUPlanWithdrawByRefNoRefType(planWithdrawEntity.RefNo.Trim(), planWithdrawEntity.RefType, planWithdrawEntity.PostedDate);
if (planWithdrawEntityExisted != null && planWithdrawEntityExisted.PostedDate.Year == planWithdrawEntity.PostedDate.Year)
{
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
planWithdrawResponse.Message = @"Số chứng từ '" + planWithdrawEntity.RefNo + @"' đã tồn tại!";
return(planWithdrawResponse);
}
planWithdrawEntity.RefId = Guid.NewGuid().ToString();
planWithdrawResponse.Message = BUPlanWithdrawDao.InsertBUPlanWithdraw(planWithdrawEntity);
if (!string.IsNullOrEmpty(planWithdrawResponse.Message))
{
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
return(planWithdrawResponse);
}
foreach (var planWithdrawDetail in planWithdrawEntity.BUPlanWithdrawDetails)
{
planWithdrawDetail.RefId = planWithdrawEntity.RefId;
planWithdrawDetail.RefDetailId = Guid.NewGuid().ToString();
if (!planWithdrawDetail.Validate())
{
foreach (var error in planWithdrawDetail.ValidationErrors)
{
planWithdrawResponse.Message += error + Environment.NewLine;
}
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
return(planWithdrawResponse);
}
planWithdrawResponse.Message = BUPlanWithdrawDetailDao.InsertBUPlanWithdrawDetail(planWithdrawDetail);
if (!string.IsNullOrEmpty(planWithdrawResponse.Message))
{
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
return(planWithdrawResponse);
}
#region Insert OriginalGeneralLedger
var originalGeneralLedgerEntity = new OriginalGeneralLedgerEntity
{
OriginalGeneralLedgerId = Guid.NewGuid().ToString(),
RefType = planWithdrawEntity.RefType,
RefId = planWithdrawEntity.RefId,
RefDetailId = planWithdrawDetail.RefDetailId,
OrgRefDate = planWithdrawDetail.OrgRefDate,
OrgRefNo = planWithdrawDetail.OrgRefNo,
RefDate = planWithdrawEntity.RefDate,
RefNo = planWithdrawEntity.RefNo,
Amount = planWithdrawDetail.Amount,
AmountOC = planWithdrawDetail.AmountOC,
BudgetChapterCode = planWithdrawDetail.BudgetChapterCode,
BudgetDetailItemCode = planWithdrawDetail.BudgetDetailItemCode,
BudgetItemCode = planWithdrawDetail.BudgetItemCode,
BudgetKindItemCode = planWithdrawDetail.BudgetKindItemCode,
BudgetSourceId = planWithdrawDetail.BudgetSourceId,
BudgetSubItemCode = planWithdrawDetail.BudgetSubItemCode,
BudgetSubKindItemCode = planWithdrawDetail.BudgetSubKindItemCode,
CreditAccount = planWithdrawDetail.CreditAccount,
Description = planWithdrawDetail.Description,
FundStructureId = planWithdrawDetail.FundStructureId,
// TaxAmount = planWithdrawDetail.TaxAmount,
JournalMemo = planWithdrawEntity.JournalMemo,
ProjectId = planWithdrawDetail.ProjectId,
PostedDate = planWithdrawEntity.PostedDate,
CurrencyCode = planWithdrawEntity.CurrencyCode,
ExchangeRate = planWithdrawEntity.ExchangeRate,
};
planWithdrawResponse.Message = OriginalGeneralLedgerDao.InsertOriginalGeneralLedger(originalGeneralLedgerEntity);
if (!string.IsNullOrEmpty(planWithdrawResponse.Message))
{
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
return(planWithdrawResponse);
}
#endregion
//// insert bang JourentryAccount
//var jourentryAccount = journalEntryAccounts[i];
//jourentryAccount.RefId = planWithdrawDetail.RefId;
//jourentryAccount.RefDetailId = iBUPlanWithdrawDetailId;
//#region " jourentryAccount: thay đổi thông tin theo đối tượng Master"
//int accountingObjectType = planWithdrawEntity.AccountingObjectType == null ? 0 : int.Parse(planWithdrawEntity.AccountingObjectType.ToString());
//switch (accountingObjectType)
//{
// case 0:
// jourentryAccount.VendorId = planWithdrawEntity.VendorId;
// break;
// case 1:
// jourentryAccount.EmployeeId = planWithdrawEntity.EmployeeId;
// break;
// case 2:
// jourentryAccount.AccountingObjectId = planWithdrawEntity.AccountingObjectId;
// break;
// case 3:
// jourentryAccount.CustomerId = planWithdrawEntity.CustomerId;
// break;
//}
////LinhMC bổ sung trường hợp người dùng chọn đối tượng khác ở phần chi tiết mà không chọn ở phần thông tin chung.
//if (jourentryAccount.AccountingObjectId == null)
//{
// jourentryAccount.AccountingObjectId = planWithdrawDetail.AccountingObjectId;
//}
//#endregion
//if (!jourentryAccount.Validate())
//{
// foreach (string error in jourentryAccount.ValidationErrors)
// planWithdrawResponse.Message += error + Environment.NewLine;
// planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
// return planWithdrawResponse;
//}
//JournalEntryAccountDao.InsertDoubleJournalEntryAccount(jourentryAccount);
//i = i + 1;
}
//foreach (var buPlanDrawDetail in planWithdrawEntity.BUPlanWithdrawDetails)
//{
// var generalLedgerEntity = new GeneralLedgerEntity
// {
// RefType = planWithdrawEntity.RefType,
// RefNo = planWithdrawEntity.RefNo,
// // AccountingObjectId = buPlanReceiptEntity.AccountingObjectId,
// //BankId = buPlanReceiptEntity.BankId,
// // BudgetChapterCode = buPlanReceiptDetail.BudgetChapterCode,
// ProjectId = buPlanDrawDetail.ProjectId,
// BudgetSourceId = buPlanDrawDetail.BudgetSourceId,
// Description = buPlanDrawDetail.Description,
// RefDetailId = buPlanDrawDetail.RefDetailId,
// ExchangeRate = planWithdrawEntity.ExchangeRate,
// // ActivityId = buPlanReceiptDetail.ActivityId,
// BudgetSubKindItemCode = buPlanDrawDetail.BudgetSubKindItemCode,
// CurrencyCode = planWithdrawEntity.CurrencyCode,
// BudgetKindItemCode = buPlanDrawDetail.BudgetKindItemCode,
// RefId = planWithdrawEntity.RefId,
// PostedDate = planWithdrawEntity.PostedDate,
// //MethodDistributeId = buPlanReceiptDetail.MethodDistributeId,
// //OrgRefNo = buPlanReceiptDetail.OrgRefNo,
// // OrgRefDate = buPlanReceiptDetail.OrgRefDate,
// BudgetItemCode = buPlanDrawDetail.BudgetItemCode,
// ListItemId = buPlanDrawDetail.ListItemId,
// BudgetSubItemCode = buPlanDrawDetail.BudgetSubItemCode,
// BudgetDetailItemCode = buPlanDrawDetail.BudgetDetailItemCode,
// //CashWithDrawTypeId = buPlanReceiptDetail.CashWithDrawTypeId,
// //AccountNumber = buPlanDrawDetail.DebitAccount,
// CorrespondingAccountNumber = buPlanDrawDetail.CreditAccount,
// DebitAmount = buPlanDrawDetail.Amount,
// DebitAmountOC = buPlanDrawDetail.AmountOC,
// CreditAmount = 0,
// CreditAmountOC = 0,
// FundStructureId = buPlanDrawDetail.FundStructureId,
// GeneralLedgerId = Guid.NewGuid().ToString(),
// JournalMemo = planWithdrawEntity.JournalMemo,
// RefDate = planWithdrawEntity.RefDate
// };
// planWithdrawResponse.Message = GeneralLedgerDao.InsertGeneralLedger(generalLedgerEntity);
// if (!string.IsNullOrEmpty(planWithdrawResponse.Message))
// {
// planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
// return planWithdrawResponse;
// }
// //insert lan 2
// generalLedgerEntity.GeneralLedgerId = Guid.NewGuid().ToString();
// generalLedgerEntity.AccountNumber = buPlanDrawDetail.CreditAccount;
// //generalLedgerEntity.CorrespondingAccountNumber = buPlanDrawDetail.DebitAccount;
// generalLedgerEntity.DebitAmount = 0;
// generalLedgerEntity.DebitAmountOC = 0;
// generalLedgerEntity.CreditAmount = buPlanDrawDetail.Amount;
// generalLedgerEntity.CreditAmountOC = buPlanDrawDetail.AmountOC;
// planWithdrawResponse.Message = GeneralLedgerDao.InsertGeneralLedger(generalLedgerEntity);
// if (!string.IsNullOrEmpty(planWithdrawResponse.Message))
// {
// planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
// return planWithdrawResponse;
// }
//}
planWithdrawResponse.RefId = planWithdrawEntity.RefId;
// Kiểm tra đã tồn tại trong bảng Account Balance
//foreach (var accountBalanceEntity in accountBalances)
//{
// var obAccoutBalanceExit = AccountBalanceDao.GetExitsAccountBalance(accountBalanceEntity);
// if (obAccoutBalanceExit != null)
// {
// // cập nhật bên TK nợ
// if (accountBalanceEntity.MovementCreditAmountOC == 0)
// {
// obAccoutBalanceExit.ExchangeRate = accountBalanceEntity.ExchangeRate;
// obAccoutBalanceExit.MovementDebitAmountExchange =
// obAccoutBalanceExit.MovementDebitAmountExchange +
// accountBalanceEntity.MovementDebitAmountExchange;
// obAccoutBalanceExit.MovementDebitAmountOC =
// obAccoutBalanceExit.MovementDebitAmountOC +
// accountBalanceEntity.MovementDebitAmountOC;
// AccountBalanceDao.UpdateAccountBalance(obAccoutBalanceExit);
// }
// else
// {
// obAccoutBalanceExit.ExchangeRate = accountBalanceEntity.ExchangeRate;
// obAccoutBalanceExit.MovementCreditAmountExchange =
// obAccoutBalanceExit.MovementCreditAmountExchange +
// accountBalanceEntity.MovementCreditAmountExchange;
// obAccoutBalanceExit.MovementCreditAmountOC =
// obAccoutBalanceExit.MovementCreditAmountOC +
// accountBalanceEntity.MovementCreditAmountOC;
// AccountBalanceDao.UpdateAccountBalance(obAccoutBalanceExit);
// }
// }
// else
// {
// AccountBalanceDao.InsertAccountBalance(accountBalanceEntity);
// }
//}
//var autoNumber = AutoNumberDao.GetAutoNumberByRefType(planWithdrawEntity.RefType);
//autoNumber.Value += 1;
//if (planWithdrawEntity.RefType != 600)//Khong cap nhat khi la chung tu luong
//{
// planWithdrawResponse.Message = AutoNumberDao.UpdateAutoNumber(autoNumber);
//}
}
if (planWithdrawResponse.Message != null)
{
planWithdrawResponse.Acknowledge = AcknowledgeType.Failure;
scope.Dispose();
return(planWithdrawResponse);
}
scope.Complete();
}
return(planWithdrawResponse);
}
catch (Exception ex)
{
planWithdrawResponse.Message = ex.Message;
return(planWithdrawResponse);
}
}