private string returnUpdateConsumerSQL(clsDB objDB)
{
string strSQL = "Update Consumer";
strSQL = strSQL + " Set FirstName = '" + txtFirst.Text + "'";
strSQL = strSQL + ", LastName= '" + txtLast.Text + "'";
strSQL = strSQL + ", SSN = '" + txtSSN.Text + "'";
strSQL = strSQL + ", AVR = '" + txtAVR.Text + "'";
strSQL = strSQL + ", VESID = '" + txtVesid.Text + "'";
strSQL = strSQL + ", Units = '" + txtUnits.Text + "'";
strSQL = strSQL + ", Service_ID = '" + cmbService.Text + "'";
strSQL = strSQL + ", Disability_ID = '" + objDB.returnComboBox_Key("Disability", "Description", cmbDisability.Text) + "'";
strSQL = strSQL + ", Funding_ID = '" + objDB.returnComboBox_Key("Funding", "Description", cmbFunding.Text) + "'";
clsFormat objFormat = new clsFormat();
if (dtReferral.Checked == true)
{
strSQL = strSQL + ", ReferralDate = " + objFormat.formatDate(dtReferral.Text);
}
else
{
strSQL = strSQL + ", ReferralDate = null";
}
if (dtIntake.Checked == true)
{
strSQL = strSQL + ", IntakeDate = " + objFormat.formatDate(dtIntake.Text);
}
else
{
strSQL = strSQL + ", IntakeDate = null";
}
strSQL = strSQL + " Where Consumer.ID = " + ID;
strSQL = strSQL.Replace("' - -'", "null");
strSQL = strSQL.Replace("''", "null");
return(strSQL);
}
private string returnAddConsumerSQL(clsDB objDB)
{
string SQL = "Insert into Consumer(SSN,AVR, VESID, FirstName, LastName, Disability_ID, Service_ID,Units, Funding_ID, ReferralDate,IntakeDate)";
SQL = SQL + " Values(";
SQL = SQL + "'" + txtSSN.Text + "'";
SQL = SQL + ",'" + txtAVR.Text + "'";
SQL = SQL + ",'" + txtVesid.Text + "'";
SQL = SQL + ",'" + txtFirst.Text + "'";
SQL = SQL + ",'" + txtLast.Text + "'";
SQL = SQL + ",'" + objDB.returnComboBox_Key("Disability", "Description", cmbDisability.Text) + "'";
SQL = SQL + ",'" + cmbService.Text + "'";
SQL = SQL + ",'" + txtUnits.Text + "'";
SQL = SQL + ",'" + objDB.returnComboBox_Key("Funding", "Description", cmbFunding.Text) + "'";
clsFormat objFormat = new clsFormat();
if (dtReferral.Checked == true)
{
SQL = SQL + ", " + objFormat.formatDate(dtReferral.Text);
}
else
{
SQL = SQL + ", null";
}
if (dtIntake.Checked == true)
{
SQL = SQL + ", " + objFormat.formatDate(dtIntake.Text);
}
else
{
SQL = SQL + ", null";
}
SQL = SQL + ")";
return(SQL);
}
