public void AtualizaFilePathImagemPromocao(int idPromocao, string filePath)
{
try
{
using (var context = new CirculoNegocioEntities())
{
tbPromoco promocao = (from p in context.tbPromocoes where p.id == idPromocao select p).First();
promocao.imagemFilePath = filePath;
context.SaveChanges();
}
}
catch (Exception)
{
throw;
}
}
public bool DeletaPromocao(int id)
{
try
{
using (var context = new CirculoNegocioEntities())
{
tbPromoco delete = (from p in context.tbPromocoes where p.id == id select p).First();
context.tbPromocoes.DeleteObject(delete);
context.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
private tbPromoco CastPromocao(PromocaoEntity promocao)
{
tbPromoco tb = new tbPromoco();
tb.dataAte = promocao.dataAte;
tb.dataDe = promocao.dataDe;
tb.dataUltimaAlteracao = promocao.dataUltimaAlteracao;
tb.idCliente = promocao.idCliente;
tb.imagemFilePath = promocao.imagemFilePath;
tb.link = promocao.link;
tb.responsavelUltimaAlteracao = promocao.responsavelUltimaAlteracao;
tb.titulo = promocao.titulo;
tb.estado = promocao.estado;
tb.Ativo = promocao.Ativo;
tb.idTipoPromocao = promocao.idTipoPromocao;
return(tb);
}
public int InserePromocao(PromocaoEntity promocao)
{
int idPromocao = 0;
try
{
using (var context = new CirculoNegocioEntities())
{
tbPromoco tb = CastPromocao(promocao);
context.tbPromocoes.AddObject(tb);
context.SaveChanges();
idPromocao = tb.id;
}
return(idPromocao);
}
catch (Exception)
{
return(0);
}
}
