public bool TableQuestionnaireDeleteAllRecords(ref string sRtnMsg)
{
string sSQL;
LocalDB DB = new LocalDB();
if (DB.TableExists(sDocQuestionnaireTableName))
{
sSQL = "delete from " + sDocQuestionnaireTableName;
return DB.ExecuteSQL(sSQL, ref sRtnMsg);
}
else
{
return true;
}
}
public bool TableITPDocumentSectionDeleteAllRecords(ref string sRtnMsg)
{
string sSQL;
LocalDB DB = new LocalDB();
if (DB.TableExists(sITPDocumentSectionTableName))
{
sSQL = "delete from " + sITPDocumentSectionTableName;
return DB.ExecuteSQL(sSQL, ref sRtnMsg);
}
else
{
return true;
}
}
public bool TableHeaderDeleteAllRecords(string sId, ref string sRtnMsg)
{
string sSQL;
LocalDB DB = new LocalDB();
if (DB.TableExists(sDocHeaderTableName))
{
sSQL = "delete from " + sDocHeaderTableName + " where ID = '" + sId + "'";
return DB.ExecuteSQL(sSQL, ref sRtnMsg);
}
else
{
return true;
}
}
public bool ITPProjectSectionDeleteAllSection10Items(string sId, ref string sRtnMsg)
{
string sSQL;
LocalDB DB = new LocalDB();
if (DB.TableExists(sITPSection10TableName))
{
sSQL = "delete from " + sITPSection10TableName + " where ID = '" + sId + "'";
return DB.ExecuteSQL(sSQL, ref sRtnMsg);
}
else
{
return true;
}
}