private static object[] Take(PUInvoiceEntity entity)
{
return(new object[]
{
"@RefID", entity.RefId,
"@RefType", entity.RefType,
"@RefDate", entity.RefDate,
"@PostedDate", entity.PostedDate,
"@RefNo", entity.RefNo,
"@IncrementRefNo", entity.IncrementRefNo,
"@AccountingObjectId", entity.AccountingObjectId,
"@CompanyTaxCode", entity.CompanyTaxCode,
"@AccountingObjectContactName", entity.AccountingObjectContactName,
"@JournalMemo", entity.JournalMemo,
"@TotalAmount", entity.TotalAmount,
"@TotalTaxAmount", entity.TotalTaxAmount,
"@TotalAmountOC", entity.TotalAmountOC,
"@CurrencyCode", entity.CurrencyCode,
"@ExchangeRate", entity.ExchangeRate,
});
}
//private List<BankInfo> banks;
public List <PUInvoiceEntity> GetPUInvoices(string connectionString)
{
List <PUInvoiceEntity> buentity = new List <PUInvoiceEntity>();
using (var context = new MISAEntity(connectionString))
{
var querry = context.PUInvoiceDetails.ToList();
var projects = context.Projects.ToList();
//var currencys = context.CCies.ToList();
var budgetsource = context.BudgetSources.ToList();
var listitems = context.ListItems.ToList();
//var funds = context.Funds.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();
//var stocks = context.Stocks.ToList();
var topics = context.Topics.ToList();
var fixedassets = context.FixedAssets.ToList();
var departments = context.Departments.ToList();
var purchasepurposes = context.PurchasePurposes.ToList();
//var inventoryitems = context.InventoryItems.ToList();
//banks = context.BankInfoes.ToList();
var detailfixedassets = context.PUInvoiceDetailFixedAssets.ToList();
var resultcontext = context.PUInvoices.Where(x => x.RefType != 301).ToList();
foreach (var result in resultcontext)
{
var newresult = new PUInvoiceEntity();
newresult.RefId = result.RefID.ToString();
newresult.RefType = ConvRefType.ConvRefType(result.RefType);
newresult.RefDate = result.RefDate;
newresult.PostedDate = result.PostedDate;
newresult.RefNo = result.RefNo;
newresult.ParalellRefNo = result.ParalellRefNo;
newresult.InwardRefNo = result.InwardRefNo;
newresult.IncrementRefNo = result.IncrementRefNo;
newresult.AccountingObjectId = result.AccountingObject == null ? null : result.AccountingObject.AccountingObjectID.ToString();
newresult.AccountingObjectName = result.AccountingObjectName;
newresult.AccountingObjectAddress = result.AccountingObjectAddress;
newresult.CompanyTaxCode = result.CompanyTaxCode;
newresult.AccountingObjectContactName = result.AccountingObjectContactName;
newresult.JournalMemo = result.JournalMemo;
newresult.TotalAmount = result.TotalAmount;
newresult.TotalTaxAmount = result.TotalTaxAmount;
newresult.TotalFreightAmount = result.TotalFreightAmount;
newresult.TotalInwardAmount = result.TotalInwardAmount;
newresult.Posted = result.Posted;
newresult.PostVersion = result.PostVersion ?? 0;
newresult.EditVersion = result.EditVersion ?? 0;
newresult.RefOrder = result.RefOrder ?? 0;
newresult.TotalFixedAssetAmount = result.TotalFixedAssetAmount;
newresult.FARefOrder = result.FARefOrder;
//newresult.CurrencyCode = result.cuu;
//newresult.ExchangeRate = result.ex;
//newresult.TotalAmountOC = result.to;
newresult.PUInvoiceDetailFixedAssets = result.PUInvoiceDetailFixedAssets.Count <= 0 ? null : PUInvoiceDetailFixedAssets(result.PUInvoiceDetailFixedAssets.ToList(), result.RefID.ToString());
buentity.Add(newresult);
}
}
return(buentity);//Bỏ chứng từ hóa đơn mua hàng
}
public PUInvoiceResponse UpdatePUInvoice(PUInvoiceEntity pUInvoice)
{
var pUInvoiceResponse = new PUInvoiceResponse {
Acknowledge = AcknowledgeType.Success
};
if (pUInvoice != null && !pUInvoice.Validate())
{
foreach (var error in pUInvoice.ValidationErrors)
{
pUInvoiceResponse.Message += error + Environment.NewLine;
}
pUInvoiceResponse.Acknowledge = AcknowledgeType.Failure;
return(pUInvoiceResponse);
}
using (var scope = new TransactionScope())
{
if (pUInvoice != null)
{
#region Master
var pUInvoiceByRefNo = PUInvoiceDao.GetPUInvoiceByRefNo(pUInvoice.RefNo, pUInvoice.PostedDate);
if (pUInvoiceByRefNo != null && !pUInvoiceByRefNo.RefId.Equals(pUInvoice.RefId) && pUInvoiceByRefNo.PostedDate.Year == pUInvoice.PostedDate.Year)
{
pUInvoiceResponse.Acknowledge = AcknowledgeType.Failure;
pUInvoiceResponse.Message = string.Format("Số chứng từ \'{0}\' đã tồn tại!", pUInvoice.RefNo);
return(pUInvoiceResponse);
}
if (string.IsNullOrEmpty(pUInvoice.RefId))
{
pUInvoice.RefId = Guid.NewGuid().ToString();
}
else
{
// Xóa detail
pUInvoiceResponse.Message = PUInvoiceDetailFixedAssetDao.DeletePUInvoiceDetailFixedAssets(pUInvoice.RefId);
if (!string.IsNullOrEmpty(pUInvoiceResponse.Message))
{
goto Error;
}
AutoMapper(DeleteGeneralLedger(pUInvoice.RefId), pUInvoiceResponse);
if (!string.IsNullOrEmpty(pUInvoiceResponse.Message))
{
goto Error;
}
AutoMapper(DeleteOriginalLedger(pUInvoice.RefId), pUInvoiceResponse);
if (!string.IsNullOrEmpty(pUInvoiceResponse.Message))
{
goto Error;
}
AutoMapper(DeleteFixAssetLedger(pUInvoice.RefId, pUInvoice.RefType), pUInvoiceResponse);
if (!string.IsNullOrEmpty(pUInvoiceResponse.Message))
{
goto Error;
}
}
pUInvoiceResponse.Message = PUInvoiceDao.UpdatePUInvoice(pUInvoice);
if (!string.IsNullOrEmpty(pUInvoiceResponse.Message))
{
goto Error;
}
#endregion
#region Detail
if (pUInvoice.PUInvoiceDetailFixedAssets != null && pUInvoice.PUInvoiceDetailFixedAssets.Count > 0)
{
foreach (PUInvoiceDetailFixedAssetEntity entity in pUInvoice.PUInvoiceDetailFixedAssets)
{
entity.RefDetailId = Guid.NewGuid().ToString();
entity.RefId = pUInvoice.RefId;
pUInvoiceResponse.Message = PUInvoiceDetailFixedAssetDao.UpdatePUInvoiceDetailFixedAsset(entity);
if (!string.IsNullOrEmpty(pUInvoiceResponse.Message))
{
goto Error;
}
#region General Ledger
AutoMapper(InsertGeneralLedger(entity, pUInvoice), pUInvoiceResponse);
if (!string.IsNullOrEmpty(pUInvoiceResponse.Message))
{
goto Error;
}
#endregion
#region Original Ledger
AutoMapper(InsertOriginalLedger(entity, pUInvoice), pUInvoiceResponse);
if (!string.IsNullOrEmpty(pUInvoiceResponse.Message))
{
goto Error;
}
#endregion
#region FixedAsset Ledger
if (entity.DebitAccount.StartsWith("21"))
{
AutoMapper(InsertFixAssetLedger(entity, pUInvoice), pUInvoiceResponse);
if (!string.IsNullOrEmpty(pUInvoiceResponse.Message))
{
goto Error;
}
}
#endregion
}
}
#endregion
#region Error
Error:
if (!string.IsNullOrEmpty(pUInvoiceResponse.Message))
{
pUInvoiceResponse.Acknowledge = AcknowledgeType.Failure;
scope.Dispose();
return(pUInvoiceResponse);
}
pUInvoiceResponse.RefId = pUInvoice.RefId;
scope.Complete();
#endregion
}
return(pUInvoiceResponse);
}
}
public string UpdatePUInvoice(PUInvoiceEntity entity)
{
const string procedures = @"uspInsert_PUInvoice";
return(Db.Insert(procedures, true, Take(entity)));
}
