public Cocktail Read(string numContrato)
{
OnBreakDBEntities db = new OnBreakDBEntities();
var result = (from c in db.Cocktail
where c.Numero == numContrato
select c).FirstOrDefault();
if (result.IdTipoAmbientacion == null)
{
Cocktail cocktail = new Cocktail()
{
MusicaAmbiental = result.MusicaAmbiental,
MusicaCliente = result.MusicaCliente
};
return(cocktail);
}
else
{
Cocktail cocktail = new Cocktail()
{
TipoAmbientacion = new TipoAmbientacion()
{
Id = result.TipoAmbientacion.IdTipoAmbientacion
},
MusicaAmbiental = result.MusicaAmbiental,
MusicaCliente = result.MusicaCliente
};
return(cocktail);
}
}
public bool Create(Cocktail cocktail)
{
OnBreakDBEntities db = new OnBreakDBEntities();
try
{
Datos.Cocktail c = new Datos.Cocktail();
if (cocktail.TipoAmbientacion == null)
{
c.Numero = cocktail.Contrato.Numero;
c.MusicaAmbiental = cocktail.MusicaAmbiental;
c.MusicaCliente = cocktail.MusicaCliente;
}
else
{
c.Numero = cocktail.Contrato.Numero;
c.MusicaAmbiental = cocktail.MusicaAmbiental;
c.MusicaCliente = cocktail.MusicaCliente;
c.IdTipoAmbientacion = cocktail.TipoAmbientacion.Id;
}
db.Cocktail.Add(c);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool Update(Cocktail cocktail)
{
OnBreakDBEntities db = new OnBreakDBEntities();
try
{
Datos.Cocktail c = (from ct in db.Cocktail
where ct.Numero == cocktail.Contrato.Numero
select ct).FirstOrDefault();
if (cocktail.TipoAmbientacion == null)
{
c.MusicaAmbiental = cocktail.MusicaAmbiental;
c.MusicaCliente = cocktail.MusicaCliente;
db.Entry(c).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(true);
}
else
{
c.MusicaAmbiental = cocktail.MusicaAmbiental;
c.MusicaCliente = cocktail.MusicaCliente;
c.IdTipoAmbientacion = cocktail.TipoAmbientacion.Id;
db.Entry(c).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
