public e removePet(int petNumber)
{
e errCode = e.success;
PetReservation petRes = new PetReservation();
List <PetReservation> petResList = petRes.ListPetReservations().FindAll(p => p.petNum == petNumber);
Reservation res = new Reservation();
for (int i = 0; i < petResList.Count; i++)
{
if (res.ListActiveReservation().Find(r => r.number == petResList[i].reservationNum) != null)
{
errCode = e.petInRes;
}
}
if (errCode == e.success)
{
PetDB petDB = new PetDB();
if (petDB.Delete(petNumber) == false)
{
errCode = e.deleteFail;
}
}
return(errCode);
}
public List <Pet> listPets()
{
PetDB petDB = new PetDB();
DataTable data = petDB.GetFullPetInfo();
return(GetPets(data).OrderBy(p => p.name).ToList());
}
public static int updatePet(int petNum, string petName, char gender, char isFixed, string breed, DateTime birthday, char size, string notes)
{
PetDB db = new PetDB();
if (db.updatePetDB(petNum, petName, gender, isFixed, breed, birthday, size, notes) != 0)
{
return(1);
}
return(0);
}
public static int deletePet(int petNum)
{
PetDB db = new PetDB();
if (db.deletePetDB(petNum) != 0)
{
return(1);
}
return(0);
}
public static Pet getOnePet(int petNumber)
{
List <Pet> petList = new List <Pet>();
PetDB db = new PetDB();
foreach (DataRow row in db.getOnePetDB(petNumber).Tables["hvk_pet"].Rows)
{
Pet pet = fillFromDataRow(row);
petList.Add(pet);
}
return(petList[0]);
}
public static List <Pet> listPetsByReservation(int resNum)
{
List <Pet> petList = new List <Pet>();
PetDB db = new PetDB();
foreach (DataRow row in db.listPetsByReservationDB(resNum).Tables[0].Rows)
{
Pet pet = fillFromDataRow(row);
petList.Add(pet);
}
return(petList);
}
public static List <Pet> listPets(int ownerNumber)
{
List <Pet> petList = new List <Pet>();
PetDB db = new PetDB();
foreach (DataRow row in db.listPetsDB(ownerNumber).Tables["hvk_pet"].Rows)
{
Pet pet = fillFromDataRow(row);
petList.Add(pet);
}
return(petList);
}
public e Update(int petNumber, String petName, char petSex, bool isFixed, String breed,
DateTime brithdate, int owner, char dogSize, String notes)
{
e errCode = e.success;
PetDB petDB = new PetDB();
if (petDB.Update(petNumber, petName, petSex, isFixed ? 'T' : 'F', breed,
brithdate, owner, dogSize, notes) == false)
{
errCode = e.updateFail;
}
return(errCode);
}
public e AddPet(String petName, char petSex, bool isFixed, String breed,
DateTime?brithdate, int owner, char dogSize, String notes)
{
e errCode = e.success;
PetDB petDB = new PetDB();
if (petDB.Add(petName, petSex, isFixed ? 'T' : 'F', breed,
brithdate, owner, dogSize, notes) != 0)
{
errCode = e.insertFail;
}
return(errCode);
}
public MainWindow()
{
InitializeComponent();
string line;
PetDB pet = new PetDB();
DataTable table = pet.GetFullPetInfo();
foreach (DataRow row in table.Rows)
{
line = "";
foreach (object item in row.ItemArray)
{
line += item.ToString() + " ";
}
listData.Items.Add(line);
}
}
private void btnexcluir_Click(object sender, EventArgs e)
{
int codigo = 0;
if (!String.IsNullOrEmpty(txtcodigo.Text))
{
codigo = Convert.ToInt32(txtcodigo.Text);
db = new PetDB();
db.DeletePet(codigo);
Limpar();
Consultar();
MessageBox.Show("Registro excluido com sucesso!");
}
else
{
MessageBox.Show("Código inválido!");
}
}
private void btncadastrar_Click(object sender, EventArgs e)
{
if (VerificaDados(txtnome.Text, cboraca.SelectedItem.ToString()))
{
pet = new Pet()
{
Nome = txtnome.Text,
Raca = cboraca.SelectedItem.ToString()
};
db = new PetDB();
db.InsertPet(pet);
Limpar();
Consultar();
MessageBox.Show("Registro deletado com sucesso!");
}
else
{
MessageBox.Show("Favor Preencher todas as informações", "Informação", MessageBoxButtons.OK);
}
}
private void btnalterar_Click(object sender, EventArgs e)
{
if (VerificaDados(txtnome.Text, cboraca.SelectedText))
{
pet = new Pet()
{
Codigo = Convert.ToInt32(txtcodigo.Text),
Nome = txtnome.Text,
Raca = cboraca.SelectedItem.ToString()
};
db = new PetDB();
db.UpdatePet(pet);
Limpar();
Consultar();
MessageBox.Show("Registro alterado com sucesso!");
}
else
{
MessageBox.Show("Favor Preencher todas as informações", "Informação", MessageBoxButtons.OK);
}
}
private void Consultar()
{
db = new PetDB();
dgvPet.DataSource = db.ListarPet();
}
private void Consultar(int id)
{
db = new PetDB();
dgvPet.DataSource = db.ListarPetPorID(id);
}
public static int checkPetsInRes(int resNum)
{
PetDB petDB = new PetDB();
return(petDB.checkPetsInReservation(resNum));
}
public void Run()
{
PetDB.InitData();
menuChoice();
}
