public List <ShowTypes> GetShow_Types()
{
List <ShowTypes> retVal = new List <ShowTypes>();
try
{
ShowTypesBL showTypes = new ShowTypesBL(_connString);
lkpShowTypes = showTypes.GetShow_Types();
if (lkpShowTypes != null && lkpShowTypes.Rows.Count > 0)
{
foreach (DataRow row in lkpShowTypes.Rows)
{
ShowTypes showType = new ShowTypes(_connString, Utils.DBNullToInt(row["Show_Type_ID"]));
retVal.Add(showType);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public ShowTypes(int show_Type_ID)
{
ShowTypesBL showTypes = new ShowTypesBL();
lkpShowTypes = showTypes.GetShow_TypesByShow_Type_ID(show_Type_ID);
Show_Type_ID = show_Type_ID;
Description = lkpShowTypes[0].Show_Type_Description;
}
public ShowTypes(string connString)
{
_connString = connString;
try
{
ShowTypesBL showTypes = new ShowTypesBL(connString);
lkpShowTypes = showTypes.GetShow_Types();
}
catch (Exception ex)
{
throw ex;
}
}
public List<ShowTypes> GetShow_Types()
{
List<ShowTypes> showTypeList = new List<ShowTypes>();
ShowTypesBL showTypes = new ShowTypesBL();
lkpShowTypes = showTypes.GetShow_Types();
if (lkpShowTypes != null && lkpShowTypes.Count > 0)
{
foreach (sss.lkpShow_TypesRow row in lkpShowTypes)
{
ShowTypes showType = new ShowTypes(row.Show_Type_ID);
showTypeList.Add(showType);
}
}
return showTypeList;
}
public ShowTypes(string connString, int show_Type_ID)
{
_connString = connString;
try
{
ShowTypesBL showTypes = new ShowTypesBL(_connString);
lkpShowTypes = showTypes.GetShow_TypesByShow_Type_ID(show_Type_ID);
DataRow row = lkpShowTypes.Rows[0];
_show_Type_ID = show_Type_ID;
_description = Utils.DBNullToString(row["Show_Type_Description"]);
}
catch (Exception ex)
{
throw ex;
}
}
public ShowTypes()
{
ShowTypesBL showTypes = new ShowTypesBL();
lkpShowTypes = showTypes.GetShow_Types();
}