private void btConfirmar_Click(object sender, EventArgs e) { try { Adoption adocao = new Adoption(); Int64 animalId = (Int64)cbAnimal.SelectedValue; adocao.Animal = animalService.GetById(animalId); int adotanteId = (int)cbAdotante.SelectedValue; adocao.Adopter = adopterService.GetById(adotanteId); DateTime data; var x = DateTime.TryParse(tbData.Text, out data); if (x == false) { throw new Exception("Data invalida"); } adocao.Date = data; adoptionService.Insert(adocao); MessageBox.Show("Adoção cadastrada com sucesso!"); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ActionResult PurchaseBird(int birdID) { using (Context ctx = new Context()) { Bird birdToAdopt = ctx.Birds.Where(x => x.ID == birdID).FirstOrDefault(); if (birdToAdopt != null) { if (birdToAdopt.IsAvailable && User.Identity.GetUserId() != birdToAdopt.PostedBy) { Adoption adopt = new Adoption() { AdopterID = User.Identity.GetUserId(), BirdID = birdToAdopt.ID, AdoptDate = DateTime.Now }; ctx.Adoptions.Add(adopt); FormCollection fc = new FormCollection(); fc.Add("IsAvailable", "false"); fc.Add("AdoptedBy", User.Identity.GetUserId()); if (TryUpdateModel(birdToAdopt, new string[] { "IsAvailable", "AdoptedBy" }, fc)) { ctx.SaveChanges(); return(View("Congratulations", birdToAdopt)); } } ViewBag.Reason = "You cannot adopt this bird."; return(View("Invalid")); } ViewBag.Reason = "The bird you tried to adopt was not available."; return(View("Invalid")); } }
internal static Adoption ParseAdoption(this ResultContainer resultContainer, GedcomChunk adoptionChunk) { var adoption = new Adoption { DatePlace = resultContainer.ParseDatePlace(adoptionChunk) }; foreach (var chunk in adoptionChunk.SubChunks) { switch (chunk.Type) { case "NOTE": adoption.Note = resultContainer.ParseNote(adoption.Note, chunk); break; case "TYPE": adoption.Type = chunk.Data; break; // Deliberately skipped for now case "DATE": case "FAMC": case "PLAC": case "SOUR": resultContainer.Warnings.Add($"Skipped Adoption Type='{chunk.Type}'"); break; default: resultContainer.Errors.Add($"Failed to handle Adoption Type='{chunk.Type}'"); break; } } return(adoption); }
public void SaveToDatabase() { Adoption.UpdateAdoption(); MessageBox.Show("Aktualizováno."); Prnt.UpdateAdoptions(); Prnt.IsWorking = false; TryClose(); }
public ActionResult DeleteConfirmed(int id) { Adoption adoption = db.Adoptions.Find(id); db.Adoptions.Remove(adoption); db.SaveChanges(); return(RedirectToAction("Index")); }
public IActionResult Put(int id, Adoption adoption) { if (id != adoption.Id) { return(BadRequest()); } _adoptionRepository.Update(adoption); return(Ok(adoption)); }
public IActionResult Index(Adoption adoption) { if (ModelState.IsValid) { _adoptionRepository.Adoption(adoption); return(RedirectToAction("Completed")); } return(View(adoption)); }
public ActionResult CollectAnimal(int?id) { Adoption adoption = db.Adoptions.Find(id); ViewBag.ID = id; ViewBag.IDName = adoption.Adopter.Adopter_Name + " " + adoption.Adopter.Adopter_Surname + ", " + adoption.Adopter.Adopter_Email; ViewBag.IDet = adoption.Animal.Animal_Name + ", " + adoption.Animal.Animal_Type.Animal_Type_Name + ", " + adoption.Animal.Animal_Breed.Animal_Breed_Name.ToString() + ", " + adoption.Animal.Animal_Age.ToString() + " Years old"; Id = Convert.ToInt32(id); return(View()); }
public ActionResult DeleteViolationsAdoption(int id) { using (PODBProjectEntities entities = new PODBProjectEntities()) { Adoption emp = entities.Adoptions.Where(x => x.adoptionId == id).FirstOrDefault <Adoption>(); entities.Adoptions.Remove(emp); entities.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public IHttpActionResult Get(int Id, string type = "Id") { try { if (type == TYPE_BY_ID) { Adoption adoption = context.Adoption .Include(a => a.Animal) .Include(a => a.AdoptionStatus) .Include(a => a.User) .FirstOrDefault(a => a.Id == Id) ; if (adoption == null) { return(NotFound()); } return(Ok(adoption)); } else if (type == TYPE_BY_ADOPTER) { IList <Adoption> list = context.Adoption .Include(a => a.Animal) .Include(a => a.AdoptionStatus) .Include(a => a.User) .Where(a => a.UserId == Id) .ToList() ; return(Ok(list)); } else if (type == TYPE_BY_DONOR) { IList <Adoption> list = context.Adoption .Include(a => a.Animal) .Include(a => a.AdoptionStatus) .Include(a => a.User) .Where(a => a.Animal.UserId == Id) .ToList() ; return(Ok(list)); } else { return(BadRequest("Tipo inválido")); } } catch (Exception e) { return(BadRequest(e.Message)); } }
public ActionResult HomeCheckReport(int?id) { if (id != 0) { Adoption adoption = db.Adoptions.Find(id); ViewBag.ID = adoption.Adoption_ID; ViewBag.IDName = adoption.Adopter.Adopter_Name + " " + adoption.Adopter.Adopter_Surname + ", " + adoption.Adopter.Adopter_Email; ViewBag.IDet = adoption.Animal.Animal_Name + ", " + adoption.Animal.Animal_Type.Animal_Type_Name + ", " + adoption.Animal.Animal_Breed.Animal_Breed_Name.ToString() + ", " + adoption.Animal.Animal_Age.ToString(); } return(View()); }
private void ModelErrors(Adoption adoption) { try { List <Adoption> userAdoptions = context.Adoption.Where(a => a.UserId == adoption.UserId && a.AdoptionStatusId == AdoptionStatus.RETURNED && a.CreatedAt <= DateTime.Today.AddMonths(1) ).ToList(); if (userAdoptions.Count > 0) { ModelState.AddModelError("adoption.UserId", "Usuários que devolveram animais devem aguardar um mês antes de iniciar uma nova adoção."); } AdoptionQueue queue = context.AdoptionQueue.Find(adoption.AdoptionQueueId); if (queue == null) { ModelState.AddModelError("adoption.AdoptionQueueId", "Fila de adoção não enontrada. É necessário estar numa fila para iniciar uma adoção."); } if (!queue.IsActive) { ModelState.AddModelError("adoption.AdoptionQueueId", "Essa fila de adoção foi cancelada."); } if (queue.AnimalId != adoption.AnimalId || queue.UserId != adoption.UserId) { ModelState.AddModelError("adoption.AdoptionQueueId", "Fila inválida: Animal ou adotante não podem ser diferentes da fila."); } Adoption queueAdoption = context.Adoption.FirstOrDefault(a => a.AdoptionQueueId == queue.Id); if (queueAdoption != null) { ModelState.AddModelError("adoption.AdoptionQueueId", "Fila inválida: Essa fila já gerou uma adoção."); } IList <Adoption> animalAdoptions = context.Adoption.Where(a => a.AnimalId == adoption.AnimalId).ToList(); if (animalAdoptions.Any(a => a.AdoptionStatusId == AdoptionStatus.FINISHED || a.AdoptionStatusId == AdoptionStatus.WAITING)) { ModelState.AddModelError("adoption.AnimalId", "Esse animal já foi adotado ou está em processo de adoção."); } if (adoption.CreatedAt == null) { ModelState.AddModelError("adoption.CreatedAt", "Data da criação obrigatória."); } } catch (Exception e) { ModelState.AddModelError("Message", e.Message); } }
public ActionResult CaptureAdoptionPayment(int?id) { adoption = db.Adoptions.Find(id);//Display the animal details object if (adoption != null) { ViewBag.ID = id; ViewBag.IDName = adoption.Adopter.Adopter_Name + " " + adoption.Adopter.Adopter_Surname + ", " + adoption.Adopter.Adopter_Email; ViewBag.IDet = adoption.Animal.Animal_Name + ", " + adoption.Animal.Animal_Type.Animal_Type_Name + ", " + adoption.Animal.Animal_Breed.Animal_Breed_Name.ToString() + ", " + adoption.Animal.Animal_Age.ToString() + " Years old"; ViewBag.Price = adoption.Animal.Animal_Type.Price; } return(View()); }
public ActionResult Edit([Bind(Include = "ID,AnimalID,PatronID,Donate")] Adoption adoption) { if (ModelState.IsValid) { db.Entry(adoption).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AnimalID = new SelectList(db.Animals, "ID", "CommonName", adoption.AnimalID); ViewBag.PatronID = new SelectList(db.Patrons, "ID", "FirstName", adoption.PatronID); return(View(adoption)); }
public ActionResult ReturnAnimal(int?id) { Adoption adoption = db.Adoptions.Find(id); Adoption aaa = db.Adoptions.FirstOrDefault(x => x.Adoption_ID == id); aaa.Adopt_Status_ID = 8; aaa.Animal.Animal_Status_ID = 2; db.SaveChanges(); TempData["ReturnMessage"] = "SADDLY!!" + " " + adoption.Animal.Animal_Name + " " + "WAS RETURNED BY ADOPTER:" + " " + adoption.Adopter.Adopter_Name; return(Redirect("http://localhost:55003/Adoptions/Index")); }
public ActionResult Edit([Bind(Include = "AdoptionID,DateAdopted,FamilyID,PetID,EmployeeName")] Adoption adoption) { if (ModelState.IsValid) { db.Entry(adoption).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.PetID = new SelectList(db.Animals, "PetID", "Type", adoption.PetID); ViewBag.FamilyID = new SelectList(db.Families, "FamilyID", "FamilyName", adoption.FamilyID); return(View(adoption)); }
private void AdoptionForm_Load(object sender, EventArgs e) { if (checkinsert == 0) { ReadFromEntity(); original = _adoption; } else { _adoption = new Adoption(); } }
public ActionResult HomeCheckReport(int?id, string val = "") { List <Adoption> adoption1 = db.Adoptions.ToList(); bool flag1 = false; Id = Convert.ToInt32(id); Adoption adoption = db.Adoptions.Find(id); Adoption aaa = db.Adoptions.FirstOrDefault(x => x.Adoption_ID == id); if (adoption != null) { if (val == "true") { val = "true"; flag1 = true; adoption.Adopt_Status_ID = 3; TempData["HomeCheckReportMessage"] = "HomeCheck Report Success "; aaa.Adopt_Status_ID = 3; db.SaveChanges(); return(View("Index", db.Adoptions)); } else { flag1 = false; val = "false"; adoption.Adopt_Status_ID = 4; TempData["HomeCheckReportErrorMessage"] = "HomeCheck Report Failed "; aaa.Adopt_Status_ID = 4; db.SaveChanges(); } ViewBag.ID = adoption.Adoption_ID; ViewBag.IDName = adoption.Adopter.Adopter_Name + " " + adoption.Adopter.Adopter_Surname + ", " + adoption.Adopter.Adopter_Email; ViewBag.IDet = adoption.Animal.Animal_Name + ", " + adoption.Animal.Animal_Type.Animal_Type_Name + ", " + adoption.Animal.Animal_Breed.Animal_Breed_Name.ToString() + ", " + adoption.Animal.Animal_Age.ToString(); return(View("Index", db.Adoptions)); } if (id == null) { return(View("Index")); //new HttpStatusCodeResult(HttpStatusCode.BadRequest); } TempData["HomeCheckReportMessage"] = "HomeCheck Successfully Reported"; return(View("Index")); }
public ActionResult Create([Bind(Include = "ID,AnimalID,PatronID")] Adoption adoption) { if (ModelState.IsValid) { db.Adoptions.Add(adoption); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AnimalID = new SelectList(db.Animals, "ID", "AnimalsName", adoption.AnimalID); ViewBag.PatronID = new SelectList(db.Patrons, "ID", "FirstName", adoption.PatronID); return(View(adoption)); }
private void ExecuteEdit() { Adoption adoption = adoptionBindingSource.Current as Adoption; if (adoption == null) { return; } AdoptionForm form = new AdoptionForm(adoption, 0); form.ShowDialog(); }
public ActionResult Create([Bind(Include = "AdoptionID,PetID,FamilyID,DateAdopted,EmployeeName")] Adoption adoption) { if (ModelState.IsValid) { db.Adoptions.Add(adoption); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.FamilyID = new SelectList(db.Families, "FamilyID", "FamilyName", adoption.FamilyID); ViewBag.PetID = new SelectList(db.Pet4, "PetID", "Type", adoption.PetID); return(View(adoption)); }
public static ValidationResult Validate(Adoption adoption) { if (!adoption.GetAdoptions().Any()) { return(new ValidationResult(new List <ValidationFailure> { new ValidationFailure("GetAdoptions", Message.MS_008) })); } return(new ValidationResult()); }
//List of All Approved Adoptions by UserID public List<Adoption> GetAllAdoptionsByUserProfileId(int id) { using (var conn = Connection) { conn.Open(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = @" SELECT ad.Id, ad.AnimalId, ad.UserProfileId, ad.IsApproved, a.Name, a.ImageLocation, up.FirstName, up.LastName, up.ImageLocation FROM Adoption ad LEFT JOIN Animal a ON ad.AnimalId = a.Id LEFT JOIN UserProfile up ON ad.UserProfileId = up.Id WHERE up.Id = @userProfileId AND ad.IsApproved = 2"; cmd.Parameters.AddWithValue("@userProfile", id); var adoptions = new List<Adoption>(); var reader = cmd.ExecuteReader(); while (reader.Read()) { Adoption adoption = new Adoption() { Id = reader.GetInt32(reader.GetOrdinal("Id")), AnimalId = reader.GetInt32(reader.GetOrdinal("AnimalId")), UserProfileId = reader.GetInt32(reader.GetOrdinal("UserProfileId")), Animal = new Animal { Id = reader.GetInt32(reader.GetOrdinal("AnimalId")), Name = reader.GetString(reader.GetOrdinal("Name")), ImageLocation = reader.GetString(reader.GetOrdinal("ImageLocation")) }, UserProfile = new UserProfile { Id = reader.GetInt32(reader.GetOrdinal("UserProfileId")), FirstName = reader.GetString(reader.GetOrdinal("FirstName")), LastName = reader.GetString(reader.GetOrdinal("LastName")), ImageLocation = reader.GetString(reader.GetOrdinal("ImageLocation")) } }; adoptions.Add(adoption); } reader.Close(); return adoptions; } } }
// GET: Adoptions/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Adoption adoption = db.Adoptions.Find(id); if (adoption == null) { return(HttpNotFound()); } return(View(adoption)); }
// Adding new Adoption public Boolean AddAdoption(int idDog, int idVolunteer, int idAdopter) { var newAdoption = new Adoption(); newAdoption.IdAdopter = idAdopter; newAdoption.IdDog = idDog; newAdoption.IdVolunteer = idVolunteer; newAdoption.Date = DateTime.Today; _context.Dog.Where(x => x.IdDog == idDog).FirstOrDefault().LeaveDate = DateTime.Today; _context.Adoption.Add(newAdoption); _context.SaveChanges(); MessageBox.Show("Pomyślnie utworzyłem adopcję w systemie."); return(true); }
public Adoption GetById(int id) { using (var conn = Connection) { conn.Open(); using (var cmd = conn.CreateCommand()) { cmd.CommandText = @" SELECT ad.id, ad.AnimalId, ad.UserProfileId, ad.IsApproved, a.Name, a.ImageLocation, up.FirstName, up.LastName, up.ImageLocation FROM Adoption ad LEFT JOIN Animal a ON ad.AnimalId = a.id LEFT JOIN UserProfile up on ad.UserProfileId = up.id WHERE ad.id = @id"; cmd.Parameters.AddWithValue("@id", id); var reader = cmd.ExecuteReader(); if (reader.Read()) { Adoption adoption = new Adoption() { Id = reader.GetInt32(reader.GetOrdinal("Id")), AnimalId = reader.GetInt32(reader.GetOrdinal("AnimalId")), UserProfileId = reader.GetInt32(reader.GetOrdinal("UserProfileId")), IsApproved = reader.GetInt32(reader.GetOrdinal("IsApproved")), Animal = new Animal { Id = reader.GetInt32(reader.GetOrdinal("AnimalId")), Name = reader.GetString(reader.GetOrdinal("Name")), ImageLocation = reader.GetString(reader.GetOrdinal("ImageLocation")) }, UserProfile = new UserProfile { Id = reader.GetInt32(reader.GetOrdinal("UserProfileId")), FirstName = reader.GetString(reader.GetOrdinal("FirstName")), LastName = reader.GetString(reader.GetOrdinal("LastName")), ImageLocation = reader.GetString(reader.GetOrdinal("ImageLocation")) } }; reader.Close(); return adoption; } reader.Close(); return null; } } }
public ActionResult CaptureAdoptionPayment(int?id, string Payment = "") { adoption = db.Adoptions.Find(id);//Display the animal details object if (adoption != null) { ViewBag.ID = id; ViewBag.IDName = adoption.Adopter.Adopter_Name + " " + adoption.Adopter.Adopter_Surname + ", " + adoption.Adopter.Adopter_Email; ViewBag.IDet = adoption.Animal.Animal_Name + ", " + adoption.Animal.Animal_Type.Animal_Type_Name + ", " + adoption.Animal.Animal_Breed.Animal_Breed_Name.ToString() + ", " + adoption.Animal.Animal_Age.ToString() + " Years old"; ViewBag.Price = adoption.Animal.Animal_Type.Price; if (Payment == "Cash") { Adoption aaa = db.Adoptions.FirstOrDefault(x => x.Adoption_ID == id); aaa.Adopt_Status_ID = 5; //AdoptionPayment obj = db.AdoptionPayments.SingleOrDefault(x => x.Adoption_ID == id); AdoptionPayment obj = new AdoptionPayment(); obj.Adoption_Fee = adoption.Animal.Animal_Type.Price; obj.Adoption_ID = id; obj.Animal_Type_ID = adoption.Animal.Animal_Type_ID; obj.Payment_Type_ID = 1; db.AdoptionPayments.Add(obj); db.SaveChanges(); } else if (Payment == "EFT") { Adoption aaa = db.Adoptions.FirstOrDefault(x => x.Adoption_ID == id); aaa.Adopt_Status_ID = 5; //AdoptionPayment obj = db.AdoptionPayments.SingleOrDefault(x => x.Adoption_ID == id); AdoptionPayment obj = new AdoptionPayment(); obj.Adoption_Fee = adoption.Animal.Animal_Type.Price; obj.Adoption_ID = id; obj.Animal_Type_ID = adoption.Animal.Animal_Type_ID; obj.Payment_Type_ID = 2; db.AdoptionPayments.Add(obj); db.SaveChanges(); } TempData["PaymentMessage"] = "Payment Successfully"; db.SaveChanges(); } Id = Convert.ToInt32(id); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TempData["PaymentMessage"] = "Payment Successfully"; return(View("CaptureAdoptionPayment")); }
// GET: Adoptions/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Adoption adoption = db.Adoptions.Find(id); if (adoption == null) { return(HttpNotFound()); } ViewBag.AnimalID = new SelectList(db.Animals, "ID", "CommonName", adoption.AnimalID); ViewBag.PatronID = new SelectList(db.Patrons, "ID", "FirstName", adoption.PatronID); return(View(adoption)); }
// GET: Adoptions/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Adoption adoption = db.Adoptions.Find(id); if (adoption == null) { return(HttpNotFound()); } ViewBag.PetID = new SelectList(db.Animals, "PetID", "Type", adoption.PetID); ViewBag.FamilyID = new SelectList(db.Families, "FamilyID", "FamilyName", adoption.FamilyID); return(View(adoption)); }
public ActionResult Delete(int?id) { Id = Convert.ToInt32(id); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Adoption adoption = db.Adoptions.Find(id); if (adoption == null) { return(HttpNotFound()); } return(View(adoption)); }