private void fillGridAdmin()
{
string SQL = AdminSQL();
clsDB objDB = new clsDB(resPinnacle.liveDB);
SQLiteDataReader objReader = objDB.returnDataReader(SQL);
clsGridUtils objGrid = new clsGridUtils();
objGrid.fillGrid(objReader, 0, ref grdAdministrative, this.CreateGraphics());
}
private void loadSelectedConsumer()
{
string strSQL = selectedConsumer_SQL();
clsDB objDB = new clsDB(strDB);
clsGridUtils objGrid = new clsGridUtils();
SQLiteDataReader objReader = objDB.returnDataReader(strSQL);
ConsumerID = objReader[0].ToString();
Consumer = objReader[2].ToString();
objGrid.fillGrid(objReader, 3, ref grdConsumers, this.CreateGraphics());
}
private void fillGrdConsumers()
{
clsDB objDB = new clsDB(strDB);
clsGridUtils objGrid = new clsGridUtils();
//SQLiteDataReader objReader = objDB.returnConsumers("Consumers", cmbStaff.Text, blActiveOnly);
string SQL = returnAllActivity_SQL();
SQLiteDataReader objReader = objDB.returnDataReader(SQL);
objGrid.fillGrid(objReader, 1, ref grdConsumers, this.CreateGraphics());
objReader.Close();
returnHours();
}
private void fillGridVoucher()
{
string SQL = "Select id";
SQL = SQL + ", strftime('%m/%d/%Y',Start) as Start";
SQL = SQL + ", strftime('%m/%d/%Y',End) as End ";
SQL = SQL + " From Voucher";
SQL = SQL + " Where Consumer_ID = " + ID;
clsDB objDB = new clsDB(resPinnacle.liveDB);
SQLiteDataReader objReader = objDB.returnDataReader(SQL);
clsGridUtils objGrid = new clsGridUtils();
objGrid.fillGrid(objReader, 1, ref grdVouchers, this.CreateGraphics());
}
private void DeleteReview(string strConsumer, string strReviewID)
{
clsDB objDB = new clsDB(resPinnacle.liveDB);
string SQL = "Delete from Review where ID = " + strReviewID;
bool blPass = objDB.executeNonQuery(SQL);
if (blPass == false)
{
MessageBox.Show("Your review was not deleted. If problem persists please contact IT.");
}
SQL = selectedConsumer_SQL();
SQLiteDataReader objReader = objDB.returnDataReader(SQL);
clsGridUtils objGrid = new clsGridUtils();
objGrid.fillGrid(objReader, 3, ref grdConsumers, this.CreateGraphics());
}
private void loadSelectedConsumer()
{
string strSQL = selectedConsumer_SQL();
clsDB objDB = new clsDB(strDB);
clsGridUtils objGrid = new clsGridUtils();
SQLiteDataReader objReader = objDB.returnDataReader(strSQL);
if (objReader.HasRows == true)
{
ConsumerID = objReader[0].ToString();
objGrid.fillGrid(objReader, 2, ref grdActivity, this.CreateGraphics());
}
else
{
MessageBox.Show("The user has no meetings currently in the system");
}
blAllConsumers = false;
}
private void fillGrid_AllActivity()
{
string SQL = returnAllActivity_SQL();
clsDB objDB = new clsDB(strDB);
SQLiteDataReader objReader = objDB.returnDataReader(SQL);
clsGridUtils objGrid = new clsGridUtils();
bool Loaded = false;
if (objReader.HasRows == true)
{
objGrid.fillGrid(objReader, 1, ref grdAllActivity, this.CreateGraphics());
returnHours();
}
else
{
grdAllActivity.Rows.Clear();
lblHours.Text = "Hours: 0";
}
}