DYBT
Table of Contents
- Server Details
- Troubleshooting
- Forms
- Reports
- []()
- []()
- []()
- []()
Server Details
Troubleshooting
Runtime Error
The above error occurs when a new instance of the app is published from Visual Studio to the gocdmofapps server. The hosting (IIS 8) configuration is in a nested format as:
- > GOCDMOFAPPS
-- > Default Web sites
---- > dybtAppAs a result, dybtApp inherits Default Web sites web.config connection settings.
To resolve this issue, add the below line in dybtApp web.config file:
<connectionStrings>
<clear/>
<!-- ===================== DB CONNECTION + ACTIVE DIRECTORY ========================== -->
....
</connectStrings> Forms
Loans Forms
ver: 2025-07-25 00:00:00.000
<!-- {REQUIRED} Calendar default event color -->
<input type="hidden" name="txtInput_13" value="#3788d8"/>
<!-- POS Invoice logic - Input Fields -->
<input type="hidden" name="txtInput_14" id="txtInput_14" value="" /><!-- dbo.capture_payments - payer -->
<input type="hidden" name="txtInput_15" id="txtInput_15" value="notes: Loan -- form entry" /><!-- dbo.capture_payments - comment -->
<input type="hidden" name="txtInput_16" id="txtInput_16" value="6024" /><!-- dbo.capture_payments - FK_items -->
<div class="vc-form">
<div class="">
<h1>Loan Form</h1>
</div>
<div>
<h3>Customer Info::</h3>
<fieldset>
<legend>+NEW</legend>
<div>
<input type="checkbox" id="newCus" />
<label for="new">customer</label>
</div>
</fieldset>
<br />
<div class="formbuilder-select form-group">
<label class="formbuilder-select-label">Customer list:</label>
<select
class="form-control"
name="selectInput_03"
id="selectInput_03">
<option>
-- Select --
</option>
</select>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Name:</label>
<input
type="text"
placeholder="e.g. Jane Doe"
class="form-control"
name="txtInput_01"
access="false"
id="txtInput_01"
/>
</div>
</div>
<div>
<h3>Guarantees::</h3>
<div class="inner-container">
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label"><span style="color:red;">*</span>Amount:</label>
<input
type="number"
placeholder="e.g. 15,000"
class="form-control"
name="txtInput_02"
id="txtInput_02"
required="required"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label"><span style="color:red;">*</span>Rate (%) Percentage:</label>
<input
type="number"
placeholder="e.g. 10"
class="form-control"
name="txtInput_03"
id="txtInput_03"
required="required"
/>
</div>
</div>
</div>
<div>
<h3>Interest::</h3>
<div class="inner-container">
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label"><span style="color:red;">*</span>Terms (in years):</label>
<input
type="number"
placeholder="e.g. 10"
class="form-control"
name="txtInput_04"
id="txtInput_04"
required="required"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Amount (in interest):</label>
<input
type="number"
placeholder="e.g. 6,000"
class="form-control"
name="txtInput_05"
id="txtInput_05"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">in Arreals:</label>
<input
type="text"
placeholder=""
class="form-control"
name="txtInput_06"
access="false"
id="txtInput_06"
/>
</div>
</div>
</div>
<div>
<h3>Loan Info::</h3>
<div class="inner-container">
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Amount:</label>
<input
type="number"
placeholder=""
class="form-control"
name="txtInput_07"
id="txtInput_07"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Approval Date:</label>
<input
type="text"
placeholder=""
class="form-control"
name="txtInput_08"
access="false"
id="txtInput_08"
readonly
/>
</div>
</div>
<div class="inner-container">
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Product:</label>
<input
type="text"
placeholder=""
class="form-control"
name="txtInput_09"
access="false"
id="txtInput_09"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Repayment:</label>
<input
type="text"
placeholder=""
class="form-control"
name="txtInput_10"
access="false"
id="txtInput_10"
/>
</div>
</div>
<div class="inner-container">
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Status:</label>
<input
type="text"
placeholder=""
class="form-control"
name="txtInput_11"
access="false"
id="txtInput_11"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Payment:</label>
<input
type="number"
placeholder=""
class="form-control"
name="txtInput_12"
access="false"
id="txtInput_12"
/>
</div>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">for Use:</label>
<input
type="text"
placeholder=""
class="form-control"
name="txtInput_13"
access="false"
id="txtInput_13"
/>
</div>
</div>
<div>
<h3>Additional Info::</h3>
<div class="additional-check">
<input type="checkbox" id="checkInput_01" />
<label for="admin">Admin Fee Paid</label>
</div>
<div class="additional-check">
<input type="checkbox" id="checkInput_02" />
<label for="bank">Bank Statement</label>
</div>
<div class="additional-check">
<input type="checkbox" id="checkInput_03" />
<label for="business">Business Plan</label>
</div>
<div class="formbuilder-text form-group comments-container">
<label class="formbuilder-text-label comments-label"
>Comments:</label
>
<textarea
type="textarea"
class="form-control"
id="txtAreaInput_01"
></textarea>
</div>
</div>
<div class="formbuilder-button form-group">
<input
type="submit"
value="Submit"
class="btn-success btn"
name="button-1676508942222"
access="false"
id="button-1676508942222"
/>
</div>
</div>
<script>
// Calendar Datetime value + Approval Date
// ================================================
var currentdate = new Date();
var datetime = currentdate.getFullYear() +"-"+ (currentdate.getMonth()+1) +"-"+ currentdate.getDate() + "T" + currentdate.getHours() + ":" +currentdate.getMinutes();
// 2024-10-12T20:03
$("#txtInput_08").val(datetime);
// Calculate loan interest amount & Invoice entry amount
// =======================================
var principleAmt = $("#txtInput_02");
var paData = "";
var rate = $("#txtInput_03");
var rData = "";
var terms = $("#txtInput_04");
var interestAmt = $("#txtInput_05");
var iData = "";
var balance = $("#txtInput_07");
var bData = "";
principleAmt.on("change", function () {
paData = $(this).val();
});
rate.on("change", function () {
rData = $(this).val();
});
terms.on("change", function () {
iData = parseFloat(paData*rData*$(this).val());
bData = parseFloat(paData) + parseFloat(iData);
interestAmt.val(iData).prop('readonly', true);
balance.val(bData).prop('readonly', true);
$("#txtInput_17").val(bData);
$("#txtInput_18").val(bData);
});
// create invoice
// =======================================
$("form").submit(function() {
$.ajax({
url: '../../capture_payments/CreateForm',
type: "POST",
data: $(this).serialize(),
success: function () {}
});
});
// Get Saved Customers
// =============================================================
$.ajax({
url: "../../customer/Json",
type: "GET",
success: function (result) {
$.each(result, function (k, v) {
$("#selectInput_03").append(
'<option value="' +
v.firstName +
"," +
v.lastName +
"," +
v.phone +
"," +
v.email +
'">' +
v.firstName +
" " +
v.lastName +
"</option>"
);
});
},
});
$("#selectInput_03").on("keyup, change", function () {
var array = $(this).val().split(",");
$("#txtInput_01").val(array[0] + " " + array[1]);
// $("#txtInput_03").val(array[2]);
// $("#txtInput_04").val(array[3]);
$("#txtInput_14").val($("#txtInput_01").val()); // UPDATE Customer name field for Invoice
$("#txtAreaInput_03").html($("#txtInput_01").val()); //UPDATE Customer name field for CalendarView
});
// Add New Customer Modal
// ==================================
$("#newCus").change(function () {
if ($(this).is(":checked")) {
Metro.dialog.create({
closeButton: true,
clsTitle: "bg-green fg-white",
title: "<span class='mif-user-plus'></span> New Customer",
content:
"<div class=form-horizontal><div class=grid style=background:#fff;border-radius:10px;width:100%;padding:20px><div class=row><div class=cell-12><form method=POST><input name=firstName data-label='First Name:'data-role=materialinput id=firstName placeholder='Enter First Name'required> <input name=lastName data-label='Last Name:'data-role=materialinput id=lastName placeholder='Enter Last Name'required> <input name=address data-label=Address: data-role=materialinput id=address placeholder=Address> <input name=state data-label=State: data-role=materialinput id=state placeholder=State> <input name=phone data-label='Phone Number:'data-role=materialinput id=phone placeholder='Enter Phone Number'required> <input name=email data-label=Email: data-role=materialinput id=email placeholder='Enter Email'type=email> <input name=FK_Location type=hidden></form></div></div></div></div>",
actions: [
{
caption: "Finish & Save",
cls: "primary",
onclick: function () {
var formData = {
firstName: $("#firstName").val(),
lastName: $("#lastName").val(),
address: $("#address").val(),
state: $("#state").val(),
phone: $("#phone").val(),
email: $("#email").val(),
FK_Location: $("#FK_Locaion").val(),
};
$.ajax({
url: "../../customer/Create/",
type: "POST",
data: formData,
success: function () {
window.location.reload();
},
});
},
},
],
});
}
});
</script>Contact Forms
ver: 2025-07-25 00:00:00.000
<input type="hidden" name="txtInput_05" value="#6666ff" />
<input type="hidden" name="txtInput_06" value="" />
<input type="hidden" name="lk_REF_formName" id="lk_REF_formName" />
<input type="hidden" name="lk_REF_formCheck" value="1" />
<div class="vc-form">
<div class="">
<h1>Contact Form</h1>
</div>
<div class="form-group files">
<label>Attach Profile Picture:</label><br />
<input type="file" class="form-control" name="fileInput_01" id="fileInput_01">
<br/><br/>
</div>
<div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Full Name:</label>
<input
type="text"
placeholder="e.g. Jane Doe"
class="form-control"
name="txtInput_01"
access="false"
id="txtInput_01"
/>
</div>
</div>
<div>
<h3>Personal Info::</h3>
<div class="inner-container">
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">First Name:</label>
<input
type="text"
placeholder="e.g. Jane"
class="form-control"
name="firstName"
id="firstName"
required
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Last Name:</label>
<input
type="text"
placeholder="e.g. Doe"
class="form-control"
name="lastName"
id="lastName"
required
/>
</div>
</div>
<div class="inner-container">
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Email:</label>
<input
type="email"
placeholder="e.g. jane.doe@example.com"
class="form-control"
name="email"
id="email"
required
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Phone Number:</label>
<input
type="tel"
placeholder="e.g. 123-456-7890"
class="form-control"
name="phone"
id="phone"
/>
</div>
</div>
<div class="inner-container">
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Address:</label>
<input
type="text"
placeholder="e.g. 123 Main St"
class="form-control"
name="address"
id="address"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">City:</label>
<input
type="text"
placeholder="e.g. New York"
class="form-control"
name="txtInput_02"
id="txtInput_02"
/>
</div>
</div>
<div class="inner-container">
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">State:</label>
<input
type="text"
placeholder="e.g. NY"
class="form-control"
name="state"
id="state"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Zip Code:</label>
<input
type="text"
placeholder="e.g. 10001"
class="form-control"
name="txtInput_03"
id="txtInput_03"
/>
</div>
</div>
<div class="inner-container">
<div class="formbuilder-select form-group">
<label class="formbuilder-select-label">Gender:</label>
<select class="form-control" name="checkInput_01" id="checkInput_01">
<option value="Female">Female</option>
<option value="Male">Male</option>
</select>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Birthday:</label>
<input
type="date"
class="form-control"
name="txtInput_04"
id="txtInput_04"
/>
</div>
</div>
</div>
<div>
<h3>Education & Employment::</h3>
<div class="inner-container">
<div class="formbuilder-select form-group">
<label class="formbuilder-select-label">Education Level:</label>
<select
class="form-control"
name="selectInput_01"
id="selectInput_01"
>
<option value="High School Completed">
High School Completed
</option>
<option value="High School Not Completed">
High School Not Completed
</option>
<option value="College Completed">College Completed</option>
<option value="University Completed">
University Completed
</option>
</select>
</div>
<div class="formbuilder-select form-group">
<label class="formbuilder-select-label"
>Current Employment Status:</label
>
<select
class="form-control"
name="selectInput_02"
id="selectInput_02"
>
<option value="Self Employed">Self Employed</option>
<option value="Employed Full Time">Employed Full Time</option>
<option value="Unemployed">Unemployed</option>
</select>
</div>
</div>
</div>
<div>
<h3>Additional Info::</h3>
<div class="additional-check">
<input type="checkbox" id="checkInput_02" name="checkInput_02" />
<label for="admin">Do Not Call</label>
</div>
<div class="additional-check">
<input type="checkbox" id="checkInput_03" name="checkInput_03" />
<label for="bank">Do Not Contact</label>
</div>
<div class="additional-check">
<input type="checkbox" id="checkInput_04" name="checkInput_04" />
<label for="business">Newsletter</label>
</div>
<div class="additional-check">
<input type="checkbox" id="txtInput_07" name="txtInput_07" />
<label for="business">No Email</label>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Type of Business:</label>
<input
type="text"
class="form-control"
name="txtInput_08"
id="txtInput_08"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Location:</label>
<input
type="text"
class="form-control"
name="txtInput_09"
id="txtInput_09"
/>
</div>
<br/>
</div>
<div class="form-group files">
<label>Attach Document:</label><br />
<input type="file" class="form-control" name="fileInput_02" id="fileInput_02">
<br/><br/>
</div>
<div class="formbuilder-button form-group">
<input
type="submit"
value="Submit"
class="btn-success btn"
name="button-1676508942222"
access="false"
id="button-1676508942222"
/>
</div>
</div>
<script>
// Description logic
// =========================================
$("#txtInput_01").on('keyup change', function() {
$("#txtAreaInput_03").html($(this).val());
$("#lk_REF_formName").val($(this).val()); // Form link
});
// create customer
// =======================================
$('form').submit(function(event) {
$.ajax({
url: '../../customer/Create/',
type: "POST",
data: $(this).serialize(),
success: function () {
}
});
});
</script>Events Forms
ver: 2025-07-25 00:00:00.000
<input type="hidden" name="txtInput_13" value="#ff0066" />
<input type="hidden" name="lk_REF_formID" id="lk_REF_formID" value="" />
<input type="hidden" name="lk_REF_formName" id="lk_REF_formName" value="" />
<div class="vc-form">
<div class="">
<h1>Event Form</h1>
</div>
<div>
<h3>Event Details::</h3>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Event Name:</label>
<input
type="text"
placeholder="e.g. Business Workshop"
class="form-control"
name="txtInput_01"
id="txtInput_01"
required
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Event Type:</label>
<input
type="text"
placeholder="e.g. Workshop"
class="form-control"
name="txtInput_02"
id="txtInput_02"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Description:</label>
<textarea
class="form-control"
name="txtAreaInput_01"
id="txtAreaInput_01"
placeholder="Enter event description"
></textarea>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Address:</label>
<input
type="text"
placeholder="e.g. 123 Main St"
class="form-control"
name="txtInput_03"
id="txtInput_03"
/>
</div>
<div class="inner-container">
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Date:</label>
<input
type="date"
class="form-control"
name="txtInput_04"
id="txtInput_04"
required
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Start Time:</label>
<input
type="datetime-local"
class="form-control"
name="txtInput_05"
id="txtInput_05"
required
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">End Time:</label>
<input
type="datetime-local"
class="form-control"
name="txtInput_06"
id="txtInput_06"
required
/>
</div>
</div>
<div class="inner-container">
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Capacity:</label>
<input
type="number"
placeholder="e.g. 50"
class="form-control"
name="txtInput_07"
id="txtInput_07"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Participant Fee:</label>
<input
type="number"
placeholder="e.g. 20"
class="form-control"
name="txtInput_08"
id="txtInput_08"
/>
</div>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Facilitator:</label>
<input
type="text"
placeholder="e.g. John Doe"
class="form-control"
name="txtInput_09"
id="txtInput_09"
/>
</div>
<div class="inner-container">
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Contact Email:</label>
<input
type="email"
placeholder="e.g. contact@example.com"
class="form-control"
name="txtInput_10"
id="txtInput_10"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Contact Phone:</label>
<input
type="tel"
placeholder="e.g. 123-456-7890"
class="form-control"
name="txtInput_11"
id="txtInput_11"
/>
</div>
</div>
</div>
<div>
<h3>Additional Info::</h3>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Event Duration (hrs):</label>
<input
type="number"
placeholder="e.g. 3"
class="form-control"
name="txtInput_12"
id="txtInput_12"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Number of Sessions:</label>
<input
type="number"
placeholder="e.g. 5"
class="form-control"
name="txtInput_14"
id="txtInput_14"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label"
>Number of People Attended:</label
>
<input
type="number"
placeholder="e.g. 100"
class="form-control"
name="txtInput_15"
id="txtInput_15"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label"
>Participant Drop-out Rate (%):</label
>
<input
type="number"
step="0.01"
placeholder="e.g. 10.5"
class="form-control"
name="txtInput_16"
id="txtInput_16"
/>
</div>
<div class="formbuilder-text form-group">
<label class="formbuilder-text-label">Comments:</label>
<textarea
class="form-control"
name="txtAreaInput_02"
id="txtAreaInput_02"
placeholder="Enter any additional information here"
></textarea>
</div>
</div>
<div class="formbuilder-button form-group">
<input
type="submit"
value="Submit"
class="btn-success btn"
name="button-1676508942222"
access="false"
id="button-1676508942222"
/>
</div>
</div>
<script>
// Description logic
// =========================================
$("#txtInput_01").on('keyup change', function() {
$("#txtAreaInput_03").html($(this).val());
});
// Link logic
// ==================================
$("#formLINK").on('keyup change', function () {
$("#lk_REF_formID").val($(this).val());
var linkDropdown = $(this).children("option:selected").text();
$("#lk_REF_formName").val(linkDropdown.replace(/(.*): /,""));
});
</script>Reports
DYBT EVENTS IN {YEAR} - DYBT_eventReport_01.rdl
DYBT_eventReport_02.rdl
SELECT
txtInput_01 as ev_name,
txtInput_03 as ev_address,
txtInput_04 as ev_date,
datepart(YEAR, txtInput_04) as ev_year
FROM dbo.VCAS_REF_forms
where FK_formsId = 1021 -- Events ID
AND datepart(YEAR, txtInput_04) = @year