public override OperationResult execute(SoundboardDBEntities entities)
{
if ((this.Sound != null) && (this.Sound.IdSound > 0))
{
entities.SoundDelete(this.Sound.IdSound);
}
return(base.execute(entities));
}
public override OperationResult execute(SoundboardDBEntities entities)
{
if ((this.User != null) && (this.User.IdUser > 0))
{
entities.DeleteUser(this.User.IdUser);
}
return(base.execute(entities));
}
public override OperationResult execute(SoundboardDBEntities entities)
{
if ((this.Sound != null) &&
!string.IsNullOrEmpty(this.Sound.SoundUrl) &&
!string.IsNullOrEmpty(this.Sound.ImageUrl))
{
entities.SoundInsert(this.Sound.SoundUrl, this.Sound.ImageUrl);
}
return(base.execute(entities));
}
public override OperationResult execute(SoundboardDBEntities entities)
{
if ((this.User != null) &&
!string.IsNullOrEmpty(this.User.Username) &&
!string.IsNullOrEmpty(this.User.Password))
{
entities.UserInsert(this.User.Username, this.User.Password);
}
return(base.execute(entities));
}
public override OperationResult execute(SoundboardDBEntities entities)
{
if ((this.About != null) && (this.About.AboutId > 0) &&
!string.IsNullOrEmpty(this.About.AboutDesc) &&
!string.IsNullOrEmpty(this.About.AboutName) &&
!string.IsNullOrEmpty(this.About.AboutImg))
{
entities.UpdateAbout(this.About.AboutId, this.About.AboutImg, this.About.AboutName, this.About.AboutDesc);
}
return(base.execute(entities));
}
public override OperationResult execute(SoundboardDBEntities entities)
{
IEnumerable <AboutOperation> ieAbout;
ieAbout = from about in entities.Abouts
select new AboutOperation
{
AboutId = about.Id,
AboutImg = about.AboutImg,
AboutDesc = about.AboutDesc,
AboutName = about.AboutName
};
AboutOperation[] arrAbout = ieAbout.ToArray();
OperationResult opRes = new OperationResult();
opRes.Message = "All About Fetched";
opRes.Status = true;
opRes.DbItems = arrAbout;
return(opRes);
}
public override OperationResult execute(SoundboardDBEntities entities)
{
IEnumerable <SoundOperation> ieSounds;
if ((this.Criterium == null) || ((this.Criterium.SoundUrl == null) && (this.Criterium.ImageUrl == null) && (this.Criterium.IdSound == null)))
{
ieSounds = from sound in entities.Sounds
select new SoundOperation
{
IdSound = sound.Id,
SoundUrl = sound.SoundUrl,
ImageUrl = sound.ImgUrl
};
}
else
{
ieSounds = from sound in entities.Sounds
where ((this.Criterium.SoundUrl == null) ? true : this.Criterium.SoundUrl == sound.SoundUrl) &&
((this.Criterium.ImageUrl == null) ? true : this.Criterium.ImageUrl == sound.ImgUrl) &&
((this.Criterium.IdSound == null)? true : this.Criterium.IdSound < sound.Id)
select new SoundOperation
{
IdSound = sound.Id,
SoundUrl = sound.SoundUrl,
ImageUrl = sound.ImgUrl
};
}
SoundOperation[] arrSounds = ieSounds.ToArray();
OperationResult opRes = new OperationResult();
opRes.Message = "All Sounds Fetched";
opRes.Status = true;
opRes.DbItems = arrSounds;
return(opRes);
}
public override OperationResult execute(SoundboardDBEntities entities)
{
IEnumerable <UserOperation> ieUsers;
if ((this.Criterium == null) || ((this.Criterium.Username == null) && (this.Criterium.Password == null) && (this.Criterium.IdUser == null)))
{
ieUsers = from user in entities.Users
select new UserOperation
{
IdUser = user.Id,
Username = user.Username,
Password = user.Password
};
}
else
{
ieUsers = from user in entities.Users
where ((this.Criterium.Username == null) ? true : this.Criterium.Username == user.Username) &&
((this.Criterium.Password == null) ? true : this.Criterium.Password == user.Password) &&
((this.Criterium.IdUser == null) ? true : this.Criterium.IdUser < user.Id)
select new UserOperation
{
IdUser = user.Id,
Username = user.Username,
Password = user.Password
};
}
UserOperation[] arrUsers = ieUsers.ToArray();
OperationResult opRes = new OperationResult();
opRes.Message = "All Users Fetched";
opRes.Status = true;
opRes.DbItems = arrUsers;
return(opRes);
}
public abstract OperationResult execute(SoundboardDBEntities entities);
