public async Task <IActionResult> PostDPDocument([FromBody] FinanceADPDocumentCreateContext createContext)
{
if (!ModelState.IsValid)
{
HIHAPIUtility.HandleModalStateError(ModelState);
}
if (createContext == null ||
createContext.DocumentInfo == null ||
createContext.AccountInfo == null ||
createContext.AccountInfo.HomeID <= 0 ||
createContext.AccountInfo.Status != (Byte)FinanceAccountStatus.Normal ||
createContext.DocumentInfo.HomeID <= 0 ||
createContext.DocumentInfo.HomeID != createContext.AccountInfo.HomeID ||
createContext.AccountInfo.ExtraDP == null ||
createContext.AccountInfo.ExtraDP.DPTmpDocs.Count <= 0)
{
throw new BadRequestException("Invalid inputted data");
}
// Check tmp doc ID
var tmpdocids = new Dictionary <int, int>();
foreach (var tmpdoc in createContext.AccountInfo.ExtraDP.DPTmpDocs)
{
if (tmpdoc.DocumentID <= 0)
{
throw new BadRequestException("Invalid document ID");
}
if (tmpdocids.ContainsKey(tmpdoc.DocumentID))
{
throw new BadRequestException("Duplicated Document ID found: " + tmpdoc.DocumentID);
}
tmpdocids.Add(tmpdoc.DocumentID, tmpdoc.DocumentID);
}
// User
String usrName = String.Empty;
try
{
usrName = HIHAPIUtility.GetUserID(this);
if (String.IsNullOrEmpty(usrName))
{
throw new UnauthorizedAccessException();
}
}
catch
{
throw new UnauthorizedAccessException();
}
// Check whether User assigned with specified Home ID
var hms = _context.HomeMembers.Where(p => p.HomeID == createContext.AccountInfo.HomeID && p.User == usrName).Count();
if (hms <= 0)
{
throw new UnauthorizedAccessException();
}
// Verify the inputted parameters
if (!(createContext.DocumentInfo.DocType == FinanceDocumentType.DocType_AdvancePayment ||
createContext.DocumentInfo.DocType == FinanceDocumentType.DocType_AdvanceReceive))
{
throw new BadRequestException("Invalid document type");
}
if (createContext.DocumentInfo.Items.Count != 1)
{
throw new BadRequestException("It shall be only one line item in DP docs");
}
// Check on the data
if (createContext.DocumentInfo.DocType == FinanceDocumentType.DocType_AdvancePayment)
{
if (createContext.DocumentInfo.Items.ElementAt(0).TranType != FinanceTransactionType.TranType_AdvancePaymentOut)
{
throw new BadRequestException("Invalid tran. type for advance payment");
}
}
else if (createContext.DocumentInfo.DocType == FinanceDocumentType.DocType_AdvanceReceive)
{
if (createContext.DocumentInfo.Items.ElementAt(0).TranType != FinanceTransactionType.TranType_AdvanceReceiveIn)
{
throw new BadRequestException("Invalid tran. type for advance receive");
}
}
foreach (var tmpdocitem in createContext.AccountInfo.ExtraDP.DPTmpDocs)
{
if (!tmpdocitem.ControlCenterID.HasValue && !tmpdocitem.OrderID.HasValue)
{
throw new BadRequestException("Tmp Doc Item miss control center or order");
}
if (tmpdocitem.TranAmount == 0)
{
throw new BadRequestException("Tmp Doc Item miss amount");
}
tmpdocitem.CreatedAt = DateTime.Now;
tmpdocitem.Createdby = usrName;
}
// Database update
var errorString = "";
var errorOccur = false;
var origdocid = 0;
var dpaccountid = 0;
using (var transaction = _context.Database.BeginTransaction())
{
try
{
createContext.DocumentInfo.Createdby = usrName;
createContext.DocumentInfo.CreatedAt = DateTime.Now;
var docEntity = _context.FinanceDocument.Add(createContext.DocumentInfo);
await _context.SaveChangesAsync();
origdocid = docEntity.Entity.ID;
// 2, Create the account
createContext.AccountInfo.ExtraDP.RefenceDocumentID = origdocid;
createContext.AccountInfo.CreatedAt = DateTime.Now;
createContext.AccountInfo.Createdby = usrName;
var acntEntity = _context.FinanceAccount.Add(createContext.AccountInfo);
await _context.SaveChangesAsync();
dpaccountid = acntEntity.Entity.ID;
// 3, Update the document
var itemid = docEntity.Entity.Items.ElementAt(0).ItemID;
// _context.Attach(docEntity);
var ndi = new FinanceDocumentItem();
ndi.ItemID = ++itemid;
ndi.AccountID = dpaccountid;
ndi.ControlCenterID = docEntity.Entity.Items.ElementAt(0).ControlCenterID;
ndi.OrderID = docEntity.Entity.Items.ElementAt(0).OrderID;
ndi.Desp = docEntity.Entity.Items.ElementAt(0).Desp;
ndi.TranAmount = docEntity.Entity.Items.ElementAt(0).TranAmount;
ndi.UseCurr2 = docEntity.Entity.Items.ElementAt(0).UseCurr2;
if (createContext.DocumentInfo.DocType == FinanceDocumentType.DocType_AdvancePayment)
{
ndi.TranType = FinanceTransactionType.TranType_OpeningAsset;
}
else if (createContext.DocumentInfo.DocType == FinanceDocumentType.DocType_AdvanceReceive)
{
ndi.TranType = FinanceTransactionType.TranType_OpeningLiability;
}
docEntity.Entity.Items.Add(ndi);
docEntity.State = EntityState.Modified;
await _context.SaveChangesAsync();
await transaction.CommitAsync();
}
catch (Exception exp)
{
errorOccur = true;
errorString = exp.Message;
transaction.Rollback();
}
}
if (errorOccur)
{
throw new BadRequestException(errorString);
}
return(Created(createContext.DocumentInfo));
}
public async Task TestCase1(int hid, string currency, string user, short doctype)
{
var context = this.fixture.GetCurrentDataContext();
// 0. Prepare the context for current home
if (hid == DataSetupUtility.Home1ID)
{
fixture.InitHome1TestData(context);
}
else if (hid == DataSetupUtility.Home2ID)
{
fixture.InitHome2TestData(context);
}
else if (hid == DataSetupUtility.Home3ID)
{
fixture.InitHome3TestData(context);
}
else if (hid == DataSetupUtility.Home4ID)
{
fixture.InitHome4TestData(context);
}
else if (hid == DataSetupUtility.Home5ID)
{
fixture.InitHome5TestData(context);
}
var account = context.FinanceAccount.Where(p => p.HomeID == hid && p.Status != (Byte)FinanceAccountStatus.Closed).FirstOrDefault();
var cc = context.FinanceControlCenter.Where(p => p.HomeID == hid).FirstOrDefault();
// 1. Create DP docs.
var control = new FinanceDocumentsController(context);
var userclaim = DataSetupUtility.GetClaimForUser(user);
var httpctx = UnitTestUtility.GetDefaultHttpContext(provider, userclaim);
control.ControllerContext = new ControllerContext()
{
HttpContext = httpctx
};
// 1a. Prepare data
var dpcontext = new FinanceADPDocumentCreateContext();
dpcontext.DocumentInfo = new FinanceDocument()
{
HomeID = hid,
DocType = doctype,
TranCurr = currency,
Desp = "Test 1"
};
var item = new FinanceDocumentItem()
{
DocumentHeader = dpcontext.DocumentInfo,
ItemID = 1,
Desp = "Item 1.1",
TranType = doctype == FinanceDocumentType.DocType_AdvancePayment
? FinanceTransactionType.TranType_AdvancePaymentOut
: FinanceTransactionType.TranType_AdvanceReceiveIn,
TranAmount = 1200,
AccountID = account.ID,
ControlCenterID = cc.ID,
};
dpcontext.DocumentInfo.Items.Add(item);
dpcontext.AccountInfo = new FinanceAccount()
{
HomeID = hid,
Name = "Account_8" + ".1",
CategoryID = doctype == FinanceDocumentType.DocType_AdvancePayment
? FinanceAccountCategory.AccountCategory_AdvancePayment
: FinanceAccountCategory.AccountCategory_AdvanceReceive,
Owner = user,
Status = (Byte)FinanceAccountStatus.Normal,
};
var startdate = DateTime.Today;
var enddate = DateTime.Today.AddMonths(6);
dpcontext.AccountInfo.ExtraDP = new FinanceAccountExtraDP()
{
StartDate = startdate,
EndDate = enddate,
RepeatType = RepeatFrequency.Month,
Comment = "Test",
};
var rsts = CommonUtility.WorkoutRepeatedDatesWithAmount(new RepeatDatesWithAmountCalculationInput
{
StartDate = startdate,
EndDate = enddate,
TotalAmount = item.TranAmount,
RepeatType = RepeatFrequency.Month,
Desp = item.Desp,
});
var tmpdocid = 1;
foreach (var rst in rsts)
{
var tmpdoc = new FinanceTmpDPDocument
{
DocumentID = tmpdocid++,
TranAmount = rst.TranAmount,
TransactionDate = rst.TranDate,
HomeID = hid,
TransactionType = 5,
ControlCenterID = item.ControlCenterID,
OrderID = item.OrderID,
Description = item.Desp
};
dpcontext.AccountInfo.ExtraDP.DPTmpDocs.Add(tmpdoc);
}
var resp = await control.PostDPDocument(dpcontext);
var doc = Assert.IsType <CreatedODataResult <FinanceDocument> >(resp).Entity;
documentsCreated.Add(doc.ID);
Assert.True(doc.Items.Count == 2);
var dpacntid = -1;
foreach (var did in doc.Items)
{
if (did.AccountID != account.ID)
{
dpacntid = did.AccountID;
accountsCreated.Add(dpacntid);
}
}
// 2. Switch to second controller
var tmpcontrol = new FinanceTmpDPDocumentsController(context);
tmpcontrol.ControllerContext = new ControllerContext()
{
HttpContext = httpctx
};
var tmpdocs = tmpcontrol.Get();
Assert.NotEmpty(tmpdocs);
Assert.Equal(rsts.Count, tmpdocs.Count());
var dpdocs = tmpdocs.Cast <FinanceTmpDPDocument>();
// 3. Create repay document
foreach (var dpdoc in dpdocs)
{
var dppostcontext = new FinanceTmpDPDocumentPostContext()
{
DocumentID = dpdoc.DocumentID,
AccountID = dpdoc.AccountID,
HomeID = dpdoc.HomeID,
};
var repaydocresp = await tmpcontrol.PostDocument(dppostcontext);
var repaydoc = Assert.IsType <CreatedODataResult <FinanceDocument> >(repaydocresp);
Assert.True(repaydoc.Entity.ID > 0);
documentsCreated.Add(repaydoc.Entity.ID);
// Check in the database
var dpdocInDB = context.FinanceTmpDPDocument.Where(p => p.DocumentID == dpdoc.DocumentID).SingleOrDefault();
Assert.NotNull(dpdocInDB);
Assert.NotNull(dpdocInDB.ReferenceDocumentID);
}
// Check the account status
var account2 = context.FinanceAccount.Where(p => p.HomeID == hid && p.ID == dpacntid).FirstOrDefault();
Assert.True(account2.Status == (Byte)FinanceAccountStatus.Closed);
CleanupCreatedEntries();
await context.DisposeAsync();
}
