public List <RingNumbers> GetRing_Numbers()
{
List <RingNumbers> retVal = new List <RingNumbers>();
try
{
RingNumbersBL ringNumbers = new RingNumbersBL(_connString);
tblRing_Numbers = ringNumbers.GetRing_Numbers();
if (tblRing_Numbers != null && tblRing_Numbers.Rows.Count > 0)
{
foreach (DataRow row in tblRing_Numbers.Rows)
{
RingNumbers ringNumber = new RingNumbers(_connString);
ringNumber.Ring_No = Utils.DBNullToShort(row["Ring_No"]);
ringNumber.Dog_ID = Utils.DBNullToGuid(row["Dog_ID"]);
ringNumber.Dog_KC_Name = Utils.DBNullToString(row["Dog_KC_Name"]);
ringNumber.Person_Forename = Utils.DBNullToString(row["Person_Forename"]);
ringNumber.Person_Surname = Utils.DBNullToString(row["Person_Surname"]);
retVal.Add(ringNumber);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public List<RingNumbers> GetRing_Numbers()
{
List<RingNumbers> ringNumberList = new List<RingNumbers>();
RingNumbersBL ringNumbers = new RingNumbersBL();
tblRing_Numbers = ringNumbers.GetRing_Numbers();
if (tblRing_Numbers != null && tblRing_Numbers.Count > 0)
{
foreach (sss.tblRing_NumbersRow row in tblRing_Numbers)
{
RingNumbers ringNumber = new RingNumbers();
ringNumber.Ring_No = row.Ring_No;
ringNumber.Dog_ID = row.Dog_ID;
ringNumber.Dog_KC_Name = row.Dog_KC_Name;
ringNumber.Person_Forename = row.Person_Forename;
ringNumber.Person_Surname = row.Person_Surname;
ringNumberList.Add(ringNumber);
}
}
return ringNumberList;
}
protected void PopulateRingNumbersTable()
{
if (!string.IsNullOrEmpty(Show_ID))
{
Guid show_ID = new Guid(Show_ID);
Shows show = new Shows(show_ID);
bool success = false;
RingNumbers ringNumbers = new RingNumbers();
success = ringNumbers.PopulateRing_Numbers(show_ID);
if (success)
{
PopulateRingNumbersGridView();
}
else
{
MessageLabel.Text = "Failed to populate the Ring_Numbers table!";
divRingNumberList.Visible = false;
}
}
}
protected void PopulateRingNumbersGridView()
{
RingNumbers ringNumbers = new RingNumbers();
RingNumberList = ringNumbers.GetRing_Numbers();
if (RingNumberList != null && RingNumberList.Count > 0)
{
Common.RingNumberList = RingNumberList;
RingNumberGridView.DataSource = RingNumberList;
RingNumberGridView.DataBind();
divRingNumberList.Visible = true;
}
else
{
MessageLabel.Text = "No Data for this Show.";
divRingNumberList.Visible = false;
}
}
