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