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