private void GetDetails()
{
try
{
ReadTextFile readTextFile = new ReadTextFile();
DataTable dtResult = new DataTable();
DataTable dtDetails = new DataTable();
dtResult.Columns.Add("Location");
dtResult.Columns.Add("Coordinates");
dtResult.Columns.Add("Lap");
dtResult.Columns.Add("DateReleased");
dtResult.Columns.Add("TimeReleased");
dtResult.Columns.Add("BirdEntry");
dtResult.Columns.Add("TotalSMS");
dtResult.Columns.Add("Version");
dtResult.Columns.Add("StopTime");
dtResult.Columns.Add("MinSpeed");
string root = Server.MapPath("~");
string Template = root + @"TextFile\RaceResult\" + Club + @"\RaceDetails" + DateRelease.Replace("-", "") + ".txt";
if (File.Exists(Template))
{
dtDetails = readTextFile.ReadFromTextFile(Template, dtResult, "", "", "");
if (dtDetails.Rows.Count > 0)
{
this.lblLocation.Text = dtDetails.Rows[0]["Location"].ToString();
this.lblCoordinates.Text = dtDetails.Rows[0]["Coordinates"].ToString();
this.lblLap.Text = dtDetails.Rows[0]["Lap"].ToString();
this.lblTimeReleased.Text = dtDetails.Rows[0]["DateReleased"].ToString() + " " + dtDetails.Rows[0]["TimeReleased"].ToString();
this.lblTotalBirdEntry.Text = dtDetails.Rows[0]["BirdEntry"].ToString();
this.lblTotalSMS.Text = dtDetails.Rows[0]["TotalSMS"].ToString();
this.lblStopTimeDetails.Text = dtDetails.Rows[0]["StopTime"].ToString();
this.lblMinimumSpeed.Text = dtDetails.Rows[0]["MinSpeed"].ToString();
Session["VERSION"] = dtDetails.Rows[0]["Version"].ToString();
if (Session["VERSION"].ToString() == "1")
{
this.rcbCategory.Enabled = false;
this.rcbGroup.Enabled = false;
}
}
}
else
{
this.lblLocation.Text = "";
this.lblCoordinates.Text = "";
this.lblLap.Text = "";
this.lblTimeReleased.Text = "";
this.lblTotalBirdEntry.Text = "";
this.lblTotalSMS.Text = "";
this.lblStopTimeDetails.Text = "";
}
}
catch (Exception ex)
{
this.RadWindowManager1.RadAlert(ex.Message, 350, 150, "Error", "");
}
}
protected void rgResults_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
try
{
ReadTextFile readTextFile = new ReadTextFile();
DataTable dtResult = new DataTable();
dtResult.Columns.Add("Rank");
dtResult.Columns.Add("Sender");
dtResult.Columns.Add("MemberName");
dtResult.Columns.Add("StickerCode");
dtResult.Columns.Add("ArrivalTime");
string root = Server.MapPath("~");
string RaceResult = root + @"TextFile\RaceResult\" + Club + @"\RaceResult" + DateRelease.Replace("-", "") + ".txt";
if (File.Exists(RaceResult))
{
rgResults.DataSource = readTextFile.ReadFromTextFile(RaceResult, dtResult, Filter, "", "");
}
}
catch (Exception ex)
{
this.RadWindowManager1.RadAlert(ex.Message, 350, 150, "Error", "");
}
}
protected void rgResults_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
try
{
ReadTextFile readTextFile = new ReadTextFile();
DataTable dtResult = new DataTable();
dtResult.Columns.Add("GroupCategory");
dtResult.Columns.Add("Rank");
dtResult.Columns.Add("MemberName");
dtResult.Columns.Add("Distance");
dtResult.Columns.Add("BandNo");
dtResult.Columns.Add("StickerCode");
dtResult.Columns.Add("ArrivalTime");
dtResult.Columns.Add("Flight");
dtResult.Columns.Add("Speed");
if (DateRelease == null || DateRelease == "")
{
rgResults.DataSource = dtResult;
}
else
{
string root = Server.MapPath("~");
string Template = root + @"TextFile\RaceResult\" + Club + @"\raceresult" + DateRelease.Replace("-", "") + ".txt";
if (File.Exists(Template))
{
rgResults.DataSource = readTextFile.ReadFromTextFile(Template, dtResult, Filter, Category, Group);
}
else
{
rgResults.DataSource = dtResult;
}
}
}
catch (Exception ex)
{
this.RadWindowManager1.RadAlert(ex.Message, 350, 150, "Error", "");
}
}
private DataTable GetReleaseDateCollection()
{
try
{
DataTable dtResult = new DataTable();
DataRow dr = dtResult.NewRow();
dtResult.Columns.Add("DateRelease");
dr["DateRelease"] = "";
dtResult.Rows.Add(dr);
string root = Server.MapPath("~");
readTextFile = new ReadTextFile();
string Template = root + @"TextFile\RaceResult\" + Club + @"\RaceDateRelease.txt";
dtResult = readTextFile.ReadFromTextFile(Template, dtResult, "", "", "");
return(dtResult);
}
catch (Exception ex)
{
throw ex;
}
}
