private void PopulateListBoxes()
{
List <DogClasses> tblDogClasses;
DogClasses dogClasses = new DogClasses(_connString);
Guid entrant_ID = new Guid(Entrant_ID);
tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
List <Dogs> dogs = new List <Dogs>();
foreach (DogClasses row in tblDogClasses)
{
Dogs dog = new Dogs(_connString, (Guid)row.Dog_ID);
Dogs dg = dogs.Find(delegate(Dogs d) { return(d.Dog_ID == row.Dog_ID); });
if (dg == null)
{
dogs.Add(dog);
}
}
lstDogs.DataSource = dogs;
lstDogs.DataBind();
if (!string.IsNullOrEmpty(Show_ID))
{
Guid show_ID = new Guid(Show_ID);
ShowEntryClasses showEntryClasses = new ShowEntryClasses(_connString);
List <ShowEntryClasses> tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID);
lstClasses.DataSource = tblShowEntryClasses;
lstClasses.DataBind();
}
}
private bool IsCorrectClassGender(Dogs dog)
{
bool correctGender = false;
ShowEntryClasses sec = new ShowEntryClasses(_connString, new Guid(Show_Entry_Class_ID));
DogGender dg = new DogGender(_connString, (int)dog.Dog_Gender_ID);
switch (dg.Description)
{
case "Dog":
if (sec.Class_Gender == Constants.CLASS_GENDER_DB || sec.Class_Gender == Constants.CLASS_GENDER_D)
{
correctGender = true;
}
break;
case "Bitch":
if (sec.Class_Gender == Constants.CLASS_GENDER_DB || sec.Class_Gender == Constants.CLASS_GENDER_B)
{
correctGender = true;
}
break;
default:
break;
}
return(correctGender);
}
protected void btnCommit_Click(object sender, EventArgs e)
{
FinalClassNameList = SplitClasses.DisplayFinalClassNames(_connString);
StoreCommon();
if (FinalClassNameList != null && FinalClassNameList.Count > 0)
{
MembershipUser userInfo = Membership.GetUser();
Guid user_ID = (Guid)userInfo.ProviderUserKey;
ClearFinalClassNames();
foreach (FinalClassNames finalClassName in FinalClassNameList)
{
Guid? show_Final_Class_ID = null;
ShowEntryClasses showEntryClass = new ShowEntryClasses(_connString, finalClassName.Show_Entry_Class_ID);
ShowFinalClasses showFinalClass = new ShowFinalClasses(_connString);
showFinalClass.Show_ID = showEntryClass.Show_ID;
showFinalClass.Show_Entry_Class_ID = showEntryClass.Show_Entry_Class_ID;
showFinalClass.Show_Final_Class_Description = finalClassName.Show_Final_Class_Description;
showFinalClass.Show_Final_Class_No = finalClassName.OrderBy;
show_Final_Class_ID = showFinalClass.Insert_Show_Final_Class(user_ID);
if (show_Final_Class_ID == null)
{
MessageLabel.Text = "Show Final Class Insert Failed!";
break;
}
else
{
MessageLabel.Text = "Show Final Class Insert Successful.";
}
}
}
}
private string GetClassName(Guid show_Entry_Class_ID)
{
ShowEntryClasses sec = new ShowEntryClasses(_connString, show_Entry_Class_ID);
ClassNames cn = new ClassNames(_connString, (int)sec.Class_Name_ID);
return(cn.Description);
}
private void PopulateDogClassGridView()
{
List <DogClasses> tblDogClasses;
DogClasses dogClasses = new DogClasses(_connString);
Guid entrant_ID = new Guid(Entrant_ID);
tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
List <DogClasses> dogClassList = new List <DogClasses>();
foreach (DogClasses row in tblDogClasses)
{
if (row.Show_Entry_Class_ID != null && row.Show_Entry_Class_ID != new Guid())
{
DogClasses dogClass = new DogClasses(_connString, (Guid)row.Dog_Class_ID);
Dogs dog = new Dogs(_connString, (Guid)row.Dog_ID);
dogClass.Dog_Class_ID = row.Dog_Class_ID;
dogClass.Dog_KC_Name = dog.Dog_KC_Name;
ShowEntryClasses showEntryClass = new ShowEntryClasses(_connString, (Guid)row.Show_Entry_Class_ID);
ClassNames className = new ClassNames(_connString, Int32.Parse(showEntryClass.Class_Name_ID.ToString()));
dogClass.Class_Name_Description = string.Format("{0} : {1}", showEntryClass.Class_No, className.Description);
if (!row.IsHandler_IDNull && row.Handler_ID != new Guid())
{
People handler = new People(_connString, (Guid)row.Handler_ID);
dogClass.Handler_Name = string.Format("{0} {1}", handler.Person_Forename, handler.Person_Surname);
}
dogClassList.Add(dogClass);
}
}
if (dogClassList != null)
{
DogClassGridView.DataSource = dogClassList;
DogClassGridView.DataBind();
}
}
private void btnCommitSplitClasses_Click(object sender, EventArgs e)
{
FinalClassNames finalClassNames = new FinalClassNames(_connString);
List <FinalClassNames> finalClassNameList = finalClassNames.GetFinalClassNames();
if (finalClassNameList != null && finalClassNameList.Count > 0)
{
ClearFinalClassNames(finalClassNameList);
foreach (FinalClassNames finalClassName in finalClassNameList)
{
Guid? show_Final_Class_ID = null;
ShowEntryClasses showEntryClass = new ShowEntryClasses(_connString, finalClassName.Show_Entry_Class_ID);
ShowFinalClasses showFinalClass = new ShowFinalClasses(_connString);
showFinalClass.Show_ID = showEntryClass.Show_ID;
showFinalClass.Show_Entry_Class_ID = showEntryClass.Show_Entry_Class_ID;
showFinalClass.Show_Final_Class_Description = finalClassName.Show_Final_Class_Description;
showFinalClass.Show_Final_Class_No = finalClassName.OrderBy;
show_Final_Class_ID = showFinalClass.Insert_Show_Final_Class(_user_ID);
if (show_Final_Class_ID == null)
{
MessageLabel.Text = "Show Final Class Insert Failed!";
break;
}
else
{
MessageLabel.Text = "Show Final Class Insert Successful.";
}
}
}
}
private void PopulateShowClass()
{
ShowEntryClasses showEntryClass = new ShowEntryClasses(_connString, _showClassID);
PopulateClassNames(int.Parse(showEntryClass.Class_Name_ID.ToString()));
numClassNumber.Value = decimal.Parse(showEntryClass.Class_No.ToString());
PopulateClassGenders((short)showEntryClass.Class_Gender);
}
protected void ClassGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
MembershipUser userInfo = Membership.GetUser();
Guid user_ID = (Guid)userInfo.ProviderUserKey;
string sec_id = ClassGridView.DataKeys[e.RowIndex]["Show_Entry_Class_ID"].ToString();
Guid Show_Entry_Class_ID = new Guid(sec_id);
ShowEntryClasses showEntryClasses = new ShowEntryClasses(_connString);
showEntryClasses.DeleteShowEntryClass = true;
if (showEntryClasses.Update_Show_Entry_Class(Show_Entry_Class_ID, user_ID))
{
PopulateClassGridview(Show_ID);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
bool valid = true;
if (cboClassNames.SelectedIndex == -1 || cboClassNames.SelectedIndex == 0)
{
MessageLabel.Text = "You must select a Class Name";
valid = false;
}
else if (numClassNumber.Value == -1)
{
MessageLabel.Text = "You must enter a Class Number";
valid = false;
}
else if (cboClassGender.SelectedIndex == -1 || cboClassGender.SelectedIndex == 0)
{
MessageLabel.Text = "You must select a Class Gender";
valid = false;
}
if (valid)
{
int class_Name_ID = Convert.ToInt32((cboClassNames.SelectedItem as ComboBoxItem).Value.ToString());
short class_No = Convert.ToInt16(numClassNumber.Value.ToString());
short class_Gender = Convert.ToInt16((cboClassGender.SelectedItem as ComboBoxItem).Value.ToString());
ShowEntryClasses showEntryClasses = new ShowEntryClasses(_connString);
showEntryClasses.Show_ID = _showID;
showEntryClasses.Class_Name_ID = class_Name_ID;
showEntryClasses.Class_No = class_No;
showEntryClasses.Class_Gender = class_Gender;
if (_showClassID == new Guid())
{
Guid?show_Entry_Class_ID = showEntryClasses.Insert_Show_Entry_Class(_user_ID);
if (show_Entry_Class_ID != null)
{
MessageLabel.Text = "The Class Name was added successfully";
}
}
else
{
if (showEntryClasses.Update_Show_Entry_Class(_showClassID, _user_ID))
{
MessageLabel.Text = "The Class Name was saved successfully";
}
}
}
}
private void PopulateClasses()
{
cboShowClasses.Items.Clear();
ShowEntryClasses showEntryClasses = new ShowEntryClasses(Utils.ConnectionString());
List <ShowEntryClasses> showEntryClassList = showEntryClasses.GetShow_Entry_ClassesByShow_ID(_showID);
ComboBoxItem item = null;
foreach (ShowEntryClasses sec in showEntryClassList)
{
item = new ComboBoxItem();
item.Text = sec.Class_Name_Description;
item.Value = sec.Show_Entry_Class_ID;
cboShowClasses.Items.Add(item);
}
}
protected void DogGridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string Dog_ID = ((HiddenField)e.Row.FindControl("hdnID")).Value;
GridView gvClasses = e.Row.FindControl("ClassGridView") as GridView;
List <DogClasses> tblDog_Classes;
DogClasses dogClasses = new DogClasses(_connString);
if (!string.IsNullOrEmpty(Entrant_ID) && !string.IsNullOrEmpty(Dog_ID))
{
Guid entrant_ID = new Guid(Entrant_ID);
Guid dog_ID = new Guid(Dog_ID);
tblDog_Classes = dogClasses.GetDog_ClassesByEntrant_ID_Dog_ID(entrant_ID, dog_ID);
if (tblDog_Classes != null && tblDog_Classes.Count > 0)
{
List <DogClasses> dogClassList = new List <DogClasses>();
foreach (DogClasses row in tblDog_Classes)
{
if (!row.IsShow_Entry_Class_IDNull && row.Show_Entry_Class_ID != new Guid())
{
DogClasses dogClass = new DogClasses(_connString, (Guid)row.Dog_Class_ID);
Dogs dog = new Dogs(_connString, (Guid)row.Dog_ID);
dogClass.Dog_Class_ID = row.Dog_Class_ID;
dogClass.Dog_KC_Name = dog.Dog_KC_Name;
ShowEntryClasses showEntryClass = new ShowEntryClasses(_connString, (Guid)row.Show_Entry_Class_ID);
ClassNames className = new ClassNames(_connString, Int32.Parse(showEntryClass.Class_Name_ID.ToString()));
dogClass.Class_Name_Description = string.Format("{0} : {1}", showEntryClass.Class_No, className.Description);
if (!row.IsHandler_IDNull && row.Handler_ID != new Guid())
{
People handler = new People(_connString, (Guid)row.Handler_ID);
dogClass.Handler_Name = string.Format("{0} {1}", handler.Person_Forename, handler.Person_Surname);
}
dogClassList.Add(dogClass);
}
}
if (dogClassList != null)
{
gvClasses.DataSource = dogClassList;
gvClasses.DataBind();
}
}
}
}
}
private void PopulateClassList(string Show_ID)
{
if (!string.IsNullOrEmpty(Show_ID))
{
Guid show_ID = new Guid(Show_ID);
ShowEntryClasses showEntryClasses = new ShowEntryClasses(_connString);
List <ShowEntryClasses> tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassesByShow_ID(show_ID);
List <ShowEntryClasses> classList = new List <ShowEntryClasses>();
ShowEntryClasses allClasses = new ShowEntryClasses(_connString);
allClasses.Class_Name_Description = "All Classes";
allClasses.Show_Entry_Class_ID = new Guid();
classList.Add(allClasses);
foreach (ShowEntryClasses row in tblShowEntryClasses)
{
classList.Add(row);
}
lstClasses.DataSource = classList;
lstClasses.DataBind();
}
}
private void PopulateClassGridview(string show_ID)
{
bool valid = false;
if (!string.IsNullOrEmpty(show_ID))
{
valid = true;
}
if (valid)
{
if (!string.IsNullOrEmpty(show_ID))
{
Guid newShow_ID = new Guid(show_ID);
ShowEntryClasses showEntryClasses = new ShowEntryClasses(_connString);
List <ShowEntryClasses> tblShowEntryClasses;
tblShowEntryClasses = showEntryClasses.GetShow_Entry_ClassesByShow_ID(newShow_ID);
ClassGridView.DataSource = tblShowEntryClasses;
ClassGridView.DataBind();
}
}
divClassList.Visible = valid;
}
private void EditEntryClass()
{
cboNewValue = new ComboBox();
cboNewValue.Width = panel1.Width;
panel1.Controls.Add(cboNewValue);
dog = new Dogs(_connString, new Guid(_dogID));
dogClass = new DogClasses(_connString, new Guid(_dogClassID));
ShowEntryClasses sec = new ShowEntryClasses(_connString);
List <ShowEntryClasses> secList = sec.GetShow_Entry_ClassesByShow_ID(new Guid(_showID));
foreach (ShowEntryClasses showEntryClass in secList)
{
ClassNames cn = new ClassNames(_connString, (int)showEntryClass.Class_Name_ID);
ComboBoxItem item = new ComboBoxItem();
item.Text = cn.Description;
item.Value = showEntryClass.Show_Entry_Class_ID;
cboNewValue.Items.Add(item);
if (dogClass.Show_Entry_Class_ID == showEntryClass.Show_Entry_Class_ID)
{
lblCurrentValue.Text = cn.Description;
lblCurrentValue.Visible = true;
}
}
}
private void PopulateDogClassesGrid(string entrantID)
{
string connString = Utils.ConnectionString();
Guid entrant_ID = new Guid(entrantID);
DogClasses dogClasses = new DogClasses(connString);
List <DogClasses> dcList = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
DataTable dt = new DataTable();
DataColumn dcDogClassID = new DataColumn("DogClassID");
DataColumn dcEntrantID = new DataColumn("EntrantID");
DataColumn dcDogID = new DataColumn("DogID");
DataColumn dcKCName = new DataColumn("KCName");
DataColumn dcBreed = new DataColumn("Breed");
DataColumn dcGender = new DataColumn("Gender");
DataColumn dcRegNo = new DataColumn("RegNo");
DataColumn dcDOB = new DataColumn("DOB");
DataColumn dcMeritPoints = new DataColumn("MeritPoints");
DataColumn dcBreeder = new DataColumn("Breeder");
DataColumn dcSire = new DataColumn("Sire");
DataColumn dcDam = new DataColumn("Dam");
DataColumn dcEntryClassName = new DataColumn("EntryClassName");
DataColumn dcPreferredPart = new DataColumn("PreferredPart");
DataColumn dcFinalClassName = new DataColumn("FinalClassName");
DataColumn dcHandler = new DataColumn("Handler");
DataColumn dcRingNo = new DataColumn("RingNo");
DataColumn dcRunningOrder = new DataColumn("RunningOrder");
DataColumn dcSpecialRequest = new DataColumn("SpecialRequest");
dt.Columns.Add(dcDogClassID);
dt.Columns.Add(dcEntrantID);
dt.Columns.Add(dcDogID);
dt.Columns.Add(dcKCName);
dt.Columns.Add(dcBreed);
dt.Columns.Add(dcGender);
dt.Columns.Add(dcRegNo);
dt.Columns.Add(dcDOB);
dt.Columns.Add(dcMeritPoints);
dt.Columns.Add(dcBreeder);
dt.Columns.Add(dcSire);
dt.Columns.Add(dcDam);
dt.Columns.Add(dcEntryClassName);
dt.Columns.Add(dcPreferredPart);
dt.Columns.Add(dcFinalClassName);
dt.Columns.Add(dcHandler);
dt.Columns.Add(dcRingNo);
dt.Columns.Add(dcRunningOrder);
dt.Columns.Add(dcSpecialRequest);
object[] dogRow = new object[19];
foreach (DogClasses dc in dcList)
{
Dogs dog = new Dogs(connString, (Guid)dc.Dog_ID);
ShowEntryClasses sec = new ShowEntryClasses(connString, (Guid)dc.Show_Entry_Class_ID);
ClassNames cn = new ClassNames(connString, (int)sec.Class_Name_ID);
DogBreeds db = new DogBreeds(connString, (int)dog.Dog_Breed_ID);
DogGender dg = new DogGender(connString, (int)dog.Dog_Gender_ID);
dogRow[0] = dc.Dog_Class_ID;
dogRow[1] = entrant_ID;
dogRow[2] = dog.Dog_ID;
dogRow[3] = dog.Dog_KC_Name;
dogRow[4] = db.Description;
dogRow[5] = dg.Description;
dogRow[6] = dog.Reg_No;
DateTime DOB = (DateTime)dog.Date_Of_Birth;
dogRow[7] = string.Format("{0}/{1}/{2}", DOB.Day, DOB.Month, DOB.Year);
dogRow[8] = dog.Merit_Points;
dogRow[9] = dog.Breeder;
dogRow[10] = dog.Sire;
dogRow[11] = dog.Dam;
dogRow[12] = string.Concat(sec.Class_No, " - ", cn.Class_Name_Description);
dogRow[13] = dc.Preferred_Part.ToString();
if (dc.Show_Final_Class_ID != null && dc.Show_Final_Class_ID != new Guid())
{
ShowFinalClasses sfc = new ShowFinalClasses(connString, (Guid)dc.Show_Final_Class_ID);
dogRow[14] = sfc.Show_Final_Class_Description;
}
else
{
dogRow[14] = "Not Yet Assigned";
}
People handler = new People(connString, (Guid)dc.Handler_ID);
dogRow[15] = handler.Person_FullName;
dogRow[16] = string.IsNullOrWhiteSpace(dc.Ring_No.ToString()) ? "Not Yet Assigned" : dc.Ring_No.ToString();
dogRow[17] = string.IsNullOrWhiteSpace(dc.Running_Order.ToString()) ? "Not Yet Assigned" : dc.Running_Order.ToString();
dogRow[18] = dc.Special_Request;
dt.Rows.Add(dogRow);
}
dgvDogClasses.DataSource = dt;
dgvDogClasses.Columns["DogClassID"].Visible = false;
dgvDogClasses.Columns["EntrantID"].Visible = false;
dgvDogClasses.Columns["DogID"].Visible = false;
//dgvDogClasses.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
//dgvDogClasses.AutoSize = true;
}
protected void btnAddDogClass_Click(object sender, EventArgs e)
{
GetFormFields();
StoreCommon();
if (ValidEntry())
{
MembershipUser userInfo = Membership.GetUser();
Guid user_ID = (Guid)userInfo.ProviderUserKey;
List <DogClasses> tblDogClasses;
DogClasses dogClasses = new DogClasses(_connString);
Guid dog_ID = new Guid(Dog_ID);
Guid show_Entry_Class_ID = new Guid(Show_Entry_Class_ID);
Guid entrant_ID = new Guid(Entrant_ID);
tblDogClasses = dogClasses.GetDog_ClassesByEntrant_ID(entrant_ID);
bool rowUpdated = false;
bool success = false;
foreach (DogClasses row in tblDogClasses)
{
if (dog_ID == row.Dog_ID && !rowUpdated)
{
if (row.IsShow_Entry_Class_IDNull || (!row.IsShow_Entry_Class_IDNull && row.Show_Entry_Class_ID == show_Entry_Class_ID))
{
Dog_Class_ID = row.Dog_Class_ID.ToString();
Guid dog_Class_ID = new Guid(Dog_Class_ID);
DogClasses dogClass = new DogClasses(_connString, dog_Class_ID);
dogClass.Show_Entry_Class_ID = show_Entry_Class_ID;
if (!string.IsNullOrEmpty(Special_Request))
{
dogClass.Special_Request = Special_Request;
}
if (!string.IsNullOrEmpty(Handler_ID))
{
if (GetClassName(show_Entry_Class_ID) != "NFC")
{
Guid handler_ID = new Guid(Handler_ID);
dogClass.Handler_ID = handler_ID;
}
}
dogClass.DeleteDogClass = false;
if (dogClass.Update_Dog_Class(dog_Class_ID, user_ID))
{
rowUpdated = true;
success = true;
}
}
}
}
if (!rowUpdated)
{
DogClasses dogClass = new DogClasses(_connString);
dogClass.Entrant_ID = entrant_ID;
dogClass.Dog_ID = dog_ID;
dogClass.Show_Entry_Class_ID = show_Entry_Class_ID;
if (!string.IsNullOrEmpty(Special_Request))
{
dogClass.Special_Request = Special_Request;
}
if (!string.IsNullOrEmpty(Handler_ID))
{
if (GetClassName(show_Entry_Class_ID) != "NFC")
{
Guid handler_ID = new Guid(Handler_ID);
dogClass.Handler_ID = handler_ID;
}
}
Guid?dog_Class_ID = new Guid?();
dog_Class_ID = dogClass.Insert_Dog_Class(user_ID);
if (dog_Class_ID != null)
{
success = true;
}
}
if (success)
{
ShowEntryClasses showEntryClass = new ShowEntryClasses(_connString, show_Entry_Class_ID);
int class_Name_ID = Int32.Parse(showEntryClass.Class_Name_ID.ToString());
ClassNames className = new ClassNames(_connString, class_Name_ID);
string class_Name_Description = className.Description;
Dogs dog = new Dogs(_connString, dog_ID);
MessageLabel.Text = string.Format("{0} was successfully added to {1}.", dog.Dog_KC_Name, class_Name_Description);
PopulateDogClassGridView();
ClearFormFields();
}
}
}
protected void btnAddClass_Click(object sender, EventArgs e)
{
bool valid = true;
if (string.IsNullOrEmpty(Club_ID))
{
MessageLabel.Text = "You must specify the Club";
}
else if (string.IsNullOrEmpty(Show_ID))
{
MessageLabel.Text = "You must specify the Show";
valid = false;
}
else if (lstClassNames.SelectedIndex == -1 || lstClassNames.SelectedIndex == 0)
{
MessageLabel.Text = "You must select a Class Name";
valid = false;
}
else if (string.IsNullOrEmpty(txtClassNo.Text))
{
MessageLabel.Text = "You must enter a Class Number";
valid = false;
}
else if (lstClassGender.SelectedIndex == -1 || lstClassGender.SelectedIndex == 0)
{
MessageLabel.Text = "You must select a Class Gender";
valid = false;
}
if (valid)
{
MembershipUser userInfo = Membership.GetUser();
Guid user_ID = (Guid)userInfo.ProviderUserKey;
if (string.IsNullOrEmpty(Class_Name_ID))
{
Class_Name_ID = lstClassNames.SelectedValue;
}
if (string.IsNullOrEmpty(Class_No))
{
Class_No = txtClassNo.Text;
}
if (string.IsNullOrEmpty(Class_Gender))
{
Class_Gender = lstClassGender.SelectedValue;
}
Guid show_ID = new Guid(Show_ID);
int class_Name_ID = Convert.ToInt32(Class_Name_ID);
short class_No = Convert.ToInt16(Class_No);
short class_Gender = Convert.ToInt16(Class_Gender);
ShowEntryClasses showEntryClasses = new ShowEntryClasses(_connString);
showEntryClasses.Show_ID = show_ID;
showEntryClasses.Class_Name_ID = class_Name_ID;
showEntryClasses.Class_No = class_No;
showEntryClasses.Class_Gender = class_Gender;
Guid?show_Entry_Class_ID = showEntryClasses.Insert_Show_Entry_Class(user_ID);
if (show_Entry_Class_ID != null)
{
Show_Entry_Class_ID = show_Entry_Class_ID.ToString();
Common.Show_Entry_Class_ID = Show_Entry_Class_ID;
MessageLabel.Text = "The Class Name was added successfully";
ClearEntryFields();
PopulateClassGridview(Show_ID);
if (!string.IsNullOrEmpty(btnReturn.PostBackUrl))
{
DivReturn.Visible = true;
divAddClasses.Visible = true;
}
}
}
}
private bool AddDogToClass(ExcelDataItem item)
{
bool ok = true;
ShowEntryClasses showEntryClasses = new ShowEntryClasses(Utils.ConnectionString());
ShowEntryClasses sec = showEntryClasses.GetShowEntryClassByShowAndClassNo(show_ID, item.Entered_Class);
Judges judges = new Judges(Utils.ConnectionString(), sec.Show_Entry_Class_ID);
if (sec != null)
{
dogClassCount++;
if (dog_ID == prev_Dog_ID)
{
if (dogClassCount > dogClassMax)
{
Utils.LogToFile("Maximum number of classes would be exceeded");
ok = false;
}
}
else
{
dogClassCount = 1;
}
if (ok)
{
if (CorrectGenderForClass(sec.Class_Gender, item.Sex))
{
showEntryClassID = sec.Show_Entry_Class_ID;
DogClasses dc = new DogClasses(Utils.ConnectionString());
List <DogClasses> dcList = dc.GetDog_ClassesByDog_IDAndShow_Entry_Class_ID(dog_ID, showEntryClassID);
if (dcList.Count > 0)
{
Utils.LogToFile("Dog already entered in this class.");
ok = false;
}
else
{
dc.Entrant_ID = entrant_ID;
dc.Dog_ID = dog_ID;
dc.Show_Entry_Class_ID = showEntryClassID;
if (!string.IsNullOrEmpty(item.Preferred_Judge))
{
dc.Preferred_Part = GetPreferredPart(judges, item.Preferred_Judge);
}
dc.Handler_ID = owner_ID;
dc.Special_Request = item.Notes_To_Organiser;
dc.Running_Order = item.RunningOrder;
Guid?dogClassID = dc.Insert_Dog_Class(user_ID);
if (dogClassID == null)
{
Utils.LogToFile("Failed to insert to tblDogClasses");
ok = false;
}
}
}
else
{
Utils.LogToFile("Incorrect gender for class");
ok = false;
}
}
}
else
{
Utils.LogToFile("Unable to get Show Entry Class by Show ID and Class No.");
ok = false;
}
if (!ok)
{
string msg = string.Format("Unable to add {0} ({1}) to class {2}", item.Registered_Name, item.Registered_Number, (sec != null) ? sec.Class_Name_Description : item.Entered_Class.ToString());
Utils.LogToFile(msg);
}
return(ok);
}
