public void LoadTree(bool IsArchived) { treeView1.Nodes.Clear(); GenerateCoupon coupon = new GenerateCoupon(); DataSet ds = coupon.GetCoupons(IsArchived); ds.Relations.Add("Sport_Coupon", ds.Tables[0].Columns["sportid"], ds.Tables[1].Columns["sportid"]); ds.Relations.Add("Coupon_Date", ds.Tables[1].Columns["couponid"], ds.Tables[2].Columns["couponid"]); //ds.Relations.Add("Date_Match", ds.Tables[1].Columns["couponid"], ds.Tables[2].Columns["couponid"]); //ds.Relations.Add("Match_Market", ds.Tables[2].Columns["couponid"], ds.Tables[3].Columns["couponid"]); //ds.Relations.Add("Match_Date", ds.Tables[0].Columns["MatchDate"], ds.Tables[1].Columns["MatchDate"]); foreach (DataRow drSport in ds.Tables[0].Rows) { TreeNode tn_group = new TreeNode(Convert.ToString(drSport["SportName"])); tn_group.Name = Convert.ToString(drSport["sportid"]); treeView1.Nodes.Add(tn_group); foreach (DataRow dr in drSport.GetChildRows("Sport_Coupon")) { TreeNode tn_coupon = new TreeNode(dr["couponname"].ToString()); string couponid = dr["couponid"].ToString(); tn_coupon.Name = couponid; tn_coupon.ContextMenuStrip = CouponMenuStrip; tn_group.Nodes.Add(tn_coupon); foreach (DataRow dr1 in dr.GetChildRows("Coupon_Date")) { string matchdate = dr1["MatchDate"].ToString(); TreeNode tn_date = new TreeNode(matchdate); tn_coupon.Nodes.Add(tn_date); string sql = "(couponid='" + couponid + "') AND (MatchDate='" + matchdate + "')"; foreach (DataRow drChild in ds.Tables[3].Select(sql)) { string matchid = drChild["matchid"].ToString(); TreeNode tn_match = new TreeNode(drChild["Home"].ToString() + " V " + drChild["Away"].ToString()); tn_date.Nodes.Add(tn_match); string sql2 = "(couponid='" + couponid + "') AND (matchid=" + matchid + ")"; foreach (DataRow drMkt in ds.Tables[4].Select(sql2)) { TreeNode tn_market = new TreeNode(drMkt["bettingmarket"].ToString()); tn_market.Name = drMkt["bettingmarketid"].ToString() + "," + drMkt["matchid"].ToString() + "," + drMkt["bettinglink"].ToString() + "," + drMkt["couponid"].ToString(); tn_match.Nodes.Add(tn_market); } } } } } // treeView1.Nodes.Add(tn_group); }
private void LoadTree(string couponid,long matchid) { bool IsArchived = false; GenerateCoupon coupon = new GenerateCoupon(); DataSet ds = coupon.GetCoupons(IsArchived); TreeNode tnupdate = new TreeNode("Markets Priced"); string sql2 = "(couponid='" + couponid + "') AND (matchid=" + matchid + ")"; foreach (DataRow drMkt in ds.Tables[4].Select(sql2)) { TreeNode tn_market = new TreeNode(drMkt["bettingmarket"].ToString()); tn_market.Name = drMkt["bettingmarketid"].ToString() + "," + drMkt["matchid"].ToString() + "," + drMkt["bettinglink"].ToString() + "," + drMkt["couponid"].ToString(); tnupdate.Nodes.Add(tn_market); } treeView1.Nodes.Add(tnupdate); }
private void button1_Click(object sender, EventArgs e) { Button btn = sender as Button; if (treeView1.SelectedNodes.Count.Equals(1)) { foreach (TreeNode node in treeView1.SelectedNodes) { if (node.Level == 1) { TreeNode mynode = new TreeNode(); mynode = node; while (mynode.Parent != null) { mynode = mynode.Parent; } SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal); saveFileDialog.Filter = "XML Files (*.xml)|*.xml"; if (saveFileDialog.ShowDialog(this) == DialogResult.OK) { string FileName = saveFileDialog.FileName; string couponid = ""; string sportname = mynode.Text; string sportid = mynode.Name; couponid = node.Name; DataSet ds; //string[] info = node.Split(','); GenerateCoupon coupon = new GenerateCoupon(); if(btn.Name.Equals("btnxmlall")) { ds = coupon.GetCoupons(couponid); } else { ds = coupon.GetUpdatedCouponInfo(couponid); } Helper.GenerateXMLforOdds(FileName, ds,sportname,sportid); MessageBox.Show("File saved successfully"); } // string node = treeView1.SelectedNode.Name; ////string[] info = node.Split(','); // GenerateCoupon coupon = new GenerateCoupon(); // DataSet ds = coupon.GetCoupons(Convert.ToInt64(node)); // GenerateXMLforOdds(ds); } else { MessageBox.Show("Please select a coupon to generate XML"); } } } }
public void CreateXMLFile() { if (treeView1.SelectedNodes.Count.Equals(1)) { foreach (TreeNode node in treeView1.SelectedNodes) { if (node.Level == 1) { SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal); saveFileDialog.Filter = "XML Files (*.xml)|*.xml"; if (saveFileDialog.ShowDialog(this) == DialogResult.OK) { string FileName = saveFileDialog.FileName; string couponid = ""; couponid = node.Name; //string[] info = node.Split(','); GenerateCoupon coupon = new GenerateCoupon(); DataSet ds = coupon.GetCoupons(couponid); GenerateXMLforOdds(FileName, ds); MessageBox.Show("File saved successfully"); } // string node = treeView1.SelectedNode.Name; ////string[] info = node.Split(','); // GenerateCoupon coupon = new GenerateCoupon(); // DataSet ds = coupon.GetCoupons(Convert.ToInt64(node)); // GenerateXMLforOdds(ds); } else { MessageBox.Show("Please select a coupon to generate XML"); } } } else { MessageBox.Show("Please select one coupon to generate XML"); } }
private void btnxml_Click(object sender, EventArgs e) { if (treeView1.SelectedNodes.Count.Equals(1)) { SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal); saveFileDialog.Filter = "XML Files (*.xml)|*.xml"; if (saveFileDialog.ShowDialog(this) == DialogResult.OK) { string FileName = saveFileDialog.FileName; string couponid=""; foreach (TreeNode node in treeView1.SelectedNodes) { couponid = node.Name; } //string[] info = node.Split(','); GenerateCoupon coupon = new GenerateCoupon(); DataSet ds = coupon.GetCoupons(couponid); GenerateXMLforOdds(FileName,ds); MessageBox.Show("File saved successfully"); } // string node = treeView1.SelectedNode.Name; ////string[] info = node.Split(','); // GenerateCoupon coupon = new GenerateCoupon(); // DataSet ds = coupon.GetCoupons(Convert.ToInt64(node)); // GenerateXMLforOdds(ds); } }