public bool Create() { try { this.Number = SetID(); CreateContract(); Datos.Cocktail coc = new Datos.Cocktail() { Numero = this.Number, IdTipoAmbientacion = (int)this.Ambient, Ambientacion = this.HasAmbient, MusicaAmbiental = this.AmbientMusic, MusicaCliente = this.ClientMusic }; Conexion.OnBreakBD.Entry(coc).State = EntityState.Added; Conexion.OnBreakBD.SaveChanges(); return(true); } catch { return(false); } }
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); } }
public bool Delete() { Datos.OnBreakEntities bbdd = new Datos.OnBreakEntities(); try { Datos.Cocktail ct = bbdd.Cocktail.First(c => c.Numero == Numero); bbdd.Cocktail.Remove(ct); bbdd.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool Update() { Datos.OnBreakEntities bbdd = new Datos.OnBreakEntities(); try { Datos.Cocktail ct = bbdd.Cocktail.First(c => c.Numero == Numero); CommonBC.Syncronize(this, ct); bbdd.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool Read() { Datos.OnBreakEntities bbdd = new Datos.OnBreakEntities(); try { Datos.Cocktail Ct = bbdd.Cocktail.First(c => c.Numero == Numero); CommonBC.Syncronize(Ct, this); return(true); } catch (Exception) { return(false); } }
public bool Create() { try { Datos.OnBreakEntities context = new Datos.OnBreakEntities(); Datos.Cocktail cocktail = new Datos.Cocktail(); CommonBC.Syncronize(this, cocktail); context.Cocktail.Add(cocktail); context.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool Create() { Datos.OnBreakEntities bbdd = new Datos.OnBreakEntities(); Datos.Cocktail ct = new Datos.Cocktail(); try { CommonBC.Syncronize(this, ct); bbdd.Cocktail.Add(ct); bbdd.SaveChanges(); return(true); } catch (Exception) { bbdd.Cocktail.Remove(ct); return(false); } }
//No accesible desde interfaz, solo para testeo public bool Delete() { try { DeleteContract(); Datos.Cocktail c**k = (from auxpa in Conexion.OnBreakBD.Cocktail where auxpa.Numero == this.Number select auxpa).First(); Conexion.OnBreakBD.Cocktail.Remove(c**k); Conexion.OnBreakBD.SaveChanges(); return(true); } catch { return(false); } }
public bool Read() { try { ReadContract(); Datos.Cocktail c**k = (from auxpaa in Conexion.OnBreakBD.Cocktail where auxpaa.Numero == this.Number select auxpaa).First(); Ambientacion ambient = (Ambientacion)c**k.IdTipoAmbientacion; this.Ambient = ambient; this.HasAmbient = c**k.Ambientacion; this.AmbientMusic = c**k.MusicaAmbiental; this.ClientMusic = c**k.MusicaCliente; return(true); } catch { return(false); } }