public async Task <IActionResult> Post([FromBody] FinanceADPDocumentUIViewModel vm)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (vm == null || !(vm.DocType == FinanceDocTypeViewModel.DocType_AdvancePayment ||
vm.DocType == FinanceDocTypeViewModel.DocType_AdvanceReceive))
{
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 <= 0 || vm.AccountVM == null || vm.AccountVM.ExtraInfo_ADP == null ||
vm.AccountVM.ExtraInfo_ADP.DPTmpDocs.Count <= 0 || vm.Items.Count != 1)
{
return(BadRequest("No item or no account or no template docs"));
}
// Check on the data
if (vm.DocType == FinanceDocTypeViewModel.DocType_AdvancePayment)
{
if (vm.Items[0].TranType != FinanceTranTypeViewModel.TranType_AdvancePaymentOut)
{
return(BadRequest("Invalid tran. type for advance payment"));
}
}
else if (vm.DocType == FinanceDocTypeViewModel.DocType_AdvanceReceive)
{
if (vm.Items[0].TranType != FinanceTranTypeViewModel.TranType_AdvanceReceiveIn)
{
return(BadRequest("Invalid tran. type for advance receive"));
}
}
foreach (var tmpdocitem in vm.AccountVM.ExtraInfo_ADP.DPTmpDocs)
{
if (!tmpdocitem.ControlCenterID.HasValue && !tmpdocitem.OrderID.HasValue)
{
return(BadRequest("Tmp Doc Item miss control center or order"));
}
if (tmpdocitem.TranAmount == 0)
{
return(BadRequest("Tmp Doc Item miss amount"));
}
}
// 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, craete 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)
{
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_AdvancePayment)
{
ivm.TranType = FinanceTranTypeViewModel.TranType_OpeningAsset;
}
else if (vm.DocType == FinanceDocTypeViewModel.DocType_AdvanceReceive)
{
ivm.TranType = FinanceTranTypeViewModel.TranType_OpeningLiability;
}
queryString = HIHDBUtility.GetFinDocItemInsertString();
cmd = new SqlCommand(queryString, conn)
{
Transaction = tran
};
HIHDBUtility.BindFinDocItemInsertParameter(cmd, ivm, nNewDocID);
await cmd.ExecuteNonQueryAsync();
cmd.Dispose();
cmd = null;
break;
}
// Fourth, creat the ADP part
queryString = HIHDBUtility.GetFinanceAccountADPInsertString();
cmd = new SqlCommand(queryString, conn)
{
Transaction = tran
};
HIHDBUtility.BindFinAccountADPInsertParameter(cmd, vm.AccountVM.ExtraInfo_ADP, nNewDocID, nNewAccountID, usrName);
nRst = await cmd.ExecuteNonQueryAsync();
cmd.Dispose();
cmd = null;
// Sixth, create template docs
foreach (FinanceTmpDocDPViewModel avm in vm.AccountVM.ExtraInfo_ADP.DPTmpDocs)
{
queryString = HIHDBUtility.getFinanceTmpDocADPInsertString();
cmd = new SqlCommand(queryString, conn)
{
Transaction = tran
};
HIHDBUtility.bindFinTmpDocADPParameter(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));
}