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; }