private void btnAdicionar_Click(object sender, EventArgs e)
{
if (idAlt != 0)
{
Racas racaNew = new Racas();
racaNew.PET_RACA_ID = idAlt;
racaNew.PET_RACA_NOME = F.toString(edPET_RACA_NOME.EditValue);
if (Racas.Update(racaNew))
{
F.Aviso("Raça alterada com sucesso");
btnAdicionar.Text = "Adicionar";
edPET_RACA_NOME.EditValue = "";
FrmCad_PET_RACA_Load(null, null);
return;
}
else
{
F.Aviso("Erro ao salvar Raça");
return;
}
}
else
{
Racas raca = new Racas
{
PET_RACA_NOME = F.toString(edPET_RACA_NOME.EditValue),
};
Racas.Insert(raca);
FrmCad_PET_RACA_Load(null, null);
List <Racas> a = new List <Racas>();
edPET_RACA_NOME.EditValue = "";
edPET_RACA_NOME.Focus();
}
}
public void AdicionaRacas(Racas racas)
{
using (var ctx = _provider.GetContexto())
{
var racasIds = racas.Select(a => a.Id).ToHashSet();
var racasExistentes = ctx.Racas.Where(linha => racasIds.Contains(linha.Id)).Select(d => d.Id).ToList();
var racasNaoExistentes = racasIds.Where(d => !racasExistentes.Contains(d)).ToList();
racas.Where(f => racasNaoExistentes.Contains(f.Id)).ToList().ForEach(d =>
{
ctx.Racas.Add(new CatAPIDataCore.Entidade.Raca
{
Id = d.Id,
Description = d.Description,
Origin = d.Origin,
Temperament = d.Temperament,
Name = d.Name
});
});
if (racasNaoExistentes.Any())
{
ctx.SaveChanges();
}
}
}
private void btnAlterar_Click(object sender, EventArgs e)
{
int PET_RACA_ID = F.toInt(gridView1.GetFocusedRowCellValue("PET_RACA_ID"));
Racas raca = Racas.Get(PET_RACA_ID);
edPET_RACA_NOME.EditValue = F.toString(raca.PET_RACA_NOME);
idAlt = F.toInt(raca.PET_RACA_ID);
btnAdicionar.Text = "Salvar";
}
private void btnRemover_Click(object sender, EventArgs e)
{
int PET_RACA_ID = F.toInt(gridView1.GetFocusedRowCellValue("PET_RACA_ID"));
if (F.YesNo("Deletar", "Deseja realmente remover esta Raça?", 1))
{
if (Racas.Delete(Racas.Get(PET_RACA_ID)))
{
F.Aviso("Raça removida com sucesso.");
FrmCad_PET_RACA_Load(null, null);
}
}
}
public Racas Register(Racas a)
{
cmd.Connection = connect.ToConnect();
cmd.CommandText =
"INSERT INTO Racas (Descricao)" +
"VALUES" +
"@descricao";
cmd.Parameters.AddWithValue("@descricao", a.Descricao);
cmd.ExecuteNonQuery();
connect.Desconnect();
return(a);
}
public Racas Update(int id, Racas a)
{
cmd.Connection = connect.ToConnect();
cmd.CommandText = "UPDATE Racas SET " +
"Descricao = @descricao" +
"IdTipo = @idtipo WHERE IdRacas = @id";
cmd.Parameters.AddWithValue("@descricao", a.Descricao);
cmd.Parameters.AddWithValue("@idtipo", a.IdTipo);
cmd.Parameters.AddWithValue("@id", a.IdRacas);
cmd.ExecuteNonQuery();
connect.Desconnect();
return(a);
}
public Racas SearchById(int id)
{
cmd.Connection = connect.ToConnect();
cmd.CommandText = "SELECT * FROM Racas WHERE IdRacas = @id";
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader data = cmd.ExecuteReader();
Racas a = new Racas();
while (data.Read())
{
a.IdRacas = Convert.ToInt32(data.GetValue(0));
a.Descricao = data.GetValue(1).ToString();
}
connect.Desconnect();
return(a);
}
private void FrmPets_Load(object sender, EventArgs e)
{
edPET_RACA.Properties.DataSource = Racas.Get();
edPET_RACA.Properties.ValueMember = "PET_RACA_ID";
edPET_RACA.Properties.DisplayMember = "PET_RACA_NOME";
if (DonoTemp > 0)
{
edCLI_ID.EditValue = DonoTemp;
edCLI_ID.ReadOnly = true;
}
if (TIPO == "A" || PETID != 0)
{
pet = Pets.Get(F.toInt(PETID));
edCLI_ID.EditValue = F.toInt(pet.CLI_ID);
edPET_COR.EditValue = F.toString(pet.PET_COR);
edPET_NAS.EditValue = Convert.ToDateTime(pet.PET_NAS);
edPET_NOME.EditValue = F.toString(F.toString(pet.PET_NOME));
edPET_OBS.EditValue = F.toString(pet.PET_OBS);
edPET_RACA.EditValue = F.toInt(pet.PET_RACA);
edPET_IMAGEM.EditValue = F.toString(pet.PET_IMG);
picPET_IMG.Image = pet.PET_IMAGEM;
}
}
private void SH_PETS_Load(object sender, EventArgs e)
{
gridControlPets.DataSource = Pets.Get();
repositoryItemGridLookUpEditDono.DataSource = Clientes.Get();
repositoryItemGridLookUpEditDono.ValueMember = "CLI_ID";
repositoryItemGridLookUpEditDono.DisplayMember = "CLI_RAZAO";
edCLI_ID.Properties.DataSource = Clientes.Get();
edCLI_ID.Properties.ValueMember = "CLI_ID";
edCLI_ID.Properties.DisplayMember = "CLI_RAZAO";
edPET_ID.Properties.DataSource = Pets.Get();
edPET_ID.Properties.ValueMember = "PET_ID";
edPET_ID.Properties.DisplayMember = "PET_NOME";
edPET_RACA.Properties.DataSource = Racas.Get();
edPET_RACA.Properties.ValueMember = "PET_RACA_ID";
edPET_RACA.Properties.DisplayMember = "PET_RACA_NOME";
repositoryItemGridLookUpEditRaca.DataSource = Racas.Get();
repositoryItemGridLookUpEditRaca.ValueMember = "PET_RACA_ID";
repositoryItemGridLookUpEditRaca.DisplayMember = "PET_RACA_NOME";
}
private void FrmCad_PET_RACA_Load(object sender, EventArgs e)
{
gridControl1.DataSource = Racas.Get();
}
void RacasSelectedIndexChanged(object sender, EventArgs e)
{
race = Racas.GetItemText(Racas.SelectedItem);
}
