public List <ShowHelpers> GetShow_HelpersByShow_ID(Guid show_ID)
{
List <ShowHelpers> retVal = new List <ShowHelpers>();
try
{
ShowHelpersBL showhelpers = new ShowHelpersBL(_connString);
tblShowHelpers = showhelpers.GetShow_HelpersByShow_ID(show_ID);
if (tblShowHelpers != null && tblShowHelpers.Rows.Count > 0)
{
foreach (DataRow row in tblShowHelpers.Rows)
{
ShowHelpers showHelper = new ShowHelpers(_connString, Utils.DBNullToGuid(row["Show_Helper_ID"]));
retVal.Add(showHelper);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public ShowHelpers(Guid show_Helper_ID)
{
ShowHelpersBL showhelpers = new ShowHelpersBL();
tblShowHelpers = showhelpers.GetShow_HelpersByShow_Helper_ID(show_Helper_ID);
Show_Helper_ID = show_Helper_ID;
Show_ID = tblShowHelpers[0].Show_ID;
Person_ID = tblShowHelpers[0].Person_ID;
Show_Role_ID = tblShowHelpers[0].Show_Role_ID;
}
public bool Update_Show_Helper(Guid show_Helper_ID, Guid user_ID)
{
bool retVal = false;
try
{
ShowHelpersBL showhelpers = new ShowHelpersBL(_connString);
retVal = showhelpers.Update_Show_Helpers(show_Helper_ID, _show_ID, _person_ID, _show_Role_ID, _deleteShowHelper, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public Guid?Insert_Show_Helper(Guid user_ID)
{
Guid?retVal = null;
try
{
ShowHelpersBL showhelpers = new ShowHelpersBL(_connString);
retVal = (Guid?)showhelpers.Insert_Show_Helpers(_show_ID, _person_ID, _show_Role_ID, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public List<ShowHelpers> GetShow_HelpersByShow_ID(Guid show_ID)
{
List<ShowHelpers> showHelperList = new List<ShowHelpers>();
ShowHelpersBL showhelpers = new ShowHelpersBL();
tblShowHelpers = showhelpers.GetShow_HelpersByShow_ID(show_ID);
if (tblShowHelpers != null && tblShowHelpers.Count > 0)
{
foreach (sss.tblShow_HelpersRow row in tblShowHelpers)
{
ShowHelpers showHelper = new ShowHelpers(row.Show_Helper_ID);
showHelperList.Add(showHelper);
}
}
return showHelperList;
}
public ShowHelpers(string connString, Guid show_Helper_ID)
{
_connString = connString;
try
{
ShowHelpersBL showhelpers = new ShowHelpersBL(_connString);
tblShowHelpers = showhelpers.GetShow_HelpersByShow_Helper_ID(show_Helper_ID);
DataRow row = tblShowHelpers.Rows[0];
_show_Helper_ID = show_Helper_ID;
_show_ID = Utils.DBNullToGuid(row["Show_ID"]);
_person_ID = Utils.DBNullToGuid(row["Person_ID"]);
_show_Role_ID = Utils.DBNullToInt(row["Show_Role_ID"]);
}
catch (Exception ex)
{
throw ex;
}
}
public Guid? Insert_Show_Helper(Guid user_ID)
{
ShowHelpersBL showhelpers = new ShowHelpersBL();
Guid? newID = (Guid?)showhelpers.Insert_Show_Helpers(Show_ID, Person_ID, Show_Role_ID, user_ID);
return newID;
}
public bool Update_Show_Helper(Guid show_Helper_ID, Guid user_ID)
{
bool success = false;
ShowHelpersBL showhelpers = new ShowHelpersBL();
success = showhelpers.Update_Show_Helpers(show_Helper_ID, Show_ID, Person_ID, Show_Role_ID, DeleteShowHelper, user_ID);
return success;
}