public List <LinkedShows> GetLinked_Shows()
{
List <LinkedShows> retVal = new List <LinkedShows>();
try
{
LinkedShowsBL linkedShows = new LinkedShowsBL(_connString);
lnkLinkedShows = linkedShows.GetLinked_Shows();
if (lnkLinkedShows != null && lnkLinkedShows.Rows.Count > 0)
{
foreach (DataRow row in lnkLinkedShows.Rows)
{
LinkedShows linkedShow = new LinkedShows(_connString, Utils.DBNullToGuid(row["Linked_Show_ID"]));
retVal.Add(linkedShow);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public LinkedShows(Guid linked_Show_ID)
{
LinkedShowsBL linkedShows = new LinkedShowsBL();
lnkLinkedShows = linkedShows.GetLinked_ShowByLinked_Show_ID(linked_Show_ID);
Linked_Show_ID = linked_Show_ID;
Parent_Show_ID = lnkLinkedShows[0].Parent_Show_ID;
Child_Show_ID = lnkLinkedShows[0].Child_Show_ID;
}
public bool Update_Linked_Shows(Guid original_ID, Guid user_ID)
{
bool retVal = false;
try
{
LinkedShowsBL linkedShows = new LinkedShowsBL(_connString);
retVal = linkedShows.Update_Linked_Shows(original_ID, _parent_Show_ID, _child_Show_ID, _deleteLinkedShow, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public Guid?Insert_Linked_Shows(Guid user_ID)
{
Guid?retVal = null;
try
{
LinkedShowsBL linkedShows = new LinkedShowsBL(_connString);
retVal = linkedShows.Insert_Linked_Shows(_parent_Show_ID, _child_Show_ID, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public LinkedShows(string connString, Guid linked_Show_ID)
{
_connString = connString;
try
{
LinkedShowsBL linkedShows = new LinkedShowsBL(_connString);
lnkLinkedShows = linkedShows.GetLinked_ShowByLinked_Show_ID(linked_Show_ID);
DataRow row = lnkLinkedShows.Rows[0];
_linked_Show_ID = linked_Show_ID;
_parent_Show_ID = Utils.DBNullToGuid(row["Parent_Show_ID"]);
_child_Show_ID = Utils.DBNullToGuid(row["Child_Show_ID"]);
}
catch (Exception ex)
{
throw ex;
}
}
public List<LinkedShows> GetLinked_Shows()
{
List<LinkedShows> linkedShowList = new List<LinkedShows>();
LinkedShowsBL linkedShows = new LinkedShowsBL();
lnkLinkedShows = linkedShows.GetLinked_Shows();
if (lnkLinkedShows != null && lnkLinkedShows.Count > 0)
{
foreach (sss.lnkLinked_ShowsRow row in lnkLinkedShows)
{
LinkedShows linkedShow = new LinkedShows(row.Linked_Show_ID);
linkedShowList.Add(linkedShow);
}
}
return linkedShowList;
}
public bool Update_Linked_Shows(Guid original_ID, Guid user_ID)
{
bool success = false;
LinkedShowsBL linkedShows = new LinkedShowsBL();
success = linkedShows.Update_Linked_Shows(original_ID, Parent_Show_ID, Child_Show_ID, DeleteLinkedShow, user_ID);
return success;
}
public Guid? Insert_Linked_Shows(Guid user_ID)
{
LinkedShowsBL linkedShows = new LinkedShowsBL();
Guid? newID = linkedShows.Insert_Linked_Shows(Parent_Show_ID, Child_Show_ID, user_ID);
return newID;
}