internal static void UpdateShot(string shotName, Animal animal) { DateTime newDate = new DateTime(); var newShot = db.AnimalShots.Where(a => a.AnimalId == animal.AnimalId).Select(a => a).SingleOrDefault(); if (newShot == null) { Shot shot = new Shot(); shot.Name = shotName; db.Shots.InsertOnSubmit(shot); db.SubmitChanges(); AnimalShot animalShot = new AnimalShot(); animalShot.DateReceived = newDate.Date; animalShot.AnimalId = animal.AnimalId; animalShot.ShotId = shot.ShotId; db.AnimalShots.InsertOnSubmit(animalShot); db.SubmitChanges(); } else { var updateAnimalShot = db.AnimalShots.Where(a => a.AnimalId == animal.AnimalId && a.Shot.Name == shotName).Select(a => a).Single(); updateAnimalShot.DateReceived = newDate.Date; } db.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { Shot shotUpdate = db.Shots.Where(s => s.Name == shotName).FirstOrDefault(); AnimalShot animalShot = db.AnimalShots.Where(a => a.AnimalId == animal.AnimalId && a.ShotId == shotUpdate.ShotId).FirstOrDefault(); animalShot.DateReceived = DateTime.Now; }
internal static void UpdateShot(string v, Animal animal) { HumaneSocietyDataContext DB = new HumaneSocietyDataContext(); AnimalShot animalShot = new AnimalShot(); DateTime dat1 = new DateTime(); var existsResult = CheckShotExists(); if (existsResult != 0) { } else { CreateNewShot(); } var foundShot = DB.Shots.Where(s => s.Name == v).FirstOrDefault(); //returns name of shot where it matches name passed in. var foundAnimalShot = DB.AnimalShots.Where(s => s.AnimalId == animal.AnimalId && s.ShotId == foundShot.ShotId).FirstOrDefault(); animalShot.AnimalId = foundAnimalShot.AnimalId; animalShot.ShotId = foundAnimalShot.ShotId; animalShot.DateReceived = dat1; DB.AnimalShots.InsertOnSubmit(animalShot); }
internal static void UpdateShot(string shotName, Animal animal) { try { AnimalShot shot = new AnimalShot(); shot.ShotId = db.Shots.Where(a => a.Name == shotName).SingleOrDefault().ShotId; shot.AnimalId = animal.AnimalId; shot.DateReceived = DateTime.Now; var shotsData = db.AnimalShots.Where(a => a.AnimalId == animal.AnimalId); shotsData = shotsData.Where(a => a.Shot.Name == shotName); if (shotsData.Count() > 0) { db.AnimalShots.Where(a => a.ShotId == db.Shots.Where(b => b.Name == shotName).SingleOrDefault().ShotId&& a.Animal == animal).SingleOrDefault().DateReceived = DateTime.Now; } else { db.AnimalShots.InsertOnSubmit(shot); } db.SubmitChanges(); } catch { throw new Exception(); } }
// Adds a shot to the AnimalShots table. internal static void UpdateShot(string shotName, Animal animal) { AnimalShot animalShot = new AnimalShot(); Shot shotFromDb; // See if shotName exists o/w create it. try { shotFromDb = db.Shots.Where(s => s.Name == shotName).Single(); } catch (InvalidOperationException e) { // Add a new shot type shotFromDb = new Shot(); shotFromDb.Name = shotName; AddShotType(shotFromDb); } animalShot.AnimalId = animal.AnimalId; animalShot.ShotId = shotFromDb.ShotId; animalShot.DateReceived = DateTime.Now; db.AnimalShots.InsertOnSubmit(animalShot); db.SubmitChanges(); }
internal static void UpdateShot(string inputName, Animal animal, int year, int month, int day) { HumaneSocietyDataContext db = new HumaneSocietyDataContext(); AnimalShot animalShot = new AnimalShot(); DateTime updatedDate = new DateTime(year, month, day); var shot = db.Shots.Where(s => s.Name == inputName).Single(); if (shot == null) { animalShot.AnimalId = animal.AnimalId; animalShot.ShotId = shot.ShotId; shot.Name = inputName; animalShot.DateReceived = updatedDate; db.AnimalShots.InsertOnSubmit(animalShot); db.Shots.InsertOnSubmit(shot); db.SubmitChanges(); } else if (shot.Name == inputName) { AnimalShot updateshots = db.AnimalShots.Where(s => s.ShotId == shot.ShotId && s.AnimalId == animal.AnimalId).Single(); updateshots.DateReceived = updatedDate; db.SubmitChanges(); } }
internal static void UpdateShot(string shotName, Animal animal) { Shot thisShot = null; Animal animalWithShot = null; try { thisShot = db.Shots.Where(c => c.Name == shotName).Single(); } catch (InvalidOperationException) { UserInterface.DisplayMessage("No record of this particular shot can be found."); UserInterface.DisplayMessage("No updates have been made."); return; } try { animalWithShot = db.Animals.Where(a => a.AnimalId == animal.AnimalId).Single(); } catch (InvalidOperationException) { UserInterface.DisplayMessage("No record of this animal can be found."); UserInterface.DisplayMessage("No updates have been made."); return; } AnimalShot shotToAdd = new AnimalShot { AnimalId = animalWithShot.AnimalId, ShotId = thisShot.ShotId, DateReceived = DateTime.Today }; db.AnimalShots.InsertOnSubmit(shotToAdd); db.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { AnimalShot updateAnimalShot = db.AnimalShots.Where(e => e.AnimalId == animal.AnimalId).FirstOrDefault(); var typeOfShot = db.Shots.Where(e => e.Name == shotName).FirstOrDefault(); updateAnimalShot.ShotId = typeOfShot.ShotId; }
internal static void UpdateShot(string shotName, Animal animal) { var shotFromDB = db.Shots.Where(x => x.Name == shotName).SingleOrDefault(); Shot shot; if (shotFromDB is null) { shot = new Shot(); shot.Name = shotName; db.Shots.InsertOnSubmit(shot); db.SubmitChanges(); } else { shot = shotFromDB; } var animalShot = new AnimalShot(); animalShot.DateReceived = DateTime.Now; animalShot.AnimalId = animal.AnimalId; animalShot.ShotId = shot.ShotId; db.AnimalShots.InsertOnSubmit(animalShot); db.SubmitChanges(); }
internal static void UpdateShot(string booster, Animal animal) { int year; int month; int day; HumaneSocietyDataContext db = new HumaneSocietyDataContext(); AnimalShot animalShot = new AnimalShot(); if (UserInterface.GetBitData($"Was {booster} what you meant to type?")) { //DateTime get Console.WriteLine("What year was the shot administered?"); year = Convert.ToInt16(Console.ReadLine()); Console.WriteLine("What month was the shot administered?"); month = Convert.ToInt16(Console.ReadLine()); Console.WriteLine("What day was the shot administered?"); day = Convert.ToInt16(Console.ReadLine()); DateTime date = new DateTime(year, month, day); animalShot.DateReceived = date; animalShot.AnimalId = animal.AnimalId; animalShot.ShotId = db.Shots.Where(s => s.Name == booster).Select(s => s.ShotId).Single(); db.AnimalShots.InsertOnSubmit(animalShot); db.SubmitChanges(); } }
internal static void UpdateShot(string shotName, Animal animal) { Shot shotGiven = db.Shots.Where(shot => shot.Name == shotName).FirstOrDefault(); AnimalShot shotToUpdate = db.AnimalShots.Where(animalShot => animalShot.AnimalId == animal.AnimalId).Where(shot => shot.ShotId == shotGiven.ShotId).SingleOrDefault(); shotToUpdate.DateReceived = System.DateTime.Today; db.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { AnimalShot newShot = new AnimalShot(); var shot = db.Shots.Where(s => s.Name == shotName).Select(s => s.ShotId).Single(); newShot.ShotId = shot; newShot.AnimalId = animal.AnimalId; }
internal static void UpdateShot(string shotName, Animal animal) { AnimalShot animalShot = new AnimalShot(); animalShot.AnimalId = animal.AnimalId; animalShot.ShotId = db.Shots.Where(s => s.Name == shotName).FirstOrDefault().ShotId; animalShot.DateReceived = new DateTime(); db.AnimalShots.InsertOnSubmit(animalShot); }
internal static void UpdateShot(string shotName, Animal animal) { AnimalShot newAnimalShot = new AnimalShot(); newAnimalShot.AnimalId = animal.AnimalId; newAnimalShot.ShotId = db.Shots.Where(s => s.Name == shotName).Select(s => s.ShotId).SingleOrDefault(); db.AnimalShots.InsertOnSubmit(newAnimalShot); db.SubmitChanges(); }
public static void UpdateShot(string shotType, Animal animal) { AnimalShot newAnimalShot = new AnimalShot(); newAnimalShot.AnimalId = animal.AnimalId; newAnimalShot.DateReceived = DateTime.Now; context.AnimalShots.InsertOnSubmit(newAnimalShot); context.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { Shot shotToAdd = db.Shots.Where(s => s.Name == shotName).FirstOrDefault(); var actualShot = new AnimalShot { AnimalId = animal.AnimalId, ShotId = shotToAdd.ShotId, DateReceived = DateTime.Today }; db.AnimalShots.InsertOnSubmit(actualShot); db.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { AnimalShot updateAnimalShot = db.AnimalShots.Where(a => a.AnimalId == animal.AnimalId).Single(); Shot shot = db.Shots.Where(s => s.Name == shotName).Single(); updateAnimalShot.DateReceived = DateTime.Now; updateAnimalShot.ShotId = shot.ShotId; db.SubmitChanges(); }
public static void UpdateShot(string shotType, Animal animal) { AnimalShot newShot = new AnimalShot(); newShot.Animal = db.Animals.Where(a => a.AnimalId == animal.AnimalId).FirstOrDefault(); newShot.Shot = db.Shots.Where(s => s.Name == shotType).FirstOrDefault(); newShot.DateReceived = DateTime.Today; db.AnimalShots.InsertOnSubmit(newShot); db.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { AnimalShot animalShot = new AnimalShot(); animalShot.AnimalId = animal.AnimalId; Shot shot = db.Shots.Where(s => s.Name == shotName).Single(); animalShot.ShotId = shot.ShotId; animalShot.DateReceived = DateTime.Today; db.AnimalShots.InsertOnSubmit(animalShot); }
internal static void UpdateShot(string shotName, Animal animal) { AnimalShot shot = new AnimalShot(); shot.AnimalId = animal.AnimalId; shot.ShotId = db.Shots.Where(s => s.Name == shotName).FirstOrDefault().ShotId; shot.DateReceived = DateTime.Now; animal.AnimalShots.Add(shot); db.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { Shot shotFromDb = db.Shots.Where(s => s.Name == shotName).FirstOrDefault(); AnimalShot animalShot = new AnimalShot(); animalShot.AnimalId = animal.AnimalId; animalShot.ShotId = shotFromDb.ShotId; animalShot.DateReceived = DateTime.Today; db.AnimalShots.InsertOnSubmit(animalShot); db.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { AnimalShot shot1 = new AnimalShot(); var newShot = db.Shots.Where(s => s.Name == shotName).Select(n => n.ShotId).Single(); shot1.AnimalId = animal.AnimalId; shot1.ShotId = newShot; db.AnimalShots.InsertOnSubmit(shot1); db.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { //insert shot into AnimalShots table AnimalShot animalShot = new AnimalShot() { Animal = animal, DateReceived = DateTime.Today, Shot = db.Shots.FirstOrDefault(a => a.Name == shotName) }; db.AnimalShots.InsertOnSubmit(animalShot); db.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { DateTime now = DateTime.Now; var updateShots = db.Shots.Where(a => a.Name == shotName).Select(s => s.ShotId).FirstOrDefault(); AnimalShot animalShot = new AnimalShot(); animalShot.AnimalId = animal.AnimalId; animalShot.ShotId = updateShots; animalShot.DateReceived = now; db.AnimalShots.InsertOnSubmit(animalShot); db.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { var shotId = db.Shots.Where(a => a.Name == shotName).Select(s => s.ShotId).Single(); AnimalShot animalShot = new AnimalShot() { AnimalId = animal.AnimalId, ShotId = shotId }; db.AnimalShots.InsertOnSubmit(animalShot); db.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { Shot newShot = new Shot(); shotName = newShot.Name; db.Shots.InsertOnSubmit(newShot); db.SubmitChanges(); AnimalShot ShotForAnimal = new AnimalShot(); ShotForAnimal.AnimalId = animal.AnimalId; db.AnimalShots.InsertOnSubmit(ShotForAnimal); db.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { AnimalShot animalShot = new AnimalShot(); var vaccineShot = db.Shots.Where(s => s.Name == shotName).Select(s => s.ShotId).SingleOrDefault(); animalShot.AnimalId = animal.AnimalId; animalShot.ShotId = vaccineShot; animalShot.DateReceived = DateTime.Now; db.AnimalShots.InsertOnSubmit(animalShot); db.SubmitChanges(); }
internal static void UpdateShot(string shotName, Animal animal) { AnimalShot newAnimalShot = new AnimalShot(); var newShotID = db.Shots.Where(shot => shot.Name == shotName).Select(shotx => shotx.ShotId).SingleOrDefault(); newAnimalShot.AnimalId = animal.AnimalId; newAnimalShot.ShotId = newShotID; newAnimalShot.DateReceived = DateTime.Now; db.AnimalShots.InsertOnSubmit(newAnimalShot); db.SubmitChanges(); }
public static void UpdateShot(string newShot, Animal animal) { var requiredData = (from x in database.Shots where x.Name == newShot select x).First(); AnimalShot newAnimalShot = new AnimalShot(); newAnimalShot.AnimalId = animal.AnimalId; newAnimalShot.ShotId = requiredData.ShotId; database.AnimalShots.InsertOnSubmit(newAnimalShot); database.SubmitChanges(); }
internal static void UpdateShot(string v, Animal animal) { AnimalShot thisShot = new AnimalShot(); thisShot.AnimalId = animal.AnimalId; var thisShotId = db.Shots.Where(s => s.Name == v).FirstOrDefault(); thisShot.ShotId = thisShotId.ShotId; DateTime thisTime = new DateTime(); thisShot.DateReceived = thisTime; db.AnimalShots.InsertOnSubmit(thisShot); TryDBChanges(); }