public async Task <IActionResult> Get([FromRoute] int id, [FromQuery] Int32 hid = 0)
{
if (hid <= 0)
{
return(BadRequest("Not HID inputted"));
}
String usrName = String.Empty;
if (Startup.UnitTestMode)
{
usrName = UnitTestUtility.UnitTestUser;
}
else
{
var usrObj = HIHAPIUtility.GetUserClaim(this);
usrName = usrObj.Value;
}
if (String.IsNullOrEmpty(usrName))
{
return(BadRequest("User cannot recognize"));
}
FinanceLoanDocumentUIViewModel vm = new FinanceLoanDocumentUIViewModel();
SqlConnection conn = null;
SqlCommand cmd = null;
SqlDataReader reader = null;
String queryString = "";
String strErrMsg = "";
HttpStatusCode errorCode = HttpStatusCode.OK;
try
{
queryString = HIHDBUtility.GetFinanceDocLoanQueryString(id, hid);
using (conn = new SqlConnection(Startup.DBConnectionString))
{
await conn.OpenAsync();
// Check Home assignment with current user
try
{
HIHAPIUtility.CheckHIDAssignment(conn, hid, usrName);
}
catch (Exception)
{
errorCode = HttpStatusCode.BadRequest;
throw;
}
cmd = new SqlCommand(queryString, conn);
reader = cmd.ExecuteReader();
if (!reader.HasRows)
{
errorCode = HttpStatusCode.NotFound;
throw new Exception();
}
// Header
while (reader.Read())
{
HIHDBUtility.FinDocHeader_DB2VM(reader, vm);
}
reader.NextResult();
// Items
while (reader.Read())
{
FinanceDocumentItemUIViewModel itemvm = new FinanceDocumentItemUIViewModel();
HIHDBUtility.FinDocItem_DB2VM(reader, itemvm);
vm.Items.Add(itemvm);
}
reader.NextResult();
// Account
while (reader.Read())
{
FinanceAccountUIViewModel vmAccount = new FinanceAccountUIViewModel();
Int32 aidx = 0;
aidx = HIHDBUtility.FinAccountHeader_DB2VM(reader, vmAccount, aidx);
vmAccount.ExtraInfo_Loan = new FinanceAccountExtLoanViewModel();
HIHDBUtility.FinAccountLoan_DB2VM(reader, vmAccount.ExtraInfo_Loan, aidx);
vm.AccountVM = vmAccount;
}
reader.NextResult();
// Tmp docs
while (reader.Read())
{
FinanceTmpDocLoanViewModel loanvm = new FinanceTmpDocLoanViewModel();
HIHDBUtility.FinTmpDocLoan_DB2VM(reader, loanvm);
vm.AccountVM.ExtraInfo_Loan.LoanTmpDocs.Add(loanvm);
}
reader.NextResult();
// Tag
if (reader.HasRows)
{
while (reader.Read())
{
Int32 itemID = reader.GetInt32(0);
String sterm = reader.GetString(1);
foreach (var vitem in vm.Items)
{
if (vitem.ItemID == itemID)
{
vitem.TagTerms.Add(sterm);
}
}
}
}
}
}
catch (Exception exp)
{
System.Diagnostics.Debug.WriteLine(exp.Message);
strErrMsg = exp.Message;
if (errorCode == HttpStatusCode.OK)
{
errorCode = HttpStatusCode.InternalServerError;
}
}
finally
{
if (reader != null)
{
reader.Dispose();
reader = null;
}
if (cmd != null)
{
cmd.Dispose();
cmd = null;
}
if (conn != null)
{
conn.Dispose();
conn = null;
}
}
if (errorCode != HttpStatusCode.OK)
{
switch (errorCode)
{
case HttpStatusCode.Unauthorized:
return(Unauthorized());
case HttpStatusCode.NotFound:
return(NotFound());
case HttpStatusCode.BadRequest:
return(BadRequest(strErrMsg));
default:
return(StatusCode(500, strErrMsg));
}
}
var setting = new Newtonsoft.Json.JsonSerializerSettings
{
DateFormatString = HIHAPIConstants.DateFormatPattern,
ContractResolver = new Newtonsoft.Json.Serialization.CamelCasePropertyNamesContractResolver()
};
return(new JsonResult(vm, setting));
}
public async Task <IActionResult> Post([FromBody] FinanceLoanDocumentUIViewModel vm)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (vm == null || (vm.DocType != FinanceDocTypeViewModel.DocType_BorrowFrom &&
vm.DocType != FinanceDocTypeViewModel.DocType_LendTo))
{
return(BadRequest("No data is inputted"));
}
if (vm.HID <= 0)
{
return(BadRequest("Not HID inputted"));
}
String usrName = String.Empty;
if (Startup.UnitTestMode)
{
usrName = UnitTestUtility.UnitTestUser;
}
else
{
var usrObj = HIHAPIUtility.GetUserClaim(this);
usrName = usrObj.Value;
}
if (String.IsNullOrEmpty(usrName))
{
return(BadRequest("User cannot recognize"));
}
// Check the items
if (vm.Items.Count != 1)
{
return(BadRequest("Only one item doc is supported by far"));
}
if (vm.AccountVM == null || vm.AccountVM.ExtraInfo_Loan == null)
{
return(BadRequest("No account info!"));
}
if (vm.AccountVM.ExtraInfo_Loan.LoanTmpDocs.Count <= 0)
{
return(BadRequest("No template docs defined!"));
}
else
{
foreach (var tdoc in vm.AccountVM.ExtraInfo_Loan.LoanTmpDocs)
{
if (!tdoc.ControlCenterID.HasValue && !tdoc.OrderID.HasValue)
{
return(BadRequest("Either control center or order shall be specified in Loan Template doc"));
}
if (tdoc.TranAmount <= 0)
{
return(BadRequest("Amount is zero!"));
}
}
}
// Update the database
SqlConnection conn = null;
SqlCommand cmd = null;
SqlDataReader reader = null;
SqlTransaction tran = null;
String queryString = "";
Int32 nNewDocID = -1;
String strErrMsg = "";
HttpStatusCode errorCode = HttpStatusCode.OK;
try
{
using (conn = new SqlConnection(Startup.DBConnectionString))
{
await conn.OpenAsync();
// Check Home assignment with current user
try
{
HIHAPIUtility.CheckHIDAssignment(conn, vm.HID, usrName);
}
catch (Exception)
{
errorCode = HttpStatusCode.BadRequest;
throw;
}
tran = conn.BeginTransaction();
// First, create the doc header => nNewDocID
queryString = HIHDBUtility.GetFinDocHeaderInsertString();
cmd = new SqlCommand(queryString, conn)
{
Transaction = tran
};
HIHDBUtility.BindFinDocHeaderInsertParameter(cmd, vm, usrName);
SqlParameter idparam = cmd.Parameters.AddWithValue("@Identity", SqlDbType.Int);
idparam.Direction = ParameterDirection.Output;
Int32 nRst = await cmd.ExecuteNonQueryAsync();
nNewDocID = (Int32)idparam.Value;
cmd.Dispose();
cmd = null;
// Then, creating the items
foreach (FinanceDocumentItemUIViewModel ivm in vm.Items)
{
if (vm.DocType == FinanceDocTypeViewModel.DocType_BorrowFrom)
{
ivm.TranType = FinanceTranTypeViewModel.TranType_BorrowFrom;
}
else if (vm.DocType == FinanceDocTypeViewModel.DocType_LendTo)
{
ivm.TranType = FinanceTranTypeViewModel.TranType_LendTo;
}
queryString = HIHDBUtility.GetFinDocItemInsertString();
cmd = new SqlCommand(queryString, conn)
{
Transaction = tran
};
HIHDBUtility.BindFinDocItemInsertParameter(cmd, ivm, nNewDocID);
await cmd.ExecuteNonQueryAsync();
cmd.Dispose();
cmd = null;
// Tags
if (ivm.TagTerms.Count > 0)
{
// Create tags
foreach (var term in ivm.TagTerms)
{
queryString = HIHDBUtility.GetTagInsertString();
cmd = new SqlCommand(queryString, conn, tran);
HIHDBUtility.BindTagInsertParameter(cmd, vm.HID, HIHTagTypeEnum.FinanceDocumentItem, nNewDocID, term, ivm.ItemID);
await cmd.ExecuteNonQueryAsync();
cmd.Dispose();
cmd = null;
}
}
}
// Third, go to the account creation => nNewAccountID
queryString = HIHDBUtility.GetFinanceAccountHeaderInsertString();
cmd = new SqlCommand(queryString, conn)
{
Transaction = tran
};
HIHDBUtility.BindFinAccountInsertParameter(cmd, vm.AccountVM, usrName);
SqlParameter idparam2 = cmd.Parameters.AddWithValue("@Identity", SqlDbType.Int);
idparam2.Direction = ParameterDirection.Output;
nRst = await cmd.ExecuteNonQueryAsync();
Int32 nNewAccountID = (Int32)idparam2.Value;
cmd.Dispose();
cmd = null;
// 3a. Create another item to loan document
var nMaxItemID = vm.Items.Max(item => item.ItemID);
foreach (FinanceDocumentItemUIViewModel ivm in vm.Items)
{
ivm.ItemID = ++nMaxItemID;
ivm.AccountID = nNewAccountID;
if (vm.DocType == FinanceDocTypeViewModel.DocType_BorrowFrom)
{
ivm.TranType = FinanceTranTypeViewModel.TranType_OpeningLiability;
}
else if (vm.DocType == FinanceDocTypeViewModel.DocType_LendTo)
{
ivm.TranType = FinanceTranTypeViewModel.TranType_OpeningAsset;
}
queryString = HIHDBUtility.GetFinDocItemInsertString();
SqlCommand cmd2 = new SqlCommand(queryString, conn)
{
Transaction = tran
};
HIHDBUtility.BindFinDocItemInsertParameter(cmd2, ivm, nNewDocID);
await cmd2.ExecuteNonQueryAsync();
cmd2.Dispose();
cmd2 = null;
}
// Fourth, creat the Loan part
queryString = HIHDBUtility.GetFinanceAccountLoanInsertString();
cmd = new SqlCommand(queryString, conn)
{
Transaction = tran
};
HIHDBUtility.BindFinAccountLoanInsertParameter(cmd, vm.AccountVM.ExtraInfo_Loan, nNewDocID, nNewAccountID, usrName);
nRst = await cmd.ExecuteNonQueryAsync();
cmd.Dispose();
cmd = null;
// Fifth, create template docs
foreach (FinanceTmpDocLoanViewModel avm in vm.AccountVM.ExtraInfo_Loan.LoanTmpDocs)
{
queryString = HIHDBUtility.GetFinanceTmpDocLoanInsertString();
cmd = new SqlCommand(queryString, conn)
{
Transaction = tran
};
HIHDBUtility.BindFinTmpDocLoanParameter(cmd, avm, nNewAccountID, usrName);
await cmd.ExecuteNonQueryAsync();
cmd.Dispose();
cmd = null;
}
tran.Commit();
// Update the buffer
// Account list
var cacheKey = String.Format(CacheKeys.FinAccountList, vm.HID, null);
this._cache.Remove(cacheKey);
}
}
catch (Exception exp)
{
#if DEBUG
System.Diagnostics.Debug.WriteLine(exp.Message);
#endif
if (tran != null)
{
tran.Rollback();
}
strErrMsg = exp.Message;
if (errorCode == HttpStatusCode.OK)
{
errorCode = HttpStatusCode.InternalServerError;
}
}
finally
{
if (tran != null)
{
tran.Dispose();
tran = null;
}
if (reader != null)
{
reader.Dispose();
reader = null;
}
if (cmd != null)
{
cmd.Dispose();
cmd = null;
}
if (conn != null)
{
conn.Dispose();
conn = null;
}
}
if (errorCode != HttpStatusCode.OK)
{
switch (errorCode)
{
case HttpStatusCode.Unauthorized:
return(Unauthorized());
case HttpStatusCode.NotFound:
return(NotFound());
case HttpStatusCode.BadRequest:
return(BadRequest(strErrMsg));
default:
return(StatusCode(500, strErrMsg));
}
}
vm.ID = nNewDocID;
var setting = new Newtonsoft.Json.JsonSerializerSettings
{
DateFormatString = HIHAPIConstants.DateFormatPattern,
ContractResolver = new Newtonsoft.Json.Serialization.CamelCasePropertyNamesContractResolver()
};
return(new JsonResult(vm, setting));
}
