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