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 void FillSpecialRequestGrid(GridView gv, bool specialRequestsOnly)
{
if (!string.IsNullOrEmpty(Show_ID))
{
Guid? show_Entry_Class_ID = null;
if (!string.IsNullOrEmpty(Show_Entry_Class_ID) && Show_Entry_Class_ID != new Guid().ToString())
{
show_Entry_Class_ID = new Guid(Show_Entry_Class_ID);
}
SpecialRequestList = SpecialRequests.GetSpecialRequestListData(Show_ID, show_Entry_Class_ID, specialRequestsOnly);
if (SpecialRequestList != null && SpecialRequestList.Count > 0)
{
short ring_No = 0;
List<SpecialRequests> displayList = new List<SpecialRequests>();
SpecialRequests displayItem = new SpecialRequests();
foreach (SpecialRequests row in SpecialRequestList)
{
if (row.Ring_No != ring_No && ring_No != 0)
{
//new ring number
SpecialRequests completeRow = BuildGridviewRow(displayItem);
displayList.Add(completeRow);
displayItem = new SpecialRequests();
}
//existing ring number
displayItem.Ring_No = row.Ring_No;
displayItem.Owners.Add(row.Owner);
displayItem.Dog_KC_Name = row.Dog_KC_Name;
displayItem.Special_Request = row.Special_Request;
displayItem.Class_Name = row.Class_Name;
displayItem.Dog_Class_ID = row.Dog_Class_ID;
displayItem.Show_Entry_Class_ID = row.Show_Entry_Class_ID;
displayItem.Show_Final_Class_ID = row.Show_Final_Class_ID;
ring_No = row.Ring_No;
}
SpecialRequests finalRow = BuildGridviewRow(displayItem);
displayList.Add(finalRow);
gv.DataSource = displayList;
gv.DataBind();
}
}
}
public static List <SpecialRequests> GetSpecialRequestListData(string connString, string Show_ID, Guid?show_Entry_Class_ID, bool specialRequestsOnly)
{
List <SpecialRequests> specialRequestList = new List <SpecialRequests>();
try
{
SpecialRequests specialRequest = new SpecialRequests(connString);
Guid show_ID = new Guid(Show_ID);
if (specialRequest.PopulateSpecialRequestList(show_ID, show_Entry_Class_ID, specialRequestsOnly))
{
specialRequestList = specialRequest.GetSpecialRequestList();
}
}
catch (Exception ex)
{
throw ex;
}
return(specialRequestList);
}
private SpecialRequests BuildGridviewRow(SpecialRequests displayItem)
{
SpecialRequests completeRow = new SpecialRequests();
completeRow.Dog_Class_ID = displayItem.Dog_Class_ID;
completeRow.Show_Entry_Class_ID = displayItem.Show_Entry_Class_ID;
completeRow.Show_Final_Class_ID = displayItem.Show_Final_Class_ID;
completeRow.Ring_No = displayItem.Ring_No;
string ownerList = string.Empty;
foreach (string owner in displayItem.Owners)
{
if (ownerList.IndexOf(owner) == -1)
{
ownerList = string.Format("{0}{1}", ownerList, " & " + owner);
}
}
completeRow.Owner = ownerList.Substring(3);
completeRow.Dog_KC_Name = displayItem.Dog_KC_Name;
completeRow.Special_Request = displayItem.Special_Request;
completeRow.Class_Name = displayItem.Class_Name;
return completeRow;
}
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;
}
public static List<SpecialRequests> GetSpecialRequestListData(string Show_ID, Guid? show_Entry_Class_ID, bool specialRequestsOnly)
{
List<SpecialRequests> specialRequestList = new List<SpecialRequests>();
SpecialRequests specialRequest = new SpecialRequests();
Guid show_ID = new Guid(Show_ID);
if (specialRequest.PopulateSpecialRequestList(show_ID, show_Entry_Class_ID, specialRequestsOnly))
{
specialRequestList = specialRequest.GetSpecialRequestList();
}
return specialRequestList;
}
