public List <DogClasses> GetDog_ClassesByDog_IDAndShow_Entry_Class_ID(Guid dog_ID, Guid show_Entry_Class_ID) { List <DogClasses> retVal = new List <DogClasses>(); try { DogClassesBL dogClasses = new DogClassesBL(_connString); tblDogClasses = dogClasses.GetDog_ClassesByDog_IDAndShow_Entry_Class_ID(dog_ID, show_Entry_Class_ID); if (tblDogClasses != null && tblDogClasses.Rows.Count > 0) { foreach (DataRow row in tblDogClasses.Rows) { DogClasses dogClass = new DogClasses(_connString, Utils.DBNullToGuid(row["Dog_Class_ID"])); retVal.Add(dogClass); } } } catch (Exception ex) { throw ex; } return(retVal); }
public DogClasses(string connString, Guid dog_Class_ID) { _connString = connString; try { DogClassesBL dogClasses = new DogClassesBL(_connString); tblDogClasses = dogClasses.GetDog_ClassByDog_Class_ID(dog_Class_ID); DataRow row = tblDogClasses.Rows[0]; _dog_Class_ID = dog_Class_ID; _entrant_ID = Utils.DBNullToGuid(row["Entrant_ID"]); _dog_ID = Utils.DBNullToGuid(row["Dog_ID"]); _show_Entry_Class_ID = Utils.DBNullToGuid(row["Show_Entry_Class_ID"]); _preferred_Part = Utils.DBNullToInt(row["Preferred_Part"]); _show_Final_Class_ID = Utils.DBNullToGuid(row["Show_Final_Class_ID"]); _handler_ID = Utils.DBNullToGuid(row["Handler_ID"]); _ring_No = Utils.DBNullToShort(row["Ring_No"]); _running_Order = Utils.DBNullToShort(row["Running_Order"]); _special_Request = Utils.DBNullToString(row["Special_Request"]); if (_show_Entry_Class_ID != null && _show_Entry_Class_ID != new Guid()) { Guid sec_id = new Guid(_show_Entry_Class_ID.ToString()); ShowEntryClasses sec = new ShowEntryClasses(_connString, sec_id); if (sec.IsNFC) { IsNFC = true; } } } catch (Exception ex) { throw ex; } }
public List <DogClasses> GetDog_ClassesByEntrant_ID(Guid entrant_ID, bool excl_NFC) { List <DogClasses> retVal = new List <DogClasses>(); try { DogClassesBL dogClasses = new DogClassesBL(_connString); tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID); if (tblDogClasses != null && tblDogClasses.Rows.Count > 0) { foreach (DataRow row in tblDogClasses.Rows) { DogClasses dogClass = new DogClasses(_connString, Utils.DBNullToGuid(row["Dog_Class_ID"])); if ((excl_NFC && !dogClass.IsNFC) || !excl_NFC) { retVal.Add(dogClass); } } } } catch (Exception ex) { throw ex; } return(retVal); }
public int GetEntryCountByShow_Final_Class_ID(Guid show_Final_Class_ID) { int retVal = 0; try { DogClassesBL dogClasses = new DogClassesBL(_connString); retVal = dogClasses.GetEntryCountByShow_Final_Class_ID(show_Final_Class_ID); } catch (Exception ex) { throw ex; } return(retVal); }
public short GetMaxRunningOrderForClass(Guid show_Final_Class_ID) { short retVal = 0; try { DogClassesBL dogClasses = new DogClassesBL(_connString); retVal = dogClasses.GetMaxRunningOrderForClass(show_Final_Class_ID); } catch (Exception ex) { throw ex; } return(retVal); }
public bool Update_Dog_Class(Guid dog_Class_ID, Guid user_ID) { bool retVal = false; try { DogClassesBL dogClasses = new DogClassesBL(_connString); retVal = dogClasses.Update_Dog_Classes(dog_Class_ID, _entrant_ID, _dog_ID, _show_Entry_Class_ID, _preferred_Part, _show_Final_Class_ID, _handler_ID, _ring_No, _running_Order, _special_Request, _deleteDogClass, user_ID); } catch (Exception ex) { throw ex; } return(retVal); }
public Guid?Insert_Dog_Class(Guid user_ID) { Guid?retVal = null; try { DogClassesBL dogClasses = new DogClassesBL(_connString); retVal = (Guid?)dogClasses.Insert_Dog_Classes(_entrant_ID, _dog_ID, _show_Entry_Class_ID, _preferred_Part, _handler_ID, _special_Request, _running_Order, user_ID); } catch (Exception ex) { throw ex; } return(retVal); }
public DogClasses(Guid dog_Class_ID) { DogClassesBL dogClasses = new DogClassesBL(); tblDogClasses = dogClasses.GetDog_ClassByDog_Class_ID(dog_Class_ID); Dog_Class_ID = dog_Class_ID; IsEntrant_IDNull = tblDogClasses[0].IsEntrant_IDNull(); if (!IsEntrant_IDNull) Entrant_ID = tblDogClasses[0].Entrant_ID; IsDog_IDNull = tblDogClasses[0].IsDog_IDNull(); if (!IsDog_IDNull) Dog_ID = tblDogClasses[0].Dog_ID; IsShow_Entry_Class_IDNull = tblDogClasses[0].IsShow_Entry_Class_IDNull(); if (!IsShow_Entry_Class_IDNull) Show_Entry_Class_ID = tblDogClasses[0].Show_Entry_Class_ID; IsShow_Final_Class_IDNull = tblDogClasses[0].IsShow_Final_Class_IDNull(); if (!IsShow_Final_Class_IDNull) Show_Final_Class_ID = tblDogClasses[0].Show_Final_Class_ID; IsHandler_IDNull = tblDogClasses[0].IsHandler_IDNull(); if (!IsHandler_IDNull) Handler_ID = tblDogClasses[0].Handler_ID; IsRing_NoNull = tblDogClasses[0].IsRing_NoNull(); if (!IsRing_NoNull) Ring_No = tblDogClasses[0].Ring_No; IsRunning_OrderNull = tblDogClasses[0].IsRunning_OrderNull(); if (!IsRunning_OrderNull) Running_Order = tblDogClasses[0].Running_Order; IsSpecial_RequestNull = tblDogClasses[0].IsSpecial_RequestNull(); if (!IsSpecial_RequestNull) Special_Request = tblDogClasses[0].Special_Request; if (Show_Entry_Class_ID != null) { Guid sec_id = new Guid(Show_Entry_Class_ID.ToString()); ShowEntryClasses sec = new ShowEntryClasses(sec_id); if (sec.IsNFC) IsNFC = true; } }
public bool Update_Dog_Class(Guid dog_Class_ID, Guid user_ID) { bool success = false; DogClassesBL dogClasses = new DogClassesBL(); success = dogClasses.Update_Dog_Classes(dog_Class_ID, Entrant_ID, Dog_ID, Show_Entry_Class_ID, Show_Final_Class_ID, Handler_ID, Ring_No, Running_Order, Special_Request, DeleteDogClass, user_ID); return success; }
public Guid? Insert_Dog_Class(Guid user_ID) { DogClassesBL dogClasses = new DogClassesBL(); Guid? newID = (Guid?)dogClasses.Insert_Dog_Classes(Entrant_ID, Dog_ID, Show_Entry_Class_ID, Handler_ID, Special_Request, user_ID); return newID; }
public short GetMaxRunningOrderForClass(Guid show_Final_Class_ID) { short maxRunningOrder = 0; DogClassesBL dogClasses = new DogClassesBL(); maxRunningOrder = dogClasses.GetMaxRunningOrderForClass(show_Final_Class_ID); return maxRunningOrder; }
public int GetEntryCountByShow_Final_Class_ID(Guid show_Final_Class_ID) { int entryCount = 0; DogClassesBL dogClasses = new DogClassesBL(); entryCount = dogClasses.GetEntryCountByShow_Final_Class_ID(show_Final_Class_ID); return entryCount; }
public List<DogClasses> GetDog_ClassesByShow_Final_Class_ID(Guid show_Final_Class_ID) { List<DogClasses> dogClassesList = new List<DogClasses>(); DogClassesBL dogClasses = new DogClassesBL(); tblDogClasses = dogClasses.GetDog_ClassesByShow_Final_Class_ID(show_Final_Class_ID); if (tblDogClasses != null && tblDogClasses.Count > 0) { foreach (sss.tblDog_ClassesRow row in tblDogClasses) { DogClasses dogClass = new DogClasses(row.Dog_Class_ID); dogClassesList.Add(dogClass); } } return dogClassesList; }
public List<DogClasses> GetDog_ClassesByEntrant_ID(Guid entrant_ID, bool excl_NFC) { List<DogClasses> dogClassesList = new List<DogClasses>(); DogClassesBL dogClasses = new DogClassesBL(); tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID); if (tblDogClasses != null && tblDogClasses.Count > 0) { foreach (sss.tblDog_ClassesRow row in tblDogClasses) { DogClasses dogClass = new DogClasses(row.Dog_Class_ID); if ((excl_NFC && !dogClass.IsNFC) || !excl_NFC) dogClassesList.Add(dogClass); } } return dogClassesList; }