public void API05_READ_SETTINGS()
{
string sSQL;
DataSet ds1;
sSQL = "SELECT * FROM [W_SystemSettings] ";
ds1 = m.SQLRunQuery(sSQL, c.DB.WhosIn);
a.AppendTableToDataset(ds1);
}
private void GetTeeTimesByGroup(string sGroupGUID, bool bShowAllTeeTimes)
{
string sSQL;
DataSet ds1;
sSQL = "SELECT * ";
sSQL = sSQL + " FROM [W_Groups] ";
sSQL = sSQL + " WHERE [GroupGUID] = " + m.InQuote(sGroupGUID);
ds1 = m.SQLRunQuery(sSQL, c.DB.WhosIn);
if (!m.EmptyTable(ds1))
{
if (m.GetFieldBol("GroupShowAllGroups", ds1))
{
sGroupGUID = "";
}
}
if (bShowAllTeeTimes)
{
sSQL = "SELECT TOP 100 t.*, c.* ";
sSQL = sSQL + " FROM [W_TeeTimes] t ";
sSQL = sSQL + " LEFT JOIN [W_Groups] c ";
sSQL = sSQL + " ON c.[GroupGUID] = t.[GroupGUID] ";
sSQL = sSQL + " Order by t.TeeTimeDate, t.TeeTimeTime ";
}
else
{
if (m.IsEmpty(sGroupGUID)) // show all groups if sGroupGUID is empty.
{
sSQL = "SELECT t.*, c.* ";
sSQL = sSQL + " FROM [W_TeeTimes] t ";
sSQL = sSQL + " LEFT JOIN [W_Groups] c ";
sSQL = sSQL + " ON c.[GroupGUID] = t.[GroupGUID] ";
sSQL = sSQL + " WHERE ( TeeTimeDate >= Convert(date, getdate()) )";
sSQL = sSQL + " AND (c.[GroupActive] = 1 )";
sSQL = sSQL + " AND (t.[IsDeleted] = 0 )";
sSQL = sSQL + " Order by t.TeeTimeDate, t.TeeTimeTime ";
}
else
{
sSQL = "SELECT t.*, c.* ";
sSQL = sSQL + " FROM [W_TeeTimes] t ";
sSQL = sSQL + " LEFT JOIN [W_Groups] c ";
sSQL = sSQL + " ON c.[GroupGUID] = t.[GroupGUID] ";
sSQL = sSQL + " WHERE ( TeeTimeDate >= Convert(date, getdate()) )";
sSQL = sSQL + " AND c.[GroupGUID] = " + m.InQuote(sGroupGUID);
sSQL = sSQL + " AND (t.[IsDeleted] = 0 )";
sSQL = sSQL + " Order by t.TeeTimeDate, t.TeeTimeTime ";
}
}
ds1 = m.SQLRunQuery(sSQL, c.DB.WhosIn);
a.AppendTableToDataset(ds1);
}
private void GetGroups(bool bAll)
{
string sSQL;
DataSet ds1;
sSQL = "SELECT * FROM [W_Groups] ";
if (!bAll)
{
sSQL = sSQL + " WHERE [GroupActive] = 1";
}
sSQL = sSQL + " ORDER BY [GroupName]";
ds1 = m.SQLRunQuery(sSQL, c.DB.WhosIn);
a.AppendTableToDataset(ds1);
}
private void SetResultCode(string sResultCode, string sResultMsg)
{
DataTable dt1;
dt1 = m.CreateReturnDT(sResultCode, sResultMsg);
a.AppendTableToDataset(dt1);
}
public void API06_GET_MESSAGES_LIST()
{
string sTTGUID;
string[] aFields = m.parseToArrayByDelimter(a.InputParameters, c.MULTI_FIELD_DELIMETER);
aFields = m.NoNullArray(aFields, 1);
sTTGUID = aFields[0];
string sSQL;
DataSet ds1;
sSQL = "SELECT * FROM [W_TeeTimeChat] ";
sSQL = sSQL + " WHERE [TeeTimeGUID] = " + m.InQuote(sTTGUID);
sSQL = sSQL + " ORDER BY DateTimeEntered DESC";
ds1 = m.SQLRunQuery(sSQL, c.DB.WhosIn);
a.AppendTableToDataset(ds1);
}
public void API07_GET_AUDITLOG()
{
string sSQL;
DataSet ds1;
string ttGUID;
string[] aFields = m.parseToArrayByDelimter(a.InputParameters, c.MULTI_FIELD_DELIMETER);
aFields = m.NoNullArray(aFields, 1);
ttGUID = aFields[0];
sSQL = "SELECT * FROM [W_TeeTimeLog] ";
sSQL = sSQL + " WHERE [TTGUID] = " + m.InQuote(ttGUID);
sSQL = sSQL + " ORDER BY LogDateTime";
ds1 = m.SQLRunQuery(sSQL, c.DB.WhosIn);
a.AppendTableToDataset(ds1);
}
