public List <SpecialRequests> GetSpecialRequestList()
{
List <SpecialRequests> retVal = new List <SpecialRequests>();
try
{
SpecialRequestsBL specialRequests = new SpecialRequestsBL(_connString);
tblSpecialRequestList = specialRequests.GetSpecialRequests();
if (tblSpecialRequestList != null && tblSpecialRequestList.Rows.Count > 0)
{
foreach (DataRow row in tblSpecialRequestList.Rows)
{
SpecialRequests specialRequest = new SpecialRequests(_connString);
specialRequest.Ring_No = Utils.DBNullToShort(row["Ring_No"]);
specialRequest.Owner = Utils.DBNullToString(row["Owner"]);
specialRequest.Dog_KC_Name = Utils.DBNullToString(row["Dog_KC_Name"]);
specialRequest.Special_Request = Utils.DBNullToString(row["Special_Request"]);
specialRequest.Class_Name = Utils.DBNullToString(row["Class_Name"]);
specialRequest.Dog_Class_ID = Utils.DBNullToGuid(row["Dog_Class_ID"]);
specialRequest.Show_Entry_Class_ID = Utils.DBNullToGuid(row["Show_Entry_Class_ID"]);
specialRequest.Show_Final_Class_ID = Utils.DBNullToGuid(row["Show_Final_Class_ID"]);
retVal.Add(specialRequest);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public bool PopulateSpecialRequestList(Guid show_ID, Guid?show_Entry_Class_ID, bool specialRequestsOnly)
{
bool success = false;
try
{
if (show_Entry_Class_ID == new Guid())
{
show_Entry_Class_ID = null;
}
SpecialRequestsBL specialRequests = new SpecialRequestsBL(_connString);
success = specialRequests.PopulateSpecialRequestList(show_ID, show_Entry_Class_ID, specialRequestsOnly);
}
catch (Exception ex)
{
throw ex;
}
return(success);
}
public bool PopulateSpecialRequestList(Guid show_ID, Guid? show_Entry_Class_ID, bool specialRequestsOnly)
{
bool success = false;
if (show_Entry_Class_ID == new Guid())
show_Entry_Class_ID = null;
SpecialRequestsBL specialRequests = new SpecialRequestsBL();
success = specialRequests.PopulateSpecialRequestList(show_ID, show_Entry_Class_ID, specialRequestsOnly);
return success;
}
public List<SpecialRequests> GetSpecialRequestList()
{
List<SpecialRequests> specialRequestList = new List<SpecialRequests>();
SpecialRequestsBL specialRequests = new SpecialRequestsBL();
tblSpecialRequestList = specialRequests.GetSpecialRequests();
if (tblSpecialRequestList != null && tblSpecialRequestList.Count > 0)
{
foreach (sss.tblSpecialRequestListRow row in tblSpecialRequestList)
{
SpecialRequests specialRequest = new SpecialRequests();
specialRequest.Ring_No = row.Ring_No;
specialRequest.Owner = row.Owner;
specialRequest.Dog_KC_Name = row.Dog_KC_Name;
if(!row.IsSpecial_RequestNull())
specialRequest.Special_Request = row.Special_Request;
specialRequest.Class_Name = row.Class_Name;
specialRequest.Dog_Class_ID = row.Dog_Class_ID;
specialRequest.Show_Entry_Class_ID = row.Show_Entry_Class_ID;
specialRequest.Show_Final_Class_ID = row.Show_Final_Class_ID;
specialRequestList.Add(specialRequest);
}
}
return specialRequestList;
}