public static void DeleteObject(ServicoPrest pPrestServ)
{
DataBase db = GetDataBase();
var query = from c in db.ServicoPrest
where c.id == pPrestServ.id
select c;
db.ServicoPrest.DeleteOnSubmit(query.ToList()[0]);
db.SubmitChanges();
}
public static void Update(ServicoPrest pServPrest)
{
DataBase db = GetDataBase();
ServicoPrest servPrest = (from c in db.ServicoPrest
where c.id == pServPrest.id
select c).First();
servPrest.NomeServicoPrest = pServPrest.NomeServicoPrest;
db.SubmitChanges();
}
private void btnServ_Click(object sender, RoutedEventArgs e)
{
if (TxtNomeServ.Text == string.Empty)
{
MessageBox.Show(" O Serviço deve ser preenchido");
return;
}
if (servPrest != null)
{
servPrest.id = int.Parse(TxtId.Text);
servPrest.NomeServicoPrest = TxtNomeServ.Text;
ServicoPrestRepositorio.Update(servPrest);
MessageBox.Show("Dados Alterados com sucesso.");
}
if (servPrest == null)
{
ServicoPrest servicoPrestado = new ServicoPrest
{
id = int.Parse(TxtId.Text),
NomeServicoPrest = TxtNomeServ.Text,
};
// Uri caminho = new Uri("/ProvaRepositorio.cs?parametro=" + TxtId.Text, UriKind.RelativeOrAbsolute);
ServicoPrestRepositorio.Create(servicoPrestado);
//ServicoPrestRepositorio.Create(servicoPrest);
if (servicoPrestado.referencia != 1)
{
MessageBox.Show("Cadastrado com Sucesso.");
}
else
{
MessageBox.Show("Esta informação já consta no banco de dados");
}
}
NavigationService.GoBack();
}
public static void Create(ServicoPrest pServPrest)
{
int ponto = 0;
DataBase db = GetDataBase();
var query = from servPrest in db.ServicoPrest orderby servPrest.id descending select servPrest;
List<ServicoPrest> lista = new List<ServicoPrest>(query.AsEnumerable());
foreach (var item in lista)
{
if ((item.NomeServicoPrest.Equals(pServPrest.NomeServicoPrest, StringComparison.OrdinalIgnoreCase)))
{
ponto = 1;
}
}
if (ponto == 0)
{
db.ServicoPrest.InsertOnSubmit(pServPrest);
db.SubmitChanges();
}
else
{
pServPrest.referencia = 1;
}
}
//ORIGINAL
private void onSelecionChange(object sender, SelectionChangedEventArgs e)
{
servPrest = (sender as ListBox).SelectedItem as ServicoPrest;
}
