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