public List <DogBreeders> GetDogBreedersByBreeder_ID(Guid breeder_ID)
{
List <DogBreeders> dogBreederList = new List <DogBreeders>();
try
{
DogBreedersBL dogBreeders = new DogBreedersBL(_connString);
lnkDogBreeders = dogBreeders.GetDog_BreedersByBreeder_ID(breeder_ID);
if (lnkDogBreeders != null && lnkDogBreeders.Rows.Count > 0)
{
foreach (DataRow row in lnkDogBreeders.Rows)
{
DogBreeders dogBreeder = new DogBreeders(_connString, Utils.DBNullToGuid(row["Dog_Breeder_ID"]));
dogBreederList.Add(dogBreeder);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(dogBreederList);
}
private void PopulateBreederList()
{
bool foundBreeder = false;
Guid dog_ID = new Guid(Current_Dog_ID);
List<DogBreeders> lnkDogBreeders;
DogBreeders dogBreeders = new DogBreeders();
lnkDogBreeders = dogBreeders.GetDogBreedersByDog_ID(dog_ID);
foreach(DogBreeders row in lnkDogBreeders)
{
AddBreederToList(row.Breeder_ID.ToString());
foundBreeder = true;
}
if (foundBreeder)
divBreederList.Visible = true;
}
private bool InsertDogBreeders(Guid dog_ID, Guid user_ID)
{
bool insertOK = true;
for (int i = 0; i < Common.DogBreederList.Count; i++)
{
bool breederFound = false;
List<DogBreeders> lnkDogBreeders;
DogBreeders dogBreeders = new DogBreeders();
lnkDogBreeders = dogBreeders.GetDogBreedersByDog_ID(dog_ID);
foreach (DogBreeders row in lnkDogBreeders)
{
if (Common.DogBreederList[i].Person_ID == row.Breeder_ID)
{
breederFound = true;
}
}
if (!breederFound)
{
DogBreeders dogBreeder = new DogBreeders();
dogBreeder.Dog_ID = dog_ID;
dogBreeder.Breeder_ID = Common.DogBreederList[i].Person_ID;
Guid? dog_Breeder_ID = dogBreeder.Insert_Dog_Breeder(user_ID);
if (dog_Breeder_ID == null)
insertOK = false;
}
}
return insertOK;
}
private short HasBreederChanges()
{
bool Changed = false;
short del = Constants.DATA_NO_CHANGE;
short ins = Constants.DATA_NO_CHANGE;
List<DogBreeders> lnkDogBreeders;
DogBreeders dogBreeders = new DogBreeders();
Guid dog_ID = new Guid(Current_Dog_ID);
lnkDogBreeders = dogBreeders.GetDogBreedersByDog_ID(dog_ID);
foreach (DogBreeders dogBreedersRow in lnkDogBreeders)
{
bool foundBreeder = false;
if (Common.DogBreederList != null && Common.DogBreederList.Count != 0)
{
for (int i = 0; i < Common.DogBreederList.Count; i++)
{
if (Common.DogBreederList[i].Person_ID == dogBreedersRow.Breeder_ID)
//Dog in table still exists in list
foundBreeder = true;
}
}
if (!foundBreeder)
//Dog in table no longer exists in list (deleted)
Changed = true;
}
if (Changed)
del = Constants.DATA_DELETED;
Changed = false;
if (Common.DogBreederList != null && Common.DogBreederList.Count != 0)
{
for (int i = 0; i < Common.DogBreederList.Count; i++)
{
bool foundBreeder = false;
foreach (DogBreeders dogBreedersRow in lnkDogBreeders)
{
if (Common.DogBreederList[i].Person_ID == dogBreedersRow.Breeder_ID)
//Dog in List already exists in table
foundBreeder = true;
}
if (!foundBreeder)
//Dog in list does not exist in table (inserted)
Changed = true;
}
}
else
{
if (lnkDogBreeders.Count > 0)
Changed = true;
}
if (Changed)
ins = Constants.DATA_INSERTED;
return del += ins;
}
private bool DeleteDogBreeders(Guid dog_ID, Guid user_ID)
{
bool deletedOK = false;
List<DogBreeders> lnkDogBreeders;
DogBreeders dogBreeders = new DogBreeders();
lnkDogBreeders = dogBreeders.GetDogBreedersByDog_ID(dog_ID);
foreach (DogBreeders row in lnkDogBreeders)
{
bool breederFound = false;
for (int i = 0; i < Common.DogBreederList.Count; i++)
{
if (Common.DogBreederList[i].Person_ID == row.Breeder_ID)
{
breederFound = true;
}
}
if (!breederFound)
{
DogBreeders dogBreeder = new DogBreeders(row.Dog_Breeder_ID);
dogBreeder.DeleteDogBreeder = true;
deletedOK = dogBreeder.Update_Dog_Breeder(row.Dog_Breeder_ID, user_ID);
}
}
return deletedOK;
}
protected void btnSaveDog_Click(object sender, EventArgs e)
{
SaveFormFields();
StoreCommon();
MembershipUser userInfo = Membership.GetUser();
Guid user_ID = (Guid)userInfo.ProviderUserKey;
bool Changed = false;
string petName=null;
bool DogChanges = false;
bool DogSuccess = false;
bool OwnerChanges = false;
bool OwnerSuccess = false;
bool BreederChanges = false;
bool BreederSuccess = false;
if (!string.IsNullOrEmpty(Current_Dog_ID))
{
Guid dog_ID = new Guid(Current_Dog_ID);
Dogs dog = new Dogs(dog_ID);
petName=dog.Dog_Pet_Name;
if (ValidDog())
{
if (HasDogChanges())
{
DogChanges = true;
if (dog.Merit_Points.ToString() != Merit_Points && !string.IsNullOrEmpty(Merit_Points))
dog.Merit_Points = short.Parse(Merit_Points);
if (dog.NLWU == null && NLWU)
dog.NLWU = NLWU;
if (dog.NLWU != null)
{
if ((bool)dog.NLWU != NLWU)
dog.NLWU = null;
}
DogSuccess = dog.Update_Dog(dog_ID, user_ID);
if (!DogSuccess)
MessageLabel.Text += " Update_Dog Failed!";
if (!string.IsNullOrEmpty(btnReturn.PostBackUrl))
DivReturn.Visible = true;
}
else
DogSuccess = true;
List<DogOwners> lnkDogOwners;
DogOwners dogOwners = new DogOwners();
lnkDogOwners = dogOwners.GetDogOwnersByDog_ID(dog_ID);
bool insertOK = true;
bool deleteOK = true;
switch (HasOwnerChanges())
{
case Constants.DATA_NO_CHANGE:
OwnerSuccess = true;
break;
case Constants.DATA_INSERTED:
OwnerChanges = true;
insertOK = InsertDogOwners(dog_ID, user_ID);
if (insertOK)
OwnerSuccess = true;
else
MessageLabel.Text = "Insert_Dog_Owners Failed";
break;
case Constants.DATA_DELETED:
OwnerChanges = true;
deleteOK = DeleteDogOwners(dog_ID, user_ID);
if (deleteOK)
OwnerSuccess = true;
else
MessageLabel.Text = "Delete_Dog_Owners Failed";
break;
case Constants.DATA_INSERTED_AND_DELETED:
OwnerChanges = true;
insertOK = InsertDogOwners(dog_ID, user_ID);
deleteOK = DeleteDogOwners(dog_ID, user_ID);
if (insertOK && deleteOK)
OwnerSuccess = true;
else
{
MessageLabel.Text = string.Empty;
if (!insertOK)
MessageLabel.Text = "Insert_Dog_Owners Failed";
if (!deleteOK)
MessageLabel.Text += "Delete_Dog_Owners Failed";
}
break;
default:
break;
}
List<DogBreeders> lnkDogBreeders;
DogBreeders dogBreeders = new DogBreeders();
lnkDogBreeders = dogBreeders.GetDogBreedersByDog_ID(dog_ID);
insertOK = true;
deleteOK = true;
switch (HasBreederChanges())
{
case Constants.DATA_NO_CHANGE:
BreederSuccess = true;
break;
case Constants.DATA_INSERTED:
BreederChanges = true;
insertOK = InsertDogBreeders(dog_ID, user_ID);
if (insertOK)
BreederSuccess = true;
else
MessageLabel.Text = "Insert_Dog_Breeders Failed";
break;
case Constants.DATA_DELETED:
BreederChanges = true;
deleteOK = DeleteDogBreeders(dog_ID, user_ID);
if (deleteOK)
BreederSuccess = true;
else
MessageLabel.Text = "Delete_Dog_Breeders Failed";
break;
case Constants.DATA_INSERTED_AND_DELETED:
BreederChanges = true;
insertOK = InsertDogBreeders(dog_ID, user_ID);
deleteOK = DeleteDogBreeders(dog_ID, user_ID);
if (insertOK && deleteOK)
BreederSuccess = true;
else
{
MessageLabel.Text = string.Empty;
if (!insertOK)
MessageLabel.Text = "Insert_Dog_Breeders Failed";
if (!deleteOK)
MessageLabel.Text += "Delete_Dog_Breeders Failed";
}
break;
default:
break;
}
if (HasDamChanges())
{
DogDams dogDam = new DogDams();
List<DogDams> lnkDogDams;
lnkDogDams = dogDam.GetDogDamsByDog_ID(dog_ID);
if (lnkDogDams.Count == 0)
{
DogDams newDogDams = new DogDams();
newDogDams.Dog_ID = dog_ID;
newDogDams.Dam_ID = new Guid(Dam_ID);
Guid? dog_Dam_ID = newDogDams.Insert_Dog_Dams(user_ID);
}
else
{
Guid dog_Dam_ID = lnkDogDams[0].Dog_Dam_ID;
DogDams newDogDams = new DogDams(dog_Dam_ID);
newDogDams.Dam_ID = new Guid(Dam_ID);
newDogDams.Update_Dog_Dams(dog_Dam_ID, user_ID);
}
Changed = true;
}
if (HasSireChanges())
{
DogSires dogSire = new DogSires();
List<DogSires> lnkDogSires;
lnkDogSires = dogSire.GetDogSiresByDog_ID(dog_ID);
if (lnkDogSires.Count == 0)
{
DogSires newDogSires = new DogSires();
newDogSires.Dog_ID = dog_ID;
newDogSires.Sire_ID = new Guid(Sire_ID);
Guid? dog_Sire_ID = newDogSires.Insert_Dog_Sire(user_ID);
}
else
{
Guid dog_Sire_ID = lnkDogSires[0].Dog_Sire_ID;
DogSires newDogSires = new DogSires(dog_Sire_ID);
newDogSires.Sire_ID = new Guid(Sire_ID);
newDogSires.Update_Dog_Sire(dog_Sire_ID, user_ID);
}
Changed = true;
}
if (OwnerChanges || BreederChanges || DogChanges)
Changed = true;
if (OwnerChanges && !OwnerSuccess)
MessageLabel.Text += " Error with Owner Changes!";
if (BreederChanges && !BreederSuccess)
MessageLabel.Text += " Error with Breeder Changes!";
if (DogChanges && !DogSuccess)
MessageLabel.Text += " Error with Dog Changes!";
if (Changed)
{
if (OwnerSuccess && BreederSuccess && DogSuccess)
{
MessageLabel.Text = string.Format("{0} was updated successfully.", petName);
PopulateDog();
}
else
{
MessageLabel.Text = string.Format("{0}{1}", "Problem!", MessageLabel.Text);
}
}
else
{
MessageLabel.Text = "Update cancelled as no changes have been made.";
}
}
}
}
public List<DogBreeders> GetDogBreedersByDog_ID(Guid dog_ID)
{
List<DogBreeders> dogBreederList = new List<DogBreeders>();
DogBreedersBL dogBreeders = new DogBreedersBL();
lnkDogBreeders = dogBreeders.GetDog_BreedersByDog_ID(dog_ID);
if (lnkDogBreeders != null && lnkDogBreeders.Count > 0)
{
foreach (sss.lnkDog_BreedersRow row in lnkDogBreeders)
{
DogBreeders dogBreeder = new DogBreeders(row.Dog_Breeder_ID);
dogBreederList.Add(dogBreeder);
}
}
return dogBreederList;
}
