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