/// <summary>
/// Execute the SQL statement returns the result to the DataSet
/// </summary>
/// <param Name="strSQL"> </ param>
/// <returns> DataSet </ returns>
public DataSet ReturnDataSet(string strSQL)
{
DataSet _DataSet = null;
try
{
_TrackerDbConn.Open();
_DataSet = new DataSet();
OleDbDataAdapter _OleDbDA = new OleDbDataAdapter(strSQL, _TrackerDbConn);
_OleDbDA.Fill(_DataSet, "objDataSet");
}
catch (OleDbException _ex)
{
// Handle exception.
TrackerTools _Tools = new TrackerTools();
_Tools.SetTrackerSessionErrorString(_ex.Message);
_DataSet.Dispose();
throw;
}
finally
{
_TrackerDbConn.Close();
}
return(_DataSet);
}
protected void btnForceNext_Click(object sender, EventArgs e)
{
QOnT.classes.TrackerTools _TTools = new QOnT.classes.TrackerTools();
DateTime _dt = _TTools.GetClosestNextRoastDate(DateTime.Now.AddDays(14)); // add a fortnight;
ClientUsageTbl _ClientUsage = new ClientUsageTbl();
_ClientUsage.ForceNextCoffeeDate(_dt.AddDays(3), Convert.ToInt64(CompanyIDLabel.Text));
CustomersTbl _CustomerTbl = new CustomersTbl();
_CustomerTbl.IncrementReminderCount(Convert.ToInt64(CompanyIDLabel.Text));
// rebind the data for this client
// dsCustomerUsage.Update();
dgCustomerUsage.DataBind();
string _ScriptToRun = "showMessage('" + String.Format("{0} force to skip a week of prediction", CompanyNameTextBox.Text) + "');";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "CustomerInserted", _ScriptToRun, true);
}
public OleDbDataReader ReturnDataReader(string strSQL)
{
OleDbDataReader _OleDataReader = null;
try
{
_TrackerDbConn.Open();
OleDbCommand _cmd = new OleDbCommand(strSQL, TrackerDbConn);
_OleDataReader = _cmd.ExecuteReader();
}
catch (OleDbException _ex)
{
// Handle exception.
TrackerTools _Tools = new TrackerTools();
_Tools.SetTrackerSessionErrorString(_ex.Message);
_OleDataReader.Dispose();
}
finally
{
///
}
return(_OleDataReader);
}
