public bool editHoliday(Holiday edit)
{
bool result = false;
// Command
string query = String.Format(@"UPDATE gfrc_volunteer_holiday SET gvh_start = {0}, gvh_end = {1}, date_modified = {2}, modified_by = {3} " +
"WHERE gvo_id = {4}", edit.Start, edit.End, edit.DateModified, edit.ModifiedBy, edit.gvoID);
int affected = 0;
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
affected = cmd.ExecuteNonQuery();
}
}
catch (Exception e)
{
result = false;
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
// checks if rows were affected by the insert query
if (affected > 0)
{
result = true;
}
return result;
}
public Vector<Holiday> listHolidays(uint gvoid)
{
// Declarations
Vector<Holiday> quals = new Vector<Holiday>();
uint gvhid = 0, modifiedby = 0;
DateTime datemodified = new DateTime(1901, 1, 1), start = new DateTime(1901, 1, 1), end = new DateTime(1901, 1, 1);
Holiday input = new Holiday();
// Declarations
// Command
string query = string.Format("SELECT gvh_id, gvh_start, gvh_end, date_modified, modified_by " +
"FROM gfrc_volunteer_holiday WHERE gvo_id = {0}", gvoid);
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
if (UInt32.TryParse(rdr.GetValue(0).ToString(), out gvhid))
{
start = rdr.GetDateTime(1);
if (!DateTime.TryParse(rdr.GetValue(2).ToString(), out end))
end = new DateTime(1901, 1, 1);
if (!DateTime.TryParse(rdr.GetValue(14).ToString(), out datemodified))
datemodified = new DateTime(1901, 1, 1);
if (!UInt32.TryParse(rdr.GetValue(15).ToString(), out modifiedby))
modifiedby = 0;
input = new Holiday(gvhid, gvoid, start, end, datemodified, modifiedby);
quals.Add(input);
}
}
}
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return quals;
}
public bool createHoliday(Holiday create)
{
bool result = false;
// Command
string query = String.Format(@"INSERT INTO gfrc_volunteer_holiday (gvo_id, gvh_start, gvh_end) " +
"VALUES({0}, {1}, {2})",
create.gvoID, create.Start, create.End);
int affected = 0;
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
affected = cmd.ExecuteNonQuery();
// checks if rows were affected by the insert query
if (affected > 0)
{
result = true;
query = String.Format(@"SELECT gvh_id FROM gfrc_volunteer_holiday WHERE gvh_id = (SELECT MAX(gvh_id) FROM gfrc_volunteer_holiday)");
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
// Set gloID
_gvhID = Convert.ToUInt32(rdr.GetInt32(0));
}
}
}
}
catch (Exception e)
{
result = false;
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return result;
}
