/// <summary>
/// Takes the specified b u commitment request entity.
/// </summary>
/// <param name="bUCommitmentRequestEntity">The b u commitment request entity.</param>
/// <returns>System.Object[].</returns>
private static object[] Take(BUCommitmentRequestEntity bUCommitmentRequestEntity)
{
return(new object[]
{
"@RefID", bUCommitmentRequestEntity.RefId,
"@RefDate", bUCommitmentRequestEntity.RefDate,
"@PostedDate", bUCommitmentRequestEntity.PostedDate,
"@RefNo", bUCommitmentRequestEntity.RefNo,
"@RefType", bUCommitmentRequestEntity.RefType,
"@AccountingObjectID", bUCommitmentRequestEntity.AccountingObjectId,
"@AccountingObjectName", bUCommitmentRequestEntity.AccountingObjectName,
"@TABMISCode", bUCommitmentRequestEntity.TABMISCode,
"@BankAccount", bUCommitmentRequestEntity.BankAccount,
"@BankName", bUCommitmentRequestEntity.BankName,
"@ContractNo", bUCommitmentRequestEntity.ContractNo,
"@ContractFrameNo", bUCommitmentRequestEntity.ContractFrameNo,
"@BudgetSourceKind", bUCommitmentRequestEntity.BudgetSourceKind,
"@TotalAmount", bUCommitmentRequestEntity.TotalAmount,
"@TotalAmountOC", bUCommitmentRequestEntity.TotalAmountOC,
"@IsForeignCurrency", bUCommitmentRequestEntity.IsForeignCurrency,
"@Posted", bUCommitmentRequestEntity.Posted,
"@EditVersion", bUCommitmentRequestEntity.EditVersion,
"@PostVersion", bUCommitmentRequestEntity.PostVersion,
"@ProjectInvestmentCode", bUCommitmentRequestEntity.ProjectInvestmentCode,
"@ProjectInvestmentName", bUCommitmentRequestEntity.ProjectInvestmentName,
"@SignDate", bUCommitmentRequestEntity.SignDate,
"@ContractAmount", bUCommitmentRequestEntity.ContractAmount,
"@PrevYearCommitmentAmount", bUCommitmentRequestEntity.PrevYearCommitmentAmount
});
}
/// <summary>
/// Deletes the bu plan receipt.
/// </summary>
/// <param name="bUCommitmentRequest">The b u commitment request.</param>
/// <returns>System.String.</returns>
public string DeleteBUCommitmentRequest(BUCommitmentRequestEntity bUCommitmentRequest)
{
const string procedures = @"uspDelete_BUCommitmentRequest";
object[] parms = { "@RefId", bUCommitmentRequest.RefId };
return(Db.Delete(procedures, true, parms));
}
public List <BUCommitmentRequestEntity> GetBUCommitmentRequests(string connectionString)
{
List <BUCommitmentRequestEntity> buentity = new List <BUCommitmentRequestEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.BUCommitmentRequestDetails.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.BUCommitmentRequests.ToList();
foreach (var result in resultcontext)
{
var newresult = new BUCommitmentRequestEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.AccountingObjectId = result.AccountingObject == null ? null : result.AccountingObject.AccountingObjectID.ToString();
newresult.AccountingObjectName = result.AccountingObjectName;
newresult.TABMISCode = result.TABMISCode;
newresult.BankAccount = result.BankAccount;
newresult.BankName = result.BankName;
newresult.ContractNo = result.ContractNo;
newresult.ContractFrameNo = result.ContractFrameNo;
newresult.BudgetSourceKind = result.BudgetSourceKind;
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.ProjectInvestmentCode = result.ProjectInvestmentCode;
newresult.ProjectInvestmentName = result.ProjectInvestmentName;
newresult.SignDate = result.SignDate;
newresult.ContractAmount = result.ContractAmount;
newresult.PrevYearCommitmentAmount = result.PrevYearCommitmentAmount ?? 0;
newresult.BUCommitmentRequestDetails = BUCommitmentRequestDetails(result.BUCommitmentRequestDetails.ToList(), result.RefID.ToString());
buentity.Add(newresult);
}
}
return(buentity);
}
/// <summary>
/// Updates the bu commitment request.
/// </summary>
/// <param name="bUCommitmentRequest">The b u commitment request.</param>
/// <returns>BUCommitmentRequestResponse.</returns>
public BUCommitmentRequestResponse UpdateBUCommitmentRequest(BUCommitmentRequestEntity bUCommitmentRequest)
{
var bUCommitmentRequestResponse = new BUCommitmentRequestResponse {
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 bUCommitmentRequestEntityExited = BUCommitmentRequestDao.GetBUCommitmentRequestByRefNo(bUCommitmentRequest.RefNo.Trim(), bUCommitmentRequest.PostedDate);
if (bUCommitmentRequestEntityExited != null && bUCommitmentRequest.RefId != bUCommitmentRequestEntityExited.RefId && bUCommitmentRequestEntityExited.PostedDate.Year == bUCommitmentRequest.PostedDate.Year)
{
bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure;
bUCommitmentRequestResponse.Message = @"Số chứng từ '" + bUCommitmentRequest.RefNo + @"' đã tồn tại!";
return(bUCommitmentRequestResponse);
}
bUCommitmentRequestResponse.Message = BUCommitmentRequestDao.UpdateBUCommitmentRequest(bUCommitmentRequest);
if (!string.IsNullOrEmpty(bUCommitmentRequestResponse.Message))
{
bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure;
return(bUCommitmentRequestResponse);
}
bUCommitmentRequestResponse.Message = BUCommitmentRequestDetailDao.DeleteBUCommitmentRequestDetail(bUCommitmentRequest.RefId);
if (!string.IsNullOrEmpty(bUCommitmentRequestResponse.Message))
{
bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure;
return(bUCommitmentRequestResponse);
}
bUCommitmentRequestResponse.Message = OriginalGeneralLedgerDao.DeleteOriginalGeneralLedger(bUCommitmentRequest.RefId);
if (!string.IsNullOrEmpty(bUCommitmentRequestResponse.Message))
{
bUCommitmentRequestResponse.Acknowledge = AcknowledgeType.Failure;
return(bUCommitmentRequestResponse);
}
foreach (var bUCommitmentRequestDetail in bUCommitmentRequest.BUCommitmentRequestDetails)
{
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 =
BUCommitmentRequestDetailDao.InsertBUPlanReceiptDetail(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="bUCommitmentRequest">The b u commitment request.</param>
/// <returns>System.String.</returns>
public string UpdateBUCommitmentRequest(BUCommitmentRequestEntity bUCommitmentRequest)
{
const string procedures = @"uspUpdate_BUCommitmentRequest";
return(Db.Update(procedures, true, Take(bUCommitmentRequest)));
}
/// <summary>
/// Inserts the bu plan receipt.
/// </summary>
/// <param name="bUCommitmentRequest">The b u commitment request.</param>
/// <returns>System.String.</returns>
public string InsertBUCommitmentRequest(BUCommitmentRequestEntity bUCommitmentRequest)
{
const string procedures = @"uspInsert_BUCommitmentRequest";
return(Db.Insert(procedures, true, Take(bUCommitmentRequest)));
}
