public bool SetUserPermission(UserBE entity) { var dbContext = new DBContext(); bool result = false; try { dbContext.BeginTran(); PermissionDAL per = new PermissionDAL(); if (per.DeleteUserPermission(entity, dbContext)) { result = per.SetUserPermission(entity, dbContext); } if (result) { dbContext.CommitTran(); return(result); } dbContext.RollBackTran(); return(result); } catch (Exception) { return(result); } }
public Guid Add(UserBE entity) { var dbContext = new DBContext(); try { var dataSet = new DataSet(); var parameters = Array.Empty <SqlParameter>(); var userguid = Guid.NewGuid(); parameters = new SqlParameter[11]; parameters[0] = dbContext.CreateParameters("@imgKey", !string.IsNullOrEmpty(entity.ImgKey) ? entity.ImgKey : null); parameters[1] = dbContext.CreateParameters("@userName", entity.UserName); parameters[2] = dbContext.CreateParameters("@lastName", entity.LastName); parameters[3] = dbContext.CreateParameters("@name", entity.Name); parameters[4] = dbContext.CreateParameters("@languageID", entity.Language.Id); parameters[5] = dbContext.CreateParameters("@email", !string.IsNullOrEmpty(entity.Email) ? entity.Email : null); parameters[6] = dbContext.CreateParameters("@password", entity.Password); parameters[8] = dbContext.CreateParameters("@artistName", !string.IsNullOrEmpty(entity.ArtistName) ? entity.ArtistName : null); parameters[7] = dbContext.CreateParameters("@serviceID", entity.Contract.Service.Id == Guid.Empty ? Guid.Empty : entity.Contract.Service.Id); parameters[9] = dbContext.CreateParameters("@userid", userguid); parameters[10] = dbContext.CreateParameters("@contractID", entity.Contract.Service.Id == Guid.Empty ? Guid.Empty : Guid.NewGuid()); dbContext.BeginTran(); if (dbContext.Write("AddUser", parameters) > 0) { entity.Id = userguid; PermissionDAL per = new PermissionDAL(); bool resultper = per.SetUserPermission(entity, dbContext); if (resultper) { dbContext.CommitTran(); return(userguid); } } dbContext.RollBackTran(); return(Guid.Empty); } catch (Exception ex) { dbContext.RollBackTran(); throw new Exception(Messages.Generic_Error); } }