internal static void UpdateAdoption(bool v, ClientAnimalJunction clientAnimalJunction) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); var updateStatus = ( from pendingAdoptions in db.ClientAnimalJunctions where pendingAdoptions.approvalStatus == "pending" select pendingAdoptions ).ToList(); if (v == true) { foreach (ClientAnimalJunction nowAdopted in updateStatus) { nowAdopted.Animal1.adoptionStatus = "adopted"; nowAdopted.approvalStatus = "approved"; } } else { foreach (ClientAnimalJunction doNotAllow in updateStatus) { doNotAllow.Animal1.adoptionStatus = "available"; doNotAllow.approvalStatus = "not approved"; } } }
public static void UpdateAdoption(bool v, ClientAnimalJunction clientAnimalJunction) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); var adoptionUpdated = from entry in db.ClientAnimalJunctions where Convert.ToBoolean(entry.approvalStatus) == Convert.ToBoolean(clientAnimalJunction.approvalStatus) select entry; adoptionUpdated.First().approvalStatus = clientAnimalJunction.approvalStatus; db.SubmitChanges(); }
public static void UpdateAdoptionStatus(string status, ClientAnimalJunction clientAnimalJunction) { var db = new HumaneSocietyDataContext(); var clientAnimalJunctionResult = db.ClientAnimalJunctions.Where(c => c.Client1.ID == clientAnimalJunction.Client1.ID && c.Animal1.ID == clientAnimalJunction.Animal1.ID).FirstOrDefault(); clientAnimalJunctionResult.approvalStatus = status; db.SubmitChanges(); }
internal static void UpdateAdoption(bool v, ClientAnimalJunction clientAnimalJunction) { HumaneSocietyDataContext database = new HumaneSocietyDataContext(); Animal animal = new Animal(); animal.adoptionStatus = "adopted"; database.SubmitChanges(); throw new NotImplementedException(); }
public static void UpdateAdoption(bool value, ClientAnimalJunction clientAnimalJunction) { using (HumaneSocietyDataContext context = new HumaneSocietyDataContext()) { ClientAnimalJunction updateAdoptionStatus = context.ClientAnimalJunctions.Where(r => r.animal == clientAnimalJunction.animal && r.client == clientAnimalJunction.client).FirstOrDefault(); updateAdoptionStatus.approvalStatus = UserInterface.BoolToYesNo(value); context.SubmitChanges(); } }
public static void UpdateAdoption(bool status, ClientAnimalJunction clientAnimalJunction) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); var update = (from u in db.ClientAnimalJunctions where u.client == clientAnimalJunction.Client1.ID && u.animal == clientAnimalJunction.Animal1.ID select u).First(); update.approvalStatus = status ? "approved" : "denied"; db.SubmitChanges(); }
public static void Adopt(Animal animal, Client client) { using (HumaneSocietyDataContext context = new HumaneSocietyDataContext()) { ClientAnimalJunction submitAdoption = new ClientAnimalJunction(); submitAdoption.animal = animal.ID; submitAdoption.client = client.ID; context.ClientAnimalJunctions.InsertOnSubmit(submitAdoption); context.SubmitChanges(); } }
public static void Adopt(Animal animal, Client client) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); ClientAnimalJunction clientAnimalJunction = new ClientAnimalJunction(); clientAnimalJunction.animal = animal.ID; clientAnimalJunction.client = client.ID; clientAnimalJunction.approvalStatus = "pending"; db.ClientAnimalJunctions.InsertOnSubmit(clientAnimalJunction); db.SubmitChanges(); }
private void CompleteAdoption(ClientAnimalJunction clientAnimalJunction) { UserInterface.DisplayAnimalInfo(clientAnimalJunction.Animal1); UserInterface.DisplayClientInfo(clientAnimalJunction.Client1); UserInterface.DisplayUserOptions("How much have your received for this adoption?"); Query.UpdateAdoptionFeesPaid(clientAnimalJunction, UserInterface.GetIntegerData()); UserInterface.DisplayUserOptions("Would you like to update the adoption status to 'ADOPTED'?"); if ((bool)UserInterface.GetBitData()) { Query.UpdateAdoptionStatus("adopted", clientAnimalJunction); } }
public static void UpdateAdoption(bool boolean, ClientAnimalJunction clientAnimalJunction) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); if (boolean) { var _animal = db.ClientAnimalJunctions.Where(s => s.animal == clientAnimalJunction.animal); foreach (var a in _animal) { a.approvalStatus = "approved"; } } }
public static void Adopt(Animal animal, Client client) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); animal.adoptionStatus = "pending"; ClientAnimalJunction clientAnimal = new ClientAnimalJunction(); clientAnimal.animal = animal.ID; clientAnimal.client = client.ID; clientAnimal.approvalStatus = clientAnimal.Animal1.adoptionStatus; db.ClientAnimalJunctions.InsertOnSubmit(clientAnimal); db.SubmitChanges(); Console.WriteLine("Your application has been received."); }
private void ApproveAdoption(ClientAnimalJunction clientAnimalJunction) { UserInterface.DisplayAnimalInfo(clientAnimalJunction.Animal1); UserInterface.DisplayClientInfo(clientAnimalJunction.Client1); UserInterface.DisplayUserOptions("Would you approve this adoption?"); if ((bool)UserInterface.GetBitData()) { Query.UpdateAdoption(true, clientAnimalJunction); } else { Query.UpdateAdoption(false, clientAnimalJunction); } }
public static void Adopt(Animal animal, Client client) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); ClientAnimalJunction clientanimaljunction = new ClientAnimalJunction(); Bank bank = new Bank(); var status = db.Animals.Where(a => a.adoptionStatus.ToLower().Equals("not adopted")); foreach (var adoption in status) { adoption.adoptionStatus = "pending adoption"; } clientanimaljunction.animal.Equals(animal.ID); clientanimaljunction.client.Equals(client.ID); bank.DepositMoney(75); }
public static void UpdateAdoptionFeesPaid(ClientAnimalJunction adoption, int feesPaid) { var db = new HumaneSocietyDataContext(); var adoptionResults = db.ClientAnimalJunctions.Where(c => c.client == adoption.client && c.animal == c.animal).First(); if (adoptionResults.feePaid == null) { adoptionResults.feePaid = feesPaid; } else { adoptionResults.feePaid += feesPaid; } db.SubmitChanges(); }
public static void Adopt(Animal animal, Client client) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); ClientAnimalJunction application = new ClientAnimalJunction(); application.animal = animal.ID; application.client = client.ID; application.approvalStatus = "pending"; db.ClientAnimalJunctions.InsertOnSubmit(application); var animalUpdate = db.Animals.Where(a => a.ID == animal.ID).First(); animalUpdate.adoptionStatus = "pending"; db.SubmitChanges(); }
public static void UpdateAdoption(bool approve, ClientAnimalJunction clientAnimalJunction) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); Animal animalAdopted = (from a in db.Animals where clientAnimalJunction.animal == a.ID select a).FirstOrDefault(); if (approve == true) { clientAnimalJunction.approvalStatus = "approved"; animalAdopted.adoptionStatus = "adopted"; } else { clientAnimalJunction.approvalStatus = "rejected"; } }
public static void UpdateAdoption(bool v, ClientAnimalJunction clientAnimalJunction) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); var animalAdopted = db.Animals.Where(c => c.ID == clientAnimalJunction.animal).First(); if (v == true) { animalAdopted.adoptionStatus = "adopted"; clientAnimalJunction.approvalStatus = "adopted"; } else if (v == false) { clientAnimalJunction.approvalStatus = "not adopted"; animalAdopted.adoptionStatus = "not adopted"; } db.SubmitChanges(); }
internal static void UpdateAdoption(bool isAdopted, ClientAnimalJunction animal) { HumaneSocietyDataContext database = new HumaneSocietyDataContext(); var currentJunction = database.ClientAnimalJunctions.Where(x => x.animal == animal.animal && x.client == animal.client).Select(x => x).First(); var currentAnimal = database.Animals.Where(x => x.ID == animal.animal).Select(x => x).First(); if (isAdopted) { currentJunction.approvalStatus = "approved"; currentAnimal.adoptionStatus = "adopted"; UserInterface.DisplayUserOptions("transferring adoption fee from adopter"); } else { currentJunction.approvalStatus = "denied"; } database.SubmitChanges(); }
internal static void UpdateAdoption(bool isApproved, ClientAnimalJunction junction) { HumaneSocietyDataContext context = new HumaneSocietyDataContext(); var currentJunction = (from data in context.ClientAnimalJunctions where data.animal == junction.animal && data.client == junction.client select data).First(); var currentAnimal = (from data in context.Animals where data.ID == junction.animal select data).First(); if (isApproved) { currentJunction.approvalStatus = "approved"; currentAnimal.adoptionStatus = "adopted"; UserInterface.DisplayUserOptions("transferring adoption fee from adopter"); } else { currentJunction.approvalStatus = "denied"; } context.SubmitChanges(); }
internal static void UpdateAdoption(bool v, ClientAnimalJunction clientAnimalJunction) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); var currentJunction = db.ClientAnimalJunctions.Where(data => data.animal == clientAnimalJunction.animal && data.client == clientAnimalJunction.client).Select(data => data).First(); var currentAnimal = db.Animals.Where(data => data.ID == clientAnimalJunction.animal).Select(data => data).First(); if (v) { currentJunction.approvalStatus = "approved"; currentAnimal.adoptionStatus = "adopted"; UserInterface.DisplayUserOptions("transferring adoption fee from adopter"); } else { currentJunction.approvalStatus = "denied"; } db.SubmitChanges(); }
public static void UpdateAdoption(bool success, ClientAnimalJunction clientAnimalJunction) //void { HumaneSocietyDataContext context = new HumaneSocietyDataContext(); Animal animalAdopted = (from a in context.Animals where clientAnimalJunction.animal == a.ID select a).FirstOrDefault(); if (success == true) { clientAnimalJunction.approvalStatus = "approved"; animalAdopted.adoptionStatus = "adopted"; } else { clientAnimalJunction.approvalStatus = "rejected"; } try { context.SubmitChanges(); } catch (Exception e) { Console.WriteLine(e); } }
internal static void UpdateAdoption(bool v, ClientAnimalJunction clientAnimalJunction) { throw new NotImplementedException(); }