public List <CatalogueList> GetCatalogueListByRingNumber()
{
List <CatalogueList> retVal = new List <CatalogueList>();
try
{
CatalogueListBL catalogueListByRingNumbers = new CatalogueListBL(_connString);
tblCatalogueListByRingNumber = catalogueListByRingNumbers.GetCatalogueListOrderByRingNumber();
if (tblCatalogueListByRingNumber != null && tblCatalogueListByRingNumber.Rows.Count > 0)
{
foreach (DataRow row in tblCatalogueListByRingNumber.Rows)
{
CatalogueList catalogueListByRingNumber = new CatalogueList(_connString);
catalogueListByRingNumber.Ring_No = Utils.DBNullToShort(row["Ring_No"]);
catalogueListByRingNumber.Owner = Utils.DBNullToString(row["Owner"]);
catalogueListByRingNumber.Address = Utils.DBNullToString(row["Address"]);
catalogueListByRingNumber.Dog_KC_Name = Utils.DBNullToString(row["Dog_KC_Name"]);
catalogueListByRingNumber.Dog_Breed_Description = Utils.DBNullToString(row["Dog_Breed_Description"]);
catalogueListByRingNumber.Dog_Gender = Utils.DBNullToString(row["Dog_Gender"]);
catalogueListByRingNumber.Date_Of_Birth = Utils.DBNullToString(row["Date_Of_Birth"]);
catalogueListByRingNumber.Class_Name = Utils.DBNullToString(row["Class_Name"]);
catalogueListByRingNumber.Catalogue = Utils.DBNullToBool(row["Catalogue"]);
retVal.Add(catalogueListByRingNumber);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public static List <CatalogueList> GetCatalogueListData(string connString, string Show_ID)
{
List <CatalogueList> retVal = new List <CatalogueList>();
try
{
CatalogueList catalogue = new CatalogueList(connString);
Guid show_ID = new Guid(Show_ID);
if (catalogue.PopulateCatalogueListByRingNumber(show_ID))
{
retVal = catalogue.GetCatalogueListByRingNumber();
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
protected void btnGetCatalogueList_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Show_ID))
{
divCatalogueList.Visible = true;
CatalogueListByRingNumberList = CatalogueList.GetCatalogueListData(Show_ID);
if (CatalogueListByRingNumberList != null && CatalogueListByRingNumberList.Count > 0)
{
short ring_No = 0;
List<CatalogueList> displayList = new List<CatalogueList>();
CatalogueList displayItem = new CatalogueList();
foreach (CatalogueList row in CatalogueListByRingNumberList)
{
if (row.Ring_No != ring_No && ring_No != 0)
{
//new ring number
CreateDisplayItem(displayItem);
displayList.Add(displayItem);
displayItem = new CatalogueList();
}
//existing ring number
displayItem.Ring_No = row.Ring_No;
displayItem.Owners.Add(row.Owner);
displayItem.Addresses.Add(row.Address);
displayItem.Dog_KC_Name = row.Dog_KC_Name;
displayItem.Dog_Breed_Description = row.Dog_Breed_Description;
displayItem.Dog_Gender = row.Dog_Gender;
displayItem.Date_Of_Birth = row.Date_Of_Birth;
displayItem.Breeders.Add(row.Breeder);
displayItem.Sire = row.Sire;
displayItem.Dam = row.Dam;
displayItem.Class_NameList.Add(row.Class_Name);
displayItem.BreederIsOwner = row.BreederIsOwner;
displayItem.Catalogue = row.Catalogue;
ring_No = row.Ring_No;
}
CreateDisplayItem(displayItem);
displayList.Add(displayItem);
}
}
}
public List<CatalogueList> GetCatalogueListByRingNumber()
{
List<CatalogueList> catalogueListByRingNumbersList = new List<CatalogueList>();
CatalogueListBL catalogueListByRingNumbers = new CatalogueListBL();
tblCatalogueListByRingNumber = catalogueListByRingNumbers.GetCatalogueListByRingNumber();
if (tblCatalogueListByRingNumber != null && tblCatalogueListByRingNumber.Count > 0)
{
foreach (sss.tblCatalogueListByRingNumberRow row in tblCatalogueListByRingNumber)
{
CatalogueList catalogueListByRingNumber = new CatalogueList();
catalogueListByRingNumber.Ring_No = row.Ring_No;
catalogueListByRingNumber.Owner = row.Owner;
catalogueListByRingNumber.Address = row.Address;
catalogueListByRingNumber.Dog_KC_Name = row.Dog_KC_Name;
catalogueListByRingNumber.Dog_Breed_Description = row.Dog_Breed_Description;
catalogueListByRingNumber.Dog_Gender = row.Dog_Gender;
catalogueListByRingNumber.Date_Of_Birth = row.Date_Of_Birth;
catalogueListByRingNumber.Breeder = row.Breeder;
catalogueListByRingNumber.Sire = row.Sire;
catalogueListByRingNumber.Dam = row.Dam;
catalogueListByRingNumber.Class_Name = row.Class_Name;
catalogueListByRingNumber.BreederIsOwner = row.BreederIsOwner;
if (!row.IsCatalogueNull())
{
catalogueListByRingNumber.Catalogue = row.Catalogue;
}
else
{
catalogueListByRingNumber.Catalogue = false;
}
catalogueListByRingNumbersList.Add(catalogueListByRingNumber);
}
}
return catalogueListByRingNumbersList;
}
public static List<CatalogueList> GetCatalogueListData(string Show_ID)
{
List<CatalogueList> catalogueList = new List<CatalogueList>();
CatalogueList catalogue = new CatalogueList();
Guid show_ID = new Guid(Show_ID);
if (catalogue.PopulateCatalogueListByRingNumber(show_ID))
{
catalogueList = catalogue.GetCatalogueListByRingNumber();
}
return catalogueList;
}
private void CreateDisplayItem(CatalogueList displayItem)
{
//TableRow r0 = new TableRow();
//TableCell r0c0 = new TableCell();
//r0c0.Text = string.Empty;
//r0c0.CssClass = "tableCellWidth1";
//r0.Cells.Add(r0c0);
//TableCell r0c2 = new TableCell();
//r0c2.Text = string.Empty;
//r0c2.CssClass = "tableCellWidth2";
//r0.Cells.Add(r0c2);
//TableCell r0c3 = new TableCell();
//r0c3.Text = string.Empty;
//r0c3.CssClass = "tableCellWidth3";
//r0.Cells.Add(r0c3);
//TableCell r0c4 = new TableCell();
//r0c4.Text = string.Empty;
//r0c4.CssClass = "tableCellWidth4";
//r0.Cells.Add(r0c4);
//TableCell r0c5 = new TableCell();
//r0c5.Text = string.Empty;
//r0c5.CssClass = "tableCellWidth5";
//r0.Cells.Add(r0c5);
//TableCell r0c6 = new TableCell();
//r0c6.Text = string.Empty;
//r0c6.CssClass = "tableCellWidth6";
//r0.Cells.Add(r0c6);
//TableCell r0c7 = new TableCell();
//r0c7.Text = string.Empty;
//r0c7.CssClass = "tableCellWidth7";
//r0.Cells.Add(r0c7);
//TableCell r0c8 = new TableCell();
//r0c8.Text = string.Empty;
////r0c8.CssClass = "tableCellWidth8";
//r0.Cells.Add(r0c8);
//tblCatalogueTable.Rows.Add(r0);
TableRow r1 = new TableRow();
TableCell r1c1 = new TableCell();
r1c1.CssClass = "CellBold";
if (displayItem.Catalogue)
{
r1c1.Text = "*";
}
else
{
r1c1.Text = string.Empty;
}
r1.Cells.Add(r1c1);
string ownerList = string.Empty;
foreach (string owner in displayItem.Owners)
{
if (ownerList.IndexOf(owner) == -1)
{
ownerList = string.Format("{0}{1}", ownerList, " & " + owner);
}
}
TableCell r1c2 = new TableCell();
r1c2.ColumnSpan = 2;
r1c2.CssClass = "CellBold";
r1c2.Text = ownerList.Substring(3);
r1.Cells.Add(r1c2);
TableCell r1c3 = new TableCell();
r1c3.ColumnSpan = 5;
r1c3.Text = displayItem.Addresses[0];
r1.Cells.Add(r1c3);
if(displayItem.Owners[0] != PreviousOwner)
tblCatalogueTable.Rows.Add(r1);
PreviousOwner = displayItem.Owners[0];
TableRow r2 = new TableRow();
TableCell r2c1 = new TableCell();
r2c1.CssClass = "CellBold";
r2c1.Text = displayItem.Ring_No.ToString();
r2.Cells.Add(r2c1);
TableCell r2c2 = new TableCell();
r2c2.CssClass = "CellBold";
r2c2.Text = displayItem.Dog_KC_Name;
r2.Cells.Add(r2c2);
TableCell r2c3 = new TableCell();
r2c3.Text = displayItem.Dog_Breed_Description;
r2.Cells.Add(r2c3);
TableCell r2c4 = new TableCell();
r2c4.Text = displayItem.Dog_Gender;
r2.Cells.Add(r2c4);
TableCell r2c5 = new TableCell();
r2c5.Width = 5;
r2c5.Text = displayItem.Date_Of_Birth;
r2.Cells.Add(r2c5);
string breederList = string.Empty;
foreach (string breeder in displayItem.Breeders)
{
if (breederList.IndexOf(breeder) == -1)
{
breederList = string.Format("{0}{1}", breederList, " & " + breeder);
}
}
TableCell r2c6 = new TableCell();
if (displayItem.BreederIsOwner)
{
r2c6.Text = "Owner";
}
else
{
r2c6.Text = breederList.Substring(3);
}
r2.Cells.Add(r2c6);
TableCell r2c7 = new TableCell();
r2c7.Text = displayItem.Sire;
r2.Cells.Add(r2c7);
TableCell r2c8 = new TableCell();
r2c8.Text = displayItem.Dam;
r2.Cells.Add(r2c8);
tblCatalogueTable.Rows.Add(r2);
string classList = string.Empty;
foreach (string className in displayItem.Class_NameList)
{
if (!string.IsNullOrEmpty(className))
{
if (classList.IndexOf(className) == -1)
{
classList = string.Format("{0}{1}", classList, " & " + className);
TableRow r3 = new TableRow();
TableCell r3c1 = new TableCell();
r3c1.ColumnSpan = 8;
r3c1.CssClass = "CellRightBold";
r3c1.Text = className;
r3.Cells.Add(r3c1);
tblCatalogueTable.Rows.Add(r3);
}
}
}
}
