public List <Entrants> GetEntrantsByShow_IDAndDog_ID(Guid show_ID, Guid dog_ID, bool includeLinked)
{
List <Entrants> retVal = new List <Entrants>();
try
{
EntrantsBL entrants = new EntrantsBL(_connString);
tblEntrants = entrants.GetEntrantsByShow_IDAndDog_ID(show_ID, dog_ID, includeLinked);
if (tblEntrants != null && tblEntrants.Rows.Count > 0)
{
foreach (DataRow row in tblEntrants.Rows)
{
Entrants entrant = new Entrants(_connString, Utils.DBNullToGuid(row["Entrant_ID"]));
retVal.Add(entrant);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public Entrants(string connString, Guid entrant_ID)
{
_connString = connString;
try
{
EntrantsBL entrants = new EntrantsBL(_connString);
tblEntrants = entrants.GetEntrantsByEntrant_ID(entrant_ID);
DataRow row = tblEntrants.Rows[0];
_entrant_ID = entrant_ID;
_show_ID = Utils.DBNullToGuid(row["Show_ID"]);
_catalogue = Utils.DBNullToBool(row["Catalogue"]);
_overnight_Camping = Utils.DBNullToBool(row["Overnight_Camping"]);
_overpayment = Utils.DBNullToDec(row["Overpayment"]);
_underpayment = Utils.DBNullToDec(row["Underpayment"]);
_offer_Of_Help = Utils.DBNullToBool(row["Offer_Of_Help"]);
_help_Details = Utils.DBNullToString(row["Help_Details"]);
_withold_Address = Utils.DBNullToBool(row["Withold_Address"]);
_send_Running_Order = Utils.DBNullToBool(row["Send_Running_Order"]);
_entry_Date = Utils.DBNullToDate(row["Entry_Date"]);
}
catch (Exception ex)
{
throw ex;
}
}
public bool Update_Entrant(Guid entrant_ID, Guid user_ID)
{
bool retVal = false;
try
{
EntrantsBL entrants = new EntrantsBL(_connString);
retVal = entrants.Update_Entrants(entrant_ID, _show_ID, _catalogue, _overnight_Camping, _overpayment,
_underpayment, _offer_Of_Help, _help_Details, _withold_Address, _send_Running_Order, _entry_Date, _deleteEntrant, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public Guid?Insert_Entrant(Guid user_ID)
{
Guid?retVal = null;
try
{
EntrantsBL entrants = new EntrantsBL(_connString);
retVal = entrants.Insert_Entrants(_show_ID, _catalogue, _overnight_Camping, _overpayment,
_underpayment, _offer_Of_Help, _help_Details, _withold_Address, _send_Running_Order, _entry_Date, user_ID);
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public Entrants(Guid entrant_ID)
{
EntrantsBL entrants = new EntrantsBL();
tblEntrants = entrants.GetEntrantsByEntrant_ID(entrant_ID);
Entrant_ID = entrant_ID;
if (!tblEntrants[0].IsShow_IDNull())
Show_ID = tblEntrants[0].Show_ID;
if (!tblEntrants[0].IsCatalogueNull())
Catalogue = tblEntrants[0].Catalogue;
else
Catalogue = false;
if (!tblEntrants[0].IsOvernight_CampingNull())
Overnight_Camping = tblEntrants[0].Overnight_Camping;
else
Overnight_Camping = false;
if (!tblEntrants[0].IsOverpaymentNull())
Overpayment = decimal.Parse(tblEntrants[0].Overpayment.ToString("#.00"));
if (!tblEntrants[0].IsUnderpaymentNull())
Underpayment = decimal.Parse(tblEntrants[0].Underpayment.ToString("#.00"));
if (!tblEntrants[0].IsOffer_Of_HelpNull())
Offer_Of_Help = tblEntrants[0].Offer_Of_Help;
else
Offer_Of_Help = false;
if (!tblEntrants[0].IsHelp_DetailsNull())
Help_Details = tblEntrants[0].Help_Details;
if (!tblEntrants[0].IsWithold_AddressNull())
Withold_Address = tblEntrants[0].Withold_Address;
else
Withold_Address = false;
if (!tblEntrants[0].IsSend_Running_OrderNull())
Send_Running_Order = tblEntrants[0].Send_Running_Order;
else
Send_Running_Order = false;
if (!tblEntrants[0].IsEntry_DateNull())
Entry_Date = tblEntrants[0].Entry_Date;
}
public bool Update_Entrant(Guid entrant_ID, Guid user_ID)
{
bool success = false;
EntrantsBL entrants = new EntrantsBL();
success = entrants.Update_Entrants(entrant_ID, Show_ID, Catalogue, Overnight_Camping, Overpayment,
Underpayment, Offer_Of_Help, Help_Details, Withold_Address, Send_Running_Order, Entry_Date, DeleteEntrant, user_ID);
return success;
}
public Guid? Insert_Entrant(Guid user_ID)
{
EntrantsBL entrants = new EntrantsBL();
Guid? newID = (Guid?)entrants.Insert_Entrants(Show_ID, Catalogue, Overnight_Camping, Overpayment,
Underpayment, Offer_Of_Help, Help_Details, Withold_Address, Send_Running_Order, Entry_Date, user_ID);
return newID;
}
public List<Entrants> GetEntrantsByShow_IDAndDog_ID(Guid show_ID, Guid dog_ID, bool includeLinked)
{
List<Entrants> entrantList = new List<Entrants>();
EntrantsBL entrants = new EntrantsBL();
tblEntrants = entrants.GetEntrantsByShow_IDAndDog_ID(show_ID, dog_ID, includeLinked);
if (tblEntrants != null && tblEntrants.Count > 0)
{
foreach (sss.tblEntrantsRow row in tblEntrants)
{
Entrants entrant = new Entrants(row.Entrant_ID);
entrantList.Add(entrant);
}
}
return entrantList;
}