public ShowFinalClasses(string connString, Guid show_Final_Class_ID)
{
_connString = connString;
if (show_Final_Class_ID != new Guid())
{
try
{
ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL(_connString);
tblShowFinalClasses = showfinalclasses.GetShow_Final_ClassByShow_Final_Class_ID(show_Final_Class_ID);
DataRow row = tblShowFinalClasses.Rows[0];
Show_Final_Class_ID = show_Final_Class_ID;
Show_ID = Utils.DBNullToGuid(row["Show_ID"]);
Show_Entry_Class_ID = Utils.DBNullToGuid(row["Show_Entry_Class_ID"]);
Show_Final_Class_Description = Utils.DBNullToString(row["Show_Final_Class_Description"]);
Show_Final_Class_No = Utils.DBNullToShort(row["Show_Final_Class_No"]);
Judge_ID = Utils.DBNullToGuid(row["Judge_ID"]);
Stay_Time = Utils.DBNullToDate(row["Stay_Time"]);
Lunch_Time = Utils.DBNullToDate(row["Lunch_Time"]);
}
catch (Exception ex)
{
throw ex;
}
}
}
public List <ShowFinalClasses> GetSplitClassParts(Guid show_ID)
{
List <ShowFinalClasses> retVal = new List <ShowFinalClasses>();
try
{
ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL(_connString);
tblShowFinalClasses = showfinalclasses.GetSplitClassParts(show_ID);
if (tblShowFinalClasses != null && tblShowFinalClasses.Rows.Count > 0)
{
foreach (DataRow row in tblShowFinalClasses.Rows)
{
ShowFinalClasses showFinalClass = new ShowFinalClasses(_connString, Utils.DBNullToGuid(row["Show_Final_Class_ID"]));
retVal.Add(showFinalClass);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public int DeleteShowFinalClassesByShowEntryClass(Guid show_Entry_Class_ID)
{
int retVal = 0;
try
{
ShowFinalClassesBL showFinalClasses = new ShowFinalClassesBL(_connString);
retVal = showFinalClasses.DeleteShowFinalClassesByShowEntryClass(show_Entry_Class_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public bool Update_Show_Final_Class(Guid show_Final_Class_ID, Guid user_ID)
{
bool retVal = false;
try
{
ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL(_connString);
retVal = showfinalclasses.Update_Show_Final_Classes(show_Final_Class_ID, _show_ID, _show_Entry_Class_ID,
_show_Final_Class_Description, _show_Final_Class_No, _judge_ID, _stay_Time, _lunch_Time, _deleteShowFinalClass, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public Guid?Insert_Show_Final_Class(Guid user_ID)
{
Guid?retVal = null;
try
{
ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL(_connString);
retVal = (Guid?)showfinalclasses.Insert_Show_Final_Classes(_show_ID, _show_Entry_Class_ID,
_show_Final_Class_Description, _show_Final_Class_No, _judge_ID, _stay_Time, _lunch_Time, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public ShowFinalClasses(Guid show_Final_Class_ID)
{
ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL();
tblShowFinalClasses = showfinalclasses.GetShow_Final_ClassByShow_Final_Class_ID(show_Final_Class_ID);
Show_Final_Class_ID = show_Final_Class_ID;
Show_ID = tblShowFinalClasses[0].Show_ID;
if (!tblShowFinalClasses[0].IsShow_Entry_Class_IDNull())
Show_Entry_Class_ID = tblShowFinalClasses[0].Show_Entry_Class_ID;
Show_Final_Class_Description = tblShowFinalClasses[0].Show_Final_Class_Description;
Show_Final_Class_No = tblShowFinalClasses[0].Show_Final_Class_No;
if (!tblShowFinalClasses[0].IsJudge_IDNull())
Judge_ID = tblShowFinalClasses[0].Judge_ID;
if (!tblShowFinalClasses[0].IsStay_TimeNull())
Stay_Time = tblShowFinalClasses[0].Stay_Time;
if (!tblShowFinalClasses[0].IsLunch_TimeNull())
Lunch_Time = tblShowFinalClasses[0].Lunch_Time;
}
public bool Update_Show_Final_Class(Guid show_Final_Class_ID, Guid user_ID)
{
bool success = false;
ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL();
success = showfinalclasses.Update_Show_Final_Classes(show_Final_Class_ID, Show_ID, Show_Entry_Class_ID,
Show_Final_Class_Description, Show_Final_Class_No, Judge_ID, Stay_Time, Lunch_Time, DeleteShowFinalClass, user_ID);
return success;
}
public Guid? Insert_Show_Final_Class(Guid user_ID)
{
ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL();
Guid? newID = (Guid?)showfinalclasses.Insert_Show_Final_Classes(Show_ID, Show_Entry_Class_ID,
Show_Final_Class_Description, Show_Final_Class_No, Judge_ID, Stay_Time, Lunch_Time, user_ID);
return newID;
}
public List<ShowFinalClasses> GetShow_Final_ClassesByShow_ID(Guid show_ID)
{
List<ShowFinalClasses> showFinalClassList = new List<ShowFinalClasses>();
ShowFinalClassesBL showfinalclasses = new ShowFinalClassesBL();
tblShowFinalClasses = showfinalclasses.GetShow_Final_ClassesByShow_ID(show_ID);
if (tblShowFinalClasses != null && tblShowFinalClasses.Count > 0)
{
foreach (sss.tblShow_Final_ClassesRow row in tblShowFinalClasses)
{
ShowFinalClasses showFinalClass = new ShowFinalClasses(row.Show_Final_Class_ID);
showFinalClassList.Add(showFinalClass);
}
}
return showFinalClassList;
}
public int DeleteShowFinalClassesByShowEntryClass(Guid show_Entry_Class_ID)
{
ShowFinalClassesBL showFinalClasses = new ShowFinalClassesBL();
return showFinalClasses.DeleteShowFinalClassesByShowEntryClass(show_Entry_Class_ID);
}