public void Delete(int id)
{
Vaccination vaccination = db.Vaccinations.FirstOrDefault(v => v.Id == id);
db.Vaccinations.Remove(vaccination);
db.SaveChanges();
}
public AddNewToCardVM(int id_pat, int id_doc)
{
elementsCard = new string[] { "Diagnosis", "Vaccination", "Survey", "Analys" };
showDiag = "Hidden";
showVacc = "Hidden";
showSurv = "Hidden";
showAnalys = "Hidden";
diagnosis = new Diagnosis()
{
Id_Patient = id_pat, Id_Doctor = id_doc
};
vaccination = new Vaccination()
{
Id_Patient = id_pat, Date = ""
};
survey = new Survey()
{
Id_Patient = id_pat, Date = ""
};
analys = new Analysis()
{
Id_Patient = id_pat, Date = ""
};
Add_Diag = new RelayCommand(x => addDiagnosis(diagnosis));
Add_Vacc = new RelayCommand(x => addVaccination(vaccination));
Add_Surv = new RelayCommand(x => addSurvey(survey));
Add_Analys = new RelayCommand(x => addAnalys(analys));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Pils,HaveVaccination,VaccinationDate, PatientId")] Vaccination vaccination)
{
if (id != vaccination.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(vaccination);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VaccinationExists(vaccination.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(vaccination));
}
public VaccinationFullForCreationDto(Vaccination vac, DateTime vaccinationDate)
{
Id = vac.Id;
Name = vac.Name;
Type = vac.Type;
VaccinationDate = vaccinationDate;
}
public List <Vaccination> GetVaccinations()
{
List <Vaccination> vaccinations = new List <Vaccination>();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("Get_VaccineSchedules", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
//cmd.ExecuteNonQuery();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Vaccination vaccination = new Vaccination();
vaccination.Id = Convert.ToInt32(rdr["Id"]);
vaccination.Description = rdr["Description"].ToString();
vaccination.OwnerName = rdr["OwnerName"].ToString();
vaccination.Email = rdr["Email"].ToString();
vaccination.CreatedDate = Convert.ToDateTime(rdr["CreatedDate"]);
vaccination.IsEnded = Convert.ToBoolean(rdr["IsEnded"]);
vaccination.LastUpdatedDate = Convert.ToDateTime(rdr["LastUpdatedDate"]);
vaccination.OwnerId = Convert.ToInt32(rdr["OwnerId"]);
vaccination.UserId = Convert.ToInt32(rdr["CreatedUserId"]);
vaccinations.Add(vaccination);
}
con.Close();
}
return(vaccinations);
}
public IHttpActionResult PostVaccination(Vaccination vaccination)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
//check if procedure already set
if (db.Procedures.FirstOrDefault(x => x.ProcedureId == vaccination.ProcedureId) != null)
{
return(Content(HttpStatusCode.Conflict, "Procedure existed!"));
}
db.Procedures.Add(vaccination);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (VaccinationExists((int)vaccination.ProcedureId))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = vaccination.ProcedureId }, vaccination));
}
public Vaccination Get(int idAChercher)
{
{
Vaccination GetVaccination = new Vaccination();
using (_connection)
{
_connection.Open();
SqlCommand command = new SqlCommand("SELECT * FROM Vaccination where id = @idCherch", _connection);
command.Parameters.AddWithValue("idCherch", idAChercher);
using SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
new Vaccination
{
Id_Vaccination = reader["Id_Vaccination"] == DBNull.Value ? 0 : (int)reader["Id_Vaccination"],
Nom_Vaccin = reader["Nom_Vaccin"] == DBNull.Value ? string.Empty : (string)reader["Nom_Vaccin"],
Delai_Indisponibilité = reader["Indisponibilite_Vaccin"] == DBNull.Value ? DateTime.Now : (DateTime)reader["Indisponibilite_Vaccin"]
};
}
}
return(GetVaccination);
}
}
//-------------------- Animal Vaccine -------------------------------------
#region
public static bool AddAnimalVaccine(AnimalVaccineAdd newentry, string operatorname)
{
try
{
using (AnimalInformationContext datamodel = new AnimalInformationContext())
{
var animal = AnimalInformationDBAcces.GetAnimalInfoByID(newentry.AnimalId);
if (animal != null)
{
Vaccination add = new Vaccination();
add.AnimalId = newentry.AnimalId;
add.VaccinationDate = newentry.VaccinationDate;
add.VaccineName = newentry.VaccineName;
add.NextVaccationDate = newentry.NextVaccationDate;
add.Comments = newentry.Comments;
add.IsApplied = true;
add.OperatorName = operatorname;
datamodel.Vaccinations.Add(add);
datamodel.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public void Create(Vaccination Nouvellevaccination)
{
using (_connection)
{
_connection.Open();
SqlCommand command = new SqlCommand("INSERT INTO Vaccination (Id_vaccination,Nom_vaccin,Delai_Indisponibilité" //les champs de la table
+
"VALUES (@id_vaccination, @nom_vaccin, @delai_indisponibilite)");
command.Parameters.AddWithValue("id_vaccination", Nouvellevaccination.Id_Vaccination);
command.Parameters.AddWithValue("nom_vaccin", Nouvellevaccination.Nom_Vaccin);
command.Parameters.AddWithValue("delai_indisponibilite", Nouvellevaccination.Delai_Indisponibilité);
command.ExecuteNonQuery();
_connection.Close();
}
}
public void UpdateVaccination(string id, bool IsVaccinated)
{
Vaccination v = VactinationRepo.GetAllListOfElements().FirstOrDefault(x => x.VaccinationId.ToString() == id);
v.IsVaccinated = IsVaccinated;
VactinationRepo.UpdateVaccine(v);
}
public IActionResult AddVaccination([FromBody] VaccinationDto vaccinationDto)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
string userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
Pet pet = _repoWrapper.Pet
.FindByCondition(p => p.Id == vaccinationDto.PetId &&
p.UserId.ToString() == userId)
.FirstOrDefault();
if (pet == null)
{
return(BadRequest("PetId is incorrect"));
}
var config = new MapperConfiguration(cfg => cfg.CreateMap <VaccinationDto, Vaccination>());
var mapper = new Mapper(config);
Vaccination vaccination = mapper.Map <VaccinationDto, Vaccination>(vaccinationDto);
_repoWrapper.Vaccination.Create(vaccination);
_repoWrapper.Save();
return(Ok(new { Success = true }));
}
public void UpdateVaccine(Vaccination _v)
{
Vaccination v = vetdb.Vaccinations.Find(_v.VaccinationId);
v.IsVaccinated = _v.IsVaccinated;
vetdb.SaveChanges();
}
public async Task <IActionResult> Edit(int id, [Bind("ID,IDVaccinId,IDPatientId,Date,Rappel")] Vaccination vaccination)
{
if (id != vaccination.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(vaccination);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!VaccinationExists(vaccination.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["IDPatientId"] = new SelectList(_context.Personnes, "ID", "ID", vaccination.IDPatientId);
ViewData["IDVaccinId"] = new SelectList(_context.Vaccins, "ID", "ID", vaccination.IDVaccinId);
return(View(vaccination));
}
private async void DeleteButton_OnClickedButton_OnClicked(object sender, EventArgs e)
{
var ci = CrossMultilingual.Current.CurrentCultureInfo;
string confirmTitle = resmgr.Value.GetString("DeleteVaccination", ci);
string confirmMessage = resmgr.Value.GetString("DeleteVaccinationMessage", ci) + " ? ";
string yes = resmgr.Value.GetString("Yes", ci);
string no = resmgr.Value.GetString("No", ci);
bool confirmDelete = await DisplayAlert(confirmTitle, confirmMessage, yes, no);
if (confirmDelete)
{
_viewModel.IsBusy = true;
_viewModel.EditMode = false;
Vaccination deletedVaccination = await ProgenyService.DeleteVaccination(_viewModel.CurrentVaccination);
if (deletedVaccination.VaccinationId == 0)
{
_viewModel.EditMode = false;
// Todo: Show success message
}
else
{
_viewModel.EditMode = true;
// Todo: Show failed message
}
_viewModel.IsBusy = false;
}
}
public IHttpActionResult PutVaccination(int id, Vaccination vaccination)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != vaccination.ProcedureId)
{
return(BadRequest());
}
db.Entry(vaccination).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!VaccinationExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
private void addVaccinations()
{
List <DateTime> expiryDates = new List <DateTime>();
expiryDates.Add((txtBordetella.Text != "") ? DateTime.Parse(txtBordetella.Text) : new DateTime(1000));
expiryDates.Add((txtDistemper.Text != "") ? DateTime.Parse(txtDistemper.Text) : new DateTime(1000));
expiryDates.Add((txtHepatitis.Text != "") ? DateTime.Parse(txtHepatitis.Text) : new DateTime(1000));
expiryDates.Add((txtParainfluenza.Text != "") ? DateTime.Parse(txtParainfluenza.Text) : new DateTime(1000));
expiryDates.Add((txtParovirus.Text != "") ? DateTime.Parse(txtParovirus.Text) : new DateTime(1000));
expiryDates.Add((txtRabies.Text != "") ? DateTime.Parse(txtRabies.Text) : new DateTime(1000));
List <CheckBox> vaccCheckBoxes = new List <CheckBox>();
vaccCheckBoxes.Add(chbValBordetella);
vaccCheckBoxes.Add(chbValDistemper);
vaccCheckBoxes.Add(chbValHepatitis);
vaccCheckBoxes.Add(chbValParainfluenza);
vaccCheckBoxes.Add(chbValParovirus);
vaccCheckBoxes.Add(chbValRabies);
Vaccination vacc = new Vaccination();
if (Session["PET_NUMBER"] != null)
{
Pet pet = new Pet();
pet = pet.getPet(Convert.ToInt32(Session["PET_NUMBER"]));
List <Vaccination> vaccinations = new List <Vaccination>();
for (int i = 1; i <= 6; i++)
{
vaccinations.Add(pet.vaccinations.Find(v => v.number == i));
}
for (int i = 0; i < 6; i++)
{
if (!DateTime.Equals(expiryDates[i], new DateTime(1000)))
{
if (vaccinations[i] != null)
{
vacc.Update(expiryDates[i], i + 1, Convert.ToInt32(Session["PET_NUMBER"]), vaccCheckBoxes[i].Checked);
}
else
{
vacc.Insert(expiryDates[i], i + 1, Convert.ToInt32(Session["PET_NUMBER"]), vaccCheckBoxes[i].Checked);
}
}
}
}
else
{
for (int i = 0; i < 6; i++)
{
if (!DateTime.Equals(expiryDates[i], new DateTime(1000)))
{
vacc.Insert(expiryDates[i], i + 1, vaccCheckBoxes[i].Checked);
}
}
}
}
public VaccinationFullDto(Vaccination vac, DateTime vaccinationDate, DateTime nextVaccinationDate)
{
Id = vac.Id;
Name = vac.Name;
Type = vac.Type;
VaccinationDate = vaccinationDate;
NextVaccinationDate = nextVaccinationDate;
}
public IActionResult DeleteAnimal(int id)
{
Vaccination feed = _repo.Vaccinations.GetById(id);
_repo.Vaccinations.Delete(id);
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(int id)
{
Vaccination vaccination = _vaccinationService.Get(id);
_vaccinationService.Delete(vaccination);
return(RedirectToAction("Details", "Patient", new { id = vaccination.PatientId }));
}
// POST: /Kurs1/Delete/5
//[HttpPost, ActionName("Delete")]
//[ValidateAntiForgeryToken]
public ActionResult DeleteConfirmed(int id, int id2)
{
Vaccination vaccination = db.Vaccination.Find(id);
db.Vaccination.Remove(vaccination);
db.SaveChanges();
return(RedirectToAction("Index", new { id = id2 }));
}
private async void SaveVaccinationButton_OnClicked(object sender, EventArgs e)
{
if (ProgenyCollectionView.SelectedItem is Progeny progeny)
{
_viewModel.IsBusy = true;
_viewModel.IsSaving = true;
Vaccination saveVaccination = new Vaccination();
saveVaccination.ProgenyId = progeny.Id;
saveVaccination.AccessLevel = _viewModel.AccessLevel;
saveVaccination.Progeny = progeny;
saveVaccination.VaccinationDate = VaccinationDatePicker.Date;
string userEmail = await UserService.GetUserEmail();
UserInfo userinfo = await UserService.GetUserInfo(userEmail);
saveVaccination.Author = userinfo.UserId;
saveVaccination.Notes = NotesEditor.Text;
saveVaccination.VaccinationDescription = DescriptionEditor.Text;
saveVaccination.VaccinationName = VaccinationNameEntry.Text;
if (ProgenyService.Online())
{
// Todo: Translate messages.
saveVaccination = await ProgenyService.SaveVaccination(saveVaccination);
_viewModel.IsBusy = false;
_viewModel.IsSaving = false;
if (saveVaccination.VaccinationId == 0)
{
var ci = CrossMultilingual.Current.CurrentCultureInfo;
ErrorLabel.Text = resmgr.Value.GetString("ErrorVaccinationNotSaved", ci);
ErrorLabel.BackgroundColor = Color.Red;
}
else
{
var ci = CrossMultilingual.Current.CurrentCultureInfo;
ErrorLabel.Text = resmgr.Value.GetString("VaccinationSaved", ci) + saveVaccination.VaccinationId;
ErrorLabel.BackgroundColor = Color.Green;
SaveVaccinationButton.IsVisible = false;
CancelVaccinationButton.Text = "Ok";
CancelVaccinationButton.BackgroundColor = Color.FromHex("#4caf50");
await Shell.Current.Navigation.PopModalAsync();
}
}
else
{
// Todo: Translate message.
ErrorLabel.Text = $"Error: No internet connection. Measurement for {progeny.NickName} was not saved. Try again later.";
ErrorLabel.BackgroundColor = Color.Red;
}
ErrorLabel.IsVisible = true;
}
_viewModel.IsBusy = false;
_viewModel.IsSaving = false;
}
public int Create(Vaccination vaccination)
{
Command command = new Command("CreateVaccination", true);
command.AddParameter("nom_vaccin", vaccination.Nom_Vaccin);
command.AddParameter("delai_indisponibilite", vaccination.Delai_Indisponibilite);
return(_connection.ExecuteNonQuery(command));
}
public async Task AddVaccination(Vaccination vaccination)
{
var vc = await _dbContext.Vaccinations.Where(x => x.Type == vaccination.Type).FirstOrDefaultAsync();
if (vc == null)
{
_dbContext.Vaccinations.Add(vaccination);
await _dbContext.SaveChangesAsync();
}
}
public Vaccination(Vaccination vaccination)
{
Vaccine = vaccination.Vaccine;
Disease = vaccination.Disease;
MaxProtectionTime = vaccination.MaxProtectionTime;
AgeImmunised = vaccination.AgeImmunised;
ReducedChanceToContractDisease = vaccination.ReducedChanceToContractDisease;
Expired = vaccination.Expired;
Missed = vaccination.Missed;
}
public void Update(VaccinationVM vaccination)
{
Vaccination fromDB = db.Vaccinations.FirstOrDefault(v => v.Id == vaccination.Id);
fromDB.VaccineName = vaccination.VaccineName;
fromDB.Consent = vaccination.Consent;
fromDB.Date = vaccination.Date;
db.Entry(fromDB).State = EntityState.Modified;
db.SaveChanges();
}
public ActionResult Edit([Bind(Include = "VaccinationID,Type,DateRecieved,DueDate")] Vaccination vaccination)
{
if (ModelState.IsValid)
{
db.Entry(vaccination).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vaccination));
}
public VaccinationDetailPage(Vaccination vaccinationItem)
{
_viewModel = new VaccinationDetailViewModel();
InitializeComponent();
_viewModel.CurrentVaccinationId = vaccinationItem.VaccinationId;
_viewModel.AccessLevel = vaccinationItem.AccessLevel;
_viewModel.Name = vaccinationItem.VaccinationName;
_viewModel.Notes = vaccinationItem.Notes;
_viewModel.Description = vaccinationItem.VaccinationDescription;
BindingContext = _viewModel;
}
public ActionResult Edit([Bind(Include = "VaccinationsID,VaccinationType,DateReceived,DueDate,PetID")] Vaccination vaccination)
{
if (ModelState.IsValid)
{
db.Entry(vaccination).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.PetID = new SelectList(db.Pets, "PetID", "PetName", vaccination.PetID);
return(View(vaccination));
}
public ActionResult Create([Bind(Include = "VaccinationID,Type,DateRecieved,DueDate")] Vaccination vaccination)
{
if (ModelState.IsValid)
{
db.Vaccinations.Add(vaccination);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vaccination));
}
public ActionResult Edit([Bind(Include = "Id,Vaccine,IsVaccinationAllowed,ReleaseDate,PatientId")] VaccinationDto vaccinationDto)
{
if (ModelState.IsValid)
{
Vaccination vaccination = Mapper.Map <VaccinationDto, Vaccination>(vaccinationDto);
_vaccinationService.Update(vaccination);
return(RedirectToAction("Details", "Patient", new { id = vaccinationDto.PatientId }));
}
return(View(vaccinationDto));
}
