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();
}
