private void button1_Click(object sender, EventArgs e)
{
try
{
if (this.comboBox3.Text != "")
{
MavcPigeonClockingPortal.Models.RaceResultData race = new MavcPigeonClockingPortal.Models.RaceResultData();
var result = race.GetRaceResult(ClubName, this.comboBox2.Text, this.comboBox1.Text, this.dateTimePicker1.Value.Date, this.textBox1.Text);
var raceDetails = race.GetRaceDetails(ClubName, this.comboBox2.Text, this.comboBox1.Text, this.dateTimePicker1.Value.Date, this.textBox1.Text, UserID);
lbllocation.Text = "Location Name: " + raceDetails.locationName;
lbltime.Text = "Release Time: " + raceDetails.releaseTime;
lblTotalEntry.Text = "Total Bird Entry: " + raceDetails.totalBird;
lblTotalArrived.Text = "Total Arrived: " + raceDetails.sMSCount;
lblTotalClock.Text = "Min Speed: " + raceDetails.minSpeed;
this.dataGridView1.DataSource = result;
foreach (DataGridViewColumn item in this.dataGridView1.Columns)
{
if (!item.Name.Contains("Rank") && !item.Name.Contains("MemberName") && !item.Name.Contains("RingNumber") && !item.Name.Contains("Speed") && !item.Name.Contains("Remarks"))
{
this.dataGridView1.Columns[item.Name].Visible = false;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}
private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
MavcPigeonClockingPortal.Models.RaceResultData race = new MavcPigeonClockingPortal.Models.RaceResultData();
ClubName = ClubList.FirstOrDefault(x => x.clubName == this.comboBox3.Text).clubAbbreviation;
var birdCategory = race.GetBirdCategory(ClubName);
var raceCategory = race.GetGroupCategory(ClubName);
this.comboBox2.Items.Clear();
this.comboBox1.Items.Clear();
this.comboBox1.Items.Add("All");
this.comboBox2.Items.Add("All");
foreach (DataRow item in birdCategory.Rows)
{
this.comboBox2.Items.Add(item["Description"]);
}
foreach (DataRow item in raceCategory.Rows)
{
this.comboBox1.Items.Add(item["Race Group"]);
}
this.comboBox1.SelectedIndex = comboBox1.FindStringExact("All");
this.comboBox2.SelectedIndex = comboBox1.FindStringExact("All");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}
private void btnSend_Click(object sender, EventArgs e)
{
try
{
if (ClubName != "" && this.textBox1.Text != "")
{
MavcPigeonClockingPortal.Models.RaceResultData race = new MavcPigeonClockingPortal.Models.RaceResultData();
var result = race.SendSticker(ClubName, UserID, this.textBox1.Text);
this.textBox1.Text = "";
this.textBox1.Focus();
MessageBox.Show(result.Rows[0]["result"].ToString(), "Send Sticker");
}
else
{
if (ClubName == "")
{
MessageBox.Show("Please select clubname", "Error");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
MavcPigeonClockingPortal.Models.RaceResultData race = new MavcPigeonClockingPortal.Models.RaceResultData();
ClubName = this.comboBox1.Text;
this.textBox1.Text = "";
DBName = ClubList.FirstOrDefault(x => x.clubAbbreviation == ClubName).dbName;
var result = race.GetRaceEntry(this.comboBox1.Text, "", "", DateTime.Today.Date, "", UserID, "UserApps");
if (result.Rows.Count > 0)
{
this.dataGridView1.DataSource = result;
this.dataGridView1.Columns[1].Visible = false;
}
else
{
this.dataGridView1.DataSource = null;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}
private void button2_Click(object sender, EventArgs e)
{
try
{
MavcPigeonClockingPortal.Models.RaceResultData race = new MavcPigeonClockingPortal.Models.RaceResultData();
var result = race.Forecast(ClubName, UserID);
MessageBox.Show(result.Rows[0]["result"].ToString(), "FORECAST");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}
private void GetClubList()
{
MavcPigeonClockingPortal.Models.RaceResultData race = new MavcPigeonClockingPortal.Models.RaceResultData();
ClubList = race.GetClubList(UserID);
foreach (var item in ClubList)
{
this.comboBox1.Items.Add(item.clubAbbreviation);
}
if (comboBox1.Items.Count > 0)
{
comboBox1.SelectedIndex = 0;
}
}
