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