private void ucRentalRequestStatusChange_Load(object sender, EventArgs e)
{
DevXMgr.FormInit(this);
string sSelect = "select count(*) from alert_rental_setup";
if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
{
string sInsert = "insert into alert_rental_setup (RentalStartEnabled,RentalStartPreEnabled,RentalEndEnabled,RentalEndPreEnabled,RentalStatus_Entered,RentalStatus_Active,RentalStatus_Complete,RentalStatus_Canceled)" +
"values (0,0,0,0,0,0,0,0)";
Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
}
sSelect = "select isnull(RentalStatus_Entered,0) from alert_rental_setup";
ceEntered.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
sSelect = "select isnull(RentalStatus_Active,0) from alert_rental_setup";
ceActive.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
sSelect = "select isnull(RentalStatus_Complete,0) from alert_rental_setup";
ceComplete.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
sSelect = "select isnull(RentalStatus_Canceled,0) from alert_rental_setup";
ceCanceled.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
}
private void ucLotHold_Load(object sender, EventArgs e)
{
DevXMgr.FormInit(this);
TR_Conn.ConnectionString = Connection.TRConnection;
daTolerance.Fill(dsTolerance);
string sSelect = "select count(*) from alert_lot_hold_setup";
if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
{
string sInsert = "insert into alert_lot_hold_setup (id, OnHold_On, PreExpiry_On, Expiry_On, reply_tolerance) values (1, 'F', 'F', 'F', 1)";
Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
}
sSelect = "select isnull(OnHold_On,'F'), isnull(PreExpiry_On,'F'), isnull(Expiry_On,'F'), isnull(reply_tolerance,1) from alert_lot_hold_setup";
DataTable dt = Connection.SQLExecutor.ExecuteDataAdapter(sSelect, Connection.TRConnection);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
if (dr != null)
{
chkOnHold.EditValue = dr[0];
chkPreExpire.EditValue = dr[1];
chkExpiry.EditValue = dr[2];
txtTolerance.EditValue = dr[3];
}
}
}
}
private void ucCollectionReminders_Load(object sender, EventArgs e)
{
DevXMgr.FormInit(this);
TR_Conn.ConnectionString = Connection.TRConnection;
string sSelect = "select count(*) from alert_land_reminder_setup where AlertID=" + AlertPointID;
if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
{
string sInsert = "insert into alert_land_reminder_setup (AlertID, X_Days) values (" + AlertPointID + ", 0)";
Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
}
sSelect = "select isnull(X_Days,0) from alert_land_reminder_setup where AlertID=" + AlertPointID;
txtDays.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
LoadCommPurpose();
LoadDocMergeFunc();
daComPur.SelectCommand.Parameters["@AlertID"].Value = AlertPointID;
daComPur.Fill(dsComPur1);
daDocMerge.SelectCommand.Parameters["@AlertID"].Value = AlertPointID;
daDocMerge.Fill(dsDocMerge1);
labelControl1.Focus();
}
private void ucEmpCertificateExpiry_Load(object sender, EventArgs e)
{
DevXMgr.FormInit(this);
string sSelect = "select isnull(DaysPrior,0) from hr_cntl";
txtDays.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
labelControl1.Focus();
}
private void ucFinancingPaymentDue_Load(object sender, EventArgs e)
{
DevXMgr.FormInit(this);
string sSelect = "select isnull(FinancingPastDueDays,0) from Alert_Properties_Setup";
isLoading = true;
txtDays.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
isLoading = false;
labelControl1.Focus();
}
private void ucLatePaymentReminder_Load(object sender, EventArgs e)
{
LoadUserControls();
DevXMgr.FormInit(this);
string sSelect = "select count(*) from alert_land_reminder_setup where AlertID=" + AlertPointID;
if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
{
string sInsert = "insert into alert_land_reminder_setup (AlertID, X_Days, Recurrence_Days, Recurrence_Months) values (" + AlertPointID + ", 0, 0, 0)";
Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
}
LoadAlertSetup();
}
private void ucProbationaryBuildersReminder_Load(object sender, EventArgs e)
{
LoadUserControls();
DevXMgr.FormInit(this);
string sSelect = "select count(*) from alert_land_reminder_setup where AlertID=" + AlertPointID;
if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
{
string sInsert = "insert into alert_land_reminder_setup (AlertID, X_Days) values (" + AlertPointID + ", 0)";
Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
}
sSelect = "select isnull(X_Days,0) from alert_land_reminder_setup where AlertID=" + AlertPointID;
txtDays.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
labelControl1.Focus();
}
private void ucHomeOwner_Load(object sender, EventArgs e)
{
DevXMgr.FormInit(this);
string sSelect = "select count(*) from alert_lot_hold_setup";
if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
{
string sInsert = "insert into alert_lot_hold_setup (id, OnHold_On, PreExpiry_On, Expiry_On, homeowner_confirmed_days, DownPayment_Due_Days) values (1, 'F', 'F', 'F', 0, 0)";
Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
}
sSelect = "select isnull(homeowner_confirmed_days,0) from alert_lot_hold_setup";
txtDays.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
labelControl1.Focus();
}
private void ucRentalStartNotification_Load(object sender, EventArgs e)
{
DevXMgr.FormInit(this);
string sSelect = "select count(*) from alert_rental_setup";
if (Convert.ToInt32(Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection)) == 0)
{
string sInsert = "insert into alert_rental_setup (RentalStartEnabled,RentalStartPreEnabled,RentalEndEnabled,RentalEndPreEnabled,RentalStatus_Entered,RentalStatus_Active,RentalStatus_Complete,RentalStatus_Canceled)" +
"values (0,0,0,0,0,0,0,0)";
Connection.SQLExecutor.ExecuteNonQuery(sInsert, Connection.TRConnection);
}
sSelect = "select isnull(RentalStartEnabled,0) from alert_rental_setup";
ceRentalStart.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
sSelect = "select isnull(RentalStartPreEnabled,0) from alert_rental_setup";
ceRentalPreStart.EditValue = Connection.SQLExecutor.ExecuteScalar(sSelect, Connection.TRConnection);
sqlTRConnection.ConnectionString = Connection.TRConnection;
daRentalStartPreAlerts.Fill(dsRentalStartPreAlerts1);
}
private void ucPayoutExtensionReminder_Load(object sender, EventArgs e)
{
LoadUserControls();
DevXMgr.FormInit(this);
}
private void ucPastDuePaymentReminder_Load(object sender, EventArgs e)
{
LoadUserControls();
DevXMgr.FormInit(this);
}