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