public Form1()
{
InitializeComponent();
PC.list = new List<PC>();
PC.total = new List<PC>();
data.Columns.Add("Id", "Id");
data.Columns.Add("PC", "PC");
data.Columns.Add("Inicio", "Inicio");
data.Columns.Add("Tiempo", "Tiempo");
data.Columns.Add("Total", "Total");
data.Columns[3].Width = 130;
data.Columns[3].Width = 130;
r = MSAConnection.read("select * from item");
while (r.Read())
{
String d = "";
PC p = new PC();
p.id = r.GetInt32(0);
p.precio = r.GetInt32(2);
if (!r.IsDBNull(3))
{
//d = r.GetDateTime(3).ToString();
DateTime x = r.GetDateTime(3);
d = x.Hour + ":" + x.Minute + ":" + x.Second;
p.inicio = r.GetDateTime(3);
PC.list.Add(p);
}
PC.total.Add(p);
data.Rows.Add(r.GetInt32(0), r.GetString(1), d);
}
// MessageBox.Show(PC.total.Count + "");
thetimer.Start();
}
protected override TreeNode AddNodeItem(TreeNode aTn, OleDbDataReader aReader, ref int aSI)
{
/// В pSQLString должен быть определен примерно такой select:
/// ...
/// SELECT
/// refCode, refBName, 1, ...
/// FROM
/// rbRef
/// ...
TreeNode ntn = new TreeNode(aReader.GetString(1));
PCTVItemData tid = new PCTVItemData();
ntn.Tag = tid;
tid.pPC.code = aReader.GetInt32(0);
/// Added M.Tor 25.06.2008:
tid.pText = aReader.GetString(1);
if (aReader.GetInt32(2) > 0)
ntn.Nodes.Add(new TreeNode());
if (aTn == null)
{
Nodes.Add(ntn);
tid.pPath = tid.pCode.ToString();
}
else
{
aTn.Nodes.Add(ntn);
tid.pPath = ((PCTVItemData)aTn.Tag).pPath + pPathDelim + tid.pCode;
}
aSI = 3;
return ntn;
}
public static FaqInfo CopyFaqQuestionsToBO(OleDbDataReader rdr)
{
FaqInfo faqquestion = new FaqInfo
{
Id = rdr.GetInt32(0),
Link = rdr.SafeGetString(1),
LinkTitle = rdr.SafeGetString(2),
LinkBody = rdr.SafeGetString(3),
CatId = rdr.GetInt32(4),
Language = rdr.SafeGetString(5),
Order = rdr.GetInt32(6)
};
return faqquestion;
}
public static CategoryInfo CopyCategoryToBO(OleDbDataReader rdr)
{
//CAT_ID, CAT_NAME, CAT_STATUS, CAT_MODERATION, CAT_SUBSCRIPTION, CAT_ORDER
CategoryInfo category = new CategoryInfo
{
Id = rdr.GetInt32(0),
Name = rdr.SafeGetString(1),
Status = rdr.GetInt16(2),
ModerationLevel = rdr.SafeGetInt32(3),
SubscriptionLevel = rdr.SafeGetInt32(4),
Order = rdr.GetInt32(5)
};
return category;
}
public Advertisement(OleDbDataReader reader)
{
this.StrId = reader.GetString(0);
if (!reader.IsDBNull(1))
this.IntType = reader.GetInt32(1);
else
this.IntType = 3;
if (!reader.IsDBNull(2))
this.StrContent = reader.GetString(2);
else
this.StrContent = "";
}
// Constructor for searched volunteer holiday
public Holiday(uint gvhid)
{
// Declarations
uint gvoid = 0, modifiedby = 0;
DateTime datemodified = new DateTime(1901, 1, 1), start = new DateTime(1901, 1, 1), end = new DateTime(1901, 1, 1);
// Command
string query = string.Format("SELECT gvo_id, gvh_start, gvh_end, date_modified, modified_by " +
"FROM gfrc_volunteer_holiday WHERE gvh_id = {0}", gvhid);
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
gvoid = Convert.ToUInt32(rdr.GetInt32(0));
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;
}
}
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
_gvhID = gvhid;
_gvoID = gvoid;
_Start = start;
_End = end;
_DateModified = datemodified;
_ModifiedBy = modifiedby;
}
public static void Load(this DataObject dataObj, OleDbDataReader reader)
{
try
{
foreach (ColumnDefinition columnDef in dataObj.ColumnDefs())
{
if (reader.GetValue(columnDef.ColumnIndex) != DBNull.Value)
{
switch (columnDef.ColumnFieldType)
{
case ColumnDefinition.FieldType.String:
dataObj.GetColumnValues()[columnDef.ColumnIndex] = reader.GetString(columnDef.ColumnIndex);
break;
case ColumnDefinition.FieldType.Int32:
dataObj.GetColumnValues()[columnDef.ColumnIndex] = reader.GetInt32(columnDef.ColumnIndex);
break;
case ColumnDefinition.FieldType.Boolean:
dataObj.GetColumnValues()[columnDef.ColumnIndex] = reader.GetBoolean(columnDef.ColumnIndex);
break;
}
}
else //default values for nulls
{
switch (columnDef.ColumnFieldType)
{
case ColumnDefinition.FieldType.String:
dataObj.GetColumnValues()[columnDef.ColumnIndex] = string.Empty;
break;
case ColumnDefinition.FieldType.Int32:
dataObj.GetColumnValues()[columnDef.ColumnIndex] = 0;
break;
case ColumnDefinition.FieldType.Boolean:
dataObj.GetColumnValues()[columnDef.ColumnIndex] = false;
break;
}
}
}
}
catch (Exception e)
{
//TODO: what to do here?
}
}
public Kontaktdaten()
{
InitializeComponent();
try
{
dBVerbindung = new OleDbConnection(verbindungsstring);
dBVerbindung.Open();
offen = true;
befehl = dBVerbindung.CreateCommand();
//Übersicht (DataGHridView) anzeigen
befehl.CommandText = "select * from Kontakte;";
datenleser = befehl.ExecuteReader();
int row = 0;
while (datenleser.Read())
{
//leere zeile hinzufügen
string[] row_init = { "", "", "", "", "" };
dataGridViewKontakte.Rows.Add(row_init);
//GridView füllen
dataGridViewKontakte.Rows[row].Cells[0].Value = datenleser.GetInt32(0).ToString();
dataGridViewKontakte.Rows[row].Cells[1].Value = datenleser.GetString(1);
dataGridViewKontakte.Rows[row].Cells[2].Value = datenleser.GetString(2);
dataGridViewKontakte.Rows[row].Cells[3].Value = datenleser.GetString(3);
dataGridViewKontakte.Rows[row].Cells[4].Value = datenleser.GetString(4);
dataGridViewKontakte.Rows[row].Cells[5].Value = datenleser.GetString(5);
row = row + 1;
}
}
catch (Exception ausnahme)
{
MessageBox.Show("Datenbankfehler: " + ausnahme.Message);
}
finally
{
if (offen == true) dBVerbindung.Close();
}
}
public static ForumInfo CopyForumToBO(OleDbDataReader rdr)
{
//"F.FORUM_ID,F.CAT_ID,F.F_STATUS,F.F_SUBJECT,F.F_URL,F.F_TOPICS" +
//",F.F_COUNT,F.F_LAST_POST,F.F_PRIVATEFORUMS,F.F_TYPE,F.F_LAST_POST_AUTHOR,F.F_A_TOPICS,F.F_A_COUNT,F.F_MODERATION" +
//",F.F_SUBSCRIPTION,F.F_ORDER, F.F_COUNT_M_POSTS,F.F_LAST_POST_TOPIC_ID,F.F_LAST_POST_REPLY_ID,F.F_POLLS,F.F_DESCRIPTION" +
//",F.F_L_ARCHIVE,F.F_ARCHIVE_SCHED,T.T_SUBJECT,M.M_NAME ";
ForumInfo forum = new ForumInfo
{
Id = rdr.GetInt32(0),
CatId = rdr.GetInt32(1),
Status = rdr.GetInt16(2),
Subject = rdr.SafeGetString(3),
Url = rdr.SafeGetString(4),
TopicCount = rdr.GetInt32(5),
PostCount = rdr.GetInt32(6),
LastPostDate = rdr.GetSnitzDate(7),
AuthType = rdr.SafeGetInt32(8),
Type = rdr.GetInt16(9),
LastPostAuthorId = rdr.SafeGetInt32(10),
ArchivedTopicCount = rdr.SafeGetInt32(11),
ArchivedPostCount = rdr.SafeGetInt32(12),
ModerationLevel = rdr.SafeGetInt32(13),
SubscriptionLevel = rdr.SafeGetInt32(14),
Order = rdr.GetInt32(15),
UpdatePostCount = rdr.GetInt16(16) == 1,
LastPostTopicId = rdr.SafeGetInt32(17),
LastPostReplyId = rdr.SafeGetInt32(18),
AllowPolls = rdr.GetInt32(19) == 1,
Description = rdr.SafeGetString(20),
LastArchived = rdr.GetSnitzDate(21),
ArchiveFrequency = rdr.SafeGetInt32(22),
LastPostSubject = rdr.SafeGetString(23),
LastPostAuthorName = rdr.SafeGetString(24)
};
return forum;
}
internal static List<Order> getOrderList()
{
List<Order> ol = new List<Order>();
try
{
//IFNULL(SUM(score),'N')
cmd = new OleDbCommand("SELECT Orders.UserID, Orders.FoodID, Orders.Quantity, Orders.TotalExpense, Orders.OrderDate, Orders.ReportID, Orders.Status, FoodList.FoodName, Users.Username, Orders.ID FROM (Users INNER JOIN Orders ON Users.ID = Orders.UserID) INNER JOIN FoodList ON Orders.FoodID = FoodList.ID ORDER BY Orders.OrderDate;", conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
Order o = new Order(reader.GetInt32(0),
reader.GetInt32(1),
reader.GetInt32(2),
reader.GetInt32(3),
reader.GetDateTime(4), reader.GetInt32(5), reader.GetString(6), reader.GetString(7), reader.GetString(8), reader.GetInt32(9));
ol.Add(o);
}
reader.Close();
}
catch (Exception ex)
{
//runs perfectly fine but theres an ERROR. I DONT KNOW WHY --> line 295 (reader.GetInt32(0)) OH NO!
MessageBox.Show("getOrderList() error: " + ex.ToString());
}
return ol;
}
internal static List<User> GetUsers()
{
List<User> usersList = new List<User>();
try
{
cmd = new OleDbCommand("SELECT * FROM Users ORDER BY ID;", conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
User u = new User(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4),
reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetDateTime(8), reader.GetInt32(9), reader.GetInt32(10));
usersList.Add(u);
}
reader.Close();
return usersList;
}
catch (Exception e)
{
MessageBox.Show("Error getting usersList: " + e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}
internal static List<Admin> GetAdmins()
{
List<Admin> adminList = new List<Admin>();
try
{
cmd = new OleDbCommand("SELECT * FROM Admins ORDER BY ID", conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
Admin a = new Admin(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3),
reader.GetString(4), reader.GetString(5), reader.GetString(6), reader.GetString(7));
adminList.Add(a);
}
reader.Close();
return adminList;
}
catch (Exception e)
{
MessageBox.Show("Error getting admin list: " + e.Message, "Server Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}
internal static List<FoodList> getFoodList()
{
List<FoodList> fl = new List<FoodList>();
try
{
cmd = new OleDbCommand("SELECT ID, FoodName, FoodPrice, FoodType FROM FoodList ORDER BY FoodName;", conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
FoodList fudList = new FoodList(reader.GetInt32(0).ToString(), reader.GetString(1), reader.GetInt32(2), reader.GetString(3));
fl.Add(fudList);
}
}
catch (Exception ee)
{
reader.Close();
MessageBox.Show("getFoodList() error: " + ee.ToString());
}
reader.Close();
return fl;
}
private EventInfo CopyEventToBO(OleDbDataReader rdr)
{
//Id,Title,Type,Audience,Author,EventDate,Description
EventInfo forumevent = new EventInfo
{
Id = rdr.GetInt32(0),
Title = rdr.SafeGetString(1),
Type = rdr.GetInt32(2),
Audience = rdr.SafeGetString(3),
MemberId = rdr.GetInt32(4),
Date = rdr.GetSnitzDate(5).Value,
Description = rdr.SafeGetString(6),
RecurringFrequency = (RecurringFrequencies) rdr.SafeGetInt32(7)
};
var mem = new Member();
forumevent.Author = new AuthorInfo(mem.GetById(forumevent.MemberId));
return forumevent;
}
public Result getUserInfo(string username)
{
Result r = new Result();
try
{
cmd = new OleDbCommand("SELECT * FROM Users WHERE Username = ?;", conn);
cmd.Parameters.Add("Username", OleDbType.VarChar).Value = username;
reader = cmd.ExecuteReader();
if (reader.Read())
{
User u = new User(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4),
reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetDateTime(8), reader.GetInt32(9), reader.GetInt32(10));
r.user = u;
r.success = true;
}
return r;
}
catch (Exception e)
{
MessageBox.Show("Error getting userInfo: " + e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}
public bool createPosition(Position create)
{
bool result = false;
// Command
string query = String.Format(@"INSERT INTO gfrc_volunteer_position (gvo_id, gvp_position, gvp_driver_cat, gvp_driver_cat_doc, gvp_driver_trans) " +
"VALUES({0}, '{1}', '{2}', '{3}', '{4}')",
create.gvoID, create.PositionA, create.DriverCat, create.DriverCatDoc, create.DriverTrans);
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 gvp_id FROM gfrc_volunteer_position WHERE gvp_id = (SELECT MAX(gvp_id) FROM gfrc_volunteer_position)");
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
// Set gloID
_gvpID = Convert.ToUInt32(rdr.GetInt32(0));
}
}
}
}
catch (Exception e)
{
result = false;
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return result;
}
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;
}
private void BuildMenu1(OleDbDataReader oReader)
{
/*** main menu - records with ParentId = 0 ***/
EasyMenu mainEM = null;
/*** ***/
/*** list with child menus ***/
Hashtable childMenus = null;
while (oReader.Read())
{
int parentId = oReader.GetInt32(1);
if (parentId == 0)
{
if (mainEM == null)
{
mainEM = new EasyMenu();
mainEM.ID = "mainEM";
mainEM.StyleFolder = "styles/horizontal1";
mainEM.Width = "400";
mainEM.ShowEvent = MenuShowEvent.Always;
mainEM.Position = MenuPosition.Horizontal;
// css classes names for the menu and the item container
mainEM.CSSMenu = "ParentMenu";
mainEM.CSSMenuItemContainer = "ParentItemContainer";
// css classes names for MenuItems
CSSClasses MenuItemCssClasses = mainEM.CSSClassesCollection[mainEM.CSSClassesCollection.Add(new CSSClasses(typeof(OboutInc.EasyMenu_Pro.MenuItem)))];
MenuItemCssClasses.ComponentSubMenuCellOver="ParentItemSubMenuCellOver";
MenuItemCssClasses.ComponentContentCell="ParentItemContentCell";
MenuItemCssClasses.Component="ParentItem";
MenuItemCssClasses.ComponentSubMenuCell="ParentItemSubMenuCell";
MenuItemCssClasses.ComponentIconCellOver="ParentItemIconCellOver";
MenuItemCssClasses.ComponentIconCell="ParentItemIconCell";
MenuItemCssClasses.ComponentOver="ParentItemOver";
MenuItemCssClasses.ComponentContentCellOver="ParentItemContentCellOver";
// add the classes names to the collection
mainEM.CSSClassesCollection.Add(MenuItemCssClasses);
// css classes names for MenuSeparators
CSSClasses MenuSeparatorCssClasses = mainEM.CSSClassesCollection[mainEM.CSSClassesCollection.Add(new CSSClasses(typeof(MenuSeparator)))];
MenuSeparatorCssClasses.ComponentSubMenuCellOver="ParentSeparatorSubMenuCellOver";
MenuSeparatorCssClasses.ComponentContentCell="ParentSeparatorContentCell";
MenuSeparatorCssClasses.Component="ParentSeparator";
MenuSeparatorCssClasses.ComponentSubMenuCell="ParentSeparatorSubMenuCell";
MenuSeparatorCssClasses.ComponentIconCellOver="ParentSeparatorIconCellOver";
MenuSeparatorCssClasses.ComponentIconCell="ParentSeparatorIconCell";
MenuSeparatorCssClasses.ComponentOver="ParentSeparatorOver";
MenuSeparatorCssClasses.ComponentContentCellOver="ParentSeparatorContentCellOver";
// add the classes names to the collection
mainEM.CSSClassesCollection.Add(MenuSeparatorCssClasses);
}
mainEM.AddItem(new OboutInc.EasyMenu_Pro.MenuItem("item_" + oReader.GetInt32(0).ToString(), oReader.GetString(2), "", "", "", ""));
placeHolder1.Controls.Add(mainEM);
}
else
{
if (childMenus == null)
childMenus = new Hashtable();
/* first time the menu is ceated */
if (!childMenus.ContainsKey(parentId))
{
EasyMenu childEM = new EasyMenu();
childEM.ID = "childEM_" + parentId;
childEM.StyleFolder = "styles/horizontal1";
childEM.ShowEvent = MenuShowEvent.MouseOver;
childEM.AttachTo = "item_" + parentId;
childEM.Width = "150";
int menuLevel = oReader.GetInt32(3);
if (menuLevel == 1)
childEM.Align = MenuAlign.Under;
else
childEM.Align = MenuAlign.Left;
childEM.AddItem(new OboutInc.EasyMenu_Pro.MenuItem("item_" + oReader.GetInt32(0).ToString(), oReader.GetString(2), "", "", "", ""));
childMenus.Add(parentId, childEM);
placeHolder1.Controls.Add(childEM);
}
/* items are added to the already created menu */
else
{
EasyMenu childEM = (EasyMenu)childMenus[parentId];
childEM.AddItem(new OboutInc.EasyMenu_Pro.MenuItem("item_" + oReader.GetInt32(0).ToString(), oReader.GetString(2), "", "", "", ""));
}
}
}
}
internal static List<User> searchUsers(string key)
{
List<User> list = new List<User>();
try
{
cmd = new OleDbCommand("SELECT * FROM Users WHERE Username LIKE '%" + key + "%';", conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
User u = new User(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4),
reader.GetString(5), reader.GetString(6), reader.GetString(7), reader.GetDateTime(8), reader.GetInt32(9), reader.GetInt32(10));
list.Add(u);
}
return list;
}
catch (Exception e)
{
MessageBox.Show("Error getting usersList in searchUsers: " + e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}
private void BuildMenu2(OleDbDataReader oReader)
{
/*** main menu - records with ParentId = 0 ***/
EasyMenu mainEM = null;
/*** ***/
/*** list with child menus ***/
Hashtable childMenus = null;
while (oReader.Read())
{
int parentId = oReader.GetInt32(1);
if (parentId == 0)
{
if (mainEM == null)
{
mainEM = new EasyMenu();
mainEM.ID = "VmainEM";
mainEM.StyleFolder = "styles/horizontal1";
mainEM.Width = "400";
mainEM.ShowEvent = MenuShowEvent.Always;
mainEM.Position = MenuPosition.Horizontal;
}
mainEM.AddItem(new OboutInc.EasyMenu_Pro.MenuItem("Vitem_" + oReader.GetInt32(0).ToString(), oReader.GetString(2), "", "", "", ""));
placeHolder2.Controls.Add(mainEM);
}
else
{
if (childMenus == null)
childMenus = new Hashtable();
/* first time the menu is ceated */
if (!childMenus.ContainsKey(parentId))
{
EasyMenu childEM = new EasyMenu();
childEM.ID = "VchildEM_" + parentId;
childEM.StyleFolder = "styles/horizontal1";
childEM.ShowEvent = MenuShowEvent.MouseOver;
childEM.AttachTo = "Vitem_" + parentId;
childEM.Width = "150";
int menuLevel = oReader.GetInt32(3);
if (menuLevel == 1)
childEM.Align = MenuAlign.Under;
else
childEM.Align = MenuAlign.Left;
childEM.AddItem(new OboutInc.EasyMenu_Pro.MenuItem("Vitem_" + oReader.GetInt32(0).ToString(), oReader.GetString(2), "", "", "", ""));
childMenus.Add(parentId, childEM);
placeHolder1.Controls.Add(childEM);
}
/* items are added to the already created menu */
else
{
EasyMenu childEM = (EasyMenu)childMenus[parentId];
childEM.AddItem(new OboutInc.EasyMenu_Pro.MenuItem("Vitem_" + oReader.GetInt32(0).ToString(), oReader.GetString(2), "", "", "", ""));
}
}
}
}
protected override TreeNode AddNodeItem(TreeNode aTn, OleDbDataReader aReader, ref int aSI)
{
/// В pSQLString должен быть определен примерно такой select:
/// ...
/// SELECT
/// objPlace, objCode, objName, CASE WHEN objTypeR=1420 THEN 0 ELSE 1 END, ...
/// FROM
/// iNode INNER JOIN iObj ON nodPObj=objPlace AND nodCObj=objCode
/// ...
TreeNode ntn = new TreeNode(aReader.GetString(2));
PCTVItemData tid = new PCTVItemData();
ntn.Tag = tid;
tid.pPC.place = aReader.GetInt32(0);
tid.pPC.code = aReader.GetInt32(1);
/// Added M.Tor 25.06.2008:
tid.pText = aReader.GetString(2);
if (aReader.GetInt32(3) > 0)
ntn.Nodes.Add(new TreeNode());
if (aTn == null)
{
Nodes.Add(ntn);
tid.pPath = tid.pCode.ToString();
}
else
{
aTn.Nodes.Add(ntn);
tid.pPath = ((PCTVItemData)aTn.Tag).pPath + pPathDelim + tid.pCode;
}
aSI = 4;
return ntn;
}
private void Draw_Universe(string netid)
{
string SQL;
string NodeName;
int NodeID, FromID, ToID, EdgeID;
double xx2, yy2, size, xx, yy;
double px, py;
int comments;
Random rnd = new Random();
Graph oGraph = new Graph(GraphDirectedness.Directed);
IVertexCollection oVertices = oGraph.Vertices;
IEdgeCollection oEdges = oGraph.Edges;
// Nuke the Display
UniverseBackground.Children.Clear();
// Add the Whiskers Programmatically
Add_Whiskers();
SQL = "select id, nodename,x,y from nodes where networkid = '" + netid + "'";
OleDbCommand aCommand = new OleDbCommand(SQL, localengine.RepositoryConnection);
try
{
//create the datareader object to connect to table
OleDbDataReader aReader = aCommand.ExecuteReader();
//Iterate throuth the database
while (aReader.Read())
{
NodeID = aReader.GetInt32(0);
NodeName = aReader.GetString(1);
ListBoxItem li = new ListBoxItem();
li.Content = NodeName;
li.Tag = NodeID.ToString();
NodeList.Items.Add(li);
px = (double)aReader.GetInt32(2);
py = (double)aReader.GetInt32(3);
UniversePadPoint p2 = new UniversePadPoint();
p2.PadName = NodeName;
xx2 = px;
yy2 = py;
xx2 = xx2 + 0;
yy2 = yy2 + 0;
// BUG p2.WhiskX = XWhisker;
// BUG p2.WhiskY = YWhisker;
size = (double)10;
p2.SetDrillFeature(DrillDetailLabel, DrillDetailList, localengine.RepositoryConnection);
p2.Render(UniverseBackground, FieldBackground, xx2, yy2, size, (int)NodeID, NodeName);
Ellipse re = new Ellipse();
re.Width = rnd.NextDouble() * 80;
re.Height = re.Width;
re.Opacity = 0.25;
re.Tag = "METRIC";
re.Fill = new SolidColorBrush(Colors.Blue);
UniverseBackground.Children.Add(re);
Canvas.SetLeft(re, xx2 - (re.Width / 2) + 5);
Canvas.SetTop(re, yy2 - (re.Width / 2) + 5);
}
aReader.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
// Connect the edges
SQL = "SELECT e.edgeid, e.fromid, n1.x, n1.y, e.toid, n2.x, n2.y ";
SQL = SQL + "FROM Edges e, Nodes n1, Nodes n2 ";
SQL = SQL + "where e.networkid = '" + netid + "' and n1.networkid = '" + netid + "' and n2.networkid = '" + netid + "' ";
SQL = SQL + " and n1.id = e.fromid and n2.id = e.toid ";
aCommandEdge = new OleDbCommand(SQL, localengine.RepositoryConnection);
try
{
//create the datareader object to connect to table
aReaderEdge = aCommandEdge.ExecuteReader();
//Iterate throuth the database
while (aReaderEdge.Read())
{
EdgeID = aReaderEdge.GetInt32(0);
FromID = aReaderEdge.GetInt32(1);
ToID = aReaderEdge.GetInt32(4);
xx = aReaderEdge.GetInt32(2);
yy = aReaderEdge.GetInt32(3);
xx2 = aReaderEdge.GetInt32(5);
yy2 = aReaderEdge.GetInt32(6);
Line l = new Line();
l.X1 = xx + 5;
l.Y1 = yy + 5;
l.X2 = xx2 + 5;
l.Y2 = yy2 + 5;
l.Tag = "EDGE(" + FromID.ToString() + ":" + ToID.ToString() + ")";
l.ToolTip = l.Tag;
l.Stroke = new SolidColorBrush(Colors.Gray);
UniverseBackground.Children.Add(l);
}
//aReaderEdge.Close();
}
catch (Exception eEdgedDraw)
{
MessageBox.Show(eEdgedDraw.Message);
}
}
private void Build_Universe_Network(string layoutmethod, string netid)
{
string SQL;
string NodeName;
int NodeID, FromID, ToID, EdgeID;
double xx2, yy2, size, xx,yy;
double px, py;
int comments;
Random rnd = new Random();
Graph oGraph = new Graph(GraphDirectedness.Directed);
IVertexCollection oVertices = oGraph.Vertices;
IEdgeCollection oEdges = oGraph.Edges;
// Nuke the Display
UniverseBackground.Children.Clear();
// Add the Whiskers Programmatically
Add_Whiskers();
SQL = "select id, nodename,x,y from nodes where networkid = '" + netid + "'";
OleDbCommand aCommand = new OleDbCommand(SQL, localengine.RepositoryConnection);
try
{
//create the datareader object to connect to table
OleDbDataReader aReader = aCommand.ExecuteReader();
//Iterate throuth the database
while (aReader.Read())
{
NodeID = aReader.GetInt32(0);
NodeName = aReader.GetString(1);
ListBoxItem li = new ListBoxItem();
li.Content = NodeName;
li.Tag = NodeID.ToString();
NodeList.Items.Add(li);
px = (double)aReader.GetInt32(2);
py = (double)aReader.GetInt32(3);
IVertex oVertexA = oVertices.Add();
oVertexA.Name = NodeName;
oVertexA.Tag = NodeID;
}
aReader.Close();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
// Connect the edges
SQL = "select edgeid, fromid, toid from edges where networkid='" + netid + "'";
aCommandEdge = new OleDbCommand(SQL, localengine.RepositoryConnection);
try
{
//create the datareader object to connect to table
aReaderEdge = aCommandEdge.ExecuteReader();
//Iterate throuth the database
while (aReaderEdge.Read())
{
EdgeID = aReaderEdge.GetInt32(0);
FromID = aReaderEdge.GetInt32(1);
ToID = aReaderEdge.GetInt32(2);
xx = Getx(FromID);
yy = Gety(FromID);
xx2 = Getx(ToID);
yy2 = Gety(ToID);
Line l = new Line();
l.X1 = xx+5;
l.Y1 = yy+5;
l.X2 = xx2+5;
l.Y2 = yy2+5;
l.Tag = "EDGE(" + FromID.ToString() + ":" + ToID.ToString() + ")";
l.ToolTip = l.Tag;
l.Stroke = new SolidColorBrush(Colors.Gray);
UniverseBackground.Children.Add(l);
IVertex oFrom=null;
IVertex oTo=null;
foreach (IVertex oVertex in oVertices)
{
if (oVertex.Tag.ToString() == FromID.ToString())
{
oFrom = oVertex;
}
if (oVertex.Tag.ToString() == ToID.ToString())
{
oTo = oVertex;
}
}
IEdge oEdge1 = oEdges.Add(oFrom, oTo, true);
}
//aReaderEdge.Close();
}
catch (Exception eEdge)
{
MessageBox.Show(eEdge.Message);
}
// Apply Layout
// ==================================================================
switch(layoutmethod)
{
case "Circular Layout":
ILayout oLayout_cir = new CircleLayout();
LayoutContext oLayoutContext_cir = new LayoutContext(new System.Drawing.Rectangle(0, 0, 5000, 5000));
oLayout_cir.LayOutGraph(oGraph, oLayoutContext_cir);
break;
case "Random Layout":
ILayout oLayout_rand = new RandomLayout();
LayoutContext oLayoutContext_rand = new LayoutContext(new System.Drawing.Rectangle(0, 0, 5000, 5000));
oLayout_rand.LayOutGraph(oGraph, oLayoutContext_rand);
break;
case "Sugiyama Layout":
ILayout oLayout_Sugi = new SugiyamaLayout();
LayoutContext oLayoutContext_Sugi = new LayoutContext(new System.Drawing.Rectangle(0, 0, 5000, 5000));
oLayout_Sugi.LayOutGraph(oGraph, oLayoutContext_Sugi);
break;
case "Grid Layout":
ILayout oLayout_grid = new GridLayout();
LayoutContext oLayoutContext_grid = new LayoutContext(new System.Drawing.Rectangle(0, 0, 5000, 5000));
oLayout_grid.LayOutGraph(oGraph, oLayoutContext_grid);
break;
case "Spiral Layout":
ILayout oLayout_spiral = new SpiralLayout();
LayoutContext oLayoutContext_spiral = new LayoutContext(new System.Drawing.Rectangle(0, 0, 5000, 5000));
oLayout_spiral.LayOutGraph(oGraph, oLayoutContext_spiral);
break;
case "Fruchterman/Reingold Layout":
ILayout oLayout_Fruch = new FruchtermanReingoldLayout();
LayoutContext oLayoutContext_Fruch = new LayoutContext(new System.Drawing.Rectangle(0, 0, 5000, 5000));
oLayout_Fruch.LayOutGraph(oGraph, oLayoutContext_Fruch);
break;
case "Sinusoid H Layout":
ILayout oLayout_SinH = new SinusoidHorizontalLayout();
LayoutContext oLayoutContext_SinH = new LayoutContext(new System.Drawing.Rectangle(0, 0, 5000, 5000));
oLayout_SinH.LayOutGraph(oGraph, oLayoutContext_SinH);
break;
case "Sinusoid V Layout":
ILayout oLayout_SinV = new SinusoidVerticalLayout();
LayoutContext oLayoutContext_SinV = new LayoutContext(new System.Drawing.Rectangle(0, 0, 500, 500));
oLayout_SinV.LayOutGraph(oGraph, oLayoutContext_SinV);
break;
}
// List the results.
int xoffset=0;
int yoffset=0;
Random rc = new Random();
Random rx = new Random();
Random ry = new Random();
Random coin = new Random();
foreach (IVertex oVertex in oVertices)
{
UniversePadPoint p2 = new UniversePadPoint();
p2.PadName = oVertex.Name;
xx2 = oVertex.Location.X;
yy2 = oVertex.Location.Y;
xx2 = xx2 + xoffset;
yy2 = yy2 + yoffset;
// BUG p2.WhiskX = XWhisker;
// BUG p2.WhiskY = YWhisker;
size = (double)10;
p2.Render(UniverseBackground, FieldBackground, xx2, yy2, size, (int)oVertex.Tag, oVertex.Name);
Ellipse re = new Ellipse();
re.Width = rnd.NextDouble() * 80;
re.Height = re.Width;
re.Opacity = 0.25;
re.Tag = "METRIC";
re.Fill = new SolidColorBrush(Colors.Blue);
UniverseBackground.Children.Add(re);
Canvas.SetLeft(re, xx2-(re.Width/2)+5);
Canvas.SetTop(re, yy2 - (re.Width / 2)+5);
}
foreach (IEdge e2 in oEdges)
{
IVertex f1 = e2.BackVertex;
IVertex t2 = e2.FrontVertex;
xx = f1.Location.X;
yy = f1.Location.Y;
xx2 = t2.Location.X;
yy2 = t2.Location.Y;
xx = xx + xoffset;
yy = yy + yoffset;
xx2 = xx2 + xoffset;
yy2 = yy2 + yoffset;
Line l = new Line();
l.X1 = xx + 5;
l.Y1 = yy + 5;
l.X2 = xx2 + 5;
l.Y2 = yy2 + 5;
l.Tag = "EDGE(" + f1.Tag.ToString() + ":" + t2.Tag.ToString() + ")";
l.ToolTip = l.Tag;
l.Stroke = new SolidColorBrush(Colors.Gray);
UniverseBackground.Children.Add(l);
}
}
private int GetValue(OleDbDataReader oData)
{
int intValue;
string strFieldType;
strFieldType = Convert.ToString(oData.GetFieldType(0));
switch (strFieldType)
{
case "System.Int16":
intValue = Convert.ToInt32(oData.GetInt16(0));
break;
case "System.Int32":
intValue = oData.GetInt32(0);
break;
case "System.Double":
intValue = Convert.ToInt32(oData.GetDouble(0));
break;
default:
intValue = oData.GetInt32(0);
break;
}
return intValue;
}
public Result foodOrderResult(string uid, string fid, int q)
{
Result r = new Result();
r.foodOrderResult = false;
r.foodResultMessage = "Ordering failed!";
try
{
int totalExpense = 0;
int price = 0;
cmd = new OleDbCommand("SELECT FoodPrice FROM FoodList WHERE ID = ?", conn);
cmd.Parameters.Add("FoodPrice", OleDbType.VarChar).Value = fid;
reader = cmd.ExecuteReader();
if (reader.Read())
{
price = reader.GetInt32(0);
}
totalExpense = price * q;
cmd = new OleDbCommand("INSERT INTO ORDERS (UserID, FoodID, Quantity, TotalExpense, OrderDate, ReportID, Status) VALUES(?, ?, ?, ?, ?, ?, ?)", conn);
cmd.Parameters.Add("UserID", OleDbType.VarChar).Value = uid;
cmd.Parameters.Add("FoodID", OleDbType.VarChar).Value = fid;
cmd.Parameters.Add("Quantity", OleDbType.Integer).Value = q;
cmd.Parameters.Add("TotalExpense", OleDbType.Integer).Value = totalExpense;
cmd.Parameters.Add("OrderDate", OleDbType.Date).Value = DateTime.Today;
cmd.Parameters.Add("ReportID", OleDbType.Integer).Value = 0;
cmd.Parameters.Add("Status", OleDbType.VarChar).Value = "pending";
cmd.ExecuteNonQuery();
r.foodOrderResult = true;
MessageBox.Show("SUCESSFUL!");
}
catch (Exception ee)
{
r.foodOrderResult = false;
r.foodResultMessage = "Ordering failed!";
MessageBox.Show("foodOrderResult() error: " + ee.ToString());
}
return r;
}
protected List<DBItem> GetSubmissionsQueryCallback(OleDbDataReader reader)
{
List<DBItem> returnList = new List<DBItem>();
if (reader.HasRows)
{
while (reader.Read())
{
DBItem item = new DBItem();
item.ID = reader.GetInt32(reader.GetOrdinal("ID"));
item.User = reader.GetString(reader.GetOrdinal("User"));
item.DateTime = reader.GetDateTime(reader.GetOrdinal("DateTime"));
item.Person = reader.GetString(reader.GetOrdinal("Person"));
item.Rating = reader.GetString(reader.GetOrdinal("Rating"));
item.Description = reader.GetString(reader.GetOrdinal("Description"));
item.Votes = reader.GetString(reader.GetOrdinal("Votes"));
returnList.Add(item);
}
}
return returnList;
}
private static Penerbit MappingDtrToObject(OleDbDataReader dtr)
{
Penerbit penerbit = new Penerbit();
penerbit.PenerbitID = dtr[0] is DBNull ? 0 : dtr.GetInt32(0);
penerbit.Nama = dtr[1] is DBNull ? string.Empty : dtr.GetString(1);
return penerbit;
}
// Constructor to login
public Login(string username, string password)
{
// Declarations
uint gloid = 0, gvoid = 0, modifiedby = 0;
string note = null, status = null;
bool active = false;
DateTime datemodified = new DateTime(1901, 1, 1);
//md5
password = CalculateMD5(password);
// Command
string query = string.Format("SELECT glo_id, glo_note, glo_active, glo_status, gvo_id, date_modified, modified_by FROM gfrc_login" +
" WHERE glo_username = '******' AND glo_password = '******'", username, password);
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
gloid = Convert.ToUInt32(rdr.GetInt32(0));
note = rdr.GetString(1);
active = rdr.GetBoolean(2);
status = rdr.GetString(3);
if (!UInt32.TryParse(rdr.GetValue(4).ToString(), out gvoid))
gvoid = 0;
if (!DateTime.TryParse(rdr.GetValue(5).ToString(), out datemodified))
datemodified = new DateTime(1901, 1, 1);
if (!UInt32.TryParse(rdr.GetValue(6).ToString(), out modifiedby))
modifiedby = 0;
}
}
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
_gloID = gloid;
_Username = username;
_Password = password;
_Note = note;
_Active = active;
_Status = status;
_gvoID = gvoid;
_DateModified = datemodified;
_ModifiedBy = modifiedby;
}
public bool createLogin(string username, string password, string note, bool active, string status, uint gvoid)
{
bool result = false;
string sGvoid;
if (gvoid == 0)
sGvoid = "null";
else
sGvoid = gvoid.ToString();
// Command
string query = String.Format(@"INSERT INTO gfrc_login (glo_username, glo_password, glo_note, glo_active, glo_status, gvo_id)" +
"VALUES ('{0}','{1}','{2}',{3},'{4}',{5})", username, password, note, active, status, sGvoid);
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 glo_id FROM gfrc_login WHERE glo_username = '******'", username);
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
// Set gloID
_gloID = Convert.ToUInt32(rdr.GetInt32(0));
}
}
}
}
catch (Exception e)
{
result = false;
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return result;
}
public bool createVolunteer(Volunteer create)
{
bool result = false;
// Command
string query = String.Format(@"INSERT INTO gfrc_volunteer (gvo_name, gvo_address, gvo_postal_address, gvo_email, gvo_home_ph, gvo_mobile_ph, gvo_dob, gvo_status, gvo_referred, " +
"gvo_referred_doc, gvo_police, gvo_police_doc, gvo_induction, gvo_application) " +
"VALUES('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', {10}, '{11}', {12}, '{13}')",
create.Name, create.Address, create.PostalAddress, create.Email, create.HomePh, create.MobilePh, create.DOB, create.Status,
create.Referred, create.ReferredDoc, create.Police, create.PoliceDoc, create.Induction, create.Application);
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 gvo_id FROM gfrc_volunteer WHERE gvo_id = (SELECT MAX(gvo_id) FROM gfrc_volunteer)");
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
// Set gloID
_gvoID = Convert.ToUInt32(rdr.GetInt32(0));
}
}
}
}
catch (Exception e)
{
result = false;
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return result;
}
