/// <summary>
/// Takes the specified b u commitment adjustment entity.
/// </summary>
/// <param name="bUCommitmentAdjustmentEntity">The b u commitment adjustment entity.</param>
/// <returns>System.Object[].</returns>
private static object[] Take(BUCommitmentAdjustmentEntity bUCommitmentAdjustmentEntity)
{
return(new object[]
{
"@RefID", bUCommitmentAdjustmentEntity.RefId,
"@RefDate", bUCommitmentAdjustmentEntity.RefDate,
"@PostedDate", bUCommitmentAdjustmentEntity.PostedDate,
"@RefNo", bUCommitmentAdjustmentEntity.RefNo,
"@BUCommitmentRequestID", bUCommitmentAdjustmentEntity.BUCommitmentRequestId,
"@ContractNo", bUCommitmentAdjustmentEntity.ContractNo,
"@ContractFrameNo", bUCommitmentAdjustmentEntity.ContractFrameNo,
"@RealContractNo", bUCommitmentAdjustmentEntity.RealContractNo,
"@RefType", bUCommitmentAdjustmentEntity.RefType,
"@TotalAmount", bUCommitmentAdjustmentEntity.TotalAmount,
"@TotalAmountOC", bUCommitmentAdjustmentEntity.TotalAmountOC,
"@IsForeignCurrency", bUCommitmentAdjustmentEntity.IsForeignCurrency,
"@Posted", bUCommitmentAdjustmentEntity.Posted,
"@EditVersion", bUCommitmentAdjustmentEntity.EditVersion,
"@PostVersion", bUCommitmentAdjustmentEntity.PostVersion,
"@IsSuggestAdjustment", bUCommitmentAdjustmentEntity.IsSuggestAdjustment,
"@IsSuggestSupplement", bUCommitmentAdjustmentEntity.IsSuggestSupplement,
"@AdjustmentProviderBankAccount", bUCommitmentAdjustmentEntity.AdjustmentProviderBankAccount,
"@AdjustmentProviderBankName", bUCommitmentAdjustmentEntity.AdjustmentProviderBankName,
"@BankAccount", bUCommitmentAdjustmentEntity.BankAccount,
"@BankName", bUCommitmentAdjustmentEntity.BankName,
"@CurrencyCode", bUCommitmentAdjustmentEntity.CurrencyCode,
"@ExchangeRate", bUCommitmentAdjustmentEntity.ExchangeRate,
});
}
/// <summary>
/// Deletes the bu plan receipt.
/// </summary>
/// <param name="bUCommitmentAdjustment">The b u commitment adjustment.</param>
/// <returns>System.String.</returns>
public string DeleteBUCommitmentAdjustment(BUCommitmentAdjustmentEntity bUCommitmentAdjustment)
{
const string procedures = @"uspDelete_BUCommitmentAdjustment";
object[] parms = { "@RefId", bUCommitmentAdjustment.RefId };
return(Db.Delete(procedures, true, parms));
}
public List <BUCommitmentAdjustmentEntity> GetBUCommitmentAdjustments(string connectionString)
{
List <BUCommitmentAdjustmentEntity> buentity = new List <BUCommitmentAdjustmentEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.BUCommitmentAdjustmentDetails.ToList();
var projects = context.Projects.ToList();
var currencys = context.CCies.ToList();
var budgetsource = context.BudgetSources.ToList();
var listitems = context.ListItems.ToList();
var fundstructures = context.FundStructures.ToList();
var budgetproviders = context.BudgetProvidences.ToList();
var accountingobject = context.AccountingObjects.ToList();
var projectexpenses = context.ProjectExpenses.ToList();
var activity = context.Activities.ToList();
var tasks = context.Tasks.ToList();
banks = context.BankInfoes.ToList();
var resultcontext = context.BUCommitmentAdjustments.ToList();
foreach (var result in resultcontext)
{
var newresult = new BUCommitmentAdjustmentEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.BUCommitmentRequestId = result.BUCommitmentRequestID.ToString();
newresult.ContractNo = result.ContractNo;
newresult.ContractFrameNo = result.ContractFrameNo;
newresult.RealContractNo = result.RealContractNo;
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.TotalAmount = result.TotalAmount;
newresult.TotalAmountOC = result.TotalAmountOC;
newresult.IsForeignCurrency = result.IsForeignCurrency;
newresult.Posted = result.Posted;
newresult.EditVersion = result.EditVersion;
newresult.PostVersion = result.PostVersion;
newresult.IsSuggestAdjustment = result.IsSuggestAdjustment;
newresult.IsSuggestSupplement = result.IsSuggestSupplement;
newresult.AdjustmentProviderBankAccount = result.AdjustmentProviderBankAccount;
newresult.AdjustmentProviderBankName = result.AdjustmentProviderBankName;
newresult.BankAccount = result.BankAccount;
newresult.BankName = result.BankName;
newresult.BUCommitmentAdjustmentDetails = BUCommitmentAdjustmentDetails(result.BUCommitmentAdjustmentDetails.ToList(), result.RefID.ToString());
buentity.Add(newresult);
}
}
return(buentity);
}
/// <summary>
/// Inserts the bu commitment request.
/// </summary>
/// <param name="bUCommitmentRequest">The b u commitment request.</param>
/// <returns>BUCommitmentAdjustmentResponse.</returns>
public BUCommitmentAdjustmentResponse InsertBUCommitmentAdjustment(BUCommitmentAdjustmentEntity bUCommitmentRequest)
{
var bUCommitmentRequestResponse = new BUCommitmentAdjustmentResponse {
Acknowledge = AcknowledgeType.Success
};
if (bUCommitmentRequest != null && !bUCommitmentRequest.Validate())
{
foreach (var error in bUCommitmentRequest.ValidationErrors)
{
bUCommitmentRequestResponse.Message += error + Environment.NewLine;
}
bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure;
return(bUCommitmentRequestResponse);
}
using (var scope = new TransactionScope())
{
if (bUCommitmentRequest != null)
{
var bUCommitmentAdjust = BUCommitmentAdjustmentDao.GetBUCommitmentAdjustmentsByRefNo(bUCommitmentRequest.RefNo, bUCommitmentRequest.PostedDate);
if (bUCommitmentAdjust != null && bUCommitmentAdjust.PostedDate.Year == bUCommitmentRequest.PostedDate.Year)
{
bUCommitmentRequestResponse.Message = string.Format("Số phiếu điều chỉnh \'{0}\' đã tồn tại!", bUCommitmentRequest.RefNo);
bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure;
return(bUCommitmentRequestResponse);
}
bUCommitmentRequest.RefId = Guid.NewGuid().ToString();
bUCommitmentRequestResponse.Message = BUCommitmentAdjustmentDao.InsertBUCommitmentAdjustment(bUCommitmentRequest);
if (!string.IsNullOrEmpty(bUCommitmentRequestResponse.Message))
{
bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure;
return(bUCommitmentRequestResponse);
}
foreach (var bUCommitmentRequestDetail in bUCommitmentRequest.BUCommitmentAdjustmentDetails)
{
bUCommitmentRequestDetail.RefId = bUCommitmentRequest.RefId;
bUCommitmentRequestDetail.RefDetailId = Guid.NewGuid().ToString();
if (!bUCommitmentRequestDetail.Validate())
{
foreach (var error in bUCommitmentRequestDetail.ValidationErrors)
{
bUCommitmentRequestResponse.Message += error + Environment.NewLine;
}
bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure;
return(bUCommitmentRequestResponse);
}
bUCommitmentRequestResponse.Message =
BUCommitmentAdjustmentDetailDao.InsertBUCommitmentAdjustmenttDetail(bUCommitmentRequestDetail);
if (!string.IsNullOrEmpty(bUCommitmentRequestResponse.Message))
{
bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure;
return(bUCommitmentRequestResponse);
}
#region Insert OriginalGeneralLedger
var originalGeneralLedgerEntity = new OriginalGeneralLedgerEntity
{
OriginalGeneralLedgerId = Guid.NewGuid().ToString(),
RefType = bUCommitmentRequest.RefType,
RefId = bUCommitmentRequest.RefId,
RefDetailId = bUCommitmentRequestDetail.RefDetailId,
RefDate = bUCommitmentRequest.RefDate,
RefNo = bUCommitmentRequest.RefNo,
Amount = bUCommitmentRequestDetail.Amount,
AmountOC = bUCommitmentRequestDetail.AmountOC,
BudgetChapterCode = bUCommitmentRequestDetail.BudgetChapterCode,
BudgetDetailItemCode = bUCommitmentRequestDetail.BudgetDetailItemCode,
BudgetItemCode = bUCommitmentRequestDetail.BudgetItemCode,
BudgetKindItemCode = bUCommitmentRequestDetail.BudgetKindItemCode,
BudgetSourceId = bUCommitmentRequestDetail.BudgetSourceId,
BudgetSubItemCode = bUCommitmentRequestDetail.BudgetSubItemCode,
BudgetSubKindItemCode = bUCommitmentRequestDetail.BudgetSubKindItemCode,
Description = bUCommitmentRequestDetail.Description,
FundStructureId = bUCommitmentRequestDetail.FundStructureId,
ProjectId = bUCommitmentRequestDetail.ProjectId,
PostedDate = bUCommitmentRequest.PostedDate,
CurrencyCode = bUCommitmentRequest.CurrencyCode,
//ExchangeRate = bUCommitmentRequest.ExchangeRate,
ContractId = bUCommitmentRequestDetail.ContractId,
};
bUCommitmentRequestResponse.Message = OriginalGeneralLedgerDao.InsertOriginalGeneralLedger(originalGeneralLedgerEntity);
if (!string.IsNullOrEmpty(bUCommitmentRequestResponse.Message))
{
bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure;
return(bUCommitmentRequestResponse);
}
#endregion
}
if (bUCommitmentRequestResponse.Message != null)
{
bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure;
scope.Dispose();
return(bUCommitmentRequestResponse);
}
bUCommitmentRequestResponse.RefId = bUCommitmentRequest.RefId;
scope.Complete();
}
return(bUCommitmentRequestResponse);
}
}
/// <summary>
/// Updates the bu plan receipt.
/// </summary>
/// <param name="bUCommitmentAdjustment">The b u commitment adjustment.</param>
/// <returns>System.String.</returns>
public string UpdateBUCommitmentAdjustment(BUCommitmentAdjustmentEntity bUCommitmentAdjustment)
{
const string procedures = @"uspUpdate_BUCommitmentAdjustment";
return(Db.Update(procedures, true, Take(bUCommitmentAdjustment)));
}
/// <summary>
/// Inserts the bu plan receipt.
/// </summary>
/// <param name="bUCommitmentAdjustment">The b u commitment adjustment.</param>
/// <returns>System.String.</returns>
public string InsertBUCommitmentAdjustment(BUCommitmentAdjustmentEntity bUCommitmentAdjustment)
{
const string procedures = @"uspInsert_BUCommitmentAdjustment";
return(Db.Insert(procedures, true, Take(bUCommitmentAdjustment)));
}
