public List <ShowEntryClasses> GetShow_Entry_ClassesByShow_ID(Guid show_ID)
{
List <ShowEntryClasses> retVal = new List <ShowEntryClasses>();
try
{
ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL(_connString);
tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID);
if (tblShowEntryClasses != null && tblShowEntryClasses.Rows.Count > 0)
{
foreach (DataRow row in tblShowEntryClasses.Rows)
{
ShowEntryClasses showEntryClass = new ShowEntryClasses(_connString, Utils.DBNullToGuid(row["Show_Entry_Class_ID"]));
retVal.Add(showEntryClass);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public Guid?Insert_Show_Entry_Class(Guid user_ID)
{
Guid?retVal = null;
try
{
ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL(_connString);
retVal = (Guid?)showEntryClasses.Insert_Show_Entry_Classes(_show_ID, _class_Name_ID, _class_No, _class_Gender, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public ShowEntryClasses(Guid show_Entry_Class_ID)
{
ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL();
tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassByShow_Entry_Class_ID(show_Entry_Class_ID);
Show_Entry_Class_ID = show_Entry_Class_ID;
Show_ID = tblShowEntryClasses[0].Show_ID;
Class_Name_ID = tblShowEntryClasses[0].Class_Name_ID;
if (tblShowEntryClasses[0].Class_Name_Description == "NFC")
IsNFC = true;
if (!tblShowEntryClasses[0].IsClass_NoNull())
Class_No = tblShowEntryClasses[0].Class_No;
if (!tblShowEntryClasses[0].IsGenderNull())
Class_Gender = tblShowEntryClasses[0].Gender;
Class_Name_Description = string.Format("{0} : {1}", Class_No, tblShowEntryClasses[0].Class_Name_Description);
}
public bool Update_Show_Entry_Class(Guid show_Entry_Class_ID, Guid user_ID)
{
bool retVal = false;
try
{
ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL(_connString);
retVal = showEntryClasses.Update_Show_Entry_Classes(show_Entry_Class_ID, _show_ID, _class_Name_ID, _class_No,
_class_Gender, _deleteShowEntryClass, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public ShowEntryClasses GetShowEntryClassByShowAndClassNo(Guid show_ID, int class_No)
{
ShowEntryClasses retVal = null;
try
{
ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL(_connString);
tblShowEntryClasses = showEntryClasses.GetShowEntryClassByShowAndClassNo(show_ID, class_No);
if (tblShowEntryClasses != null && tblShowEntryClasses.Rows.Count > 0)
{
retVal = new ShowEntryClasses(_connString, new Guid(tblShowEntryClasses.Rows[0]["Show_Entry_Class_ID"].ToString()));
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public ShowEntryClasses(string connString, Guid show_Entry_Class_ID)
{
_connString = connString;
try
{
ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL(_connString);
tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassByShow_Entry_Class_ID(show_Entry_Class_ID);
DataRow row = tblShowEntryClasses.Rows[0];
_show_Entry_Class_ID = show_Entry_Class_ID;
_show_ID = Utils.DBNullToGuid(row["Show_ID"]);
_class_Name_ID = Utils.DBNullToInt(row["Class_Name_ID"]);
_isNFC = Utils.DBNullToString(row["Class_Name_Description"]) == "NFC";
_class_No = Utils.DBNullToShort(row["Class_No"]);
_class_Gender = Utils.DBNullToShort(row["Gender"]);
_class_Name_Description = string.Format("{0} : {1}", _class_No, Utils.DBNullToString(row["Class_Name_Description"]));
}
catch (Exception ex)
{
throw ex;
}
}
public bool Update_Show_Entry_Class(Guid show_Entry_Class_ID, Guid user_ID)
{
bool success = false;
ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL();
success = showEntryClasses.Update_Show_Entry_Classes(show_Entry_Class_ID, Show_ID, Class_Name_ID, Class_No,
Class_Gender, DeleteShowEntryClass, user_ID);
return success;
}
public Guid? Insert_Show_Entry_Class(Guid user_ID)
{
ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL();
Guid? newID = (Guid?)showEntryClasses.Insert_Show_Entry_Classes(Show_ID, Class_Name_ID, Class_No, Class_Gender, user_ID);
return newID;
}
public List<ShowEntryClasses> GetShow_Entry_ClassesByShow_ID(Guid show_ID)
{
List<ShowEntryClasses> showEntryClassList = new List<ShowEntryClasses>();
ShowEntryClassesBL showEntryClasses = new ShowEntryClassesBL();
tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID);
if (tblShowEntryClasses != null && tblShowEntryClasses.Count > 0)
{
foreach (sss.tblShow_Entry_ClassesRow row in tblShowEntryClasses)
{
ShowEntryClasses showEntryClass = new ShowEntryClasses(row.Show_Entry_Class_ID);
showEntryClassList.Add(showEntryClass);
}
}
return showEntryClassList;
}